Oracle8 Time Series Cartridge User's Guide
Release 8.0.4
A57501-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

A

addition

TSAdd function, 5-93

TSSum function, 5-127

advanced-developer demo, 1-4

aggregate functions, 2-28

architecture

Time Series cartridge, 2-10

arithmetic functions, 2-28

average

TSAvg function, 5-97

average, moving

Mavg function, 2-29, 5-69

B

bottom values

TSMinN function, 5-113

bulk loading of time series data, 3-10

consistency, 2-20, 3-10

C

D

data cartridge

definition, 1-1

datatypes

time series, 2-23

defining

DeleteExceptions function, 4-7

demos of Time Series cartridge

advanced-developer, 1-4

Developer/2000, 1-4

DeriveExceptions function, 2-9, 5-13

Developer/2000 demo, 1-4

direct path (SQL*Loader), 3-13

Display function, 5-15

DisplayValCal procedure, 4-10

DisplayValTS procedure, 5-18

division

TSDivide function, 5-101

E

EqualCals function, 4-17

error messages, A-1

exceptions, 2-5

ExtractCal function, 5-26

ExtractDate function, 5-28

extraction functions, 2-26

ExtractTable function, 5-30

ExtractValue function, 5-32

F

Fill function, 5-34

First function, 5-40

FirstN function, 5-42

functions

calendar, 2-20, 4-1

CombineCals, 4-2

DeleteExceptions, 4-7

DeriveExceptions, 2-9, 5-13

DisplayValCal procedure, 4-10

DisplayValTS procedure, 5-18

EqualCals, 4-17

ExtractCal, 5-26

ExtractDate, 5-28

ExtractTable, 5-30

ExtractValue, 5-32

GetDatedElement, 5-44

GetNthElement, 5-46

GetOffset, 4-20

GetSeries, 5-48

InsertExceptions, 4-23

IntersectCals, 4-27

InvalidTimeStampsBetween, 4-31

IsValidCal, 4-34

IsValidDate, 4-40

IsValidTS, 5-51

NumInvalidTimeStampsBetween, 4-43

NumOffExceptions, 4-46

NumOnExceptions, 4-49

NumTimeStampsBetween, 4-52

OffsetDate, 4-55

ScaleupAvg, 5-76

ScaleupCount, 5-78

ScaleupFirst, 5-80

ScaleupLast, 5-82

ScaleupMax, 5-84

ScaleupMin, 5-86

ScaleupSum, 5-88

SetPrecision, 4-58

time scaling, 2-31, 5-1

time series, 2-23, 5-1

TimeStampsBetween, 4-61

TrimSeries, 5-90

TSDivide, 5-101

TSMedian, 5-109

TSMultiply, 5-115

TSStdDev, 5-121

TSSubtract, 5-123

TSVariance, 5-129

UnionCals, 4-65

VallidateCal, 4-69

VallidateTS, 5-131

G

GetDatedElement function, 5-44

GetNthElement function, 5-46

GetOffset function, 4-20

GetSeries function, 5-48

H

highest values

I

incremental loading of time series data, 3-12

InsertExceptions function, 4-23

installation of the cartridge, 1-3

instance-based interface, 2-13

INSTEAD OF triggers, 3-4

IntersectCals function, 4-27

InvalidTimeStampsBetween function, 4-31

irregular time series, 2-2, 2-6

IsValidCal function, 4-34

IsValidDate function, 4-40

IsValidTS function, 5-51

K

kit installation, 1-3

L

Lag function, 5-59

Last function, 5-62

LastN function, 5-64

Lead function, 5-66

loading

time series data, 3-9

lowest values

M

Mavg function, 2-29, 5-69

maximum

TSMax function, 5-105

median

TSMedian function, 5-109

messages

metadata for usage demo, 1-6, 2-16

minimum

TSMin function, 5-111

moving average

Mavg function, 2-29, 5-69

moving sum

Msum function, 2-29, 5-72

Msum function, 2-29, 5-72

multiplication

TSMultiply function, 5-115

TSProd function, 5-119

N

null operand semantics, 2-24

NumInvalidTimeStampsBetween function, 4-43

NumOffExceptions function, 4-46

NumOnExceptions function, 4-49

NumTimeStampsBetween function, 4-52

O

P

package names

public synonyms for, 1-4

purified timestamps, 2-19

PRO*C/C++ demo, 1-4

procedures

DisplayValCal, 4-10

DisplayValTS, 5-18

product

TSAvg function, 5-119

public synonyms for package names, 1-4

purified timestamps, 2-19

R

reference-based interface, 2-15

reference-based view, 1-6, 2-16

regular time series, 2-1

S

Scaleup function, 5-74

ScaleupAvg function, 5-76

ScaleupCount function, 5-78

ScaleupFirst function, 5-80

ScaleupLast function, 5-82

ScaleupMax function, 5-84

ScaleupMin function, 5-86

ScaleupSum function, 5-88

security view, 1-6, 2-16, 3-4

semantics

null operands, 2-24

off-exception operands, 2-25

server output, setting, 5-16

SET SERVEROUTPUT ON statement, 5-16

SetPrecision function, 4-58

shift functions, 2-27

SQL formatting functions, 2-27

SQL*Loader utility, 3-9

bulk loading, 3-10

conventional and direct paths, 3-13

incremental loading, 3-12

standard deviation

TSStdDev function, 5-121

stockdemo_metadata table, 1-6, 2-16

stockdemo_sv security view, 1-6, 2-16

stockdemo_ts reference-based view, 1-6, 2-16

subtraction

TSSubtract function, 5-123

sum

TSSum function, 5-127

sum, moving

Msum function, 2-29, 5-72

synonyms

public (package names), 1-4

T

U

UnionCals function, 4-65

usage demo, 1-4

tables and views, 1-6, 2-16

V

ValidateCal function, 4-69

ValidateTS function, 5-131

validating

calendar, 4-34, 4-69

time series, 3-11, 5-51, 5-131

variance

TSVariance function, 5-129

Copyright © 1997 Oracle Corporation.
All Rights Reserved.