today s class n.
Skip this Video
Loading SlideShow in 5 Seconds..
Today’s Class PowerPoint Presentation
Download Presentation
Today’s Class

Loading in 2 Seconds...

play fullscreen
1 / 14

Today’s Class - PowerPoint PPT Presentation

  • Uploaded on

Welcome to IS C332/IS F243: Database Systems and Applications. Today’s Class. Course operational details Introduction overview of DBMS. General Info. Instructor- Incharge : Dr.Yashvardhan Sharma [ yash@bits- ]

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

Today’s Class

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
today s class

Welcome to

IS C332/IS F243: Database Systems and Applications

Today’s Class

Course operational details


overview of DBMS

general info
General Info.
  • Instructor-Incharge : Dr.Yashvardhan Sharma []
  • Book: Database System Concepts, 6th Ed, A. Silberschatz, H.F. Korth and S. Sudarshan
  • Course website: http://csis/faculty/yash/ISC332/ISC332.htm
  • Chamber Consultation Hrs: Thursday, 4.00pm to 5pm @1136-B
course salient features
Course Salient features
  • Applications Emphasis rather than Systems
    • Foundational concepts
    • Query Language
    • Application Development
    • Database System Implementation
    • Database design and tuning
  • Structured labs – Monday [5:00-7:00pm]- 1138,1139
  • MidSem Test-I[40M]+Assignments[50M]+ Compre[40%-60M] = Total[100% -150M]
  • Assignments scope:
    • Class Assignments – 10 [ Individual]
    • Term Paper – 10[ Group]
    • Online Test – 20 [ Individual]
    • Lab Attendance – 10 [ Individual]
  • Reading Assignments
why study databases


Why Study Databases??
  • Simply fascinating
    • Commercially very relevant !!
  • DBMS encompasses most of CS
    • OS, languages, theory, AI, multimedia, logic
  • Significance of Databases with Internet
  • Datasets increasing in diversity and volume.
    • Numeric and Textual Databases
    • Multimedia Databases
    • Geographic Information Systems (GIS)
    • Data warehousing, Data mining, Business Intelligence, DSS
    • Digital libraries, interactive video, Human Genome project
    • ... need for DBMS exploding
what we study in this course


What we Study in this course??
  • Foundations
    • Data Models: ER, Relational Models
    • Query languages : RA, SQL
  • Design & Development
    • Normalization, Application Development
  • Efficiency & Scalability
    • Indexing
    • Query evaluation
  • Concurrency & Robustness
    • Transaction Management – concurrency, recovery
  • Advanced Database Concepts – XML, Data Warehousing, Data Mining
big names in database systems
Big Names in Database Systems

Company Product

OracleOracle 8i, 9i, 10g,11g

IBMDB2, Universal Server

MicrosoftAccess, SQL Server-2008

SybaseAdaptive Server

InformixDynamic Server

who needs database systems

Web data management

Who Needs Database Systems

Typical Applications:

Personnel management

Inventory and purchase order

Insurance policies and customer data

… …

Corporate databases

Typical Applications:

Web page management

Personalize web pages

… …

examples of database applications
Examples of Database Applications
  • Purchases from the supermarket
  • Purchases using your credit card
  • Booking a holiday at the travel agents
  • Using the local library
  • Taking out insurance
  • Using the Internet
  • Studying at university
what is a database dbms database systems
What is a Database,DBMS, Database Systems?
  • A very large, integrated collection of structured data.
    • Gigabytes (230 or 109), Terabytes, Petabytes
  • Models real-world enterprise.
    • Entities (e.g., students, courses)
    • Relationships (e.g., Mohan is taking ISC332)
  • A Database Management System (DBMS)is a software package designed to store and manage large databases with complex features.
  • Goal : Store and Retrieve database information conveniently and efficiently
basic definitions




Basic Definitions
  • Database System: The DBMS software together with the data itself. Sometimes, the applications are also included.

database system



e.g., the student records database system

typical dbms functionality
Typical DBMS Functionality


  • Define a database: in terms of data types, structures and constraints
  • Construct or Load the Database on a secondary storage medium
  • Manipulating the database: querying, generating reports, insertions, deletions and modifications to its content
  • Concurrent Processing and Sharing by a set of users and programs – yet, keeping all data valid and consistent
  • Other features:
    • Protection or Security measures to prevent unauthorized access
what is in a database
What is in a Database?
  • A database contains information about a particular enterpriseor a particularapplication.
    • E.g., a database for an enterprise may contain everything needed for the planning and operation of the enterprise: customer information, employee information, product information, sales and expenses, etc.
    • You don’t have to be a company to use a database: you can store your personal information, expenses, phone numbers in a database (e.g., using Access on a PC).
    • As a matter of fact, you could store all data pertinent to a particular purpose in a database.
    • This usually means that a database stores data that are related to each other.
database design
Database Design


ARC database:

students: names, IDNO, PRNo, …

courses: course-no, course-names, …

classroom: number, location, …

db designer 1

db designer 2

SWD database:

classroom: number, location, …

office: number, location, …

faculty-residence: building-no, …

student-residence: room-no, …

is a database the same as a file
Is a database the same as a file?
  • You can store data in a file or a set of files, but …
    • How do you input data and to get back the data from the files?
  • A database is managed by a DBMS.