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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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) is based on the Write Ahead Log (WAL) protocol. Every update operation writes a log record which… Read More »
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 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 »
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 »