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
-
Economics & Finance
Database Articles
Page 145 of 547
Cascadeless in DBMS
Cascadeless in DBMS: Understanding and Implementing the Concept A database management system (DBMS) is a software that is used to store, organize, and manage data in a structured manner. One of the key concepts in DBMS is cascading, which refers to the automatic propagation of changes made to the data in one table to the related data in other tables. While cascading can be convenient in many cases, it can also lead to unintended consequences, such as data loss. To mitigate this, many DBMSs allow for the use of cascadeless operations, which prevent cascading from taking place. In this article, ...
Read MoreCalculation of Serial and Non-Serial Schedules in DBMS
Introduction In a database management system (DBMS), the scheduler is responsible for managing the execution of concurrent transactions. The scheduler uses a schedule, which is a sequence of actions that the DBMS must execute, to ensure that the system remains in a consistent state and that concurrent transactions do not interfere with each other. There are two types of schedules: serial schedules and non-serial schedules. In this article, we will discuss the calculation of both types of schedules in a DBMS. Serial Schedules A serial schedule is a schedule in which all transactions are executed one after another, without any ...
Read MoreDifference between Fundamental data types and derived Data Types
In computer programming, a datatype represents the type and nature of data that is to be used by the user. It is the data type that tells the compiler or interpreter how to deal with the data and provide corresponding storing location in computer memory. According to the nature of data, the data types can be of two types namely Fundamental Datatype and Derived Datatype. Both these datatypes are extensively used in computer programming. They are equally important when we require to implement the business logic over the data. Read this tutorial to find out more about Fundamental and Derived ...
Read MoreDifference between Data Warehouse and Operational Database
A data warehouse is a repository for structured, filtered data that has already been processed for a specific purpose. It collects the data from multiple sources and transforms the data using ETL process, then loads it to the Data Warehouse for business purpose. An operational database, on the other hand, is a database where the data changes frequently. They are mainly designed for high volume of data transaction. They are the source database for the data warehouse. Operational databases are used for recording online transactions and maintaining integrity in multi-access environments. Read this article to learn more about data warehouses ...
Read MoreDifference between Data Scientist, Data Engineer, Data Analyst
Data scientists, data engineers, and data analysts are all professionals who work with data in some way. However, they have different roles and responsibilities. Read this article to find out more the job profiles of data scientists, data engineers, and data analysts and how you can distinguish among them. Who is a Data Scientist? A Data Scientist is one who analyses and interprets complex data in digital form. Data scientists are responsible for extracting insights and knowledge from data. They use a variety of techniques, including machine learning, to analyze data and communicate their findings to stakeholders. There are several ...
Read MoreBulk Reading in Cassandra
Introduction Bulk reading is a common operation when working with Cassandra, a popular NoSQL database known for its scalability and high performance. It allows you to efficiently retrieve large amounts of data from a Cassandra cluster by making use of the database's distributed architecture. In this article, we'll explore the various ways you can perform bulk reading in Cassandra and the considerations you should keep in mind when doing so. What is Cassandra? Before diving into the specifics of bulk reading, let's first take a step back and talk about Cassandra itself. Cassandra is a distributed database management system designed ...
Read MoreBuilding blocks of a Data Model
Introduction A data model is a blueprint that represents the organization of data and the relationships between different data entities. It is an essential component of any software system as it defines how data is stored, accessed, and modified. In this article, we will explore the building blocks of a data model and how they work together to form a cohesive whole. Data Entities The first building block of a data model is data entities, which represent the objects or concepts that are relevant to the system. For example, in an e-commerce system, data entities might include products, customers, orders, ...
Read MoreBuffering of Blocks
What is Buffering of Blocks? In computer science, buffering refers to the temporary storage of data in a buffer, or a small, fixed-sized area in memory, while it is being moved from one place to another. When data is transferred from one location to another, it is often necessary to store it temporarily in a buffer to ensure that the transfer is smooth and efficient. There are two main types of buffering: input buffering and output buffering. Input buffering refers to the temporary storage of data that is being received from an external source, such as a file on a ...
Read MoreBlob conversion function in Cassandra
Introduction If you are working with Cassandra, you may have come across the need to convert blobs to other data types or vice versa. Cassandra, being a distributed NoSQL database, stores data in the form of blobs (binary large objects) to increase flexibility and scalability. However, this can cause issues when you need to query or manipulate the data stored as blobs. That's where the blob conversion function comes in handy. In Cassandra, you can use the "blobAs*" function to convert blobs to various data types, such as integers, floats, timestamps, and more. This function allows you to easily access ...
Read MoreBitmap Indexing in DBMS
Bitmap indexing in DBMS is a type of indexing technique that is used to improve the performance of database systems. It works by creating a bitmap for each distinct value in a database column, with each bit in the bitmap representing a row in the database table. The bitmap index can then be used to quickly identify which rows in the table match a given search criteria, making it an efficient way to filter and retrieve data from large tables. In this article, we will delve into the concept of bitmap indexing and how it works, the advantages and disadvantages ...
Read More