BUSI 3400 Chapter Notes - Chapter 2: Unstructured Data, Nosql, Online Analytical Processing
4 May 2017
School
Department
Course
Professor
Document Summary
Data modeling: iterative and progressive process of creating a specific data model for a determined problem domain. Data models: simple representations of complex real-world data structures. useful for supporting a specific problem domain. Model: abstraction of a real-world object or event. Entity: person, place, thing or eventunique and distinct object used to collect and store data. Constraint: set of rules to ensure data integrity. Business rules: brief, precise, and unambiguous description of a policy, procedure, or principal. Importance of business rules: standardize company view of data, com tool between user and designer, allow designer to do (adtm, daprcn, udrsndtbp) Hierarchical model: developed to manage large amounts of data for complex manufacturing projects. Network model: created to represent complex data relationships effectively . Improved database performance and imposed a database standard. (1:m and m:m relationships) Schema: conceptual organization of the entire database as viewed by the database admin.
