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 – Introduction of ER Model Generalization, Specialization and Aggregation in ER model are used for data abstraction in which abstraction mechanis
ER Model is used to model the logical view of the system from data perspective which consists of these components: Entity, Entity Type, Entity Set – An Entity
Prerequisite – Introduction of ER Model Enhanced entity-relationship diagrams are advanced database diagrams very similar to regular ER diagrams which represe
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.
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
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
To understand this, you should have an idea about: ER model Relation model After designing the ER diagram of system, we need to convert it to Relational models
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
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
