140 likes | 303 Views
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 ]
E N D
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] • 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 • 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?? • 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?? • 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 Company Product OracleOracle 8i, 9i, 10g,11g IBMDB2, Universal Server MicrosoftAccess, SQL Server-2008 SybaseAdaptive Server InformixDynamic Server
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 • 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? • 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
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 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? • 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 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? • 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.