Facebook Twitter Pinterest
Gebraucht kaufen
EUR 3,20
+ EUR 3,00 Versandkosten
Gebraucht: Gut | Details
Verkauft von reBuy reCommerce GmbH
Zustand: Gebraucht: Gut
Möchten Sie verkaufen?
Zur Rückseite klappen Zur Vorderseite klappen
Hörprobe Wird gespielt... Angehalten   Sie hören eine Hörprobe des Audible Hörbuch-Downloads.
Mehr erfahren
Alle 2 Bilder anzeigen

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Computer Science) (Englisch) Taschenbuch – 25. April 2002

5.0 von 5 Sternen 2 Kundenrezensionen

Alle Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Neu ab Gebraucht ab
"Bitte wiederholen"
EUR 40,21 EUR 3,20
3 neu ab EUR 40,21 10 gebraucht ab EUR 3,20

Dieses Buch gibt es in einer neuen Auflage:

click to open popover

Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.

  • Apple
  • Android
  • Windows Phone

Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.

Jeder kann Kindle Bücher lesen — selbst ohne ein Kindle-Gerät — mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.




"...this is the daddy of data warehousing process books. No other material available so concisely and precisely explains what is required from a data warehousing solution...this is a great book..." (Enterprise Server Magazine, July 2002)


Single most authoritative guide from the inventor of the technique. Presents unique modeling techniques for e-commerce, and shows strategies for optimizing performance. Companion Web site provides updates on dimensional modeling techniques, links related to sites, and source code where appropriate.

Alle Produktbeschreibungen


5.0 von 5 Sternen
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Stern
Beide Kundenrezensionen anzeigen
Sagen Sie Ihre Meinung zu diesem Artikel


Format: Taschenbuch
The book has fulfilled my personal expectations for a practical guide in setting up the Data Warehouse. After concise delving into dimensional modelling all kinds of business environments by branch are tackled for best practice and also obstacles which lay ahead when delivering concrete and robust based Data Marts and Warehouses. I personally like the Author's apporoach to a blend of IT based facts like discussion on dimensions, keys, data table size and so on together with business user expectations and terminology. This is highly readable.
The book should best be purchased and read with it's companion from same author "The Data Warehouse Lifecycle Toolkit" where the full project planning and lifecycle administration together with in-depth techniques for dimensional modelling are layed out.
Full 5 of 5 possible for the twosome DWH package. Recommended!
Kommentar 6 Personen fanden diese Informationen hilfreich. War diese Rezension für Sie hilfreich? Ja Nein Feedback senden...
Vielen Dank für Ihr Feedback.
Wir konnten Ihre Stimmabgabe leider nicht speichern. Bitte erneut versuchen
Missbrauch melden
Format: Taschenbuch Verifizierter Kauf
Strukturen und Aufbau von Datenbanken werden in verständlicher Art und an vielen Beispielen in diesem Buch beschrieben. Durch die stufenweise Erweiterung des Beispiel-Datenmodells erschließen sich in eindrucksvoller Weise die Möglichkeiten und Variationen einer relationalen Datenbank.

Obgleich das Buch schon einige Jahre alt ist, hat es nicht an Wert verloren. Die Prämissen sind auch heute noch ohne große Einschränkungen anwendbar.

Wirklich empfehlenswert.
Kommentar Eine Person fand diese Informationen hilfreich. War diese Rezension für Sie hilfreich? Ja Nein Feedback senden...
Vielen Dank für Ihr Feedback.
Wir konnten Ihre Stimmabgabe leider nicht speichern. Bitte erneut versuchen
Missbrauch melden

Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)

Amazon.com: HASH(0x969ed0d8) von 5 Sternen 64 Rezensionen
121 von 127 Kunden fanden die folgende Rezension hilfreich
HASH(0x96c66b1c) von 5 Sternen Practical Wisdom 5. Mai 2002
Von Jim Stagnitto - Veröffentlicht auf Amazon.com
Format: Taschenbuch
There are a lot of data warehousing books out there that try to answer the question: 'Why'? Why data warehouses are needed to help businesses make better decisions - why the OLTP systems that run the business can't do this - and sometimes even why businesses ought to invest in data warehouses. These books were terrifically useful to us years ago, when we needed help (and scholarly footnotes) in our data warehouse project proposals. This book is not one of those - it is all about:


