• Your Trusted Usenet Provider
  • Secure, Private, Unlimited

Newsgroups Main » Newsgroups Directory » Computers - Non-OS » Databases

OLAP ( comp.databases.olap )
 
From ddruker@netcom.com Thu Aug  4 15:37:13 1994
Path: uunet!bounce-back
From: ddruker@netcom.com (Daniel Druker)
Newsgroups: news.announce.newgroups,news.groups,comp.databases,comp.databases.theory,comp.databases.oracle,comp.databases.sybase,comp.databases.informix,comp.databases.rdb
Subject: RFD: comp.databases.olap
Followup-To: news.groups
Date: 4 Aug 1994 15:16:29 -0400
Organization: The Anderson School at UCLA
Lines: 212
Sender: tale@uunet.uu.net
Approved: tale@uunet.uu.net
Message-ID: <31reqd$5oh@rodan.UU.NET>
NNTP-Posting-Host: rodan.uu.net
Xref: uunet news.announce.newgroups:5446 news.groups:111282 comp.databases:37365 comp.databases.theory:2693 comp.databases.oracle:17234 comp.databases.sybase:9571 comp.databases.informix:11345 comp.databases.rdb:1182

This is a formal Request For Discussion (RFD) regarding the formation of 
the group comp.databases.olap. This usenet newsgroup will discuss 
the issues encompassing On-Line Analytical Processing, as defined by E.F. 
Codd of Codd and Date Inc. in his recent white paper entitled "Providing 
OLAP (On-line Analytical Processing) to User-Analysts: an IT Mandate". 

Topics which could be discussed in this newsgroup include 
multidimensional databases, multidimensional analysis tools and 
techniques, decision support systems (DSS), executive information systems 
(EIS), data warehousing, data marting, and a host of other related 
topics. In general, OLAP is about getting data out of transaction 
procesing systems and turning it into information. A more complete 
description of the Codd paper on OLAP is given below, along with 
additional references that I have found to be helpful on this topic. 

This is ***NOT*** a Call For Votes (CFV).

A CFV will be issued to the newsgroups that this RFD had been posted to 
21 to 30 days from the date that this message first appears. This assumes 
that no serious problems with the newsgroup proposal are noted. Voting 
will be recorded by a neutral third party at the CFV stage.

This message will be reposted weekly until the CFV is issued. 

Any follow-up to this RFD should be directed to news.groups.

Name           : comp.databases.olap
Description    : On-Line Analytical Processing, MDDBMS, DSS, EIS
Status         : Unmoderated
Distribution   : Worldwide
Proposed by    : Daniel Druker (ddruker@netcom.com)
Important Note : I work for Arbor Software, which distributes a product, 
                 Essbase, that will probably be discussed in this      
                 group.  My intent is NOT to use this group as a           
                 marketing tool for Essbase, but rather to provide a      
                 forum for discussion about all OLAP products and      
                 concepts, including competing products and   
                 technologies.


BACKGROUND:
===========

In August 1993, Codd and Date announced a major breakthrough in business 
computing with 12 rules for On-Line Analytial Processing (OLAP).  
Developed by Dr. E.F. Codd, with colleagues Clynch Salley and Sharon 
Codd, OLAP is defined as the dynamic synthesis, analysis, and 
consolidation of large volumes of multidimensional data.  Dr. Codd is the 
founder of Codd and Date, Inc, and is the inventor of the abstract model 
and the 12 rules for relational technology. 

With OLAP, Codd and Date has established and clarified a significant area 
of business data processing and a new product category for 
"multidimensional analysis" -- which are not adequately addressed by the 
current combination of relational systems, spreadsheets, and query tools.  
OLAP involves the dynamic and extensive manipulation of unlimited 
variables of data, and complements On-Line Transaction Processing (OLTP) 
applications.  OLAP applications include rapid consolidations and 
multiple scenarios of forecasts, budgets, product plans, capital asset 
plans, sales analyses, and performance reports.  OLAP products make 
multidimensional analysis easier and more efficient for business users. 


RELEVANCE:
==========

There has recently been an explosion in industry interest in OLAP 
concepts, techniques, and products.  This is reflected both in an 
increase in trade press articles and commercial products which serve this 
segment.  In the comp.databases hierarchy there has been a similar 
increase in postings relating to the issues that would be covered by this 
newsgroup.

It is my belief that the increasing interest has been largely driven by 
the realization that now that we have figured out how to stuff 1000 TPS 
into a database, we need better tools and techniques to get the data out 
in a form that analysts can use to solve business problems.  The intent 
is for this newsgroup to provide a place to centralize issues, expertise, 
and information relating to OLAP. 


CHARTER:
========

The purpose of this group is to discuss all aspects of On-Line Analytical 
Processing. 

This newsgroup will be an unmoderated group.

Topics appropriate to this newsgroup include but are not limited to:

     - Decision Support Systems
     - Executive Information Systems
     - Multidimensional Database Systems
     - Data Warehousing
     - Data Marting
     - Very Large Read-Only Databases
     - Multidimensional Front-End Tools
     - Sparse Data Models and Optimization Techniques
     - Multidimensional Analysis using Relational Systems
     - Limitations of SQL for business analysis
     - Parallelization and other methods to speed processing.
     - End User Query Tools
     - Ad-Hoc Query Tools
     - Business Reporting and Financial Analysis Tools


Commercial products which would probably be discussed in this newsgroup 
include but are not limited to:

Multidimensional / Psuedo-Multidimensional Servers
--------------------------------------------------
Vendor                      Product
Arbor Software              Essbase
Comshare                    FDC, Commander EIS
Dimensional Insight         CrossTarget
IMRS                        Hyperion
IRI                         Express
Kenan Technologies          Acumate, Multiway
Pilot                       Lightship Server


Data Warehouses / Relational Systems
------------------------------------
Vendor                      Product
Digital                     rdb
IBI                         Focus
IBM                         DB2
Informix                    Informix Database
NCR/Terradata               Terradata Enterprise Server
Oracle                      Oracle7
Red Brick                   Warehouse     
Sybase                      System 10
Tandem                      Non-Stop, Himalaya
Unify                       Unify/Uniface


