Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: How to express SQL3/OLAP analysis functions by ORACLE9iR2 DML ?

Re: How to express SQL3/OLAP analysis functions by ORACLE9iR2 DML ?

From: Jack Dull <jack_dull_at_sina.com>
Date: Sat, 10 May 2003 16:26:40 +0800
Message-ID: <b9id8g$271o$1@mail.cn99.com>


Hi, Bob Badour,

    Thanks for your reply.

    In the context of SQL enviornment, DML is refer to as update, insert and delete actions. But 'ORACLE9.2 OLAP DML' is a brand new language for multidimensional analysis. It is only used in 'Analysis Workspace'.

Jack dull

"Bob Badour" <bbadour_at_golden.net> wrote in message news:EVZua.178$4v4.52127813_at_mantis.golden.net...
> "firegoddess" <dr_zhhl_at_sina.com> wrote in message
> news:b9fs8o$5ud$1_at_mail.cn99.com...
> > hi, all:
> >
> > SQL3/OLAP have introduced many powerful analysis functions for OLAP,
> > such as Ranking, windowing aggregate, LAG/LEAD and etc. Now, they are
> > supported by ORACLE9iR2 data warehouses. Meanwhile ORACLE developed
> another
> > multidimensional query language DML for ORACLE9iR2 multidimensional
> analysis
> > engine 'analysis workspace'. I am not familiar with DML. My questions is
> > that whether the functionality provided by SQL3/OLAP is supported by DML
> in
> > the way of multdimensional paradigm or not? Especially 'windowing
> > aggregate'. and How ?
>
> Usually, DML, ie. data manipulation language, refers to those parts of SQL
> that allow one to manipulate data: UPDATE, INSERT, SELECT, DELETE. Those
> parts of SQL that allow one to define the objects in the database are
called
> DDL, ie. data definition language: CREATE, ALTER, DROP etc.
>
> Is this really a new language or just a term you have never encountered
> before?
>
>
Received on Sat May 10 2003 - 03:26:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US