SYSTEMS DEVELOPMENT LIFE CYCLE: DATA ANALYSIS METHODS

By S. MILAY

CONTENTS INTRODUCTION INFORMATION MODELING MODELING APPROACHES SOME HISTORICAL BACKGROUND THE RELEVANT SKILLS SUMMARY INFORMATION LEVELS AND FRAMEWORKS FOUR INFORMATION LEVELS THE CONCEPTUAL LEVEL FROM EXTERNAL TO CONCEPTUAL TO RELATIONAL DEVELOPMENT FRAMEWORKS CONCEPTUAL MODELING: FIRST STEPS CONCEPTUAL MODELING LANGUAGE CRITERIA ORM’S CONCEPTUAL SCHEMA DESIGN PROCEDURE CSDP STEP 1: FROM EXAMPLES TO ELEMENTARY FACTS CSDP STEP 2: DRAW FACT TYPES, AND POPULATE CSDP STEP 3: TRIM SCHEMA; NOTE BASIC DERIVATIONS UNIQUENESS CONSTRAINTS CSDP STEP 4: UNIQUENESS CONSTRAINTS; ARITY CHECK UNIQUENESS CONSTRAINTS ON UNARIES AND BINARIES UNIQUENESS CONSTRAINTS ON LONGER FACT TYPES EXTERNAL UNIQUENESS CONSTRAINTS KEY LENGTH CHECK PROJECTION-JOIN CHECK MANDATORY ROLES INTRODUCTION TO CSDP STEP MANDATORY AND OPTIONAL ROLES LOGICAL DERIVATION CHECK REFERENCE SCHEMES CASE STUDY: A COMPACT DISC RETAILER VALUE, SET-COMPARISON, AND SUBTYPE CONSTRAINTS CSDP STEP 6: VALUE, SET, AND SUBTYPE CONSTRAINTS BASIC SET THEORY VALUE CONSTRAINTS AND INDEPENDENT OBJECTS SUBSET, EQUALITY, AND EXCLUSION CONSTRAINTS SUBTYPING GENERALIZATION OF OBJECT TYPES OTHER CONSTRAINTS AND FINAL CHECKS CSDP STEP 7: OTHER CONSTRAINTS; FINAL CHECKS OCCURRENCE FREQUENCIES RING CONSTRAINTS OTHER CONSTRAINTS FINAL CHECKS ENTITY RELATIONSHIP MODELING OVERVIEW OF ER BARKER NOTATION INFORMATION ENGINEERING NOTATION IDEF1X MAPPING FROM ORM TO ER DATA MODELING IN UML OBJECT REFERENCE AND SINGLE-VALUED ATTRIBUTES MULTI-VALUED ATTRIBUTES ASSOCIATIONS SET COMPARISON CONSTRAINTS OTHER CONSTRAINTS AND DERIVATION RULES MAPPING FROM ORM TO UML RELATIONAL MAPPING IMPLEMENTING A CONCEPTUAL SCHEMA RELATIONAL SCHEMAS RELATIONAL MAPPING PROCEDURE ADVANCED MAPPING ASPECTS RELATIONAL LANGUAGES RELATIONAL ALGEBRA RELATIONAL DATABASE SYSTEMS SQL: HISTORICAL AND STRUCTURAL OVERVIEW SQL: IDENTI?ERS AND DATA TYPES SQL: CHOOSING COLUMNS, ROWS, AND ORDER SQL: JOINS SQL: IN, BETWEEN, LIKE, AND NULL OPERATORS SQL: UNION AND SIMPLE SUBQUERIES SQL: SCALAR OPERATORS AND BAG FUNCTIONS SQL: GROUPING SQL: CORRELATED AND EXISTENTIAL SUBQUERIES SQL: DATA DE?NITION SQL: UPDATING TABLE POPULATIONS SQL: SECURITY AND META-DATA SCHEMA TRANSFORMATIONS SCHEMA EQUIVALENCE AND OPTIMIZATION PREDICATE SPECIALIZATION AND GENERALIZATION NESTING, CO-REFERENCING AND FLATTENING OTHER CONCEPTUAL TRANSFORMATIONS CONCEPTUAL SCHEMA OPTIMIZATION NORMALIZATION DENORMALIZATION AND LOW LEVEL OPTIMIZATION RE-ENGINEERING OTHER MODELING ASPECTS AND TRENDS DATA WAREHOUSING AND OLAP CONCEPTUAL QUERY LANGUAGES SCHEMA ABSTRACTION MECHANISMS PROCESS MODELING AND EXTERNAL DESIGN POST-RELATIONAL DATABASES AND OTHER TRENDS META-MODELING