How to actually design and build a repository that will deliver real value to real people. In this reviewer's opinion, Ralph Kimball's many contributions related to the 'how' of data warehousing stand alone.

An engineer wishing to jump-start his or her data warehouse education would need to read Ralph's Data Warehouse Toolkit first edition, his Data Webhouse Toolkit... a bunch of "Data Warehouse Designer" Intelligence Enterprise magazine articles... AND lurk on the Data Warehousing List Server...for a few years (all terrific resources - by the way) - in order to stockpile the knowledge that is crisply presented here.

No shortcuts taken by the authors that I can spot: all of the toughest dimensional design issues that I've tripped on - and that I can remember surfacing on in discussion groups over the past few years - are addressed in this significantly updated text. Not all of the solutions are 'pretty' - but it is clear that they thoughtfully address the problem. This approach, in my opinion, instills student confidence - and lets us know that we are getting sound instruction - not dogma.

The authors have been listening to and addressing the data warehouse community's 'pain' through periodicals and posts for years - but this book pulls these point solutions together very nicely. I learned a surprising number of really useful new techniques, and was genuinely enlightened by the 'Present Imperatives and Future Outlook' section.

As in the first edition, there is minimal philosophical lecturing, and zero religion. Instead, we get generous helpings of real-world case studies - aptly applied to progressively more advanced series of design concepts.

This style absolutely works for me. And I suspect that engineering mindsets typical of the folks that build these things will likely agree. In short, the Data Warehouse Toolkit Second Edition will significantly lighten the load of books that I carry between data warehouse engagements.

Jim Stagnitto
Llumino, Inc.
45 von 48 Kunden fanden die folgende Rezension hilfreich
HASH(0x96c66b70) von 5 Sternen Top-notch course in dimensional data warehouses 27. August 2002
Von Ein Kunde - Veröffentlicht auf Amazon.com
Format: Taschenbuch
If you want to understand data warehouse design either as user, architect or developer, you need to read this book cover to cover.
Things I like about this book:
* Coverage of all core principles in dimensional data modeling using examples. Ralph does not just lecture to you -- he shows you how to put it into practice
* Coverage of a vast variety of domains. This alone makes the book a must-read
* Recap of major principles at the end of the book to bring it all together
* Excellent writing -- Ralph does not treat you like a dummy; neither does he assume that you have an IQ north of 200
* When you purchase this book, you are in effect purchasing a sliver of the combined knowledge of both authors in the data warehousing field. Highly recommended
I implemented a data warehouse using some of these principles back in 1999. The project was a resounding success and is the most popular application in the financial services firm that I implemented it in. (Infact when I lost my job at an Internet company, they immediately offered me a job based on this implementation). The only sad part to the whole story is that we made a few mistakes in implementation that are now very difficult to correct because the data warehouse has become core to the business -- we have too many end-user applications riding on it!
22 von 23 Kunden fanden die folgende Rezension hilfreich
HASH(0x96c66d44) von 5 Sternen An Indispensible Book 7. Juni 2003
Von Paul A. Chernoch - Veröffentlicht auf Amazon.com
Format: Taschenbuch
After six years of creating data warehouse applications, making a plethora of mistakes and learning stuff the hard way, I wish I had had this book at the start! Every other page offers a solution to some problem or other that I have had. In the project I am just starting I am facing new challenges and am finding help with them as well. The best part is how solutions I used in the past which were appropriate for those problems are contrasted with solutions for problems like the ones I am facing now. Almost as bad as solving a problem the wrong way (or overlooking it entirely) is reusing an old solution that does not fit the new problem. This book clearly spells out when each solution is appropriate. I can not speak too highly about how useful this book will be for you!
15 von 15 Kunden fanden die folgende Rezension hilfreich
HASH(0x96c67390) von 5 Sternen Mixed feelings 19. Januar 2013
Von Dimitri Shvorob - Veröffentlicht auf Amazon.com
Format: Taschenbuch
The book's complete title is "Data warehouse toolkit: the complete guide to dimensional modeling". What is dimensional modeling? Chapter 1, "Dimensional modeling primer", will surely explain. Page 1 - nothing, page 2 - nothing... page 8 - nothing, page 9 - "By default, normalized databases are excluded from the presentation area, which should be strictly dimensionally structured". What is "dimensionally structured" though? Have I missed the definition? Leafing back... no, Kimball is just using a concept before he defined it, moving on... Page 10: "Dimensional modeling is a new name for an old technique for making databases simple and understandable". Great, what is it then? Page 11 - "Dimensional modeling is quite different from third-normal-form (3NF) modeling". Yees? Page 12 - nothing, page 13 - "If the presentation area is based on a relational database, then these dimensionally modeled tables are referred to as star schemas". Finally! Now, this sort-of-definition would not help someone who did not know about star schema, but thankfully I do, and anyway, this is the closest thing to a definition that you get - although things start to get clearer on page 16, where fact tables and dimension tables are introduced. The essence of dimensional modeling, it seems, is "Star is good; snowflake is bad".

