What is Stored Procedures in SQL ?
Stored Procedures are created to perform one or more DML operations on Database. It is nothing but the group of SQL statements that accepts some… Read More »
Category Archives: DBMS
Introduction to Graph Databases
What is a Graph Database? A Graph Database is a designed to treat the relationships between data as equally important to the data itself. Why… Read More »
Difference between RDBMS and MongoDB
What is MongoDB? MongoDB is an open-source document-oriented database used for high volume data storage. It falls under the classification of a NoSQL database. NoSQL… Read More »
What is Cursor in SQL ?
Cursor is a Temporary Memory or Temporary Work Station. It is Allocated by Database Server at the Time of Performing DML operations on Table by… Read More »
Apache Cassandra (NOSQL database)
In this article we will learn basics of Apache Cassandra and basics of CQL (Cassandra Query Language) operations like Create, insert, delete, select etc. Apache… Read More »
What is Temporary Table in SQL?
Temporary Tables are most likely as Permanent Tables. Temporary Tables are Created in TempDB and are automatically deleted as soon as the last connection is… Read More »
MySQL | Database Files
Whenever MySQL database installation is done, all the database related data and metadata are stored in one folder.This is the actual database schema with some… Read More »
Applications of Commercial Deductive Database Systems
A Deductive Database is a type of database that can make conclusions or we can say deductions using a sets of well defined rules and… Read More »
Properties of Relational Decomposition
When a relation in the relational model is not appropriate normal form then the decomposition of a relation is required. In a database, breaking down… Read More »
Neo4j Query Cypher Language
The Neo4j has its own query language that called Cypher Language. It is similar to SQL, remember one one thing Neo4j does not work with… Read More »
Neo4j Drop Index
In neo4j you can drop index for both property and nodes. Indexing is data structure that helps faster performance on retrieval operation on database. There… Read More »
Algorithm for Recovery and Isolation Exploiting Semantics (ARIES)
Algorithm for Recovery and Isolation Exploiting Semantics (ARIES) is based on the Write Ahead Log (WAL) protocol. Every update operation writes a log record which… Read More »
Neo4j Create Constraint
The neo4j constraint helps user to nor enter in wrong kind of data. When the constraint is applied and the user by mistake entering the… Read More »
Concurrency Control Techniques
Concurrency control is provided in a database to: (i) enforce isolation among transactions. (ii) preserve database consistency through consistency preserving execution of transactions. (iii) resolve… Read More »
Neo4j Delete Node
In Neo4j to delete a node or relations between nodes you have to use DELETE clause. To delete any node you need DELETE clause with… Read More »
