Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Relational databases --- Database design --- Database management --- Entity-relationship modeling --- 681.3*H2 --- 681.3*E --- EAR modeling --- Entity-attribute-relationship modeling --- ER modeling --- Information modeling --- Data base design --- System design --- Database management: security; integrity; protection--See also {?681.5*E5} --- Data --- 681.3*E Data --- 681.3*H2 Database management: security; integrity; protection--See also {?681.5*E5}

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

681.3*H2 --- 681.3*H2 Database management: security integrity protection--See also {?681.5*E5} --- Database management: security integrity protection--See also {?681.5*E5} --- Entity-relationship modeling --- Database management: security; integrity; protection--See also {?681.5*E5} --- 681.3*H2 Database management: security; integrity; protection--See also {?681.5*E5} --- Database design --- Database management --- Relational databases --- Relational data bases --- Databases --- Data base management --- Data services (Database management) --- Database management services --- DBMS (Computer science) --- Generalized data management systems --- Services, Database management --- Systems, Database management --- Systems, Generalized database management --- Electronic data processing --- Data base design --- System design

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

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.

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

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 fourth 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

Relational databases --- Database design --- Bases de données relationnelles --- Bases de données --- Conception --- Relational databases. --- Database design. --- Data base design --- System design --- Relational data bases --- Databases --- Bases de données relationnelles --- Bases de données --- Information Technology --- General and Others --- Informatica --- Systeemontwikkeling

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

I highly recommend Physical Database Design by Lightstone, Teorey, and Nadeau. The book covers fine aspects of physical design -- issues such as the effects of different approaches to indexes, tradeoffs in materializing views, and details of physical data layout. Unlike other books, it does not focus on a particular product, but instead covers the deep principles that cut across products. The book addresses both transaction intensive applications (OLTP) as well as data warehouses (OLAP). Their new book is a welcome addition to the literature. --Michael Blaha, OMT Associates, Inc. This is an excellent book on physical database design, giving pragmatic models and advice. It has a wealth of information for both the student and for the practitioner -- presenting analytic models and practical tips that are demonstrated with examples using Oracle, DB2, and Microsoft SQL Server. --Jim Gray, Microsoft Research 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 improved using the methods provided in the book. Features The first complete treatment on physical database design, written by the authors of the seminal, Database Modeling and Design: Logical Design, 4th edition. Includes an introduction to the major concepts of physical database design as well as detailed examples, using methodologies and tools most popular for relational databases today: Oracle, DB2 (IBM), and SQL Server (Microsoft). Focuses on physical database design for exploiting B+tree indexing, clustered indexes, multidimensional clustering (MDC), range partitioning, shared nothing partitioning, shared disk data placement, materialized views, bitmap indexes, automated design tools, and more! The first complete treatment on physical database design, written by the authors of the seminal, Database Modeling and Design: Logical Design, 4th edition. Includes an introduction to the major concepts of physical database design as well as detailed examples, using methodologies and tools most popular for relational databases today: Oracle, DB2 (IBM), and SQL Server (Microsoft). Focuses on physical database design for exploiting B+tree indexing, clustered indexes, multidimensional clustering (MDC), range partitioning, shared nothing partitioning, shared disk data placement, materialized views, bitmap indexes, automated design tools, and more!