Untitled

README.txt -

ORACLE8 SERVER TIME SERIES CARTRIDGE RELEASE INFORMATION

VERSION 8.0.5.0.0

=======================

Contents

========

INTERFACE CHANGES IN THIS RELEASE *** Important ***

Warnings

Installation Procedures

Quotas for Running Time Series Cartridge

Installing the Demo

Bugs Fixed This Release

INTERFACE CHANGES IN THIS RELEASE

=================================

******** IMPORTANT ********

Current plans for the next release of this product require that the

interface to the CALENDAR.SetPrecision function change.

Version 8.0.4 Interface :

CALENDAR.SetPrecision(tstamp IN DATE, frequency IN INTEGER) return DATE

New Interface :

CALENDAR.SetPrecision(cal IN ORDSYS.ORDTCalendar, tstamp IN DATE) return DATE

To clarify, the current frequency based interface is being replaced

with an interface which uses a calendar. And it should be noted that

in order to be consistent with the other functions in the CALENDAR

package, the input calendar will be the first argument to the

function and the input timestamp will become the second argument.

The semantics of the two functions are the same, but based on current

plans for our next release, the frequency will no longer be sufficient

to correctly determine a "precise" timestamp.

The old style interface will NOT be supported beyond this release.

Users are encouraged to examine their current usage of this function

and migrate to the new interface as soon as possible.

In particular, users are reminded to examine any triggers they

currently use to ensure consistency of updates to their time series

data. In our 8.0.4 usage demo we included use of CALENDAR.SetPrecision

in our sample triggers. Users may now wish to examine our updated

usage demo. It no longer makes use of CALENDAR.SetPrecision in the

triggers and includes certain other improvements to the triggers.

******** IMPORTANT ********

Warnings

========

The Time Series Cartridge is installed under the database user ORDSYS. This

user is created during installation and is subject to change in future

beta or production releases.

THE FUNCTIONS, PACKAGES AND TYPES SUPPLIED BY THIS PACKAGE AND ITS EXTERNAL

INTERFACE ARE RESERVED BY ORACLE AND ARE SUBJECT TO CHANGE IN FUTURE RELEASES.

THESE PACKAGES MUST NOT BE MODIFIED BY THE CUSTOMER. DOING SO

COULD CAUSE INTERNAL ERRORS AND SECURITY VIOLATIONS IN THE DBMS.

If you created database objects during the installation of the Time Series

Cartridge, the password for the ORDSYS user may have been written to the log

file. Please check your installation log files for this and other important

information.

=======================

Installation Procedures

=======================

For Solaris, users have the option of installing the entire cartridge

including its database components automatically from within the

Oracle Installer. To do so, users simply need to install Oracle8 RDBMS,

the PL/SQL option, the Time Series Cartridge, and any other options

as appropriate, making sure to select the Create DB Objects option.

This section describes the steps required to manually install the

Time Series Cartridge and is intended for those wishing to custom craft

their database installation, or those simply wishing to better understand

the Time Series installation process:

1 Cartridge Related Installation Decisions

During the installation process you will need to create

ORDSYS as a user for Oracle cartridges, if it does not already

exist. This user ID is the standard Oracle database account

with special privileges for data cartridges.

Users will need to decide on a password for the ORDSYS user.

2 Software Installation

Minimally, the following software components must be installed:

Oracle8 Enterprise Edition (RDBMS), PL/SQL (on platforms on which

it is a separate installation option), and the Oracle8 Time Series

Cartridge.

This software may be installed all at once, or the cartridge can

be added to an existing Oracle8 Enterprise Edition version 8.0.4

installation which includes PL/SQL.

3 Create and Startup the Database

The details of manual database creation are outside of the scope

of this README. Please refer to the Oracle8 Installation and

Configuration Guide for your operating system and to the Oracle8

Server Administrator's Guide and Server Concepts manuals for

detailed information about database creation and startup.

4 Create the ORDSYS Account If Needed (It may already exist.)

As DBA, execute the following:

SVRMGR> create user ORDSYS identified by <ORDSYS password>;

5 Set Privileges for ORDSYS Account

As DBA, execute the following:

SVRMGR> grant connect,resource,create library to ORDSYS;

6 Install the Time Series Cartridge types and stored procedures:

SVRMGR> connect ORDSYS/<ORDSYS password>

SVRMGR> @<ORACLE_HOME>\ord80\ts\admin\ordtinst.sql

where <ORACLE_HOME> is the ORACLE_HOME directory.

Note: Execute privileges will be granted to PUBLIC for all Time Series

types and packages.

=======================

Quotas for Running Time Series Cartridge

========================================

It is recommended that "shared_pool_size" in the init.ora be set to a

large setting (at least 8000000). For this quota to take affect you

need to shutdown and restart the server. This large value is

necessary to efficiently manage the large number of PL/SQL stored

procedures used by the cartridge.

=======================

Installing the Demo

===================

Once you have installed the Time Series cartridge, and set the

recommended "shared_pool_size" quota, you may choose to

install the Time Series cartridge demos.

The Time Series demo files are located in <ORACLE_HOME>\ord80\ts\demo.

This directory contains several demos each in its own subdirectory.

The "usage" demo shows how to build a time series object and call time

series functions. The "extend" demo shows how to write and

add customized time series functions. The "proc" demo demonstrates

accessing data stored with the cartridge using Pro*C. Similarly,

the "oci" demo demonstrates accessing data via the Oracle Call

Interface. And finally the "dev2k" demo includes a Developer 2000

form which retrieves data using the cartridge.See README.txt in the demo

directory for more information. Also see the README.txt file

in each demo directory for detailed information about that demo.

All demos utilize the context established by the "usage" demo, so

one will want to run it first to create sample time series schemas.

=======================

Bugs Fixed This Release

=======================

Bug # 566951

------------

In 8.0.4 when a user connected to the database in server manager,

executed a time series function, and issued another connect statement

in the same session, subsequent time series functions could cause

internal errors. This problem has been corrected.

Bug # 590783

------------

Excessive limitations on the lengths of the pattern and exception lists

have been corrected.

Bug # 636970

------------

Time series functions MaxN and MinN now correctly ignore NULLS

found in the input time series.

Bug # 631635

------------

Calendar functions NumTimeStampsBetween and NumInvalidTimeStampsBetween

now correctly handle imprecise dates passed as input parameters.

Bug # 631352

------------

Calendar function InvalidTimeStampsBetween now correctly handles

imprecise dates passed as input parameters.

Bug # 631393

------------

Lead function now raises a more appropriate error message when

called with an invalid target date for leading.

END OF README.txt