MGS 351 Study Guide - Midterm Guide: Data Manipulation Language, Data Definition Language, Database

• School: University at Buffalo
• Department: Management Science and Systems
• Course: MGS 351
• Professor: David Murray

Document Summary

Database management system components: data definition language (ddl, specifies content and structure of database and defines each data element. Data type, length, properties: example: creating tables, data manipulation language (dml, manipulates data records in a database, record insertion or deletion, example, data dictionary, stores definitions of data elements and data characteristics, keeps or stores ddl, example: Database design: conceptual/logical design, abstract model of database from business perspective, example - how business operates, physical design, determines how the database is arranged, optimized, and tuned on storage devices. A subset of data warehouse in which only a focused portion of the data warehouse information is kept. Used to find hidden patterns and previously unknown trends in data. Computer system with software that can analyze and display data using digitized maps: enables display and analysis of spatial information, examples, location analyses, law enforcement, identification of efficient delivery routes.