Talk:OLAP cube

From Wikipedia, the free encyclopedia

Contents

[edit] PK Preserving?

What does the comment "hopefully PK-preserving" mean? Please explain. --MauriceKA 09:36, 17 Mar 2005 (UTC)

I do not know the answer to that, but I'd like to point out that Google has only one page of results for "pk-preserving," the first result being this article, with the rest being mirrors. Can someone knowledgable explain if this is even a real concept? In the meantime, I have placed a cleanup tag on it for being technical. --Migs 08:46, 8 August 2005 (UTC)
PK in that context almost certainly refers to Primary Key. Unfortunately, I am insufficiently knowledgeable about Database Theory to cleanup the article myself. --Eyrian 18 August 2005
I believe however put it meant that the Primary Key must be retrieved somehow in the OLAP cube projection. Anyway, Im taking it off. SSPecter talk ♠ 08:06, 6 January 2007 (UTC).

Preserving privacy while using authorization certificates ?

[edit] Other cubes

Shouldn't this article reference ROLAP, MOLAP, and HOLAP cubes as well? 65.202.85.9 15:23, 11 January 2007 (UTC)

I don't think so. ROLAP, MOLAP and HOLAP are all about different physical storage methods. The logical essense of OLAP Cube is the same regardless of physical storage details. Wikiolap 17:03, 11 January 2007 (UTC)
I think it should relate to all the other OLAPs, since a cube is a MOLAP and others like ROLAP (relational OLAP) are totally different concepts and ways of preparing the data to be queried. —Preceding unsigned comment added by 12.145.46.162 (talk) 23:36, 11 September 2007 (UTC)

[edit] Functional notation

Can someone please explain the functional notation here? I believe it should be f: (X, Y, Z) |--> W, not W: (X, Y, Z) |--> W. Ericdbw 06:15, 16 September 2007 (UTC)

[edit] References

Why does this article need sources? It's not as if the source would be any more reputable anyway. —Preceding unsigned comment added by 128.237.241.67 (talk) 03:34, 18 February 2008 (UTC)

The article needs to have references because Wikipedia does not allow original research. Everything needs to be referenced. If it's not properly referenced, someone will come around and delete the whole article. Here is a bibliography that can be used to properly add references to the article.
Daniel Lemire (2007-12). Data Warehousing and OLAP-A Research-Oriented Bibliography (English).

I will take it on myself to work on properly adding the references on this article. Anyone want to help? Kgrr (talk) 18:54, 5 March 2008 (UTC)

[edit] Functionality

This needs to be included in the article:

The OLAP cube consists of numeric facts called measures which are categorized by dimensions. The cube metadata is typically created from a star schema or snowflake schema of tables in a relational database. Measures are derived from the records in the fact table and dimensions are derived from the dimension tables.Kgrr (talk) 11:55, 18 March 2008 (UTC)