Oracle8i Time Series User's Guide
Release 8.1.5

A67294-01

Library

Product

Contents

Prev

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 


Numerics

8.1
documentation changes for release 8.1, xix

A

Add_Existing_Column procedure, 7-3
Add_Integer_Column procedure, 7-6
Add_Number_Column procedure, 7-8
Add_Varchar2_Column procedure, 7-10
addition
TSAdd function, 5-85
TSSum function, 5-119
administrative tools procedures, 2-43, 7-1
role requirement, 2-44
UTL_FILE requirements, 2-45
advanced-developer demo, 1-9
aggregate functions, 2-34
ALL_TIMESERIES_xxx views, B-2
API
Java client, 1-14
architecture
Oracle8i Time Series, 2-18
arithmetic functions, 2-35
average
TSAvg function, 5-89
average, moving
Mavg function, 2-36, 5-76

B

Begin_Create_TS_Group procedure, 7-12
bottom values
TSMinN function, 5-105
bulk loading of time series data, 3-8
consistency, 2-29, 3-9

C

calendar, 2-5
data types, 2-14
defining, 2-10
exceptions, 2-6
frequency, 2-6
pattern, 2-5
precision, 2-9
shared, 2-5, 3-7
validating, 4-49, 4-98
calendar functions, 2-30, 4-1
calendar precision, 2-8
calendar-creation functions, 2-30
Cancel_Create_TS_Group procedure, 7-14
Cavg function, 5-3
changes to documentation for release 8.1, xix
client-side API
Java, 1-14
Close_Log procedure, 7-15
Cmax function, 5-5
Cmin function, 5-8
collection-based interface, 2-22
CombineCals function, 4-3
compatibility matrix for scaleup/scaledown, 2-39
consistency of time series data
approaches, 2-29, 3-9
conventional path (SQL*Loader), 3-11
conversion functions, 2-37
count
TSCount function, 5-91
Cprod function, 5-11
cumulative sequence functions, 2-36

D

data types
calendar, 2-14
time series, 2-14
Database Configuration Assistant (ODCA), 1-7
data-driven time series, 2-2
Day function, 4-8
DBA_TIMESERIES_xxx views, B-3
defining
calendar, 2-10
DeleteExceptions function, 4-10
demos (demonstration files)
advanced-developer, 1-9
electric utility, 1-9
Java, 1-9, 1-14
Oracle Call Interface (OCI), 1-10
Oracle Developer, 1-10
PRO*C/C++, 1-9
quick-start, 1-10
retrofitting existing tables, 1-9
usage, 1-9
deprecated features, C-1
DeriveExceptions function, 2-12, 5-15
Developer/2000 (Oracle Developer) demo, 1-10
direct path (SQL*Loader), 3-11
DiscardError options for scaleup, 2-41
Display function, 5-18
Display_Attributes procedure, 7-16
DisplayValCal procedure, 4-13
DisplayValTS procedure, 5-21
division
TSDivide function, 5-93
Drop_TS_Group procedure, 7-18
Drop_TS_Group_All procedure, 7-20

E

electric utility demo, 1-9
End_Create_TS_Group procedure, 7-22
EqualCals function, 4-20
error messages, A-1
errors
DiscardError options for scaleup, 2-41
exceptions, 2-6
deriving, 2-12
ExtractCal function, 5-29
ExtractDate function, 5-31
extraction functions, 2-33
ExtractTable function, 5-33
ExtractValue function, 5-35

F

