Found 119 Articles for RDBMS

How To Configure PostgreSQL 12 Streaming Replication in CentOS 8?

Satish Kumar
Updated on 11-Jul-2023 16:59:59


Introduction PostgreSQL is one of the most popular open-source relational database management systems (RDBMS). It provides a wide range of features such as data integrity, fault-tolerance, and scalability. One of the essential features in PostgreSQL is Streaming Replication. It allows you to create multiple copies of a PostgreSQL database cluster in near-real-time by continuously streaming the changes from the primary node to the standby nodes. Streaming replication works by streaming the write-ahead log (WAL) data generated by the primary node to one or more standby nodes over a network connection. Configuration of Master Node for Streaming ... Read More

How to Download and Install PostgreSQL on Windows?

Satish Kumar
Updated on 11-Jul-2023 16:25:34


Introduction PostgreSQL is a powerful, open-source object-relational database system that is widely used for enterprise-level applications. It boasts extensive features and capabilities, including support for advanced data types, scalability, reliability, and security. With PostgreSQL, users can store vast amounts of structured data with ease. PostgreSQL is one of the most popular database management systems available today. It was first released in 1989 as an open-source project and has since become the go-to choice for many organizations worldwide due to its robustness, flexibility, and scalability. Being an open-source project means that it is free to use and can be modified by ... Read More

How to Deploy PostgreSQL on Kubernetes?

Satish Kumar
Updated on 10-Jul-2023 18:34:12


Introduction PostgreSQL is an open-source relational database management system (RDBMS) known for its robustness, stability, and ability to handle complex and large data sets. On the other hand, Kubernetes is an open-source container orchestration system that automates the deployment, scaling, and management of containerized applications. Combining these two powerful technologies provides a highly scalable and reliable environment for hosting your PostgreSQL database. In this article, we will explore how to deploy PostgreSQL on Kubernetes. We will start by explaining what PostgreSQL and Kubernetes are and the benefits of deploying PostgreSQL on Kubernetes. Then we will go through an overview of ... Read More

Overview of Dynamic Partition in Hive

Mithlesh Upadhyay
Updated on 18-May-2023 16:30:14


Hive was developed by Facebook. It is used for analytics and MapReduce jobs. It can read, write, and manage large datasets. Hive can replace traditional database operations. Hive uses indexing to make queries more efficient, and it can work with compressed data stored in the Hadoop ecosystem. In this article, we will discuss Dynamic Partitioning and operations on Dynamic Partition in Hive. Apache Hive Apache Hive is a warehousing system. It is used to perform operations on structured data. It is widely used for analytics and MapReduce jobs. Apache Hive provides functionality for reading, writing, and managing large datasets. One ... Read More

Overview of Data Warehousing and OLAP

Mithlesh Upadhyay
Updated on 18-May-2023 16:31:39


Data Warehouse A data warehouse is like a big library where we keep a lot of information from different places. It analyzes and understands the information easily. So you can make good decisions based on these facts. You have all the required information that you need in one place. We organize the information so it's easy to find and use. It takes information from different places and put it all together in one place, hence it is easier to understand. Characteristics of Data Warehouse Data Warehouse has the following characteristics. Subject-oriented A data warehouse focuses on a specific topic ... Read More

Overview of Data Mining Technology

Mithlesh Upadhyay
Updated on 18-May-2023 16:33:36


Data mining technology is a powerful tool used to extract valuable insights and patterns from large datasets. In this article, we will discuss Data mining and techniques, process, applications etc. Data mining uses statistical and computational techniques. It is used in various fields to gain insights into complex data sets. That would otherwise be impossible to analyze manually. Knowledge Discovery From Data Process of Knowledge Discovery From Data consists of following steps − Data Cleaning It is the first step. This step involves removing noise or irrelevant data from the dataset. Data Integration In this step, multiple data sources are ... Read More

Overview of Concurrency Control and Recovery in Distributed Databases

Mithlesh Upadhyay
Updated on 18-May-2023 17:20:32


In a distributed DBMS environment, several challenges arise in concurrency control and recovery, which are not present in a centralized DBMS environment. This article will discuss these challenges and their potential solutions. Multiple Copies of Data Items Dealing with multiple copies of data items is a significant challenge in distributed DBMS environments. Consistency among these copies is crucial for proper concurrency control, and recovery methods are responsible for making a copy consistent with others if the site storing the copy fails. Failure of Individual Sites In the event of site failure, distributed DBMS should continue to operate with its running ... Read More

Overview of Apache Spark

Mithlesh Upadhyay
Updated on 18-May-2023 17:22:55


Apache Spark helps people study big information and teach machines how to learn. Some smart people at a university called UC Berkeley made it in 2009. Companies like yahoo! and Intel help make it better. Apache Spark is a big project that lots of people work on to help process data really fast and keep it in the computer's memory. In this article, we will discuss Apache Spark and its history, components and various features. History of Apache Spark Spark is a distributed computing framework. It was first developed in 2009 at UC Berkeley R&D Lab, formerly known as AMPLab. ... Read More

Other Types of Indexes

Mithlesh Upadhyay
Updated on 18-May-2023 17:23:56


Hash Indexes In DBMS, it is possible to create access structures that function similar to indexes by using hashing. This secondary structure is known as a hash index and is used to access the file based on a search key that is different from the one used for the primary data file organization. Index entries in a hash index are of the form or , where K is the search key, Pr is a pointer to the record containing the key, or P is a pointer to the block containing the record for that key. The hash index file ... Read More

Other Concurrency Control Issues

Mithlesh Upadhyay
Updated on 18-May-2023 17:26:11


In this article, we will discuss some other issues related to concurrency control. These are problems related to the insertion and deletion of records. These are known as phantom problems that can occur when records are joined. We will also discuss problems that can occur when a transaction outputs some data before monitoring, and then the transaction is later aborted. Insertion, Deletion, and Phantom Records In DBMS, when a new data item is inserted, it is not immediately accessible until the insert operation is completed. To maintain data consistency and integrity, in a locking environment, an exclusive (write) lock for ... Read More

1 2 3 4 5 ... 12 Next