Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Oracle 11g - What would be the equivalent to ordsys.timeseries from Oracle 8?

71 views
Skip to first unread message

Jiri Pik

unread,
Feb 28, 2012, 11:30:41 AM2/28/12
to
I am looking at as fast times series implementation as possible and in
version 8, there used to be a ordsys.timeseries package, see
http://www.iselfschooling.com/Free_Oracle_Training/04_Advanced/03_Articles_3/03_Articles_2/lesson32.html
or http://docs.oracle.com/cd/A64702_01/doc/cartridg.805/a57501/ts_tsuse.htm.

What would be the equivalent in Oracle 11g, pls?

Can you recommend any other standard Oracle package for superfast time
series operations?

thanks!

Jiri Pik, ji...@jiripik.com
Web: http://jiripik.com, LinkedIn: http://www.linkedin.com/in/jiripik,
Twitter: http://twitter.com/@JiriPik

John Hurley

unread,
Feb 28, 2012, 1:39:58 PM2/28/12
to
Jiri:

# Can you recommend any other standard Oracle package for superfast
time series operations?

I am more of an OLTP guy than analystics but there is a whole bunch of
stuff now builtin to the ( proprietary Oracle sql extensions to the
SQL standards ) but probably is immediately useful in a query.

If I were you and unless you give us here a complete example of what
you are trying to do specifically think about checking out the 11.2
Data Warehousing Guide perhaps.

Like here maybe ... http://docs.oracle.com/cd/E11882_01/server.112/e25554/analysis.htm#i1007779

Jiri Pik

unread,
Mar 3, 2012, 4:01:12 AM3/3/12
to
Thank you,
0 new messages