Front Ends providing DSS, EIS, or Multidimensional Analysis
-----------------------------------------------------------
Vendor                      Product
Andyne                      Pablo
Brio                        DataPivot, DataPrism
Business Objects            Business Objects
CA                          Compete, Supercalc
Cognos                      PowerPlay
Information Advantage       Decision Support Suite
IntelligenceWare            Corporate Vision
Lighten                     Advance 
Lotus                       Improv
Metaphor                    DIS 
Pilot                       Lightship
Power Thinking Tools        FreeThink
Sinper                      TM/1 Perspectives


This list was taken from DBMS magazine, and augmented by me wherever 
possible. If there are other products that you think should be added, 
feel free to send me an email and I will add them to the list the next 
time this RFD is posted. 


REQUEST FOR DISCUSSION (RFD) DISTRIBUTION
=========================================

This RFD will be sent to the following newsgroups:
          news.announce.newgroups
          news.groups
          comp.databases
          comp.databases.informix
          comp.databases.oracle
          comp.databases.rdb
          comp.databases.sybase
          comp.databases.theory

This RFD has been proposed in accordance with the guidelines in
"How to Create a Usenet Newsgroup". A large portion of the 
procedural text in this note was taken from a previous RFD written by 
Paul N. Hayton.


BIBLIOGRAPHY AND RECOMMENDED FURTHER READINGS
=============================================

Codd, E.F., "Providing OLAP (On-line Analytical Processing) to User-
     Analysts: An IT Mandate", E.F. Codd and Associates, 1993
     This white paper defined OLAP, and presents business cases for its
     need and usefullness. 

Finkelstein, Richard, "Understanding the need for On-Line Analytical 
     Servers" Performance Computing Inc., 1994
     This white paper discusses the need for a seperate class of servers
     for analytical processing. 

Kimball, Ralph, "What's wrong with SQL", Datamation, June 1994. 
     This article discusses the limitations of SQL for business analysis. 
     It proposes a number of extensions to SQL. There is an associated 
     article which discusses modelling multidimensional data in 
     relational databases, but I couldn't remember its title off the top 
     of my head. 

Kimball, Ralph, Interview in DBMS Magazine, June 1994.
     Ralph discusses his experiences at Red Brick and Metaphor, two of 
     the seminal vendors in the DSS industry. 

Survey of Multidimensional Analysis Tools", DBMS Magazine, June 1994.
     This is a survey of multidimensional servers and products on the 
     market today. 
-- 

                                          Daniel Druker
                                          Arbor Software Corporation
                                          ddruker@netcom.com

From rdippold@qualcomm.com (RonDippold) Wed Aug 31 12:47:18 1994
Path: uunet!bounce-back
From: rdippold@qualcomm.com (Ron "Asbestos" Dippold)
Newsgroups: news.announce.newgroups,news.groups,comp.databases,comp.databases.theory,comp.databases.oracle,comp.databases.sybase,comp.databases.informix,comp.databases.rdb,comp.databases.ingres,comp.client-server
Subject: CFV: comp.databases.olap
Followup-To: poster
Date: 30 Aug 1994 15:18:58 -0400
Organization: Usenet Volunteer Votetakers
Lines: 211
Sender: tale@uunet.uu.net
Approved: tale@uunet.uu.net
Expires: 21 Sep 1994 00:00:00 GMT
Message-ID: <comp.databases.olap-CFV1@uunet.uu.net>
References: <comp.databases.olap-RFD1@uunet.uu.net>
Reply-To: voting@qualcomm.com (Ron Dippold Voting Alias)
NNTP-Posting-Host: rodan.uu.net
Xref: uunet news.announce.newgroups:5554 news.groups:114441 comp.databases:38128 comp.databases.theory:2822 comp.databases.oracle:18406 comp.databases.sybase:10323 comp.databases.informix:11932 comp.databases.rdb:1350 comp.databases.ingres:8536 comp.client-server:5404

                          FIRST CALL FOR VOTES (of 2)
                    unmoderated group comp.databases.olap

Newsgroups line:
comp.databases.olap	Analytical Processing, Multidimensional DBMS, EIS, DSS


Votes must be received by 23:59:59 UTC, 20 September 1994.

This vote is being conducted by a neutral third party.  For voting
questions only contact rdippold@qualcomm.com.  For questions about the
proposed group contact Daniel Druker <ddruker@netcom.com>

CHARTER

This usenet newsgroup will discuss the issues encompassing On-Line
Analytical Processing, as defined by E.F. Codd of Codd and Date Inc.
in his recent white paper entitled "Providing OLAP (On-line Analytical
Processing) to User-Analysts: an IT Mandate".

Topics appropriate to this newsgroup include but are not limited to:
     - Decision Support Systems
     - Executive Information Systems
     - Multidimensional Database Systems
     - Data Warehousing
     - Data Marting
     - Very Large Read-Only Databases
     - Multidimensional Front-End Tools
     - Sparse Data Models and Optimization Techniques
     - Multidimensional Analysis using Relational Systems
     - Limitations of SQL for business analysis
     - Parallelization and other methods to speed processing.
     - End User Query Tools
     - Ad-Hoc Query Tools
     - Business Reporting and Financial Analysis Tools

Topics which could be discussed in this newsgroup include
multidimensional databases, multidimensional analysis tools and
techniques, decision support systems (DSS), executive information
systems (EIS), data warehousing, data marting, and a host of other
related topics. In general, OLAP is about getting data out of
transaction procesing systems and turning it into information. A more
complete description of the Codd paper on OLAP is given below, along
with additional references that I have found to be helpful on this
topic.

Note from Daniel Druker (ddruker@netcom.com): I work for Arbor
Software, which distributes a product, Essbase, that will probably be
discussed in this group.  My intent is NOT to use this group as a
marketing tool for Essbase, but rather to provide a forum for
discussion about all OLAP products and concepts, including competing
products and technologies.


BACKGROUND:
===========
In August 1993, Codd and Date announced a major breakthrough in business 
computing with 12 rules for On-Line Analytial Processing (OLAP).  
Developed by Dr. E.F. Codd, with colleagues Clynch Salley and Sharon 
Codd, OLAP is defined as the dynamic synthesis, analysis, and 
consolidation of large volumes of multidimensional data.  Dr. Codd is the 
founder of Codd and Date, Inc, and is the inventor of the abstract model 
and the 12 rules for relational technology. 

