Advanced Database Concepts
A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views and other objects. The data is typically organized to model aspects of reality in a way that supports processes requiring information.
A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyse data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL,Microsoft SQL Server, Oracle, Sybase and IBM DB2.
Following are some MS Powerpoint presentations covering some advanced DBMS concepts.
1) Transaction Processing Concepts
2) Indexing and Hashing
3) Query Processing and Optimization
4) Data Storage in Database
5) Database Concurrency Control and Recovery
Post a Comment