Database Modeling & Design Fourth Edition- P57: Database technology has evolved rapidly in the three decades since the rise and eventual dominance of relational database systems. While many specialized database systems (object-oriented, spatial, multimedia, etc.) have found substantial user communities in the science and engineering fields, relational systems remain the dominant database technology for business enterprises. | Index 267 defined 33-34 example 43-46 notation 35-37 packages 43-46 See also UML diagrams Classes associations 37 defined 34 entities vs. 34-35 notation 35 organization 43 Clustering 74-81 concepts 75-76 defined 74 grouping operations 76-78 illustrated 76 results 81 techniques 78-81 See also Entity-relationship ER model Collaboration capabilities 200-201 concurrency control 200 support 200-201 Columns 2 Comparison operators 214 Compliance checkers 204-5 Composition 36-37 aggregation vs. 41 defined 37 Computer-aided software engineering tools. See CASE tools Conceptual data modeling 3-4 8-10 55-66 alternative notations 20-22 analysis results 142 diagram for UML 142 emphasis 9 notations 21-22 substeps 55-56 transformation to SQL 6 83-106 See also Data modeling Concurrency control 200 Constraints foreign 217 not null 216 primary 217 unique 216-17 Data independence 2 items 2 semi-structured 209-10 summarizing 165-66 XML 209-10 Database design class diagrams for 37-43 compliance checking 204-5 knowledge of 11 logical 3-6 53-54 139-45 physical 1 6-8 Database life cycle 3-8 illustrated 4 implementation 8 logical design 3-6 physical design 6-8 requirements analysis 3 step-by-step results 5 7 Database management system DBMS DDL 8 defined 2 relational 2 Databases CASE tools support 199-200 defined 2 generating from designs 196-99 Data definition language DDL 8 190 196 213 215-18 constraints 216-17 referential trigger actions 217-18 Data manipulation language DML 8 214 218-29 aggregate functions 222-24 basic commands 220-21 intersection command 221-22 268 Index Data manipulation language DML cant d. referential integrity 227-28 select command 219 union command 221-22 update commands 226-27 usage 218 views 228-29 Data mining 178-85 algorithms 147 178 forecasting 179-81 text mining 181-85 Data modeling conceptual 3-4 8-10 55-66 example 61-66 example illustration 62-63 65 knowledge of 11 Data warehouses 148-66 architecture 148 architecture illustration 150 bus 164 CASE tool .
