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...

Full description

Bibliographic Details
Other Authors: The Pennsylvania State University CiteSeerX Archives
Format: Text
Language:English
Subjects:
DML
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
id ftciteseerx:oai:CiteSeerX.psu:10.1.1.399.9294
record_format openpolar
spelling ftciteseerx:oai:CiteSeerX.psu:10.1.1.399.9294 2023-05-15T16:01:43+02:00 CSCI 305 – F13, Lecture 2 [Slides originally assembled by Prof. King] The DBMSDBMS • Database Management System The Pennsylvania State University CiteSeerX Archives application/pdf 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 en eng 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 Metadata may be used without restrictions as long as the oai identifier remains attached to it. http://www.eg.bucknell.edu/~csci305/F13/305-01_Intro_SMG.pdf text ftciteseerx 2016-09-25T00:13:53Z – 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 Text DML Unknown
institution Open Polar
collection Unknown
op_collection_id ftciteseerx
language English
description – 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
author2 The Pennsylvania State University CiteSeerX Archives
format Text
title CSCI 305 – F13, Lecture 2 [Slides originally assembled by Prof. King] The DBMSDBMS • Database Management System
spellingShingle CSCI 305 – F13, Lecture 2 [Slides originally assembled by Prof. King] The DBMSDBMS • Database Management System
title_short CSCI 305 – F13, Lecture 2 [Slides originally assembled by Prof. King] The DBMSDBMS • Database Management System
title_full CSCI 305 – F13, Lecture 2 [Slides originally assembled by Prof. King] The DBMSDBMS • Database Management System
title_fullStr CSCI 305 – F13, Lecture 2 [Slides originally assembled by Prof. King] The DBMSDBMS • Database Management System
title_full_unstemmed CSCI 305 – F13, Lecture 2 [Slides originally assembled by Prof. King] The DBMSDBMS • Database Management System
title_sort csci 305 – f13, lecture 2 [slides originally assembled by prof. king] the dbmsdbms • database management system
url 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
genre DML
genre_facet DML
op_source http://www.eg.bucknell.edu/~csci305/F13/305-01_Intro_SMG.pdf
op_relation 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
op_rights Metadata may be used without restrictions as long as the oai identifier remains attached to it.
_version_ 1766397471147163648