Fill function, 5-37
First function, 5-43
FirstN function, 5-45
flat IOT storage model, 2-19
frequency, 2-6
functions
Add_Existing_Column procedure, 7-3
Add_Integer_Column procedure, 7-6
Add_Number_Column procedure, 7-8
Add_Varchar2_Column procedure, 7-10
Begin_Create_TS_Group procedure, 7-12
calendar, 2-30, 4-1
calendar-creation, 2-30
Cancel_Create_TS_Group procedure, 7-14
Cavg, 5-3
Close_Log procedure, 7-15
Cmax, 5-5
Cmin, 5-8
CombineCals, 4-3
Cprod, 5-11
Day, 4-8
DeleteExceptions, 4-10
DeriveExceptions, 2-12, 5-15
Display, 5-18
Display_Attributes procedure, 7-16
DisplayValCal procedure, 4-13
DisplayValTS procedure, 5-21
Drop_TS_Group procedure, 7-18
Drop_TS_Group_All procedure, 7-20
End_Create_TS_Group procedure, 7-22
EqualCals, 4-20
ExtractCal, 5-29
ExtractDate, 5-31
ExtractTable, 5-33
ExtractValue, 5-35
Fill, 5-37
First, 5-43
FirstN, 5-45
GenDateRangeTab, 4-23
Get_Flat_Attributes procedure, 7-24
Get_Object_Attributes procedure, 7-29
Get_Status procedure, 7-33
GetDatedElement, 5-48
GetIntervalEnd, 4-27
GetIntervalStart, 4-30
GetNthElement, 5-50
GetOffset, 4-33
GetSeries, 5-52
Hour, 4-36
InsertExceptions, 4-38
IntersectCals, 4-42
InvalidTimeStampsBetween, 4-46
IsValidCal, 4-49
IsValidDate, 4-55
IsValidTS, 5-55
Lag, 5-63
Last, 5-67
LastN, 5-69
Lead, 5-72
Mavg, 5-76
Minute, 4-58
Month, 4-60
Msum, 5-79
NumInvalidTimeStampsBetween, 4-62
NumOffExceptions, 4-65
NumOnExceptions, 4-68
NumTimeStampsBetween, 4-71
OffsetDate, 4-74
Open_Log procedure, 7-35
Quarter, 4-77
ScaledownInterpolate, 6-3
ScaledownRepeat, 6-6
ScaledownSplit, 6-9
ScaleupAvg, 6-12
ScaleupAvgX, 6-15
ScaleupCount, 6-18
ScaleupFirst, 6-21
ScaleupGMean, 6-24
ScaleupLast, 6-27
ScaleupMax, 6-30
ScaleupMin, 6-33
ScaleupSum, 6-36
ScaleupSumAnnual, 6-39
Second, 4-79
Semi_annual, 4-81
Semi_monthly, 4-83
Set_Flat_Attributes procedure, 7-37
Set_Object_Attributes procedure, 7-41
SetPrecision, 4-85
Ten_day, 4-88
time scaling, 2-37, 6-1
time series, 2-32, 5-1
TimeStampsBetween, 4-90
Trace_Off procedure, 7-45
Trace_On procedure, 7-46
TrimSeries, 5-82
TSAdd, 5-85
TSAvg, 5-89
TSCount, 5-91
TSDivide, 5-93
TSMax, 5-97
TSMaxN, 5-99
TSMedian, 5-101
TSMin, 5-103
TSMinN, 5-105
TSMultiply, 5-107
TSProd, 5-111
TSStdDev, 5-113
TSSubtract, 5-115
TSSum, 5-119
TSVariance, 5-121
UnionCals, 4-94
ValidateCal, 4-98
ValidateTS, 5-123
Week, 4-106
Year, 4-108

G

GenDateRangeTab function, 4-23
Get_Flat_Attributes procedure, 7-24
Get_Object_Attributes procedure, 7-29
Get_Status procedure, 7-33
GetDatedElement function, 5-48
GetIntervalEnd function, 4-27
GetIntervalStart function, 4-30
GetNthElement function, 5-50
GetOffset function, 4-33
GetSeries function, 5-52
group (time series), 7-12

H

highest values
TSMaxN, 5-99
Hour function, 4-36

I

IgnoreNulls options for scaleup, 2-41
imprecise timestamps, 2-8
incremental loading of time series data, 3-10
index-organized table (IOT)
flat (storage model), 2-19
nested (storage model), 2-20
InsertExceptions function, 4-38
installing the product, 1-7
instance-based interface, 2-22
interpolation with scaledown, 6-3
IntersectCals function, 4-42
InvalidTimeStampsBetween function, 4-46
irregular time series, 1-4, 2-2
IsValidCal function, 4-49
IsValidDate function, 4-55
IsValidTS function, 5-55

