Star schema: [features in-depth coverage of dimensional design principles, illustrates best practices through detailed examples, provides architecture-neutral techniques for any data warehouse]
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
New York [u.a.]
McGraw-Hill
2010
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | Includes bibliographical references and index |
| Beschreibung: | XXVI, 486 S. |
| ISBN: | 9780071744324 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV036957335 | ||
| 003 | DE-604 | ||
| 005 | 20110125 | ||
| 007 | t | ||
| 008 | 110114s2010 |||| 00||| eng d | ||
| 010 | |a 2010025657 | ||
| 020 | |a 9780071744324 |c alk. paper |9 978-0-07-174432-4 | ||
| 035 | |a (OCoLC)731796449 | ||
| 035 | |a (DE-599)GBV630711186 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-523 | ||
| 082 | 0 | |a 005.745 | |
| 084 | |a ST 530 |0 (DE-625)143679: |2 rvk | ||
| 100 | 1 | |a Adamson, Christopher |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Star schema |b [features in-depth coverage of dimensional design principles, illustrates best practices through detailed examples, provides architecture-neutral techniques for any data warehouse] |c Christopher Adamson |
| 246 | 1 | 3 | |a The complete reference star schema |
| 264 | 1 | |a New York [u.a.] |b McGraw-Hill |c 2010 | |
| 300 | |a XXVI, 486 S. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a Includes bibliographical references and index | ||
| 650 | 0 | 7 | |a Relationale Datenbank |0 (DE-588)4049358-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Data-Warehouse-Konzept |0 (DE-588)4406462-7 |2 gnd |9 rswk-swf |
| 653 | |a data warehousing | ||
| 653 | |a relational databases | ||
| 689 | 0 | 0 | |a Data-Warehouse-Konzept |0 (DE-588)4406462-7 |D s |
| 689 | 0 | 1 | |a Relationale Datenbank |0 (DE-588)4049358-1 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020872283&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-020872283 | ||
Datensatz im Suchindex
| _version_ | 1804143680951418880 |
|---|---|
| adam_text | Titel: Star schema
Autor: Adamson, Christopher
Jahr: 2010
Contents at a Glance
Part I Fundamentals
1 Analytic Databases and Dimensional Design 3
2 Data Warehouse Architectures 17
3 Stars and Cubes 29
Part II Multiple Stars
4 A Fact Table for Each Process 61
5 Conformed Dimensions 85
Part III Dimension Design
6 More on Dimension Tables 113
7 Hierarchies and Snowflakes 147
8 More Slow Change Techniques 171
9 Multi-Valued Dimensions and Bridges 195
10 Recursive Hierarchies and Bridges 219
Part IV Fact Table Design
11 Transactions, Snapshots, and
Accumulating Snapshots 259
12 Factless Fact Tables 291
13 Type-Specific Stars 307
Part V Performance
14 Derived Schemas 325
15 Aggregates 345
Part VI Tools and Documentation
16 Design and Business Intelligence 369
17 Design and ETL 403
18 How to Design and Document a Dimensional Model 431
Index 465
|
| any_adam_object | 1 |
| author | Adamson, Christopher |
| author_facet | Adamson, Christopher |
| author_role | aut |
| author_sort | Adamson, Christopher |
| author_variant | c a ca |
| building | Verbundindex |
| bvnumber | BV036957335 |
| classification_rvk | ST 530 |
| ctrlnum | (OCoLC)731796449 (DE-599)GBV630711186 |
| dewey-full | 005.745 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.745 |
| dewey-search | 005.745 |
| dewey-sort | 15.745 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01698nam a2200409 c 4500</leader><controlfield tag="001">BV036957335</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20110125 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">110114s2010 |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2010025657</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780071744324</subfield><subfield code="c">alk. paper</subfield><subfield code="9">978-0-07-174432-4</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)731796449</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)GBV630711186</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-523</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.745</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 530</subfield><subfield code="0">(DE-625)143679:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Adamson, Christopher</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Star schema</subfield><subfield code="b">[features in-depth coverage of dimensional design principles, illustrates best practices through detailed examples, provides architecture-neutral techniques for any data warehouse]</subfield><subfield code="c">Christopher Adamson</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">The complete reference star schema</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">New York [u.a.]</subfield><subfield code="b">McGraw-Hill</subfield><subfield code="c">2010</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXVI, 486 S.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references and index</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Relationale Datenbank</subfield><subfield code="0">(DE-588)4049358-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Data-Warehouse-Konzept</subfield><subfield code="0">(DE-588)4406462-7</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">data warehousing</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">relational databases</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Data-Warehouse-Konzept</subfield><subfield code="0">(DE-588)4406462-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Relationale Datenbank</subfield><subfield code="0">(DE-588)4049358-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020872283&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-020872283</subfield></datafield></record></collection> |
| id | DE-604.BV036957335 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-09T22:51:31Z |
| institution | BVB |
| isbn | 9780071744324 |
| language | English |
| lccn | 2010025657 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-020872283 |
| oclc_num | 731796449 |
| open_access_boolean | |
| owner | DE-523 |
| owner_facet | DE-523 |
| physical | XXVI, 486 S. |
| publishDate | 2010 |
| publishDateSearch | 2010 |
| publishDateSort | 2010 |
| publisher | McGraw-Hill |
| record_format | marc |
| spelling | Adamson, Christopher Verfasser aut Star schema [features in-depth coverage of dimensional design principles, illustrates best practices through detailed examples, provides architecture-neutral techniques for any data warehouse] Christopher Adamson The complete reference star schema New York [u.a.] McGraw-Hill 2010 XXVI, 486 S. txt rdacontent n rdamedia nc rdacarrier Includes bibliographical references and index Relationale Datenbank (DE-588)4049358-1 gnd rswk-swf Data-Warehouse-Konzept (DE-588)4406462-7 gnd rswk-swf data warehousing relational databases Data-Warehouse-Konzept (DE-588)4406462-7 s Relationale Datenbank (DE-588)4049358-1 s DE-604 HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020872283&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Adamson, Christopher Star schema [features in-depth coverage of dimensional design principles, illustrates best practices through detailed examples, provides architecture-neutral techniques for any data warehouse] Relationale Datenbank (DE-588)4049358-1 gnd Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
| subject_GND | (DE-588)4049358-1 (DE-588)4406462-7 |
| title | Star schema [features in-depth coverage of dimensional design principles, illustrates best practices through detailed examples, provides architecture-neutral techniques for any data warehouse] |
| title_alt | The complete reference star schema |
| title_auth | Star schema [features in-depth coverage of dimensional design principles, illustrates best practices through detailed examples, provides architecture-neutral techniques for any data warehouse] |
| title_exact_search | Star schema [features in-depth coverage of dimensional design principles, illustrates best practices through detailed examples, provides architecture-neutral techniques for any data warehouse] |
| title_full | Star schema [features in-depth coverage of dimensional design principles, illustrates best practices through detailed examples, provides architecture-neutral techniques for any data warehouse] Christopher Adamson |
| title_fullStr | Star schema [features in-depth coverage of dimensional design principles, illustrates best practices through detailed examples, provides architecture-neutral techniques for any data warehouse] Christopher Adamson |
| title_full_unstemmed | Star schema [features in-depth coverage of dimensional design principles, illustrates best practices through detailed examples, provides architecture-neutral techniques for any data warehouse] Christopher Adamson |
| title_short | Star schema |
| title_sort | star schema features in depth coverage of dimensional design principles illustrates best practices through detailed examples provides architecture neutral techniques for any data warehouse |
| title_sub | [features in-depth coverage of dimensional design principles, illustrates best practices through detailed examples, provides architecture-neutral techniques for any data warehouse] |
| topic | Relationale Datenbank (DE-588)4049358-1 gnd Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
| topic_facet | Relationale Datenbank Data-Warehouse-Konzept |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020872283&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT adamsonchristopher starschemafeaturesindepthcoverageofdimensionaldesignprinciplesillustratesbestpracticesthroughdetailedexamplesprovidesarchitectureneutraltechniquesforanydatawarehouse AT adamsonchristopher thecompletereferencestarschema |