A couple of pages later, on page 18, I see this passage. "The fact table itself generally has its own primary key made up of a subset of the foreign keys. This key is often called a composite or concatenated key. Every fact table in a dimensional model has a composite key, and conversely, every table that has a composite key is a fact table. Another way to say this is that in a dimensional model, every table that expresses a many-to-many relationship must be a fact table". I am confused, for three reasons. A fact table's primary key is "generally" made up of a subset of foreign keys? This is not the case with Kimball's own first fact table on page 36 - "POS Transaction Number" definitely should be part of a primary key (he does not define one, so I assume), but it does not foreign-key into anything. Oh, and Sentence 3 means it's "always", not "generally", if we follow the "conversely" path. Is the "another way to say this" part true? ... And overall, isn't this all just a confused way to say that fact tables have foreign keys and dimension tables don't? "Stars, no snowflakes". (What's wrong with snowflakes, apart from the increased design complexity? Among the reasons listed on page 60 - views are never mentioned - the technical and the scariest one is "snowflaking defeats the use of bitmap indexes").

The two examples above are representative of the book's style, and I am quite sure that it could use a lot more editing. I wish that somebody did a better job, but don't know a reasonable substitute. (Yes, I have seen Inmon's book - not a fan). Nonetheless, it's an impressive, concrete book that will give you a lot of practical ideas, and, when it suggests something that looks suboptimal or incomplete or self-contradictory, will make you think about schema design. Not a sufficient reference on the subject, but a very necessary one.

PS. I recommend "Kimball Group Reader" as the alternative to this book: I believe that it covers the material here, and offers a lot of additional information.
32 von 37 Kunden fanden die folgende Rezension hilfreich
HASH(0x96c673b4) von 5 Sternen Data Warehousing is in the eye of the beholder 6. Juni 2003
Von Srihari Mailvaganam - Veröffentlicht auf Amazon.com
Format: Taschenbuch
Data Warehousing is more of an art than a science - but then again what isn't?
There isn't a standard blueprint that can come close to solving most data issues. Data Warehousing (DW) involves constant tweaking and the goal of good DW project management is minimizing the associated operational cost.
I have been a fan of Ralph Kimball as he writes as a person who has been through many implementations. With Mr. Kimball there isn't a miracle cure being touted - stay away from publications that claim such a cure.
Mr. Kimball approached the subject with good advices and encourages the readers to watch out for the pitfalls and follow best-practices in design implementation. It is similar to working with a well experienced supervisor.
The core to successful DW implementations is - LISTENING. Listening to the users on their needs and gauging the software resources available at your disposal.
Trade-offs in design versus cost/performance are a must. You will never have all the resources you need to implement the DW of your dreams. And if you did, chances are very high that once the DW is ready for use the business cases have changed making the design redundant.
Mr. Kimball will help in passing these information and much more. It also goes in good technical detail for suggested modeling of data.
I hope this review is helpful, please let me know if you have any questions or suggestions.
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.