Skip to content

Category Archives: DBMS

ER model is used for logical representation or the conceptual view of data. It is a high level of the conceptual data model. It forms… Read More
The first generation of database revolutions occurred in the late 1960s and early 1970s when the relational model was first introduced. This was followed by… Read More
A multinational information technology company based in India, Infosys Limited offers business consulting, IT, and outsourcing services. Founded in Pune and headquartered in Bangalore, Infosys… Read More
In this article, we are going to learn about the Business Logic Layer in Database Management systems. A DBMS usually consists of various layers where… Read More
Pre-requisites: Different types of Procedures in MySQL Delimiters are used when we need to define the stored procedures as well as to create triggers. Default… Read More
Pre-requisites: Various types of Backup A database backup is a copy of storage that is stored on a server. Backup is used to prevent unexpected… Read More
Audit trail keeps track of different actions that took place for an activity in a chronological order, these activities may be scientific, financial transaction or… Read More
In this article, we are going to learn about the Business Logic Layer in Database Management systems. The Business Logic Layer also known as BLL… Read More
View and Table both are integral parts of a relational database, and both terms are used interchangeably. The view is a result of an SQL… Read More
Pre requisites: Query Execution Engine in SQL, Query-Execution Plan in SQL In this article, we will see about Query Evaluation Plan in SQL and how… Read More
Double Buffering refers to minimizing the delay that occurs between input and output operations in database management systems that use a buffer. Double buffering saves… Read More
Virtual Private Database(VPD) is the most popular secured database which was introduced by Oracle Database Enterprise. It is used when the object privileges and database… Read More
Elasticsearch is a distributed search and a real-time analytical search engine. Elasticsearch is generally used for structured text, analytics, full-text search, and the combination of… Read More
A NoSQL originally referring to non SQL or nonrelational is a database that provides a mechanism for storage and retrieval of data. In this article,… Read More
An Oracle database is a collection of data treated as a unit. The sole purpose of a database is to store and retrieve related data.… Read More

Start Your Coding Journey Now!