ITM 100 Lecture Notes - Lecture 6: Data Definition Language, Software Framework, Referential Integrity

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 100
• Professor: Sui Sui

Document Summary

Analytic platform: platforms using both relational and non-relational technology that are optimized for analyzing large datasets. Attribute: a characteristic or quality describing a particular entity. Big data: datasets with volumes so huge that they are beyond the ability of typical. Bit: the smallest unit of data a computer can handle. Byte: a group of bits which can represent a single character such as a letter, a number, or another symbol. Data administration: responsible for the specific policies and procedures through which data can be managed as an organizational resource. Data cleansing: consists of activities for detecting and correcting data in a database that are incorrect, incomplete, improperly formatted, or redundant. Data definition: dbms"s ability to specify the structure of the content of the database. Data dictionary: an automated or manual file that stores definitions of data elements and their characteristics.