Oracle8 Time Series Cartridge User's Guide
Release 8.0.4
A57501-01

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introduction

1.1 Data Cartridges

1.2 Object Relational Technology

1.3 Storing and Accessing Data

1.4 Installing the Kit

1.5 Creating Public Synonyms for Time Series Packages

1.6 Time Series Cartridge Demos (Demonstrations)

1.6.1 Running the Usage Demo

1.6.2 Usage Demo Files

1.6.3 Tables and Views in the Usage Demo

2 Time Series Concepts

2.1 Overview of Time Series Data

2.1.1 Data Generation for a Time Series

2.1.2 Historical Data

2.2.1 Frequency and Precision

2.2.2 Calendar Datatypes

2.2.3 Overview of Calendar Definition

2.2.4 Deriving Calendar Exceptions from Time Series Data

2.3 Time Series Cartridge Architecture

2.4 Storage of Time Series Data

2.4.1 Flat IOT Storage

2.5 Interfaces to Time Series and Time Scaling Functions

2.5.1 Instance-Based Interface

2.5.2 Reference-Based Interface

2.6 Consistency of Time Series Data

2.6.1 Rules for Time Series Consistency

2.6.2 Enforcing Time Series Consistency with Security Views

2.6.3 Bulk Loading and Consistency

2.7 Calendar Functions

2.7.1 End-User Functions

2.7.2 Product-Developer Functions

2.8 Time Series Functions

2.8.1 Time Series Datatypes

2.8.2 Conventions and Semantics

2.8.3 Extraction, Retrieval, and Trim Functions

2.8.4 Shift Functions

2.8.5 SQL Formatting Functions

2.8.6 Aggregate Functions

2.8.7 Arithmetic Functions

2.8.8 Cumulative Sequence Functions

2.8.9 Moving Average and Sum Functions

2.8.10 Conversion Functions

2.9 Time Scaling Functions

2.9.1 Time Scaling on Collections

2.9.2 Time Scaling in the GROUP BY Clause

3 Time Series Usage

3.1 Using the Cartridge

3.1.1 Step 1: Create the Underlying Storage (Table)

3.1.2 Step 2: Define a Calendar

3.1.3 Step 3: Load Time Series Data

3.1.4 Step 4: Create a Security View and INSTEAD OF Triggers

3.1.5 Step 5: Create a Reference-Based View

3.1.6 Step 6: Validate Time Series Consistency

3.1.7 Step 7: Formulate Time Series Queries

3.2 Loading Time Series Data

3.2.1 Bulk Loading

3.2.2 Incremental Loading

3.3 Deriving Calendar Exceptions

3.3.1 Deriving Exceptions Using a Calendar and Table of Dates (Approach 1)

3.3.2 Deriving Exceptions Using Two Time Series Parameters (Approach 2)

3.4 Using Product-Developer Functions

4 Calendar Functions: Reference

DeleteExceptions

DisplayValCal Procedure

InsertExceptions

InvalidTimeStampsBetween

NumInvalidTimeStampsBetween

NumOffExceptions

NumOnExceptions

NumTimeStampsBetween

TimeStampsBetween

5 Time Series and Time Scaling Functions: Reference

DeriveExceptions

DisplayValTS Procedure

GetDatedElement

A Error Messages

Copyright © 1997 Oracle Corporation.
All Rights Reserved.