Database management system Essay

Submitted By Abdelkaderr
Words: 875
Pages: 4
Open Document
CSCI 305 – F13, Lecture 2
[Slides originally assembled by Prof. King]

The DBMS

DBMS
• Database Management System
– DBMS
– Specialized software design for the sole purpose of providing services to store, manage, and query data in an efficient manner

Task #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 databases – XQuery – used for XML repositories

Task #3 – Large amounts of data
• A modern DBMS must handle an enormous amount of data efficiently
• It must be scalable
• It must be reliable and offer persistence
– (i.e. keep the data around for a LONG time)

Task #4 - Durability
• A DBMS must be resilient in the face of:
– Hardware failure
– Periods of heavy use
• Must still be responsive
• Think – Amazon in December!

– Attempts to breach security

Task #5 - concurrency
• Provide concurrent access with isolation and atomicity: – Ensure isolation among concurrent users
– Ensure individual DB actions to be atomic

Evolution of the database

The data model
• Every database system has an underlying model that determines
– Structure placed on the data
– Operations on the data
– Constraints on the data

• Let's explore the history of these models, specifically focusing on the structure for now…

Flat File
• aka - table model
• Entire database consists of a single table
– spreadsheet

• Often stored in a standard text file, CSV or tabdelimited
• Example...

• Simple user database for a system admin

Flat file
• Discuss advantages / disadvantages
– HINT – consider an order management system.
How would you have a single table containing everything you need with orders?

• Still occasionally used for simple designs
– Even here it is usually discouraged. Why?
– Always need to consider scalability!

Hierarchical Database Model
• 1960s – 1970s
• Data is organized into a tree-like structure
• Restriction – must maintain tree structure
– Parents have many children
– Children have only one parent

• Introduced by IBM with IMS – Information
Management System
– Also used by the Windows Registry!

• Image from oracle.com

Relational Model
•
•

Used by the majority of modern database management systems (DBMS)
Database = set of relations (or tables)
– Each relation in the database has a distinct name
– Example: Student, Campus

•

Each relation has a set of attributes
– Each attribute has a distinct name, used to describe the entities in the relation
– Example: Students have FirstName, LastName, ID, SS#, etc.

•

Tuple has a value for each attribute, representing a single entity
– Example: Each student in the class is a tuple
– An specific entity, Brian

•

Each attribute has a type (or domain)
– ID:char(9), name:char(25), GPA:float

•

One attribute is used to represent something unique about the record
– Called a key
– Other tables reference this key instead of containing duplication information
• This is what makes it relational

• Widespread use today!
• Yet, it has its challenges
– Type system
– Implementation of a table
• Are you going to keep the entire facebook database of users in memory at all times? (Probably not!)
• Rarely implemented as a 2D table…

Object-oriented model
• You'll also see object-relational model
• A relational model with the restriction that the underlying database system has the same type system as the application program
– What benefits does this offer the application developer? – JDBC

Example

Better example
Look familiar?
UML Class diagram! Semi-structured
Show More

Related Documents: Database management system Essay

Database: Database and Database Management Systems Essay

A database is a table consisting ofcolumns (fields) and rows (records) where each column contains a specific attribute and each row features a certain value for the corresponding attribute. The number of columns within a single table depends on how many different types/categories of information we need to store within a database, while the number of rows is defined by the quantity of the objects that have to be introduced categorized records for. This kind of simple organization of the data in database…

Words 1052 - Pages 5

The Use Of Databases And Database Management Systems

storing and converting raw data bits into useful information. This complex process can only be achieved through the use of databases and database management systems (DBMS), where information is logically placed, arranged, and related enabling information to be accessed at some point in the future. It’s important to note that although it’s not completely obvious, databases are utilized in nearly any organization in the modern world. They are crucial in many parts of an organization and can assist…

Words 775 - Pages 4

Systems: Sql and Database Management Systems Essay

ch 7 Systems 1. When doing a traditional file you can make an error and it could be wrong in more than one location making it a huge problem. Also it takes up tons of space which means money. 2. A database typically stores data values in tables. Databases offer a greater range of complexity in terms of data manipulation. With database management systems, several people can access the same data set. 3. Database management system is a software that manages database on a computer. Eg. Microsoft…

Words 400 - Pages 2

Advantages And Disadvantages Of Database Management System

A Database Management System (DBMS) is a software package that comes with computer programs with which we can control the creation, maintenance and use of a database. A database is an integrated collection of data records, files and other objects that are maintained with the help of database administrators and other specialists. DBMS may use variety of data models such as relational model or object model in order to describe and support applications. It supports query languages that are dedicated…

Words 828 - Pages 4

Cloud: Database Management System and Vcu Essay

INFO 610 - 901 Analysis and Design of Database Systems Instructor Instructors: Dr. Victoria Yoon Office Location: Snead Hall B4113 Phone: 804.828.0672 Email: vyyoon@vcu.edu Office Hours: Tuesday 4:30pm – 6:30pm Other times by appointment Course Description: The course is designed to prepare students for the development of information systems using databases and database management techniques. Learning Outcomes: Upon successful completion of the course the student will: • Be…

Words 2059 - Pages 9

Difference Between Database Management And Information Retrieval System

QUESTION 1 Differentiate between Database Management System and Information Retrieval System by focusing on their functionalities DEFINITION DATABASE MANAGEMENT SYSTEM (DBMS)  Database management system program that enables users to store, modify and extract information from databases.  Software that uses a standard method of cataloguing, retrieving, and running queries on data. It also manages incoming data, organizes it, and provides ways for data to be modified, extracted by other user and…

Words 1250 - Pages 5

Distributed Database System Essay

INTRODUCTION Databases have become an important function of everyday life in the management of business or departments as now it is possible to have an access to numerous websites and the information that is kept in these sites (Cavage 2013). A distributed database system is composed of a distributed database that administers or manages the distributed database management system while a distributed database system is a compilation of data that is logically interconnected over several sites that…

Words 1375 - Pages 6

Database Essay

Chapter 03: Database Systems, Data Centers, and Business Intelligence TRUE/FALSE 1. A database, a database management system, and the application programs that use the data make up a database environment. ANS: T PTS: 1 REF: Why Learn About Database Systems, Data Centers, And Business Intelligence 2. A database scientist is a skilled and trained IS professional who directs all activities related to an organization’s database, including providing security from intruders. ANS: F PTS: 1 REF:…

Words 3288 - Pages 14

Database Design Essay

Database Design Dustin Brown DBM380 March 23rd, 2015 Debra Martin Database Design Databases are a key elements of today’s business world. Almost every company in the world makes use of databases to help store, process, and utilize information to achieve various tasks and goals. To get the most out of databases companies employ database management systems. In this paper we will be taking a look at what database systems are, as well as the architecture that defines them. Before we begin it is important…

Words 773 - Pages 4

Database: Database and Microsoft Excel Essay

Database Database A database system is defined as a integrated computer structure which stores collections of end user or meta data. In any organization, a database system is very important. Databases can be used to store any information you to collect and store. This information could be a company storing information on all of its employees or a company collecting monthly sales data. The size of the organization or company will determine how you will store this data. Microsoft Access is a great…

Words 412 - Pages 2