Posts

SQLite

Image
SQLite is a relational database management system contained in a C programming library. In contrast to many other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program.   Read PPT here

Deadlock in DBMS

Image
In a database, a  deadlock  is a situation in which two or more transactions are waiting for one another to give up locks. For example, Transaction A might hold a lock on some rows in the Accounts table and needs to update some rows in the Orders table to finish. Read PPT Here

Database security and authorization

A privilege is a type of permission for an  authorization  name, or a permission to perform an action or a task. The privilege allows a user to create or access  database  resources. Privileges are stored in the  database  catalogs.... Read ppt here

An introduction to Neo4j

Image
Neo4j is the world's leading open source Graph Database which is developed using Java technology. It is highly scalable and schema free (NoSQL). Meet Neo4j : The graph database platform powering today's mission-critical enterprise applications, including artificial intelligence, fraud detection and recommendations. Credits: tutorialpoint.com Read PPT Here

MULTIPLE GRANULARITY DBMS

Granularity is the size of data item  allowed to lock. Multiple Granularity is the hierarchically  breaking up the database into portions which are lockable and maintaining the track of what to be lock and how much to be lock so that it can be decided very quickly either to lock a data item or to unlock a data item. Read ppt here

POSTGRESQL

Image
PostgreSQL , often simply Postgres , is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications.  READ PPT HERE

FIREBASE

Image
  Firebase is a mobile and web application development platform developed by Firebase, Inc. in 2011, then acquired by Google in 2014. READ PPT HERE