Oracle8i Time Series User's Guide
Release 8.1.5

A67294-01

Library

Product

Contents

Index

Prev Next

B
Oracle8i Time Series Metadata Views

This appendix describes the views that Oracle8i Time Series uses to store information about time series schema objects:

These views are created when Oracle8i Time Series is installed, and they are updated when time series schema objects are created, deleted, or altered.

Access to these views is determined as follows:

You can query these views to get information about time series schema objects. For example, to display the available information about all time series schemas, enter the following query:

SELECT * from ALL_TIMESERIES_GROUPS;

In addition to examining these views, you can examine certain standard Oracle dictionary views for metadata relating to specific schema names. For example, the following queries return names of objects associated with any time series schemas with names containing MYTS:

SELECT table_name   from USER_TABLES   where table_name like 'MYTS%';
SELECT trigger_name from USER_TRIGGERS where trigger_name like 'MYTS%';
SELECT view_name    from USER_VIEWS    where view_name like 'MYTS%';
SELECT table_name   from USER_OBJECT_TABLES where table_name like 'MYTS%';

For information about standard Oracle dictionary views, see the Oracle8i Reference manual.

B.1 View Definitions

This section shows the definitions of the Oracle8i Time Series metadata views.

For explanations of the columns in these views, see Section B.2.

B.1.1 ALL_TIMESERIES_xxx View Definitions

The following code example shows the definitions of the ALL_TIMESERIES_GROUPS, ALL_TIMESERIES_OBJS, and ALL_TIMESERIES_COLS views:

SVRMGR> DESCRIBE ALL_TIMESERIES_GROUPS;
Column Name                    Null?    Type
------------------------------ -------- ----
OWNER                                   VARCHAR2(30)
GROUP_NAME                              VARCHAR2(30)
STORAGE_MODEL                           VARCHAR2(30)
DESCRIPTION                             VARCHAR2(4000)

SVRMGR> DESCRIBE ALL_TIMESERIES_OBJS;
Column Name                    Null?    Type
------------------------------ -------- ----
OWNER                                   VARCHAR2(30)
GROUP_NAME                              VARCHAR2(30)
OBJ_NAME                                VARCHAR2(30)
OBJ_TYPE                                VARCHAR2(30)
TS_OBJ_TYPE                             VARCHAR2(30)
OWNED                                   CHAR(1)
STORAGE_MODEL                           VARCHAR2(30)
DESCRIPTION                             VARCHAR2(4000)

SVRMGR> DESCRIBE ALL_TIMESERIES_COLS;
Column Name                    Null?    Type
------------------------------ -------- ----
OWNER                          NOT NULL VARCHAR2(30)
GROUP_NAME                     NOT NULL VARCHAR2(30)
TS_OBJ_TYPE                    NOT NULL VARCHAR2(30)
VIEW_NAME                      NOT NULL VARCHAR2(30)
COLUMN_NAME                    NOT NULL VARCHAR2(30)
DATA_TYPE                      NOT NULL VARCHAR2(106)
DATA_LENGTH                             NUMBER
DATA_PRECISION                          NUMBER
DATA_SCALE                              NUMBER
IS_TSNAME                      NOT NULL CHAR(1)
IS_TSTAMP                      NOT NULL CHAR(1)
IS_TSVALUE                     NOT NULL CHAR(1)
COLUMN_ID                      NOT NULL NUMBER

B.1.2 DBA_TIMESERIES_xxx View Definitions

The following code example shows the definitions of the DBA_TIMESERIES_GROUPS, DBA_TIMESERIES_OBJS, and DBA_TIMESERIES_COLS views:

SVRMGR> DESCRIBE DBA_TIMESERIES_GROUPS;
Column Name                    Null?    Type
------------------------------ -------- ----
OWNER                          NOT NULL VARCHAR2(30)
GROUP_NAME                     NOT NULL VARCHAR2(30)
STORAGE_MODEL                  NOT NULL VARCHAR2(30)
DESCRIPTION                             VARCHAR2(4000)

SVRMGR> DESCRIBE DBA_TIMESERIES_OBJS;
Column Name                    Null?    Type
------------------------------ -------- ----
OWNER                          NOT NULL VARCHAR2(30)
GROUP_NAME                     NOT NULL VARCHAR2(30)
OBJ_NAME                       NOT NULL VARCHAR2(30)
OBJ_TYPE                       NOT NULL VARCHAR2(30)
TS_OBJ_TYPE                    NOT NULL VARCHAR2(30)
OWNED                          NOT NULL CHAR(1)
STORAGE_MODEL                  NOT NULL VARCHAR2(30)
DESCRIPTION                             VARCHAR2(4000)

