Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!news.cn99.com!not-for-mail
From: "Jack Dull" <jack_dull@sina.com>
Newsgroups: comp.databases.olap,comp.databases.oracle.server,comp.databases.theory
Subject: Re: How to express SQL3/OLAP analysis functions by ORACLE9iR2 DML ?
Date: Sat, 10 May 2003 16:26:40 +0800
Organization: Bentium Ltd. (CN99)
Lines: 41
Message-ID: <b9id8g$271o$1@mail.cn99.com>
References: <b9fs8o$5ud$1@mail.cn99.com> <EVZua.178$4v4.52127813@mantis.golden.net>
Reply-To: "Jack Dull" <jack_dull@sina.com>
NNTP-Posting-Host: 61.150.43.22
X-Trace: mail.cn99.com 1052555344 72760 61.150.43.22 (10 May 2003 08:29:04 GMT)
X-Complaints-To: usenet@news.cn99.com
NNTP-Posting-Date: Sat, 10 May 2003 08:29:04 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Xref: core-easynews comp.databases.olap:20343 comp.databases.oracle.server:185894 comp.databases.theory:26327
X-Received-Date: Sat, 10 May 2003 01:28:30 MST (news.easynews.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@golden.net> wrote in message
news:EVZua.178$4v4.52127813@mantis.golden.net...
> "firegoddess" <dr_zhhl@sina.com> wrote in message
> news:b9fs8o$5ud$1@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?
>
>