B
Oracle8i Time Series Metadata Views

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

ALL_TIMESERIES_GROUPS
ALL_TIMESERIES_OBJS
ALL_TIMESERIES_COLS
DBA_TIMESERIES_GROUPS
DBA_TIMESERIES_OBJS
DBA_TIMESERIES_COLS
USER_TIMESERIES_GROUPS
USER_TIMESERIES_OBJS
USER_TIMESERIES_COLS

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:

ALL_TIMESERIES_xxx views are accessible if you can use the time series from your schema. To use the time series, you must have been granted select privilege on the object relational view, the detail table, and the calendar table. Moreover, for ALL_TIMESERIES_OBJS, the corresponding ALL_xxx views must be accessible. For example, to access the map table as an object in ALL_TIMESERIES_OBJS, you must be able to access the time series and to access the map table in ALL_TABLES.
DBA_TIMESERIES_xxx views are accessible if you have been granted either or both of the following roles: DBA or TIMESERIES_DBA.
USER_TIMESERIES_xxx views are accessible if the objects have been created under your schema.

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).

B Oracle8i Time Series Metadata Views