COMMERCE 2KA3 Study Guide - Final Guide: Nosql, Unstructured Data, Data Warehouse

• School: McMaster University
• Department: Commerce
• Course: COMMERCE 2KA3
• Professor: Ali Reza Montazemi

Document Summary

High-speed platforms using both relational and non-relational tools. Each characteristic or quality describing a particular entity. Handle large volumes of structured and unstructured data: bi analytical. The smallest unit of data a computer can handle: business. In memory computing a group of 8 bits representing a single character (letter, number, etc) Massive set of unstructured or semi- structured data. Cannot be stored and analyzed using traditional dbms: database mngmt. Cleansing/scrubbing: data definition, data dictionary, data governance, the data hierarchy, data inconsistency, data manipulation. A db built and accessed through a cloud platform. E. g amazon"s simpledb and rds: data mining (5, columns. Responsible for the specific policies and procedures through which data can be managed as an organizational resource: database. Responsible for defining and organizing the structure and content of the database, and maintaining the db. Software that permits an org to centralize data, manage them efficiently, and provide access to the stored data by app programs.