Foundations of Database Design – serie

Until now, almost all books on logical database design focused exclusively on relational design. However, modern database management systems have added powerful features that have driven a movement away from truly normalized database design. Logical Database Design Principles reflects these recent changes. The book begins by covering traditional logical design principles, followed by an analysis of the normalizing and modeling of data. It then examines designing for specific purposes, such as object-oriented databases, online transaction processing (OLTP), and data warehouses. As the text progresses, it moves from the purely logical into some physical design, as determined by how the features of modern databases are implemented.Because this is a logical-design book, the authors attempt to make the examples database-neutral. Because various vendors implement features in different ways, this volume sometimes offers examples from a specific database management system. When necessary, it highlights a specific application, clearly demonstrating the concept being discussed.

Today's database professionals must understand how to apply database systems to business processes and how to develop database systems for both business intelligence and Web-based applications.Database Development and Management explains all aspects of database design, access, implementation, application development, and management, as well as data analysis for business intelligence. This self-contained text gives students hands-on projects required for professionally developing and managing databases. It provides detailed instruction via an easy-to-follow, step-by-step case-based approach.Following an introduction to database components, the book uses case studies to illustrate the modeling process, covers table structures and normalization, and analyzes the transformation of a data model to a relational database. It explains the use of SQL in managing database objects and in querying databases, then discusses Transact-SQL and the views, indexes, and cursors that bridge databases and their applications.The book examines three major data-accessing techniques, and then shows how to develop sophisticated applications based upon the material included in previous chapters. It explores the use of databases in network environments, and details the multiple tasks handled by database administrators (DBAs).The text also discusses the OnLine Analytical Processing (OLAP) system, data warehousing, and other analysis tools that support business intelligence and decision making. It concludes with a review of data mining.

Today's database professionals must understand how to apply database systems to business processes and how to develop database systems for both business intelligence and Web-based applications.Database Development and Management explains all aspects of database design, access, implementation, application development, and management, as well

Today's database professionals must understand how to apply database systems to business processes and how to develop database systems for both business intelligence and Web-based applications.Database Development and Management explains all aspects of database design, access, implementation, application development, and management, as well