With OLAP, Codd and Date has established and clarified a significant area 
of business data processing and a new product category for 
"multidimensional analysis" -- which are not adequately addressed by the 
current combination of relational systems, spreadsheets, and query tools.  

OLAP involves the dynamic and extensive manipulation of unlimited 
variables of data, and complements On-Line Transaction Processing (OLTP) 
applications.  OLAP applications include rapid consolidations and 
multiple scenarios of forecasts, budgets, product plans, capital asset 
plans, sales analyses, and performance reports.  OLAP products make 
multidimensional analysis easier and more efficient for business users. 


RELEVANCE:
==========
There has recently been an explosion in industry interest in OLAP 
concepts, techniques, and products.  This is reflected both in an 
increase in trade press articles and commercial products which serve this 
segment.  In the comp.databases hierarchy there has been a similar 
increase in postings relating to the issues that would be covered by this 
newsgroup.

It is my belief that the increasing interest has been largely driven by 
the realization that now that we have figured out how to stuff 1000 TPS 
into a database, we need better tools and techniques to get the data out 
in a form that analysts can use to solve business problems.  The intent 
is for this newsgroup to provide a place to centralize issues, expertise, 
and information relating to OLAP. 


Commercial products which would probably be discussed in this newsgroup 
include but are not limited to:

Multidimensional / Psuedo-Multidimensional Servers
--------------------------------------------------
Vendor                      Product
Arbor Software              Essbase
Comshare                    FDC, Commander EIS
Dimensional Insight         CrossTarget
IMRS                        Hyperion
IRI                         Express
Kenan Technologies          Acumate, Multiway
Pilot                       Lightship Server

Data Warehouses / Relational Systems
------------------------------------
Vendor                      Product
Digital                     rdb
IBI                         Focus
IBM                         DB2
Informix                    Informix Database
NCR/Terradata               Terradata Enterprise Server
Oracle                      Oracle7
Red Brick                   Warehouse     
Sybase                      System 10
Tandem                      Non-Stop, Himalaya
Unify                       Unify/Uniface

Front Ends providing DSS, EIS, or Multidimensional Analysis
-----------------------------------------------------------
Vendor                      Product
Ambit Research              Ark
Andyne                      Pablo
Brio                        DataPivot, DataPrism
Business Objects            Business Objects
CA                          Compete, Supercalc
Cognos                      PowerPlay
Information Advantage       Decision Support Suite
IntelligenceWare            Corporate Vision
Lighten                     Advance 
Lotus                       Improv
Metaphor                    DIS 
Pilot                       Lightship
Power Thinking Tools        FreeThink
SAS Institute               SAS
Sinper                      TM/1 Perspectives
Sycomp Pty Ltd              CorVu


This list was taken from DBMS magazine, and augmented by me wherever 
possible. If there are other products that you think should be added, 
feel free to send me an email and I will add them to the list.


BIBLIOGRAPHY AND RECOMMENDED FURTHER READINGS
=============================================
Codd, E.F., "Providing OLAP (On-line Analytical Processing) to User-
     Analysts: An IT Mandate", E.F. Codd and Associates, 1993
     This white paper defined OLAP, and presents business cases for its
     need and usefullness. 

Finkelstein, Richard, "Understanding the need for On-Line Analytical 
     Servers" Performance Computing Inc., 1994
     This white paper discusses the need for a seperate class of servers
     for analytical processing. 

Kimball, Ralph, and Strehlo, Kevin "What's wrong with SQL", Datamation, 
     June 1994. 
     This article discusses the limitations of SQL for business analysis. 
     It proposes a number of extensions to SQL

Kimball, Ralph and Strehlo, Kevin "Why Decision Support fails and how
     to fix it." Datamation, June 1994. 
     This article discusses modelling multidimensional data in 
     relational databases.

DBMS Magazine Interview "The Doctor of DSS", DBMS Magazine, July 1994.
     Ralph Kimball discusses his experiences at Red Brick and Metaphor,
     two of the seminal vendors in the DSS industry. 

Frank, Maurice, "A drill down analysis of Multidimensional Databases,"
     DBMS Magazine, July  1994.
     This is a survey of multidimensional servers and products on the 
     market today. 

McGill, "Multidimensionality - An alternative database format,"
     April 1994. 
     A detailed theoretical comparison of relational vs. multidimensional
     databases.

Lots of people have emailed asking how to get the Codd and Date and the
Finkelstein Papers. Arbor Software is providing them at no charge. TO
get a copy call 1-800-858-1666 or internationally +44-734-566749. Some
of the other vendors also offer the Codd paper, and numerous other
documents about OLAP. Contact them directly for more information. There
are efforts underway to make the white papers at least available on the
net, but this will take some time. 



HOW TO VOTE

Send MAIL to:   voting@qualcomm.com
Just Replying should work if you are not reading this on a mailing list.

Your mail message should contain one of the following statements:
      I vote YES on comp.databases.olap
      I vote NO on comp.databases.olap

You may also ABSTAIN in place of YES/NO - this will not affect the outcome.
Anything else may be rejected by the automatic vote counting program.  The
votetaker will respond to your received ballots with a personal acknowledge-
ment by mail - if you do not receive one within several days, try again.
It's your responsibility to make sure your vote is registered correctly.

One vote counted per person, no more than one per account. Addresses
and votes of all voters will be published in the final voting results list.

