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 7 of 546
Data 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 MoreJava application to insert null value into a MySQL database
In this program, we will connect to a MySQL database and insert a null value into a table using Java's JDBC API. We will use the PreparedStatement class along with the setNull() method to achieve this. After the value is inserted, you can check the table to see how the null value is reflected. Steps to insert null value into a MySQL database Following are the steps to insert null value into a MySQL database − Establish a connection to the MySQL database using the DriverManager.getConnection() method. Define the SQL query that ...
Read MoreDifference between Kimball and Inmon
One of the important aspects of business development is the design of a Data Warehouse in which a schema is used to collect different data sources. The two popular architectures used to design a data warehouse are Kimball and Inmon. In this article, we will discuss the difference between Kimball and Inmon. What is Kimball? Ralph Kimball introduced the Kimball approach to design a data warehouse. This is an approach in which business processes and questions are recognized and the answer to these questions has to be given by the data warehouse. The information provided by the data warehouse is ...
Read MoreDifference between Shared Lock and Exclusive Lock
There are situations in a database in which if one transaction has to access data, other transactions should not be allowed to access the same data. In such a case, the lock is important to prevent other transactions from using the data that is being used by a transaction. Locks are of two types which include shared locks and exclusive locks. In this article, we will see the difference between shared lock and exclusive lock. What is a Shared Lock? Shared lock is a lock that does not permit to work on data by a transaction if it is being ...
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 MoreWhat is shared memory architecture in parallel databases?
In parallel database system data processing performance is improved by using multiple resources in parallel. In this CPU, disks are used parallel to enhance the processing performance. Operations like data loading and query processing are performed parallel. Centralized and client server database systems are not powerful enough to handle applications that need fast processing. Parallel database systems have great advantages for online transaction processing and decision support applications. Parallel processing divides a large task into multiple tasks and each task is performed concurrently on several nodes. This gives a larger task to complete more quickly. Architectural Models There are several ...
Read MoreWhat is shared nothing architecture in parallel databases?
In parallel database system data processing performance is improved by using multiple resources in parallel. In this CPU, disks are used parallel to enhance the processing performance. Operations like data loading and query processing are performed parallel. Centralized and client server database systems are not powerful enough to handle applications that need fast processing. Parallel database systems have great advantages for online transaction processing and decision support applications. Parallel processing divides a large task into multiple tasks and each task is performed concurrently on several nodes. This gives a larger task to complete more quickly. Architectural Models For Parallel Database ...
Read MorePhysical Database Design and Tuning
Introduction Have you been grappled with slow database performance and clueless how to optimize it? Fact is, efficient physical database design and tuning can significantly enhance your database operations. In this enlightening article, we will unravel practical methods that revamp your system's speed by addressing bottlenecks, utilizing proper indexing strategies, optimizing queries, storage management and much more. Overview of Physical Database Design Physical database design plays a crucial role in the overall performance and efficiency of a database system, as it involves making decisions about how the data is stored, organized, and accessed at the physical level. Importance Physical ...
Read More