Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

CSIS 350 Lecture 1: Introduction to Databases and Database Management Systems, Study notes of Database Management Systems (DBMS)

An introduction to databases and database management systems (dbms) in the context of a university course, csis 350. The lecture covers the basics of databases, their applications, and the importance of dbmss. The document also discusses three major data models used in dbmss: hierarchical, network, and relational. Each model is explained with examples and advantages and disadvantages.

Typology: Study notes

Pre 2010

Uploaded on 08/05/2009

koofers-user-y5g
koofers-user-y5g 🇺🇸

10 documents

1 / 7

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CSIS 350 – Lecture 1
Go over syllabus. Discuss a typical class period.
Ask what is a database?
- A collection of data items related to some enterprise
oFor example, customer account information in a bank
oMight be stored in a Rolodex or a file cabinet
oWe’re really more interested in computer databases
- A set of related information
- A collection of related data elements
- An organized collection of data used for the purpose of modeling some type of
organization or organizational process
- System for storing data so that information can be derived from it.
-
See if anyone has ever used a database. Discuss applications that use databases: Banner/
WebOpus, Amazon.com, online banking/ATM, Google, airline reservation/scheduling
system, City Market, medical office, others?
Database Management System (DBMS)
System that creates, processes, and administers the database.
Collection of components that supports creation, use, and maintenance of databases.
How is data organized by a DBMS?
Three major Data models used in DBMSs: Hierarchical, network, relational
Hierarchical Model
Data is organized hierarchically, which we can diagram with a tree.
Example: Entertainers sign up with agents, who book jobs for them with clients.
pf3
pf4
pf5

Partial preview of the text

Download CSIS 350 Lecture 1: Introduction to Databases and Database Management Systems and more Study notes Database Management Systems (DBMS) in PDF only on Docsity!

CSIS 350 – Lecture 1

Go over syllabus. Discuss a typical class period. Ask what is a database?

  • A collection of data items related to some enterprise o For example, customer account information in a bank o Might be stored in a Rolodex or a file cabinet o We’re really more interested in computer databases
  • A set of related information
  • A collection of related data elements
  • An organized collection of data used for the purpose of modeling some type of organization or organizational process
  • System for storing data so that information can be derived from it.

See if anyone has ever used a database. Discuss applications that use databases: Banner/ WebOpus, Amazon.com, online banking/ATM, Google, airline reservation/scheduling system, City Market, medical office, others? Database Management System (DBMS) System that creates, processes, and administers the database. Collection of components that supports creation, use, and maintenance of databases. How is data organized by a DBMS? Three major Data models used in DBMSs: Hierarchical, network, relational Hierarchical Model Data is organized hierarchically, which we can diagram with a tree. Example: Entertainers sign up with agents, who book jobs for them with clients.

QuickTime™ and a TIFF (LZW) decompressor are needed to see this picture. (From Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design , Second Edition, chapter 1, Michael Hernandez)

"A relationship in a hierarchical database is represented by the

term parent/child. In this type of relationship, a parent table can

be associated with one or more child tables, but a single child

table can be associated with only one parent table. These tables

are explicitly linked via a pointer or by the physical

arrangement of the records within the tables. A user accesses

data within this model by starting at the root table and working

down through the tree to the target data. This access method

requires the user to be very familiar with the structure of the

database."

Advantages

  • very fast
  • referential integrity is easy to maintain

Disadvantages

  • Difficult to support complex relationships
  • Redundant data

o Schedule table may include duplicated information

about clients

o Engagement table may include duplicated info about

entertainers

Hierarchical model worked well with magnetic tape based storage

systems common in the 1970s.

Network Model Attempt to address some of the problems with hierarchical model QuickTime™ and a TIFF (LZW) decompressor are needed to see this picture. (From Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design , Second Edition, chapter 1, Michael Hernandez)

"Agent represents a number of clients and manages a number of

entertainers. Each client schedules any number of engagements

and makes payments to the agent for his or her services. Each

entertainer performs a number of engagements and may play a

variety of musical styles."

"A node represents a collection of records, and a set structure

establishes and represents a relationship in a network database.

It is a transparent construction that relates a pair of nodes

together by using one node as an owner and the other node as a

member ."

Sets are maintained with physical links (pointers) in the database.

Key points:

  1. A node can be a member of multiple sets (e.g., Engagements)
  2. Queries can start at any node Benefits
  • fast
  • supports more complex queries than hierarchical model. Drawbacks
  • Users must have a thorough understanding of the set structure
  • Difficult to reorganize Relational Model Invented in 1969 by E.F. Codd at IBM Not commercially developed until late 1970s Most DBs today use relational model Data is stored in relations , which appear to be tables Each record in a relation is uniquely identified Unlike hierarchical and network models, where the data is stored does not matter – there are no physical links in the database. Example Relations QuickTime™ and a TIFF (LZW) decompressor are needed to see this picture. (From Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design , Second Edition, chapter 1, Michael Hernandez) It is important to remember that the link between records in this diagram is logical – it is based on the AgentID value. The relational model is very flexible – it allows us to define 1-1, 1-many, and many- many relationships.

Homework Before class on Thursday:

  • Read the web site
  • Read chapter 1 of the text.