J

Java
client-side API, 1-14
demos, 1-9, 1-14

K

kit installation, 1-7

L

Lag function, 5-63
Last function, 5-67
LastN function, 5-69
Lead function, 5-72
loading
time series data, 3-7
logging
UTL_FILE procedure used, 2-45
lowest values
TSMinN, 5-105

M

map table, 3-6
Mavg function, 2-36, 5-76
maxDate
effect if null, 2-12
maximum
TSMax function, 5-97
median
TSMedian function, 5-101
messages
error, A-1
metadata (map) table, 3-6
metadata for usage demo, 1-13, 2-25
metadata views
Oracle8i Time Series metadata, B-1
minDate
effect if null, 2-12
minimum
TSMin function, 5-103
Minute function, 4-58
Month function, 4-60
moving average
Mavg function, 2-36, 5-76
moving sum
Msum function, 2-36, 5-79
Msum function, 2-36, 5-79
multiplication
TSMultiply function, 5-107
TSProd function, 5-111

N

nested IOT storage model, 2-20
null minDate or maxDate for calendar, 2-12
null operand semantics, 2-16
scaleup options, 2-41
NumInvalidTimeStampsBetween function, 4-62
NumOffExceptions function, 4-65
NumOnExceptions function, 4-68
NumTimeStampsBetween function, 4-71

O

object model (nested IOT storage), 2-20
object relational technology, 1-2
object view, 1-13
OCI demo, 1-10
off-exception, 2-6
semantics, 2-17
OffsetDate function, 4-74
on-exception, 2-6
Open_Log procedure, 7-35
Oracle Call Interface (OCI) demo, 1-10
Oracle Database Configuration Assistant (ODCA), 1-7
Oracle Developer demo, 1-10
Oracle Forms demo, 1-10
Oracle Universal Installer, 1-7
ORDSYS schema, 1-9
ORDTCalendar data type, 2-14
ORDTDateRange data type, 2-16
ORDTDateRangeTab data type, 2-16
ORDTDateTab data type, 2-15
ORDTExceptions data type, 2-14
ORDTNumCell data type, 2-14
ORDTNumSeries data type, 2-14
ORDTNumSeriesIOTRef data type, 2-15
ORDTNumSeriesIOTRef type, 2-24
ORDTNumTab data type, 2-14
ORDTPattern data type, 2-14
ORDTPatternBits data type, 2-14
ordtsyn.sql (public synonyms), 1-9
ORDTVarchar2Cell data type, 2-15
ORDTVarchar2Series data type, 2-15
ORDTVarchar2SeriesIOTRef data type, 2-15
ORDTVarchar2Tab data type, 2-15

P

package names
public synonyms for, 1-9
package state, 7-33
pattern, 2-5
PRAGMA RESTRICT_REFERENCES
with ORDTNumSeriesIOTRef view, 2-25
precision, 2-8, 2-9
privilege (role) requirements for tools procedures, 2-44
PRO*C/C++ demo, 1-9
procedures
Add_Existing_Column, 7-3
Add_Integer_Column, 7-6
Add_Number_Column, 7-8
Add_Varchar2_Column, 7-10
administrative tools, 2-43, 7-1
Begin_Create_TS_Group, 7-12
Cancel_Create_TS_Group, 7-14
Close_Log, 7-15
Display_Attributes, 7-16
DisplayValCal, 4-13
DisplayValTS, 5-21
Drop_TS_Group, 7-18
Drop_TS_Group_All, 7-20
End_Create_TS_Group, 7-22
Get_Flat_Attributes, 7-24
Get_Object_Attributes, 7-29
Get_Status, 7-33
Open_Log, 7-35
Set_Flat_Attributes, 7-37
Set_Object_Attributes, 7-41
Trace_Off, 7-45
Trace_On, 7-46
product
TSProd function, 5-111
public synonyms for package names, 1-9

Q

