1 / 14

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

ura
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Welcome to IS C332/IS F243: Database Systems and Applications Today’s Class Course operational details Introduction overview of DBMS

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

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

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

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

  6. Big Names in Database Systems Company Product OracleOracle 8i, 9i, 10g,11g IBMDB2, Universal Server MicrosoftAccess, SQL Server-2008 SybaseAdaptive Server InformixDynamic Server

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

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

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

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

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

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

  13. 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, …

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

More Related