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
DBMS Articles
Found 267 articles
Different Types of Database Users
Database users interact with data to update, read, and modify the given information daily. There are various types of database users and we will learn in detail about them. Database users can be divided into the following types − Naive users / Parametric users Sophisticated users End Users Application Programmer or Specialized users or Back-End Developer System Analyst Database Administrator (DBA) Temporary Users or Casual Users These users can access the database and recover the data using various applications. Let’s have a quick understanding of all the types in detail − End Users/Parametric Users These users access the ...
Read MoreHow to create a B-Tree in DBMS?
A B-tree is a self-balancing tree in data structures that allows efficient storage of sorted data. Each node can hold multiple keys and have many child nodes. B-trees are versatile data structures that can efficiently handle large amounts of data. However, traditional binary search trees become inefficient for storing and searching large datasets due to their lower performance and high memory usage. B-trees, balanced trees, are self-balancing trees designed to overcome these limitations. B-trees are characterized by the large number of keys that can be stored in a single node, often called "large key" trees. Each node in a ...
Read MoreEmbedded SQL, Dynamic SQL, and SQLJ
Embedded SQL Embedded SQL is a method that combines SQL with a high−level programming language's features. It enables programmers to put SQL statements right into the source code files used to set up an application. Database operations may be carried out effortlessly by developers by adding SQL statements to the application code. The source code files having embedded SQL statements should be preprocessed before compilation because of the issue of interpretation of SQL statements by the high−level programming languages in embedded SQL. The terms EXEC SQL and END_EXEC must be used before and after each SQL statement in the source ...
Read MoreEmbedded SQL in DBMS
Embedded SQL is a powerful method that allows the integration of high−level programming languages with database management systems (DBMS). It acts as a bridge between applications and databases which helps in data manipulation and communication. Various database management systems offer embedded SQL, giving developers the freedom to select the one that best serves their requirements. Popular DBMS that support Embedded SQL are Altibase, IBM Db2, Microsoft SQL Server, Mimer SQL, Oracle Database, PostgreSQL, and SAP Sybase. Need of Embedded SQL The goal to make database interactions simpler for application developers and end users determines the demand for embedded SQL. ...
Read More10 Advance MySQL Database Interview Questions and Answers
Introduction MySQL is one of the most widely used open-source relational database management systems (RDBMS) in world. It is used by some of the largest companies in the world, including Google, Facebook, and Twitter. If you are preparing for an interview for a MySQL developer position, you need to be well-prepared with advance MySQL database interview questions and answers. In this article, we will cover some of the most common and advanced MySQL database interview questions and provide you with the best possible answers. What is MySQL? MySQL is an open-source relational database management system. It is widely used by ...
Read More10 Basic MySQL Interview Questions for Database Administrators
As a database administrator, you need to be well-versed in MySQL, one of the most popular open-source database management systems. Whether you are a beginner or an experienced professional, there are some basic MySQL interview questions that you should be prepared to answer. In this article, we'll cover some of the most common questions and provide examples to help you prepare for your next interview. What is MySQL? MySQL is an open-source relational database management system (RDBMS) that uses SQL (Structured Query Language) to manage and manipulate data. It was first released in 1995 and is currently owned by Oracle ...
Read MoreData Architecture Design & Data Management
Data architecture design consists of standards that have certain rules, policies, and data types to be collected, from where the data is collected, storage of data, arrangement of data, and then using that data for further analysis. Data plays a vital role in the successful execution of business strategy. Data architecture design It helps us to show how users view the data in the database. It describes the type of data structures used to manage data and make the processing easy. the concept of dbms depends on its architecture. It is divided into three models i.e. conceptual model, ...
Read MoreConceptual Database Design
Conceptual database design is the process of identifying the essential data elements, relationships, and constraints in a data model, which represents a particular organization's business requirements. The conceptual design stage is the first step in the database design process, which precedes the logical and physical design stages. In this article, we will discuss the conceptual database design, its objectives, its process, and the key components of a conceptual data model. Objectives of Conceptual Database Design The primary objective of conceptual database design is to create a high-level data model that reflects the business requirements and provides a clear understanding ...
Read MoreConcurrent execution and its problems
Several transactions can be carried out simultaneously in a shared database when using a database management system (DBMS). Concurrent execution can provide a number of benefits, including increased system capacity and quicker reaction times. To ensure accurate and dependable database functioning, there may be a number of issues that need to be resolved. We shall talk about concurrent execution in DBMSs and its issues in this post. Concurrent execution in a DBMS refers to the capacity to carry out numerous transactions simultaneously in a shared database. A collection of database activities known as a transaction, such as inserting, updating, or ...
Read MoreParallelism in Query in DBMS
Introduction Are you struggling with slow query execution in your Database Management System (DBMS)? Actually, the fact is, parallelism in DBMS can significantly enhance the performance and speed of your queries. In this article, we'll unravel the concept of parallel query execution, its types - intraquery and interquery parallelism, their benefits and how they can be implemented to optimize your DBMS operations. Intrigued? Let’s dive into the world of efficient data processing! Types of Parallelism in Query Execution in DBMS There are two types of parallelism in query execution in DBMS: intraquery parallelism and interquery parallelism. Intraquery Parallelism Intraquery ...
Read More