CSCI 305 – F13, Lecture 2 [Slides originally assembled by Prof. King] The DBMSDBMS • Database Management System
– Specialized software design for the sole purpose of providing services to store, manage, and query data in an efficient mannerTask #1 – Create new DB • A DBMS allows a DB administrator to specify the DB schema – Schema is a DB blueprint – Uses some type of data definition language (DDL) – Is usual...
| Other Authors: | |
|---|---|
| Format: | Text |
| Language: | English |
| Subjects: | |
| Online Access: | http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.399.9294 http://www.eg.bucknell.edu/~csci305/F13/305-01_Intro_SMG.pdf |
| Summary: | – Specialized software design for the sole purpose of providing services to store, manage, and query data in an efficient mannerTask #1 – Create new DB • A DBMS allows a DB administrator to specify the DB schema – Schema is a DB blueprint – Uses some type of data definition language (DDL) – Is usually a part of the query language (e.g., SQL) – Example: Task #2 – Allow querying data • Query languages are used to request specific data from databases – Sometimes called a Data-Manipulation Language (DML) • Examples: – SQL – very common; especially for relational |
|---|