Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Database Articles
Page 10 of 546
Overview of Transaction Management in Distributed Databases
Introduction Navigating the complex world of distributed databases can feel like a daunting task, especially when it comes to managing transactions. Did you know that successful transaction management ensures data integrity and consistency across multiple nodes in a system? This article will provide an in-depth overview of transaction management in distributed databases, breaking down its core components and illustrating its importance. What is Transaction Management in Distributed Databases? Transaction Management in Distributed Databases is a pivotal process that ensures database operations are performed accurately and reliably. It essentially deals with the administration of transactions occurring in a distributed database environment, ...
Read MoreOverview of Just a Bunch Of Disks (JBOD)
Introduction Whenever we deal with the data storage can often feel frustrating, especially as files grow in size and our need for required space expands. Did you happen to know that there is a simple storage solution called 'Just a Bunch Of Disks' or JBOD that might be what your system needs? This article will guide you through an overview of JBOD, helping to clarify its benefits and when it may be suggested to prefer over other configurations for example, RAID. What is JBOD? The option for data storage, JBOD, short for "Just a Bunch Of Disks, " refers like ...
Read MoreExplain about two phase locking (2PL) protocol(DBMS)
Locking and unlocking of the database should be done in such a way that there is no inconsistency, deadlock, and no starvation.2PL locking protocolEvery transaction will lock and unlock the data item in two different phases.Growing Phase − All the locks are issued in this phase. No locks are released, after all changes to data-items are committed and then the second phase (shrinking phase) starts.Shrinking phase − No locks are issued in this phase, all the changes to data-items are noted (stored) and then locks are released.The 2PL locking protocol is represented diagrammatically as follows −In the growing phase transaction ...
Read MoreWhat is the difference Rename and Alias In DBMS
In this article, we are going to study Rename and Alias. Both these have their specific role when we talk in terms of DBMS. Renaming and aliases to the elements of the database provide a layer of abstraction and make the attributes of the relation presentable for the viewer. Mostly, Database store crucial information the concepts of renaming and aliasing plays an important role in representing data with efficiency. Let's gain an understanding of these concepts, their syntax, and the difference between them. What is Alias? Alias is an alternative name given to a column in the database Management System. This practice ...
Read MoreList Key Differences between Keyword Queries and Database Queries
When faced with knowledge gaps, our innate reaction is to utilize search engines as a source of information. This is because we're well aware that the answers to our queries can be found there; the key lies in using accurate keywords for our searches. Both Database Queries and Keyword Queries are revolved around the retrieval of information. This article endeavors to assist you in comprehending the distinction between these two notions. Let's explore and gain an understanding of these concepts one by one. What is Keyword Queries? They are used to get information from the web. In this concept, the ...
Read MoreNoSQL Systems VS Traditional Database Systems
As individuals, we often save our data on devices like laptops and phones, but rarely do we consider the databases that underlie these storage systems. Databases are the place where organizations can easily store their data. DBMS is used to manage the database. In this article, we will study the two specific databases NoSQL and Traditional Database. However, their designs diverge, resulting in distinct approaches to data storage and retrieval. Let's explore the below article which gives you depth of understanding about the key differences in each of them. What is a NoSQL Database? When we say NoSQL it sounds ...
Read MoreExplain attributes and the different types of attributes in DBMS?
Attributes are the properties which describe an entity. Example The attributes of student entity are as follows − Roll number Name Branch Age Types of attributes The different types of attributes are as follows − Composite attribute It can be divided into smaller sub parts, each sub part can form an independent attribute. For example − ...
Read MoreBaserow Alternatives
What is Baserow? Baserow is a platform which you can use to create databases even if you do not have technical knowledge. The app has a user-friendly web interface and no coding is required to make a database. Data can be easily organized and unlimited data can be stored on this platform. You have to sign up and create an account to use the application. It uses popular frameworks like Django Vue.js and PostgreSQL. Price Plans of Baserow There are four price plans and the cost is given in the table below − Plan Price Free ...
Read MoreWhat are the differences between Stored procedures and functions?
Following are the main differences between functions and procedures:FunctionsProceduresA function has a return type and returns a value.A procedure does not have a return type. But it returns values using the OUT parameters.You cannot use a function with Data Manipulation queries. Only Select queries are allowed in functions.You can use DML queries such as insert, update, select etc… with procedures.A function does not allow output parametersA procedure allows both input and output parameters.You cannot manage transactions inside a function.You can manage transactions inside a procedure.You cannot call stored procedures from a functionYou can call a function from a stored procedure.You ...
Read MoreExplain the role of the Database Administrator in DBMS?
A database administrator (DBA) is a person or group in charge of implementing DBMS in an organization. The DBA job requires a high degree of technical expertise. DBA consists of a team of people rather than just one person.The primary role of Database administrator is as follows −Database designPerformance issuesDatabase accessibilityCapacity issuesData replicationTable MaintenanceResponsibilities of DBAThe responsibilities of DBA are as follows −Makes the decision concerning the content of the database.Plans the storage structure and access strategy.Provides the support to the users.Defines the security and integrity checks.Interpreter backup and recovery strategies.Monitoring the performance and responding to the changes in the ...
Read More