From rdippold@qualcomm.com (RonDippold) Wed Sep  7 16:29:23 1994
Path: uunet!bounce-back
From: rdippold@qualcomm.com (Ron "Asbestos" Dippold)
Newsgroups: news.announce.newgroups,news.groups,comp.databases,comp.databases.theory,comp.databases.oracle,comp.databases.sybase,comp.databases.informix,comp.databases.rdb,comp.databases.ingres,comp.client-server
Subject: 2nd CFV: comp.databases.olap
Supersedes: <comp.databases.olap-CFV1@uunet.uu.net>
Followup-To: poster
Date: 7 Sep 1994 16:12:26 -0400
Organization: Usenet Volunteer Votetakers
Lines: 218
Sender: tale@uunet.uu.net
Approved: tale@uunet.uu.net
Expires: 21 Sep 1994 00:00:00 GMT
Message-ID: <comp.databases.olap-CFV2@uunet.uu.net>
References: <comp.databases.olap-RFD1@uunet.uu.net> <comp.databases.olap-CFV1@uunet.uu.net>
Reply-To: voting@qualcomm.com (Ron Dippold Voting Alias)
NNTP-Posting-Host: rodan.uu.net
Xref: uunet news.announce.newgroups:5598 news.groups:115277 comp.databases:38368 comp.databases.theory:2851 comp.databases.oracle:18757 comp.databases.sybase:10520 comp.databases.informix:12079 comp.databases.rdb:1432 comp.databases.ingres:8657 comp.client-server:5545

                          LAST CALL FOR VOTES (of 2)
                    unmoderated group comp.databases.olap

Newsgroups line:
comp.databases.olap	Analytical Processing, Multidimensional DBMS, EIS, DSS


Votes must be received by 23:59:59 UTC, 20 September 1994.

This vote is being conducted by a neutral third party.  For voting
questions only contact rdippold@qualcomm.com.  For questions about the
proposed group contact Daniel Druker <ddruker@netcom.com>

CHARTER

This usenet newsgroup will discuss the issues encompassing On-Line
Analytical Processing, as defined by E.F. Codd of Codd and Date Inc.
in his recent white paper entitled "Providing OLAP (On-line Analytical
Processing) to User-Analysts: an IT Mandate".

Topics appropriate to this newsgroup include but are not limited to:
     - Decision Support Systems
     - Executive Information Systems
     - Multidimensional Database Systems
     - Data Warehousing
     - Data Marting
     - Very Large Read-Only Databases
     - Multidimensional Front-End Tools
     - Sparse Data Models and Optimization Techniques
     - Multidimensional Analysis using Relational Systems
     - Limitations of SQL for business analysis
     - Parallelization and other methods to speed processing.
     - End User Query Tools
     - Ad-Hoc Query Tools
     - Business Reporting and Financial Analysis Tools

Topics which could be discussed in this newsgroup include
multidimensional databases, multidimensional analysis tools and
techniques, decision support systems (DSS), executive information
systems (EIS), data warehousing, data marting, and a host of other
related topics. In general, OLAP is about getting data out of
transaction procesing systems and turning it into information. A more
complete description of the Codd paper on OLAP is given below, along
with additional references that I have found to be helpful on this
topic.

Note from Daniel Druker (ddruker@netcom.com): I work for Arbor
Software, which distributes a product, Essbase, that will probably be
discussed in this group.  My intent is NOT to use this group as a
marketing tool for Essbase, but rather to provide a forum for
discussion about all OLAP products and concepts, including competing
products and technologies.


BACKGROUND:
===========
In August 1993, Codd and Date announced a major breakthrough in business 
computing with 12 rules for On-Line Analytial Processing (OLAP).  
Developed by Dr. E.F. Codd, with colleagues Clynch Salley and Sharon 
Codd, OLAP is defined as the dynamic synthesis, analysis, and 
consolidation of large volumes of multidimensional data.  Dr. Codd is the 
founder of Codd and Date, Inc, and is the inventor of the abstract model 
and the 12 rules for relational technology. 

With OLAP, Codd and Date has established and clarified a significant area 
of business data processing and a new product category for 
"multidimensional analysis" -- which are not adequately addressed by the 
current combination of relational systems, spreadsheets, and query tools.  

OLAP involves the dynamic and extensive manipulation of unlimited 
variables of data, and complements On-Line Transaction Processing (OLTP) 
applications.  OLAP applications include rapid consolidations and 
multiple scenarios of forecasts, budgets, product plans, capital asset 
plans, sales analyses, and performance reports.  OLAP products make 
multidimensional analysis easier and more efficient for business users. 


RELEVANCE:
==========
There has recently been an explosion in industry interest in OLAP 
concepts, techniques, and products.  This is reflected both in an 
increase in trade press articles and commercial products which serve this 
segment.  In the comp.databases hierarchy there has been a similar 
increase in postings relating to the issues that would be covered by this 
newsgroup.

It is my belief that the increasing interest has been largely driven by 
the realization that now that we have figured out how to stuff 1000 TPS 
into a database, we need better tools and techniques to get the data out 
in a form that analysts can use to solve business problems.  The intent 
is for this newsgroup to provide a place to centralize issues, expertise, 
and information relating to OLAP. 


Commercial products which would probably be discussed in this newsgroup 
include but are not limited to:

Multidimensional / Psuedo-Multidimensional Servers
--------------------------------------------------
Vendor                      Product
Arbor Software              Essbase
Comshare                    FDC, Commander EIS
Dimensional Insight         CrossTarget
IMRS                        Hyperion
IRI                         Express
Kenan Technologies          Acumate, Multiway
Pilot                       Lightship Server

Data Warehouses / Relational Systems
------------------------------------
Vendor                      Product
Digital                     rdb
IBI                         Focus
IBM                         DB2
Informix                    Informix Database
NCR/Terradata               Terradata Enterprise Server
Oracle                      Oracle7
Red Brick                   Warehouse     
Sybase                      System 10
Tandem                      Non-Stop, Himalaya
Unify                       Unify/Uniface

Front Ends providing DSS, EIS, or Multidimensional Analysis
-----------------------------------------------------------
Vendor                      Product
Ambit Research              Ark
Andyne                      Pablo
Brio                        DataPivot, DataPrism
Business Objects            Business Objects
CA                          Compete, Supercalc
Cognos                      PowerPlay
Information Advantage       Decision Support Suite
IntelligenceWare            Corporate Vision
Lighten                     Advance 
Lotus                       Improv
Metaphor                    DIS 
Pilot                       Lightship
Power Thinking Tools        FreeThink
SAS Institute               SAS
Sinper                      TM/1 Perspectives
Sycomp Pty Ltd              CorVu


This list was taken from DBMS magazine, and augmented by me wherever 
possible. If there are other products that you think should be added, 
feel free to send me an email and I will add them to the list.


BIBLIOGRAPHY AND RECOMMENDED FURTHER READINGS
=============================================
Codd, E.F., "Providing OLAP (On-line Analytical Processing) to User-
     Analysts: An IT Mandate", E.F. Codd and Associates, 1993
     This white paper defined OLAP, and presents business cases for its
     need and usefullness. 

