Oracle8i Time Series User's Guide
Release 8.1.5
A67294-01

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

data types, 2-14

exceptions, 2-6

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

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

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

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

quick-start, 1-10

retrofitting existing tables, 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

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

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

Close_Log procedure, 7-15

CombineCals, 4-3

DeleteExceptions, 4-10

DeriveExceptions, 2-12, 5-15

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

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

InsertExceptions, 4-38

IntersectCals, 4-42

InvalidTimeStampsBetween, 4-46

IsValidCal, 4-49

IsValidDate, 4-55

IsValidTS, 5-55

NumInvalidTimeStampsBetween, 4-62

NumOffExceptions, 4-65

NumOnExceptions, 4-68

NumTimeStampsBetween, 4-71

OffsetDate, 4-74

Open_Log procedure, 7-35

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

Semi_annual, 4-81

Semi_monthly, 4-83

Set_Flat_Attributes procedure, 7-37

Set_Object_Attributes procedure, 7-41

SetPrecision, 4-85

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

TSMedian, 5-101

TSMultiply, 5-107

TSStdDev, 5-113

TSSubtract, 5-115

TSVariance, 5-121

UnionCals, 4-94

ValidateCal, 4-98

ValidateTS, 5-123

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

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

M

Mavg function, 2-36, 5-76

maxDate

effect if null, 2-12

maximum

TSMax function, 5-97

median

TSMedian function, 5-101

messages

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

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

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

product

TSProd function, 5-111

public synonyms for package names, 1-9

Q

Quarter function, 4-77

quick-start demo, 1-10

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

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

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

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

Copyright © 1999 Oracle Corporation.
All Rights Reserved.