Practical Issues in Database Management: A Reference for the Thinking Practitioner--C. J. Date Three decades ago relational technology put the database field on a sound, scientific foundation for the first time. But the database industry--vendors, users, experts, and the trade press--has essentially flouted its principles, focusing instead on a cookbook, product-specific approach, devoid of conceptual understanding. The consequences have been costly: DBMS products, databases, development tools, and applications dont always perform up to expectation or potential, and they can encourage the wrong questions and provide the wrong answers. Practical Issues in Database Management is an attempt to remedy this intractable and costly situation. Written for database designers, programmers, managers, and users, it addresses the core, commonly recurring issues and problems that practitioners--even the most experienced database professionals--seem to systematically misunderstand, namely: *Unstructured data and complex data types *Business rules and integrity enforcement *Keys *Duplicates *Normalization and denormalization *Entity subtypes and supertypes *Data hierarchies and recursive queries *Redundancy *Quota queries *Missing information Fabian Pascal examines these crit |
Cosa dicono le persone - Scrivi una recensione
Nessuna recensione trovata nei soliti posti.
Indice
Chapter | 1 |
Chapter | 3 |
Possible Representations for Image Types | 25 |
Copyright | |
11 sezioni non visualizzate
Parole e frasi comuni
100 Spenser 110 Lucchessi A00 130 Quintana 310 Setright Addison-Wesley assigned attributes base tables business rules C. J. Date Cake mix box candidate keys Chapter character strings CM1 CM1 CM1 commission complex CREATE TABLE data types database design DBMS DBMS support DBMS vendors Declared representation defined DELETE denormalization domain duplicate rows Dvorak Dvorak.org employee numbers ENAME DEPT enforce entity types example FINGERPRINT foreign key format fully normalized HIREDATE SALARY identified implementation integrity constraints Java Java servlets key constraint logical metadata MVDs node normal form Note NULL O'Connell A00 object class optimization Parker D31 PC Magazine predicate primary key PROJ proprietary Quintana C01 quota queries RDBMS real world redundancy referential Relational Database Writings repeating groups result SALE_AMT set applicable Setright D31 Spenser E21 SQL DBMSs stored procedure supertables surrogate key system-defined table in Figure table operation Type constraint unique user-defined users
Riferimenti a questo libro
Database Design for Mere Mortals: A Hands-on Guide to Relational Database Design Michael James Hernandez Visualizzazione frammento - 2003 |
Database Design for Mere Mortals: A Hands-on Guide to Relational Database Design Michael James Hernandez Visualizzazione frammento - 2003 |