CP102 Study Guide - Final Guide: Database, Sql, Scalable Vector Graphics
Document Summary
Data mining: process of analyzing existing database information to discover previously unknown and potentially useful information, including relationships and patterns. Predictive analytics: analyze existing facts to make predictions about future events. Online analytical processing (olap) allows decision makers to quickly get answers to complex queries. Unstructured file: unique structure and contains different kinds of data. Structured file: uses a uniform format to store data. Flat file: consists of a single, two-dimensional table of data elements. Field: contains the smallest unit of meaningful information. Relationship: association between data that is stored in different record types. Cardinality: refers to the number of associations that can exist between two record types. Hierarchical database: allows one-to-one and one-to-many relationships, linked in a hierarchical structure. Network database: uses a mesh-like structure to offer the additional capacity to define many-to-many relationships. Relational database: stores data in a collection of related tables. Dimensional database: organizes relationships over three or more dimensions.
