Talk:OLAP

From Wikipedia, the free encyclopedia

What's the story about the text "Around 50% of Olap licences are never deployed"? -- Waveguy

A nice indicator of how tricky Olap is to set-up and use. TwoOneTwo

Reply to Jay - technically yes, in usage sometimes no. You can regard it as an affectation and change it if you want. Thanks for pointing up Waveguy's question TwoOneTwo

I think usage also should be given a priority. Can you show me an article (outside Wikipedia of course) where OLAP is mentioned as Olap ? I couldn't find any instances from Google because Google searches are case-insensitive. Jay 08:18, 3 Oct 2003 (UTC)

The article states that Oracle Express was released in 1970. This cannot be true as Oracle did not exist as a product until 1979. Could this be a typo for 1990? Geoff97 22:32, 2 Jan 2004 (UTC)

Express has been around since about 1970 (with IRI) but was only taken over by Oracle in about 1995. -- TonyP 13:17, 23 Jan 2005 (UTC)

The history I've heard was that it was originally an MIT research project in the early 70s (PhD project maybe?) and was then productized. I believe IRI acquired it sometime in the mid to late 70s - previously I believe it was owned by a company called Multidimensional Systems or something? Cchiappa 22:02, 11 January 2006 (UTC)

I would dispute the definition of OLAP as given here. I would guess Codd's paper has to be the true definition since it coined the term. However, multi-dimension data and indexes were in use long before that paper. It really is a different way of indexing/accessing the data (as distinct from relational), and sometimes even different storage too (as in MOLAP). It is not specifically a snapshot of any relational database. Also, products such as Holos demonstrated that multi-cube and joining were just as applicable to OLAP as SQL data -- TonyP 14:45, 25 Jan 2005 (UTC)

Contents

[edit] Market Shares - Copyrighted information

The market share data that comes from OLAP Report is copyrighted by "Optima Publishing Ltd". I'm not sure if the use here qualifies as Fair use.

The page says the following: "This is copyright material. You can make brief references to it freely, with attribution, but not reproduce large sections or the entire article without permission from the publisher. You are free to link to this page without permission." I assumed that sdfsdf copying the names of the companies and their market shares would fit under "brief reference" and "not reproduce large sections". Should we contact the publisher to clarify this ? Wikiolap 20:17, 12 January 2006 (UTC)
I missed that note on the page. I would think it qualifies as brief.

[edit] Merging FASMI

I think it is OK to leave FASMI at its own page and not to redirect to OLAP page.

[edit] OLAP Operation Types

It would be nice to have a listing of the OLAP operation types (e.g. slice/dice, roll-up, drill-down, pivot, etc.) I don't have a good definition of them in my head so I came here to refresh. I think they're one of the key properties of OLAP, no?

--Michaell 04:19, 13 October 2006 (UTC)

[edit] Examples

It would be nice to have some examples, of measures and values, for instance. It is a little difficult for non-experts to understand without them.

--Gilliancs 19:32, 17 February 2007 (UTC)