tailieunhanh - Database Modeling and Design

In 1983, RSI was renamed Oracle Corporation to avoid confusion with a competitor named RTI. At this time, the developers made a critical decision to create a portable version of Oracle (Version 3) that ran not only on Digital VAX/VMS systems, but also on Unix and other platforms. By 1985, Oracle claimed the ability to run on more than 30 platforms. Some of these platforms are historical curiosities today, but others remain in use. (In addition to VMS, early operating systems supported by Oracle included IBM MVS, DEC Ultrix, HP/UX, IBM AIX, and Sun’s Solaris version of Unix.) Oracle was able to leverage and accelerate the growth. | Database Modeling and Design 3rd Edition Toby J. Teorey University of Michigan Lecture Notes Contents I. Database Systems and the Life Cycle Chapter 1 .2 Introductory concepts objectives of database management 2 Relational database life cycle 3 Characteristics of a good database design process 7 II. Requirements Analysis Chapter 3 .8 III. Entity-Relationship ER Modeling Chapters 2-4 . 11 Basic ER modeling concepts 11 Schema integration methods 22 Entity-relationship 26 Transformations from ER diagrams to SQL Tables 29 IV. Normalization and normal forms Chapter 5 .35 First normal form 1NF to third normal form 3NF and BCNF 35 3NF synthesis algorithm Bernstein 42 Fourth normal form 4NF 47 V. Access Methods Chapter 6 .50 Sequential access methods 50 Random access methods 52 Secondary Indexes 58 Denormalization 62 Join strategies 64 VI. Database Distribution Strategies Chapter 8 .66 Requirements of a generalized DDBMS Date s 12 Rules 68 Distributed database requirements 72 The non-redundant best fit method 74 The redundant all beneficial sites method 77 VII. Data Warehousing OLAP and Data Mining Chapter 9 .79 Data warehousing 79 On-line analytical processing OLAP 86 Data mining 93 Revised 11 18 98 - modify Section V Revised 11 21 98 - insertions into Section VII Revised 1 14 99 - modify Section VI Revised 2 11 99 - modify Section IV 4NF FD MVD mix Revised 6 13 00 - modify Section V secondary indexes 1 I. Database Systems and the Life Cycle Introductory Concepts data a fact something upon which an inference is based information or knowledge has value data has cost data item smallest named unit of data that has meaning in the real world examples last name address ssn political party data aggregate or group -- a collection of related data items that form a whole concept a simple group is a fixed collection . date month day year a repeating group is a variable length collection . a set of aliases. record group of related data items treated as a unit by an .