In a database, a deadlock is an unwanted situation in which two or more transactions are waiting indefinitely for one another to give up locks. Deadlock is said
As discussed in Concurrency control , serial schedules have less resource utilization and low throughput. To improve it, two are more transactions are run concu
Bitmap Indexing is a special type of database indexing that uses bitmaps. This technique is used for huge databases, when column is of low cardinality and these
Starvation or Livelock is the situation when a transaction has to wait for a indefinate period of time to acquire a lock. Reasons of Starvation – If waiting s
A Data Base Management System is a system software for easy, efficient and reliable data processing and management. It can be used for: Creation of a database.
Multimedia database is the collection of interrelated multimedia data that includes text, graphics (sketches, drawings), images, animations, video, audio etc an
Datawarehouse and Data Mart, both are storage components of HDFS. Data mart is such a storage component which is concerned on a specific department of an organi
A database object is any defined object in a database that is used to store or reference data.Anything which we make from create command is known as Database Ob
A database management system (DBMS) interface is a user interface which allows for the ability to input queries to a database without using the query language i
With the phenomenal growth in digital data, particularly generated from multi-media and other enterprise application the need for high-performance storage solut
There are many advantages and disadvantages of DBMS (Database Management System). Disadvantages of DBMS are explained as following below. 1. Increased Cost: The
Prerequisite – ER Model A relationship between two entities of similar entity type is called a recursive relationship. Here the same entity type participates
Impedance mismatch is basically the term used to refer to the problems that basically occurs due to differences between the database model and the programming l
Terminology Relational Model: Relational model represents data in the form of relations or tables. Relational Schema: Schema represents structure of a relation.
Relational Model was proposed by E.F. Codd to model data in the form of relations or tables. After designing the conceptual model of Database using ER diagram,
Basically for large databases with many expected users and applications the view integration approach of designing individual schema and then merging them can b
We strongly recommend to refer below posts as a prerequisite of this. DBMS | Relational Model Introduction and Codd Rules DBMS | Keys in Relational Model (Candi
Relational Algebra is procedural query language, which takes Relation as input and generate relation as output. Relational algebra mainly provides theoretical f
Basic idea about relational model and basic operators in Relational Algebra: Relational Model Basic Operators in Relational Algebra Extended operators are tho
Tupple Relational Calculus is a non-procedural query language unlike relational algebra. Tupple Calculus provides only the description of the query but it does
We strongly recommend to refer below post as a prerequisite of this. DBMS | Relational Model Introduction and Codd Rules Different Types of Keys in Relational M
Data Replication is the process of storing data in more than one site or node. It is useful in improving the availability of data. It is simply copying data fro
Basics of Relational model: Relational Model Relational Algebra is a procedural query language which takes relations as an input and returns relation as an outp
Semantic Heterogeneity basically occurs when schema or data set for same domain is developed by independent parties which leads to differences in meaning, inter
DBMS(DATABASE MANAGEMENT SYSTEM) A database is an organized collection of data, generally stored and accessed electronically from a computer system. Where datab