Finkelstein, Richard, "Understanding the need for On-Line Analytical 
     Servers" Performance Computing Inc., 1994
     This white paper discusses the need for a seperate class of servers
     for analytical processing. 

Kimball, Ralph, and Strehlo, Kevin "What's wrong with SQL", Datamation, 
     June 1994. 
     This article discusses the limitations of SQL for business analysis. 
     It proposes a number of extensions to SQL

Kimball, Ralph and Strehlo, Kevin "Why Decision Support fails and how
     to fix it." Datamation, June 1994. 
     This article discusses modelling multidimensional data in 
     relational databases.

DBMS Magazine Interview "The Doctor of DSS", DBMS Magazine, July 1994.
     Ralph Kimball discusses his experiences at Red Brick and Metaphor,
     two of the seminal vendors in the DSS industry. 

Frank, Maurice, "A drill down analysis of Multidimensional Databases,"
     DBMS Magazine, July  1994.
     This is a survey of multidimensional servers and products on the 
     market today. 

McGill, "Multidimensionality - An alternative database format,"
     April 1994. 
     A detailed theoretical comparison of relational vs. multidimensional
     databases.

Lots of people have emailed asking how to get the Codd and Date and the
Finkelstein Papers. Arbor Software is providing them at no charge. TO
get a copy call 1-800-858-1666 or internationally +44-734-566749. Some
of the other vendors also offer the Codd paper, and numerous other
documents about OLAP. Contact them directly for more information. There
are efforts underway to make the white papers at least available on the
net, but this will take some time. 



HOW TO VOTE

Send MAIL to:   voting@qualcomm.com
Just Replying should work if you are not reading this on a mailing list.

Your mail message should contain one of the following statements:
      I vote YES on comp.databases.olap
      I vote NO on comp.databases.olap

You may also ABSTAIN in place of YES/NO - this will not affect the outcome.
Anything else may be rejected by the automatic vote counting program.  The
votetaker will respond to your received ballots with a personal acknowledge-
ment by mail - if you do not receive one within several days, try again.
It's your responsibility to make sure your vote is registered correctly.

One vote counted per person, no more than one per account. Addresses
and votes of all voters will be published in the final voting results list.



comp.databases.olap Bounce List - No need to revote
------------------------------------------------------------------------------
linus%zythera.UUCP                                        Robert 'linus' Thona
rick_williams@rwilliams.us.dell.com                        R. Michael Williams

From rdippold@qualcomm.com (RonDippold) Thu Sep 22 22:49:33 1994
Path: uunet!bounce-back
From: rdippold@qualcomm.com (Ron "Asbestos" Dippold)
Newsgroups: news.announce.newgroups,news.groups,comp.databases,comp.databases.theory,comp.databases.oracle,comp.databases.sybase,comp.databases.informix,comp.databases.rdb,comp.databases.ingres,comp.client-server
Subject: RESULT: comp.databases.olap passes 175:25
Supersedes: <comp.databases.olap-CFV2@uunet.uu.net>
Followup-To: news.groups
Date: 22 Sep 1994 21:29:38 -0400
Organization: Usenet Volunteer Votetakers
Lines: 415
Sender: tale@uunet.uu.net
Approved: tale@uunet.uu.net
Message-ID: <comp.databases.olap-RESULT@uunet.uu.net>
References: <comp.databases.olap-RFD1@uunet.uu.net> <comp.databases.olap-CFV1@uunet.uu.net> <comp.databases.olap-CFV2@uunet.uu.net>
NNTP-Posting-Host: rodan.uu.net
Xref: uunet news.announce.newgroups:5672 news.groups:117315 comp.databases:38774 comp.databases.theory:2930 comp.databases.oracle:19474 comp.databases.sybase:11104 comp.databases.informix:12504 comp.databases.rdb:1546 comp.databases.ingres:8959 comp.client-server:5804

                                    RESULT
	 unmoderated group comp.databases.olap passes 175:25

There were 175 YES votes and 25 NO votes, for a total of 200 valid votes. 
There was 200 invalid ballot.

For group passage, YES votes must be at least 2/3 of all valid (YES and NO)
votes.   There also must be at least 100 more YES votes than NO votes. 

There is a five day discussion period after these results are posted.  If no
serious allegations of voting irregularities are raised, the moderator of
news.announce.newgroups will create the group shortly thereafter.


Newsgroups line:
comp.databases.olap	Analytical Processing, Multidimensional DBMS, EIS, DSS


This vote is being conducted by a neutral third party.  For voting
questions only contact rdippold@qualcomm.com.  For questions about the
proposed group contact Daniel Druker <ddruker@netcom.com>

CHARTER

This usenet newsgroup will discuss the issues encompassing On-Line
Analytical Processing, as defined by E.F. Codd of Codd and Date Inc.
in his recent white paper entitled "Providing OLAP (On-line Analytical
Processing) to User-Analysts: an IT Mandate".

Topics appropriate to this newsgroup include but are not limited to:
     - Decision Support Systems
     - Executive Information Systems
     - Multidimensional Database Systems
     - Data Warehousing
     - Data Marting
     - Very Large Read-Only Databases
     - Multidimensional Front-End Tools
     - Sparse Data Models and Optimization Techniques
     - Multidimensional Analysis using Relational Systems
     - Limitations of SQL for business analysis
     - Parallelization and other methods to speed processing.
     - End User Query Tools
     - Ad-Hoc Query Tools
     - Business Reporting and Financial Analysis Tools

Topics which could be discussed in this newsgroup include
multidimensional databases, multidimensional analysis tools and
techniques, decision support systems (DSS), executive information
systems (EIS), data warehousing, data marting, and a host of other
related topics. In general, OLAP is about getting data out of
transaction procesing systems and turning it into information. A more
complete description of the Codd paper on OLAP is given below, along
with additional references that I have found to be helpful on this
topic.

Note from Daniel Druker (ddruker@netcom.com): I work for Arbor
Software, which distributes a product, Essbase, that will probably be
discussed in this group.  My intent is NOT to use this group as a
marketing tool for Essbase, but rather to provide a forum for
discussion about all OLAP products and concepts, including competing
products and technologies.


