Muutke küpsiste eelistusi

Database Modeling and Design: Logical Design 5th edition [Pehme köide]

3.65/5 (32 hinnangut Goodreads-ist)
(Professor, Electrical Engineering and Computer Science Department, University of Michigan, Ann Arbor, USA), (Univ of Mich, ), (Senior Technical Staff Member and Development Manager, IBM, Toronto, Canada), (Ubiquiti Inc., Ann Arbor, MI)
  • Formaat: Paperback / softback, 352 pages, kõrgus x laius: 235x191 mm, kaal: 720 g, Approx. 130 illustrations; Illustrations, unspecified
  • Sari: The Morgan Kaufmann Series in Data Management Systems
  • Ilmumisaeg: 28-Mar-2011
  • Kirjastus: Morgan Kaufmann Publishers In
  • ISBN-10: 0123820200
  • ISBN-13: 9780123820204
Teised raamatud teemal:
Database Modeling and Design: Logical Design 5th editionSuurem pilt
  • Formaat: Paperback / softback, 352 pages, kõrgus x laius: 235x191 mm, kaal: 720 g, Approx. 130 illustrations; Illustrations, unspecified
  • Sari: The Morgan Kaufmann Series in Data Management Systems
  • Ilmumisaeg: 28-Mar-2011
  • Kirjastus: Morgan Kaufmann Publishers In
  • ISBN-10: 0123820200
  • ISBN-13: 9780123820204
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780123820204.html
Märksõnad:
Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs?

In the extensively revised fifth edition, you’ll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with design rules that are applicable to any SQL-based system. But you’ll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems. 
  • In-depth detail and plenty of real-world, practical examples throughout

  • Loaded with design rules and illustrative case studies that are applicable to any SQL, UML, or XML-based system

  • Immediately useful to anyone tasked with the creation of data models for the integration of large-scale enterprise data.


Arvustused

"Database Modeling and Design is one of the best books that I have seen for explaining how to build database applications. The book is informative, well-written, and concise." --Michael Blaha, DSc., Consultant, Modelsoft Consulting Corp"This book book is by far the best book available on classic database design. Topics like normalization and many-to-many and n-ary association semantics are without peer in teaching you how to model real-world complexities. This latest edition extends the classic material with extensive discussion of modern tools and other aspects of logical database design. Every database architect should have this book at hand." --Bob Muller, Data Analyst, Poesys AssociatesThe book is not only good for beginners, but it also provides greater insight for experienced learners. Perhaps this is why it has evolved into its fifth edition. The book is generally well organized. It starts with the first step in the database life cycle, and progresses in a chronological order to more advanced concepts such as object relational design, Extensible Markup Language (XML), and Web databases. The writing style of the book is simple and straightforward, and the use of database terminology is very conciseIn my opinion, the book could be used as a course text, with some help from other sources to cover SQL query-related concepts. However, I would have liked a chapter on SQL that covered simple and complex query design, as well as optimization." --Computing Reviews

Muu info

The database professional's only complete business intelligence guide to data modeling concepts and logical database design.
Preface ix
About the Authors xiii
Chapter 1 Introduction
1(12)
Chapter 2 The Entity--Relationship Model
13(22)
Chapter 3 The Unified Modeling Language
35(20)
Chapter 4 Requirements Analysis and Conceptual Data Modeling
55(30)
Chapter 5 Transforming the Conceptual Data Model to Sql
85(24)
Chapter 6 Normalization
109(22)
Chapter 7 An Example of Logical Database Design
131(8)
Chapter 8 Object-Relational Design
139(22)
Chapter 9 Xml and Web Databases
161(28)
Chapter 10 Business Intelligence
189(44)
Chapter 11 Case Tools for Logical Database Design
233(28)
Appendix: The Basics of Sql 261(18)
References 279(6)
Exercises 285(6)
Solutions to Selected Exercises 291(4)
Glossary 295(6)
Index 301
Chapter 3 Query Optimization and Plan Selection 3
Appendix A A Simple Performance Model for Databases 1
Toby J. Teorey is a professor in the Electrical Engineering and Computer Science Department at the University of Michigan, Ann Arbor. He received his B.S. and M.S. degrees in electrical engineering from the University of Arizona, Tucson, and a Ph.D. in computer sciences from the University of Wisconsin, Madison. He was general chair of the 1981 ACM SIGMOD Conference and program chair for the 1991 Entity-Relationship Conference. Professor Teoreys current research focuses on database design and data warehousing, OLAP, advanced database systems, and performance of computer networks. He is a member of the ACM and the IEEE Computer Society. Sam Lightstone is a Senior Technical Staff Member and Development Manager with IBMs DB2 product development team. His work includes numerous topics in autonomic computing and relational database management systems. He is cofounder and leader of DB2s autonomic computing R&D effort. He is Chair of the IEEE Data Engineering Workgroup on Self Managing Database Systems and a member of the IEEE Computer Society Task Force on Autonomous and Autonomic Computing. In 2003 he was elected to the Canadian Technical Excellence Council, the Canadian affiliate of the IBM Academy of Technology. He is an IBM Master Inventor with over 25 patents and patents pending; he has published widely on autonomic computing for relational database systems. He has been with IBM since 1991. Tom Nadeau is the founder of Aladdin Software (aladdinsoftware.com) and works in the area of data and text mining. He received his B.S. degree in computer science and M.S. and Ph.D. degrees in electrical engineering and computer science from the University of Michigan, Ann Arbor. His technical interests include data warehousing, OLAP, data mining and machine learning. He won the best paper award at the 2001 IBM CASCON Conference. H.V. Jagadish is a professor in EE and CS at the University of Michigan, Ann Arbor, where he is part of the database group affiliated with the bioinformatics program and the Center for Computational Medicine and Bioinformatics. Prior to joining the Michigan faculty, he spent over a decade at AT&T Bell Laboratories as a research scientist where he became head of the Database division.