SVRMGR> DESCRIBE DBA_TIMESERIES_COLS;
Column Name                    Null?    Type
------------------------------ -------- ----
OWNER                          NOT NULL VARCHAR2(30)
GROUP_NAME                     NOT NULL VARCHAR2(30)
TS_OBJ_TYPE                    NOT NULL VARCHAR2(30)
VIEW_NAME                      NOT NULL VARCHAR2(30)
COLUMN_NAME                    NOT NULL VARCHAR2(30)
DATA_TYPE                      NOT NULL VARCHAR2(106)
DATA_LENGTH                             NUMBER
DATA_PRECISION                          NUMBER
DATA_SCALE                              NUMBER
IS_TSNAME                      NOT NULL CHAR(1)
IS_TSTAMP                      NOT NULL CHAR(1)
IS_TSVALUE                     NOT NULL CHAR(1)
COLUMN_ID                      NOT NULL NUMBER

B.1.3 USER_TIMESERIES_xxx View Definitions

The following code example shows the definitions of the USER_TIMESERIES_GROUPS, USER_TIMESERIES_OBJS, and USER_TIMESERIES_COLS views:

SVRMGR> DESCRIBE USER_TIMESERIES_GROUPS;
Column Name                    Null?    Type
------------------------------ -------- ----
GROUP_NAME                     NOT NULL VARCHAR2(30)
STORAGE_MODEL                  NOT NULL VARCHAR2(30)
DESCRIPTION                             VARCHAR2(4000)

SVRMGR> DESCRIBE USER_TIMESERIES_OBJS;
Column Name                    Null?    Type
------------------------------ -------- ----
GROUP_NAME                     NOT NULL VARCHAR2(30)
OBJ_NAME                       NOT NULL VARCHAR2(30)
OBJ_TYPE                       NOT NULL VARCHAR2(30)
TS_OBJ_TYPE                    NOT NULL VARCHAR2(30)
OWNED                          NOT NULL CHAR(1)
STORAGE_MODEL                  NOT NULL VARCHAR2(30)
DESCRIPTION                             VARCHAR2(4000)

SVRMGR> DESCRIBE USER_TIMESERIES_COLS;
Column Name                    Null?    Type
------------------------------ -------- ----
GROUP_NAME                     NOT NULL VARCHAR2(30)
TS_OBJ_TYPE                    NOT NULL VARCHAR2(30)
VIEW_NAME                      NOT NULL VARCHAR2(30)
COLUMN_NAME                    NOT NULL VARCHAR2(30)
DATA_TYPE                      NOT NULL VARCHAR2(106)
DATA_LENGTH                             NUMBER
DATA_PRECISION                          NUMBER
DATA_SCALE                              NUMBER
IS_TSNAME                      NOT NULL CHAR(1)
IS_TSTAMP                      NOT NULL CHAR(1)
IS_TSVALUE                     NOT NULL CHAR(1)
COLUMN_ID                      NOT NULL NUMBER

B.2 Column Descriptions

This section describes the columns in the Oracle8i Time Series metadata views.

The corresponding ALL_TIMESERIES_xxx, DBA_TIMESERIES_xxx, and USER_TIMESERIES_xxx views have the same columns, except that the ALL_TIMESERIES_xxx and DBA_TIMESERIES_xxx views also include owner as the first column. The USER_TIMESERIES_xxx views do not contain an owner column.

B.2.1 xxx_TIMESERIES_GROUPS Columns

Table B-1 describes the columns in the ALL_TIMESERIES_GROUPS, DBA_TIMESERIES_GROUPS, and USER_TIMESERIES_GROUPS, views. Note that owner is not included in the USER_TIMESERIES_GROUPS view.

Table B-1 xxx_TIMESERIES_GROUPS Columns
Column Name  Data Type  Explanation 

owner  

VARCHAR2(30)  

Identifies the schema under which the time series schema objects are defined.  

group_name  

VARCHAR2(30)  

Contains the name of the time series schema, which is also the name of the time series object relational view (flat storage model) or object view (object storage model).  

storage_model  

VARCHAR2(30)  