Quarter function, 4-77
quick-start demo, 1-10
files, 1-11

R

README.txt files, 1-10
reference-based interface, 2-24
reference-based view, 1-13
regular time series, 2-2
relational view, 1-13
release 8.1 documentation changes, xix
repeat with scaledown, 6-6
RESTRICT_REFERENCES
with ORDTNumSeriesIOTRef view, 2-25
retrofit demo, 1-9
retrofitting existing tables to create time series schema objects, 3-11
role requirement for administrative tools procedures, 2-44

S

scaledown
compatibility matrix, 2-39
ScaledownInterpolate function, 6-3
ScaledownRepeat function, 6-6
ScaledownSplit function, 6-9
scaleup
compatibility matrix, 2-39
ScaleupAvg function, 6-12
ScaleupAvgX function, 6-15
ScaleupCount function, 6-18
ScaleupFirst function, 6-21
ScaleupGmean function, 6-24
ScaleupLast function, 6-27
ScaleupMax function, 6-30
ScaleupMin function, 6-33
ScaleupSum function, 6-36
ScaleupSumAnnual function, 6-39
Second function, 4-79
semantics
null operands, 2-16
off-exception operands, 2-17
Semi_annual function, 4-81
Semi_monthly function, 4-83
server output, setting, 5-19
SET SERVEROUTPUT ON statement, 5-19
Set_Flat_Attributes procedure, 7-37
Set_Object_Attributes procedure, 7-41
SetPrecision function, 4-85
shared calendar, 2-5, 3-7
shift functions, 2-34
split with scaledown, 6-9
SQL formatting functions, 2-34
SQL*Loader utility, 3-7
bulk loading, 3-8
conventional and direct paths, 3-11
incremental loading, 3-10
standard deviation
TSStdDev function, 5-113
state
package, 7-33
stockdemo_metadata table, 1-13, 2-25
stockdemo_sv object view, 1-13
stockdemo_sv relational view, 1-13
stockdemo_ts reference-based view, 1-13
stockdemo_ts view, 2-25
subtraction
TSSubtract function, 5-115
sum
TSSum function, 5-119
sum, moving
Msum function, 2-36, 5-79
synonyms
public (package names), 1-9

T

Ten_day function, 4-88
time scaling functions, 2-37, 6-1
time series
architecture, 2-18
data storage, 2-19
data types, 2-14
irregular, 1-4, 2-2
regular, 2-2
validating, 3-9, 5-55, 5-123
time series functions, 2-32, 5-1
time series group, 7-12
TIMESERIES_DBA role, 2-44
TIMESERIES_DEVELOPER role, 2-44
TimeStampsBetween function, 4-90
tools procedures, 7-1
role requirement, 2-44
UTL_FILE requirements, 2-45
top values
TSMaxN function, 5-99
Trace_Off procedure, 7-45
Trace_On procedure, 7-46
trim functions, 2-33
TrimSeries function, 5-82
TSAdd function, 5-85
TSAvg function, 5-89
TSCount function, 5-91
TSDivide function, 5-93
TSMax function, 5-97
TSMaxN function, 5-99
TSMedian function, 5-101
TSMin function, 5-103
TSMinN function, 5-105
TSMultiply function, 5-107
TSProd function, 5-111
TSStdDev function, 5-113
TSSubtract function, 5-115
TSSum function, 5-119
TSVariance function, 5-121

U

UnionCals function, 4-94
usage demo, 1-9
files, 1-12
tables and views, 1-13, 2-25
USER_TIMESERIES_xxx views, B-4
utility (electric) demo, 1-9
UTL_FILE procedure and logging, 2-45
UTL_FILE_DIR parameter in Oracle initialization file, 2-45

V

ValidateCal function, 4-98
ValidateTS function, 5-123
validating
calendar, 4-49, 4-98
time series, 3-9, 5-55, 5-123
variance
TSVariance function, 5-121
view
with ORDTNumSeriesIOTRef data type, 2-25
views
Oracle8i Time Series metadata, B-1

W

Week function, 4-106

Y

Year function, 4-108


Prev
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents