Database Management Systems

In computing, a database is an organized collection of data (also known as a data store) stored and accessed electronically through the use of a database management system. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases spans formal techniques and practical considerations, including data modelling, efficient data representation and storage, query languages, security and privacy of sensitive data, and distributed computing issues, including supporting concurrent access and fault tolerance.

A database management system (DBMS) is the software that interacts with end users, applications, and the database itself to capture and analyze the data. The DBMS software additionally encompasses the core facilities provided to administer the database. The sum total of the database, the DBMS and the associated applications can be referred to as a database system. Often the term "database" is also used loosely to refer to any of the DBMS, the database system or an application associated with the database..

Content Video

Database Management Systems

Database Management Systems

Unit	Details Contents
Unit -I	Database System Concepts and Architecture Data Models Schemas and Instances Three-Schema Architecture and Data Independence Database Languages and Interfaces Centralized and Client/Server Architectures for DBMS
Unit -II	Data Modeling Entity-Relationship Diagram Relational Model - Constraints Languages Design of Data Modeling Relational Database Schemas Update Operations and Dealing with Constraint Violations Relational Algebra and Relational Calculus Codd Rules
Unit -III	SQL SQL Data Definition and Data Types Constraints, Queries, Insert, Delete, and Update Statements Views, Stored Procedures and Functions Database Triggers SQL Injection
Unit -IV	Normalization for Relational Databases Functional Dependencies and Normalization Algorithms for Query Processing and Optimization Transaction Processing Concurrency Control Techniques Database Recovery Techniques Object and Object-Relational Databases Database Security and Authorization
Unit -V	Enhanced Data Models Enhanced Data Models Temporal Database Concepts Multimedia Databases Deductive Databases XML and Internet Databases Mobile Databases Geographic Information Systems Genome Data Management Distributed Databases and ClientServer Architectures
Unit -VI	Data Warehousing and Data Mining Data modelling for Data Warehouses Concept Hierarchy OLAP and OLTP Association Rules Classification, Clustering, and Regression 4 Support Vector Machine K-Nearest Neighbour Hidden Markov Model Summarization, Dependency modelling Link Analysis, Sequencing Analysis, Social Network Analysis
Unit -VII	Big Data Systems Big Data Big Data Characteristics Types of Big Data Big Data Architecture Map-Reduce and Hadoop Distributed File System & HDFS
Unit -VIII	NOSQL NOSQL and Query Optimization Types of NOSQL Querying and Managing NOSQL Indexing and Ordering Data Sets NOSQL in Cloud