Beginning Database Design
Book Details:
Pages: | 504 |
Published: | Dec 05 2005 |
Posted: | Nov 19 2014 |
Language: | English |
Book format: | PDF |
Book size: | 10.65 MB |
Book Description:
The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficientlyShows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and OracleCovers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performanceProvides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements
From Novice to Professional
2nd Edition
Beginning Database Design, Second Edition provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, youll learn to discover and represent the details and scope of any design problem you choose to attack. Database design is not an exact science. Many are surprised to find that problems with their databases are caused by poor design rather than by difficulties in using the database management software. Beginning Database Design, S...
A Hands-On Guide to Relational Database Design
2nd Edition
'This book takes the somewhat daunting process of database design and breaks it into completely manageable and understandable components. Mike's approach whilst simple is completely professional, and I can recommend this book to any novice database designer.' Sandra Barker, Lecturer, University of South Australia, Australia 'Databases are a critical infrastructure technology for information systems and today's business. Mike Hernandez has written a literate explanation of database technologya topic that is intricate and often obscure. If you design databases yourself, this book will educate you about pitfalls and show you what to do. If you purchase pr...
The database professional's guide to exploiting indexes, views, storage, and more
The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration. Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be impr...
2007 - 2021 © eBooks-IT.org