BACKGROUND:
===========
In August 1993, Codd and Date announced a major breakthrough in business 
computing with 12 rules for On-Line Analytial Processing (OLAP).  
Developed by Dr. E.F. Codd, with colleagues Clynch Salley and Sharon 
Codd, OLAP is defined as the dynamic synthesis, analysis, and 
consolidation of large volumes of multidimensional data.  Dr. Codd is the 
founder of Codd and Date, Inc, and is the inventor of the abstract model 
and the 12 rules for relational technology. 

With OLAP, Codd and Date has established and clarified a significant area 
of business data processing and a new product category for 
"multidimensional analysis" -- which are not adequately addressed by the 
current combination of relational systems, spreadsheets, and query tools.  

OLAP involves the dynamic and extensive manipulation of unlimited 
variables of data, and complements On-Line Transaction Processing (OLTP) 
applications.  OLAP applications include rapid consolidations and 
multiple scenarios of forecasts, budgets, product plans, capital asset 
plans, sales analyses, and performance reports.  OLAP products make 
multidimensional analysis easier and more efficient for business users. 


RELEVANCE:
==========
There has recently been an explosion in industry interest in OLAP 
concepts, techniques, and products.  This is reflected both in an 
increase in trade press articles and commercial products which serve this 
segment.  In the comp.databases hierarchy there has been a similar 
increase in postings relating to the issues that would be covered by this 
newsgroup.

It is my belief that the increasing interest has been largely driven by 
the realization that now that we have figured out how to stuff 1000 TPS 
into a database, we need better tools and techniques to get the data out 
in a form that analysts can use to solve business problems.  The intent 
is for this newsgroup to provide a place to centralize issues, expertise, 
and information relating to OLAP. 


Commercial products which would probably be discussed in this newsgroup 
include but are not limited to:

Multidimensional / Psuedo-Multidimensional Servers
--------------------------------------------------
Vendor                      Product
Arbor Software              Essbase
Comshare                    FDC, Commander EIS
Dimensional Insight         CrossTarget
IMRS                        Hyperion
IRI                         Express
Kenan Technologies          Acumate, Multiway
Pilot                       Lightship Server

Data Warehouses / Relational Systems
------------------------------------
Vendor                      Product
Digital                     rdb
IBI                         Focus
IBM                         DB2
Informix                    Informix Database
NCR/Terradata               Terradata Enterprise Server
Oracle                      Oracle7
Red Brick                   Warehouse     
Sybase                      System 10
Tandem                      Non-Stop, Himalaya
Unify                       Unify/Uniface

Front Ends providing DSS, EIS, or Multidimensional Analysis
-----------------------------------------------------------
Vendor                      Product
Ambit Research              Ark
Andyne                      Pablo
Brio                        DataPivot, DataPrism
Business Objects            Business Objects
CA                          Compete, Supercalc
Cognos                      PowerPlay
Information Advantage       Decision Support Suite
IntelligenceWare            Corporate Vision
Lighten                     Advance 
Lotus                       Improv
Metaphor                    DIS 
Pilot                       Lightship
Power Thinking Tools        FreeThink
SAS Institute               SAS
Sinper                      TM/1 Perspectives
Sycomp Pty Ltd              CorVu


This list was taken from DBMS magazine, and augmented by me wherever 
possible. If there are other products that you think should be added, 
feel free to send me an email and I will add them to the list.


BIBLIOGRAPHY AND RECOMMENDED FURTHER READINGS
=============================================
Codd, E.F., "Providing OLAP (On-line Analytical Processing) to User-
     Analysts: An IT Mandate", E.F. Codd and Associates, 1993
     This white paper defined OLAP, and presents business cases for its
     need and usefullness. 

Finkelstein, Richard, "Understanding the need for On-Line Analytical 
     Servers" Performance Computing Inc., 1994
     This white paper discusses the need for a seperate class of servers
     for analytical processing. 

Kimball, Ralph, and Strehlo, Kevin "What's wrong with SQL", Datamation, 
     June 1994. 
     This article discusses the limitations of SQL for business analysis. 
     It proposes a number of extensions to SQL

Kimball, Ralph and Strehlo, Kevin "Why Decision Support fails and how
     to fix it." Datamation, June 1994. 
     This article discusses modelling multidimensional data in 
     relational databases.

DBMS Magazine Interview "The Doctor of DSS", DBMS Magazine, July 1994.
     Ralph Kimball discusses his experiences at Red Brick and Metaphor,
     two of the seminal vendors in the DSS industry. 

Frank, Maurice, "A drill down analysis of Multidimensional Databases,"
     DBMS Magazine, July  1994.
     This is a survey of multidimensional servers and products on the 
     market today. 

McGill, "Multidimensionality - An alternative database format,"
     April 1994. 
     A detailed theoretical comparison of relational vs. multidimensional
     databases.

Lots of people have emailed asking how to get the Codd and Date and the
Finkelstein Papers. Arbor Software is providing them at no charge. TO
get a copy call 1-800-858-1666 or internationally +44-734-566749. Some
of the other vendors also offer the Codd paper, and numerous other
documents about OLAP. Contact them directly for more information. There
are efforts underway to make the white papers at least available on the
net, but this will take some time. 


comp.databases.olap Final Vote Ack

