Practical Issues in Database Management: A Refernce for the Thinking Practitioner
Databasics clearly explains the key concepts users and database professionals need to understand in order to build well-designed databases that answer business questions accurately and efficiently. Fabian Pascal, one of the industry's leading experts, identifies ten critical, recurring issues that both database users and vendors often fail to address appropriately. Among the topics covered: unstructured data and complex data types; business rules and enforcing data integrity; keys; duplicates; normalization; entity subtypes and supertypes; data hierarchies and recursive queries; redundancy; quota queries; and how to handle missing information. Along the way, Pascal offers no-holds-barred assessments of how well current SQL implementations and commercial products address each issue. Databasics, in short, is a complete guide to building databases right the first time, so they don't have to be rebuilt later. For all DBAs, developers, managers, and end-users that need to understand the best ways to design and implement database systems.
26 pages matching integrity constraints in this book
Results 1-3 of 26
What people are saying - Write a review
We haven't found any reviews in the usual places.
Possible Representations for Image Types
11 other sections not shown
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