today s class n.
Download
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


  • 120 Views
  • 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- pilani.ac.in ]

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

PowerPoint Slideshow about 'Today’s Class' - ura


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

Introduction

overview of DBMS

general info
General Info.
  • Instructor-Incharge : Dr.Yashvardhan Sharma [yash@bits-pilani.ac.in]
  • 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

data

catalog

database

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

database system

DBMS

Application

e.g., the student records database system

typical dbms functionality
Typical DBMS Functionality

DBMS

  • 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

BITS

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.