An Alternative Relational OLAP Modeling Approach
Schema design is one of the fundamentals in database theory and practice as well. In this paper, we discuss the problem of locally valid dimensional attributes in a classification hierarchy of a typical OLAP scenario. In a first step, we show that the traditional star and snowflake schema approach i...
Gespeichert in:
| Hauptverfasser: | , , |
|---|---|
| Format: | Buchkapitel |
| Sprache: | eng |
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| container_end_page | 198 |
|---|---|
| container_issue | |
| container_start_page | 189 |
| container_title | |
| container_volume | 1874 |
| creator | Bauer, Andreas Hümmer, Wolfgang Lehner, Wolfgang |
| description | Schema design is one of the fundamentals in database theory and practice as well. In this paper, we discuss the problem of locally valid dimensional attributes in a classification hierarchy of a typical OLAP scenario. In a first step, we show that the traditional star and snowflake schema approach is not feasible in this very natural case of a hierarchy. Therefore, we sketch two alternative modeling approaches resulting in practical solutions and a seamless extension of the traditional star and snowflake schema approach: In a pure relational approach, we replace each dimension table of a star / snowflake schema by a set of views directly reflecting the classification hierarchy. The second approach takes advantage of the object-relational extensions. Using object-relational techniques in the context for the relational representation of a multidimensional OLAP scenario is a novel approach and promises a clean and smooth schema design. |
| doi_str_mv | 10.1007/3-540-44466-1_19 |
| format | Book Chapter |
| fullrecord | <record><control><sourceid>pascalfrancis_sprin</sourceid><recordid>TN_cdi_pascalfrancis_primary_781431</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>781431</sourcerecordid><originalsourceid>FETCH-LOGICAL-p264t-be779bebd063da74ebf6b694180d706f4d3f1ae452302340a1d9aff46f59a9be3</originalsourceid><addsrcrecordid>eNo9kM1PwzAMxcOXxDR251iJc4Zde0lzrCa-pKEhBOcoXZNRKG3VTEj892QD4Yut954t6yfEJcIcAfQ1yQWDZGalJFo0R2JmdEFJPGh8LCaoECURm5N_T2lTgDoVEyDIpdFM52IW4zukojxnMhMBZZeV7c6Pnds1Xz579m0a-s612XpVPmWPfe3bpttm5TCMvdu8XYiz4NroZ399Kl5vb16W93K1vntYlis55Ip3svJam8pXNSiqnWZfBVUpw1hArUEFrimg87zI02_E4LA2LgRWYWFcWqSpuPq9O7i4cW0YXbdpoh3G5tON31YXyIQpNf9NxWR0Wz_aqu8_okWwe3CWbOJgD5DsHhz9AK1JWdA</addsrcrecordid><sourcetype>Index Database</sourcetype><iscdi>true</iscdi><recordtype>book_chapter</recordtype></control><display><type>book_chapter</type><title>An Alternative Relational OLAP Modeling Approach</title><source>Springer Books</source><creator>Bauer, Andreas ; Hümmer, Wolfgang ; Lehner, Wolfgang</creator><contributor>Kambayashi, Yahiko ; Tjoa, A. Min ; Mohania, Mukesh</contributor><creatorcontrib>Bauer, Andreas ; Hümmer, Wolfgang ; Lehner, Wolfgang ; Kambayashi, Yahiko ; Tjoa, A. Min ; Mohania, Mukesh</creatorcontrib><description>Schema design is one of the fundamentals in database theory and practice as well. In this paper, we discuss the problem of locally valid dimensional attributes in a classification hierarchy of a typical OLAP scenario. In a first step, we show that the traditional star and snowflake schema approach is not feasible in this very natural case of a hierarchy. Therefore, we sketch two alternative modeling approaches resulting in practical solutions and a seamless extension of the traditional star and snowflake schema approach: In a pure relational approach, we replace each dimension table of a star / snowflake schema by a set of views directly reflecting the classification hierarchy. The second approach takes advantage of the object-relational extensions. Using object-relational techniques in the context for the relational representation of a multidimensional OLAP scenario is a novel approach and promises a clean and smooth schema design.</description><identifier>ISSN: 0302-9743</identifier><identifier>ISBN: 9783540679806</identifier><identifier>ISBN: 3540679804</identifier><identifier>EISSN: 1611-3349</identifier><identifier>EISBN: 9783540444664</identifier><identifier>EISBN: 3540444661</identifier><identifier>DOI: 10.1007/3-540-44466-1_19</identifier><language>eng</language><publisher>Berlin, Heidelberg: Springer Berlin Heidelberg</publisher><subject>Dimension Table ; Exact sciences and technology ; Fact Table ; Information and communication sciences ; Information retrieval systems. Information and document management system ; Information science. Documentation ; Miscellaneous ; Primary Attribute ; Product Dimension ; Product Family ; Sciences and techniques of general use</subject><ispartof>Data Warehousing and Knowledge Discovery, 2000, Vol.1874, p.189-198</ispartof><rights>Springer-Verlag Berlin Heidelberg 2000</rights><rights>2001 INIST-CNRS</rights><lds50>peer_reviewed</lds50><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed><relation>Lecture Notes in Computer Science</relation></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktopdf>$$Uhttps://link.springer.com/content/pdf/10.1007/3-540-44466-1_19$$EPDF$$P50$$Gspringer$$H</linktopdf><linktohtml>$$Uhttps://link.springer.com/10.1007/3-540-44466-1_19$$EHTML$$P50$$Gspringer$$H</linktohtml><link.rule.ids>309,310,775,776,780,785,786,789,4035,4036,27904,38234,41421,42490</link.rule.ids><backlink>$$Uhttp://pascal-francis.inist.fr/vibad/index.php?action=getRecordDetail&idt=781431$$DView record in Pascal Francis$$Hfree_for_read</backlink></links><search><contributor>Kambayashi, Yahiko</contributor><contributor>Tjoa, A. Min</contributor><contributor>Mohania, Mukesh</contributor><creatorcontrib>Bauer, Andreas</creatorcontrib><creatorcontrib>Hümmer, Wolfgang</creatorcontrib><creatorcontrib>Lehner, Wolfgang</creatorcontrib><title>An Alternative Relational OLAP Modeling Approach</title><title>Data Warehousing and Knowledge Discovery</title><description>Schema design is one of the fundamentals in database theory and practice as well. In this paper, we discuss the problem of locally valid dimensional attributes in a classification hierarchy of a typical OLAP scenario. In a first step, we show that the traditional star and snowflake schema approach is not feasible in this very natural case of a hierarchy. Therefore, we sketch two alternative modeling approaches resulting in practical solutions and a seamless extension of the traditional star and snowflake schema approach: In a pure relational approach, we replace each dimension table of a star / snowflake schema by a set of views directly reflecting the classification hierarchy. The second approach takes advantage of the object-relational extensions. Using object-relational techniques in the context for the relational representation of a multidimensional OLAP scenario is a novel approach and promises a clean and smooth schema design.</description><subject>Dimension Table</subject><subject>Exact sciences and technology</subject><subject>Fact Table</subject><subject>Information and communication sciences</subject><subject>Information retrieval systems. Information and document management system</subject><subject>Information science. Documentation</subject><subject>Miscellaneous</subject><subject>Primary Attribute</subject><subject>Product Dimension</subject><subject>Product Family</subject><subject>Sciences and techniques of general use</subject><issn>0302-9743</issn><issn>1611-3349</issn><isbn>9783540679806</isbn><isbn>3540679804</isbn><isbn>9783540444664</isbn><isbn>3540444661</isbn><fulltext>true</fulltext><rsrctype>book_chapter</rsrctype><creationdate>2000</creationdate><recordtype>book_chapter</recordtype><recordid>eNo9kM1PwzAMxcOXxDR251iJc4Zde0lzrCa-pKEhBOcoXZNRKG3VTEj892QD4Yut954t6yfEJcIcAfQ1yQWDZGalJFo0R2JmdEFJPGh8LCaoECURm5N_T2lTgDoVEyDIpdFM52IW4zukojxnMhMBZZeV7c6Pnds1Xz579m0a-s612XpVPmWPfe3bpttm5TCMvdu8XYiz4NroZ399Kl5vb16W93K1vntYlis55Ip3svJam8pXNSiqnWZfBVUpw1hArUEFrimg87zI02_E4LA2LgRWYWFcWqSpuPq9O7i4cW0YXbdpoh3G5tON31YXyIQpNf9NxWR0Wz_aqu8_okWwe3CWbOJgD5DsHhz9AK1JWdA</recordid><startdate>2000</startdate><enddate>2000</enddate><creator>Bauer, Andreas</creator><creator>Hümmer, Wolfgang</creator><creator>Lehner, Wolfgang</creator><general>Springer Berlin Heidelberg</general><general>Springer</general><scope>IQODW</scope></search><sort><creationdate>2000</creationdate><title>An Alternative Relational OLAP Modeling Approach</title><author>Bauer, Andreas ; Hümmer, Wolfgang ; Lehner, Wolfgang</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-p264t-be779bebd063da74ebf6b694180d706f4d3f1ae452302340a1d9aff46f59a9be3</frbrgroupid><rsrctype>book_chapters</rsrctype><prefilter>book_chapters</prefilter><language>eng</language><creationdate>2000</creationdate><topic>Dimension Table</topic><topic>Exact sciences and technology</topic><topic>Fact Table</topic><topic>Information and communication sciences</topic><topic>Information retrieval systems. Information and document management system</topic><topic>Information science. Documentation</topic><topic>Miscellaneous</topic><topic>Primary Attribute</topic><topic>Product Dimension</topic><topic>Product Family</topic><topic>Sciences and techniques of general use</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Bauer, Andreas</creatorcontrib><creatorcontrib>Hümmer, Wolfgang</creatorcontrib><creatorcontrib>Lehner, Wolfgang</creatorcontrib><collection>Pascal-Francis</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Bauer, Andreas</au><au>Hümmer, Wolfgang</au><au>Lehner, Wolfgang</au><au>Kambayashi, Yahiko</au><au>Tjoa, A. Min</au><au>Mohania, Mukesh</au><format>book</format><genre>bookitem</genre><ristype>CHAP</ristype><atitle>An Alternative Relational OLAP Modeling Approach</atitle><btitle>Data Warehousing and Knowledge Discovery</btitle><seriestitle>Lecture Notes in Computer Science</seriestitle><date>2000</date><risdate>2000</risdate><volume>1874</volume><spage>189</spage><epage>198</epage><pages>189-198</pages><issn>0302-9743</issn><eissn>1611-3349</eissn><isbn>9783540679806</isbn><isbn>3540679804</isbn><eisbn>9783540444664</eisbn><eisbn>3540444661</eisbn><abstract>Schema design is one of the fundamentals in database theory and practice as well. In this paper, we discuss the problem of locally valid dimensional attributes in a classification hierarchy of a typical OLAP scenario. In a first step, we show that the traditional star and snowflake schema approach is not feasible in this very natural case of a hierarchy. Therefore, we sketch two alternative modeling approaches resulting in practical solutions and a seamless extension of the traditional star and snowflake schema approach: In a pure relational approach, we replace each dimension table of a star / snowflake schema by a set of views directly reflecting the classification hierarchy. The second approach takes advantage of the object-relational extensions. Using object-relational techniques in the context for the relational representation of a multidimensional OLAP scenario is a novel approach and promises a clean and smooth schema design.</abstract><cop>Berlin, Heidelberg</cop><pub>Springer Berlin Heidelberg</pub><doi>10.1007/3-540-44466-1_19</doi><tpages>10</tpages><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext |
| identifier | ISSN: 0302-9743 |
| ispartof | Data Warehousing and Knowledge Discovery, 2000, Vol.1874, p.189-198 |
| issn | 0302-9743 1611-3349 |
| language | eng |
| recordid | cdi_pascalfrancis_primary_781431 |
| source | Springer Books |
| subjects | Dimension Table Exact sciences and technology Fact Table Information and communication sciences Information retrieval systems. Information and document management system Information science. Documentation Miscellaneous Primary Attribute Product Dimension Product Family Sciences and techniques of general use |
| title | An Alternative Relational OLAP Modeling Approach |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-24T04%3A18%3A39IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-pascalfrancis_sprin&rft_val_fmt=info:ofi/fmt:kev:mtx:book&rft.genre=bookitem&rft.atitle=An%20Alternative%20Relational%20OLAP%20Modeling%20Approach&rft.btitle=Data%20Warehousing%20and%20Knowledge%20Discovery&rft.au=Bauer,%20Andreas&rft.date=2000&rft.volume=1874&rft.spage=189&rft.epage=198&rft.pages=189-198&rft.issn=0302-9743&rft.eissn=1611-3349&rft.isbn=9783540679806&rft.isbn_list=3540679804&rft_id=info:doi/10.1007/3-540-44466-1_19&rft_dat=%3Cpascalfrancis_sprin%3E781431%3C/pascalfrancis_sprin%3E%3Curl%3E%3C/url%3E&rft.eisbn=9783540444664&rft.eisbn_list=3540444661&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true |