Voted Yes
------------------------------------------------------------------------------
6sigma@netcom.com                                                  Zach Shoher
ack@forte.com                                                   David Ackerman
ambit@cix.compulink.co.uk                                       Ambit Research
andrevw@ideta.nl                                             Andre van Winssen
angelako@ponderosa.is.monash.edu.au                            Miss Angela Koh
Arun.Shah@amail.amdahl.com                                           Arun Shah
ash@plaza.ds.adp.com                                             Ashley Furman
ashutosh@panix.com                                           Ashutosh Joglekar
atuzhili@square1.stern.nyu.edu                              Alexander Tuzhilin
ault@cs.albany.edu                                                    Jim Ault
baumgard@hpocia.sj.hp.com                                    Felix Baumgardner
bh@granby.demon.co.uk                                           Bruce Horrocks
bhenk02@cps.plnin.gmeds.com                                         Brian Henk
bill@REV.RE.uokhsc.edu                                          Bill Standefer
bill@tardis.co.uk                                                William Hails
Bill_Piwonka@ccm.sc.intel.com                                     Bill Piwonka
bonk@positron.med.ge.com                                            Frank Bonk
bumidev.pad@sni.de                                                     bumidev
C.Tattersall@research.ptt.nl                                  Colin Tattersall
carols@strider.andyne.on.ca                                     Carol Sherrard
casey.green@amail.amdahl.com                                                  
ccmail.kenan.com!ramonb@kenan.com                                  Ramon Bueno
CELLER@us.oracle.com                                      CELLER.US.ORACLE.COM
chen@xray.rad.med.umich.edu                                     Sheau-Yen Chen
chev79@ccsun.strath.ac.uk                                              e.keung
cimarron@illustra.com                                          Cimarron Taylor
cklau@hkusub.hku.hk                                                   Andy Lau
colin@scdipc0.ueci.com                                           Colin Mcgrath
cpow@bluecross.on.ca                                              Chuck Powley
cudau@csv.warwick.ac.uk                                          Hank Robinson
cynthia@hpsgcip1.sgp.hp.com                                      Cynthia Leong
daniel@patora.mrec.ar                                        N Daniel Bonesana
dbi@xmission.com                                                     Databases
ddruker@netcom.com                                               Daniel Druker
DMMATT@ccmail.monsanto.com                                                    
Douthat@cris.com                                                              
dproksch@vrx.vhi.com                                                          
drayer@minerva.cis.yale.edu                                     Rebecca Drayer
dsmcquay@nps.navy.mil                                               Dan McQuay
EDRUKER@us.oracle.com                                             Ellie Druker
essm@occuphealth.fi                                                  Essaim oy
face@arizona.edu                                                  Chris Janton
fburstei@ponderosa.is.monash.edu.au                         Dr. Frada Burstein
fermat@indirect.com                                          David Shackelford
fsammet@multicorp.com                                                  fsammet
g3737121@mucc.mahidol.ac.th            Supachai Kanchanapokin - SCCS - 3737121
georges@strider.andyne.on.ca                                    George Scriban
graeme@pyra.co.uk                                               Graeme Sargent
grant@devbn0.triumf.ca                                             Peter Grant
grimes@access.digex.net                                            Seth Grimes
handlman@libre.com                                              Marc Handelman
hans_mueller@il.us.swissbank.com                                  Hans Mueller
harper@aaahq05.aaa.com                                          K. Eric Harper
hharriso@dircon.co.uk                                           Henry Harrison
illya@nest.stu.spb.su                                                         
james@olympus.dosli.govt.nz                                         James Cone
Jan.Diesel@rivm.nl                                                  Jan Diesel
janest@panix.com                                                    John Anest
jasonw@ponderosa.is.monash.edu.au                             Mr. Jason Watson
jcheung@ponderosa.is.monash.edu.au                            Josephine Cheung
jdavis@ccu1.auckland.ac.nz                                      Joseph G Davis
Jean-Claude.Courbon@galaxie.int-evry.fr                    COURBON Jean-Claude
jeffg@loki.engr.sgi.com                                         Jeff C. Glover
jfortt@dorsai.dorsai.org                                          Joseph_Fortt
jgallo01@cps.plnin.gmeds.com                                     John Galloway
jgraves@Eng.Auburn.EDU                                             Jeff Graves
jhcaldwell@amoco.com                                          John H. Caldwell
jhobson@cix.compulink.co.uk                                        John Hobson
jimf@central.shared.com                                           Jim Franklin
jlambert@ca.mdis.com                                              John Lambert
jlee@cs.uml.edu                                                         JP Lee
jmay@ctp.com                                                         Jason May
jms@informix.com                                                              
John@minster.co.uk                                            John Hadjioannou
johnd@goliath.unisys.co.nz                                         John Dobson
johnl@anubis.informix.com                                     Jonathan Leffler
Kant_Patel-CPGN88@email.mot.com                                               
kasmith@wpo.borland.com                                            Kevin Smith
kcochran@nyx10.cs.du.edu                 Keith "Justified And Ancient" Cochran
kcruikshank@arborsoft.com                                                     
keegan@helios.acm.rpi.edu                                  james g. keegan jr.
kenk@winternet.com                                                  Ken Kiefer
kirkwood@strider.andyne.on.ca                                   Scott Kirkwood
kosmas@triton.iesl.forth.gr                                     Giannis Kosmas
L15D@ZFN.UNI-BREMEN.DE                                        Martin Schroeder
lantz@halcyon.com                                                Lantz Rowland
lazlo@is.net                                                         Ken Brown
lehn@informatik.tu-muenchen.de                                 Richard A. Lehn
linus%zythera.UUCP                                        Robert 'linus' Thona
lneustad@utdallas.edu                                        Laurel Neustadter
mannhart@zuv.unizh.ch                                             Leo Mannhart
Manote.N@sunsupport.nectec.or.th                          Manote Nuangchamnong
maraya@sci.kuniv.edu.kw                                      maraya altuwaijri
maraz@ics.forth.gr                                           Manolis Marazakis
Mark.Butler@m.cc.utah.edu                                          Mark Butler
MARK@gumby.tfn.com                   Mark Agulnick-FirstCall R&D-TFS-Boston-MA
MBAPN@rohvm1.rohmhaas.com                                                     
mbm@dsbc.icl.co.uk                                          Malcolm Mladenovic
mcitron@hsc.usc.edu                                                Mark Citron
MCKENNA%OLORIN@BILBO.MGH.HARVARD.EDU                                          
mcolton@illustra.com                                            Malcolm Colton
mgiezen@malamut.GerWin.NET                                         Marc Giezen
MGRICE@fcit-c1.fcit.monash.edu.au                                Michael Grice
mikek@krt.com                                                   Mike Kranzdorf
mjeaton@sandia.gov                                                            
mkimber@globeandmail.ca                                         Michael Kimber
mmt@RedBrick.COM                                          Maxime Taksar KC6ZPS
mpicard@gabriel.resudox.net                                        Marc Picard
MRichardso@shinet01.losangeles.mm1.shl.com          RICHARDSON Marv (SHINET01)
mtaylor@microsoft.com                                        Mark Taylor (Fin)
m_milis@pavo.concordia.ca                                  Marko Milisavljevic
nneuman@mailnet.comshare.com                                       Norm Neuman
nsysdbj@acs.ncsu.edu                                                          
pangea@netcom.com                                                 Dexter Smith
parno@wbst845e.xerox.com                                            Pam Arnold
paula@netcom.com                                                   Paul Ananth
PeepingEd@aol.com                                                             
perrin@cs.tulane.edu                                            Patrick Perrin
phambly@lssec.bt.co.uk                                                        
podonnel@fcit.monash.edu.au                                Mr. Peter O'Donnell
prabha@sickbay.az05.bull.com                          Prabhakar Kandashamy [e]
pramakri@techapp.com                                      Pradeep Ramakrishnan
PROD@VAXC.ERIM.ORG                                                            
qiu@WPI.EDU                                                             Ke Qiu
Ratnadeep_Damle@strategy.com                                   Ratnadeep Damle
rblack@eskimo.com                                                   Tony Black
rhh@tachy.uah.ualberta.ca                                             Roy Hann
Ria.Vandenberghe@rug.ac.be                                    Ria Vandenberghe
richard.spitz@ana.med.uni-muenchen.de                                         
richard.wegener@sstff.mn.org                                   Richard Wegener
Richard@carrot.demon.co.uk                                      Richard Leyton
rick_williams@rwilliams.us.dell.com                        R. Michael Williams
Risto.Jesoi@ingres.fi                         Risto Jesoi, tel. +358-0-5027343
Robert@aeroastro.com                                                    Robert
robert@sybase.com                                                Robert Garvey
Robinson_George/HP-Vancouver_om2@om2.vcd.hp.com                               
ross@informix.com                                                Ross Hagglund
rossix!dgh@openlink.openlink.com                              David Harrington
rscary@bcbso.com                                                    Scott Cary
rufinus@mbe.ece.wisc.edu                                       Jeffrey Rufinus
samk@hpoetc07.sj.hp.com                                              SAM KUMAR
sandwest@lightside.com                                                        
sanjog@baan.nl                                                                
SCANDORA@cmt.anl.gov                                Tony Scandora 708-252-7541
Scott.Allred@NORTH-SUPPLY.SMNOSUP.LANGATE.sprint.com                          
Sean.OSullivan@cs.tcd.ie                                       Sean O'Sullivan
sek@mis.krt.com                                                Susan Kranzdorf
Seth.S.G.GRIMES@DCC-SDD.oecd.fr    Seth GRIMES, DCC/SDD           (Tel (33-1) 
SINHAA@delphi.com                                                             
slsee@ponderosa.is.monash.edu.au                                  Swee Lan See
smaynard@ponderosa.is.monash.edu.au                               Sean Maynard
Smith_Avery/HP-Vancouver_om1@openmail.vcd.hp.com                              
SSANFILI@us.oracle.com                                      Scott San Filippo 
steveg@data-CACHE.COM                                             Steve Gordon
STEVE_MCAFEE_at_PO.BART@smtplink.infores.com                                  
sudhir@nickel.ucs.indiana.edu                                       Sudhir Rao
taoc@pcsdnfs1.eq.gs.com                                               Chun Tao
tcox@netcom.com                                                  Thomas B. Cox
tfl@psp.co.uk                                                     Thomas F Lee
tgorman@mhc.mtholyoke.edu                                      Thomas M Gorman
theobald@asc100.ets.ford.com                                                  
timh@dial.demon.co.uk                                               Tim Holmes
tkmclean@hsv20.pcmail.ingr.com                                McLean, Thomas K
twfox@mmm.com                                                                 
VEI@stud.hsn.no                                                               
vincentd@muug.mb.ca                                  Vincent Edward DiBernardo
walt@mathcs.emory.edu                                                         
wandajp@strider.andyne.on.ca                                WandaJane Phillips
warrenb@WAIRC.GOVT.NZ                                                         
weiqigao@crl.com                                                     Weiqi Gao
yadallee@gAlLiF.ersys.EDmonTON.Ab.Ca                     Dave Shariff Yadallee
yao@cs.columbia.edu                                                  Yulin Yao
yueji@csgo.usc.edu                                                      Yue Ji
yuri@andromeda.rutgers.edu                                Yuri Korostyshevskiy
Yves.Noel@univ-lille1.fr                                             Yves Noel

Voted No
------------------------------------------------------------------------------
brenchn@wam.umd.edu                                         Neil Andrew Brench
catseye@netcom.com                                              Mark Kupferman
ch90096@atlas.central.ntua.gr                         dionisopoulos panagiotis
crouchkp@flidh103.delcoelect.com                              Kenneth P Crouch
cward@Think.COM                                               Christopher Ward
D.W.Wright@bnr.co.uk                                                          
david@election.demon.co.uk                                     David Boothroyd
drew@objy.com                                                             drew
eburger@mason1.gmu.edu                                           Eric W Burger
ewl@panix.com                                                   Emery Lapinski
gt5139c@prism.gatech.edu                                   Pete 'Happy' Thomas
gtd543a@prism.gatech.edu                                                      
jeremy@election.demon.co.uk                                       Jeremy Dixon
joey@cs.wisc.edu                                               Joe Hellerstein
jrm@globalvillag.com                                     John R. MacWilliamson
l.carl.pedersen@Dartmouth.EDU                                 L. Carl Pedersen
M.A.KURA@TEC-BOX.gun.de                                        Marc Andre Kura
mg@ac.duke.edu                                                   Michael Grubb
Porter.Clark@msfc.nasa.gov                                     J. Porter Clark
rick@bcm.tmc.edu                                             Richard H. Miller
rwaters@jabba.ess.harris.com                                      Ralph Waters
smarry@turing.toronto.edu                                         Smarasderagd
srogers@tps.mcs.eds.com                                           Steve Rogers
stainles@bga.com                                                  Dwight Brown
VEAL@gateway.ce.utk.edu                                             David Veal


Votes in error
------------------------------------------------------------------------------
root@rpux01.rphp.com                                                Super-User
   ! Invalid address

 
USENET FACT: Kill File
A set of filters setup to determine which user's posts will be read/downloaded or ignored.