Contains FLAT for flat storage model or OBJECT for nested table storage.  

description  

VARCHAR2(4000)  

Optional descriptive comment.  

B.2.2 xxx_TIMESERIES_COLS Columns

Table B-2 describes the columns in the ALL_TIMESERIES_COLS, DBA_TIMESERIES_COLS, and USER_TIMESERIES_COLS, views. Note that owner is not included in the USER_TIMESERIES_COLS view.

Table B-2 xxx_TIMESERIES_COLS Columns
Column Name  Data Type  Explanation 

owner  

VARCHAR2(30)  

Identifies the schema under which the time series schema objects are defined.  

group_name  

VARCHAR2(30)  

Contains the name of the time series schema, which is also the name of the time series object relational view (flat storage model) or object view (object storage model).  

ts_obj_type  

VARCHAR2(30)  

Contains RELATIONAL VIEW for a relational view or OBJECT RELATIONAL VIEW for an object view.  

view_name  

VARCHAR2(30)  

Name of the view.  

column_name  

VARCHAR2(30)  

Name of the column in the view (for example, open, close, tstamp, ticker, volume using the flat storage model).  

data_type  

VARCHAR2(106)  

Data type of column_name.  

data_length  

NUMBER  

Maximum length in bytes of column_name data.  

data_precision  

NUMBER  

The precision of column_name (if numeric), that is, the maximum number of digits permitted to the left of the decimal point.  

data_scale  

NUMBER  

The scale of column_name (if numeric), that is, the number of digits to the right of the decimal point.  

is_tsname  

CHAR(1)  

Contains Y if column_name is the time series name; contains N if column_name is not the time series name.  

is_tstamp  

CHAR(1)  

Contains Y if column_name is the timestamp column; contains N if column_name is not the timestamp column.  

is_tsvalue  

CHAR(1)  

Contains Y if column_name is a data value column; contains N if column_name is not a data value column.  

column_id  

NUMBER  

Internally assigned ID number.  

B.2.3 xxx_TIMESERIES_OBJS Columns

Table B-3 describes the columns in the ALL_TIMESERIES_OBJS, DBA_TIMESERIES_OBJS, and USER_TIMESERIES_OBJS, views. Note that owner is not included in the USER_TIMESERIES_COLS view.

Table B-3 xxx_TIMESERIES_OBJS Columns
Column Name  Data Type  Explanation 

owner  

VARCHAR2(30)  

Identifies the schema under which the time series schema objects are defined.  

group_name  

VARCHAR2(30)  

Contains the name of the time series schema, which is also the name of the time series object relational view (flat storage model) or object view (object storage model).  

obj_name  

VARCHAR2(30)  

Name of the Oracle DDL object.  

obj_type  

VARCHAR2(30)  

Type of Oracle DDL object (for example, TABLE or VIEW).  

ts_obj_type  

VARCHAR2(30)  

Type of Oracle time series object See Table B-4 for a list of ts_obj_type values.  

owned  

VARCHAR2(1)  

Contains Y if the object was created by a TSTools procedure; contains N if was not originally created by a TSTools procedure.  

storage_model  

VARCHAR2(30)  

Indicates the storage model: FLAT or OBJECT.  

description  

VARCHAR2(4000)  

Optional descriptive comment.  

Table B-4 lists the values that the ts_obj_type column in Table B-3 can contain.

Table B-4 ts_obj_type Column Values
Value  Explanation 

CALENDAR TABLE  

Calendar table in the flat storage model.  

DETAIL TABLE  

Detail table in the flat storage model.  

MAP TABLE  

Map table in the flat storage model.  

OBJECT RELATIONAL VIEW  

Time series view for time series and time scaling functions in the flat storage model.  

OBJECT TABLE  

Time series table in the object storage model.  

OBJECT VIEW  

Time series view for time series and time scaling functions in the object storage model.  

OBJECT VIEW NT TRIGGER  

Trigger on the object view (object storage model) for nested table insert, update, and delete operations.  

OBJECT VIEW TRIGGER  

Trigger on the object view (object storage model) for object insert and update operations.  

RELATIONAL VIEW  

Relational view for the flat storage model or object storage model.  

RELATIONAL VIEW TRIGGER  

Trigger on the relational view (flat or object storage model) for relational insert, update, and delete operations.  

STORAGE TABLE  

Nested table storage for the nested table (object storage model).  




Prev

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index