DBMS
Data, Information and Databases
Data is raw recorded fact, information is data placed in context, and a database is an organised, shared, self describing collection of related data...
DBMS
A complete DBMS path: database fundamentals, architecture, data models, the ER model, the relational model, relational algebra, functional dependencies, normalisation, transactions, concurrency control, recovery, storage, indexing, query processing, distributed databases, NoSQL, security, administration, performance and exam preparation.
59 notes in 21 topics
Topics in DBMS
DBMS Fundamentals 9
Database Architecture 4
Data Models 5
ER Model 9
ER Design Projects 5
Relational Model 6
Relational Algebra 6
Functional Dependencies 5
Normalisation 9
Transactions 0
Concurrency Control 1
Recovery 0
Storage and File Organisation 0
Indexing 0
Query Processing 0
Distributed Databases 0
NoSQL and Modern Databases 0
Database Security 0
Database Administration 0
Database Performance 0
Practice and Exams 0
Notes
DBMS
What a DBMS Is and Why It Exists
A DBMS is the software layer between users and stored data. It exists to give many users controlled, concurrent, recoverable and consistent access to...
DBMS
File System versus DBMS
The file based approach fails on redundancy, inconsistency, isolation, atomicity, concurrency, security and integrity. Each failure maps to one specif...
DBMS
Advantages and Limitations of a DBMS
A DBMS buys controlled redundancy, enforced integrity, sharing, security, recovery and independence. It charges for them in cost, complexity, hardware...
DBMS
Database Users and the Role of the DBA
A database system serves naive users, application programmers, sophisticated users and specialised users, and is run by a database administrator whose...
DBMS
Three Level Architecture and Data Abstraction
The ANSI-SPARC architecture separates a database into external, conceptual and internal levels. That separation is what makes data abstraction and dat...
DBMS
Logical and Physical Data Independence
Data independence is the ability to change a schema at one level without changing the level above. Physical independence is easy to achieve; logical i...
DBMS
Schema, Instance and Metadata
A schema is the design of a database and rarely changes. An instance is the data in it at one moment and changes constantly. Metadata is the stored de...
DBMS
Database Applications and the Database System Environment
Where databases are actually used, and what sits inside a running database system: the DBMS software, the stored database, the catalog, the applicatio...
DBMS
One Tier, Two Tier and Three Tier Architecture
Tier architecture describes how many machines or layers a database request passes through. One tier is local, two tier puts the application on the cli...
DBMS
Client Server Architecture and Database Servers
In client server architecture the database server owns the data and answers requests, while clients ask questions. Understanding what the server keeps...
DBMS
Centralised and Distributed Databases
A centralised database keeps all data at one site; a distributed database spreads it across several. The choice changes availability, performance, com...