Found 66 Articles for RDBMS

Hadoop and RDBMS are a part of the data ecosystem but they are very different from each other while designing and implementing them. In this article, we will discuss the difference between RDBMS and Hadoop. What is RDBMS? The full form of RDBMS is Relational Database Management System. RDBMS is a system in which data is stored in tables which consists of rows and columns. A record is represented in the form of a row and attributes are represented through columns. A database is designed in RDBMS on the basis of the following properties: Atomicity Consistency Integrity Durability ... Read More

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

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

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

Oracle Label-Based Security (OLS) is a feature of the Oracle Database that provides fine-grained access control over sensitive data based on security labels. This feature enables organizations to enforce access control policies based on the sensitivity of the data rather than the traditional approach of user roles and privileges. In this article, we will discuss how Oracle Label-Based Security works and its benefits. Oracle Label-Based Security Oracle Label-Based Security works by assigning a security label to each row of data in a table. The label identifies the sensitivity level of the data, such as confidential, secret, or top secret. Each ... Read More

Cassandra is a distributed NoSQL database system. It offers high scalability, availability, and fault-tolerance. It uses a decentralized architecture, where data is distributed across multiple nodes, and provides several operations to manipulate data. In this article, we will discuss operations on tables in Cassandra. Creating Tables The first operation in Cassandra is to create a table. A table is defined by set of columns. Each column has name, data type, and an optional value. To create a table, you need to specify the keyspace. It is namespace that defines the replication strategy, and the table name. You also need to ... Read More

Retrieval and Update Operations When we work with files, we usually do two types of operations: retrieval and update. Retrieval operations help us find specific records in the file and look at their data. Update operations change the file by adding, removing, or modifying records. Selection Conditions To do either operation, we may need to specify a condition that the records must meet. For example, we might want to retrieve all the records where the salary is greater than or equal to $30, 000. This is called a selection condition. Selection conditions can be simple or complex. A simple condition ... Read More

On-Line Transaction Processing (OLTP) System is a type of computer system that helps manage transaction-related tasks. These systems are made to quickly handle transactions and queries on the internet. For instance, supermarket's POS (point of sale) system is an example of an OLTP system. Almost every industry nowadays uses OLTP systems to keep track of their transactional data. OLTP systems mainly focus on entering, storing, and retrieving data, which includes daily operations like purchasing, manufacturing, payroll, accounting, etc. Many users use these systems for short transactions. They support simple database queries, which makes it easier for users to get ... Read More

OLAP (Online Analytical Processing) is data processing technique. It is used to query and analyze data. It analyze data in real time from multiple sources. In 1993, EF Codd introduced 12 rules for the relational database model for OLAP systems. These rules are known as "Codd’s rules". These rules serve as a guideline for the design and development of OLAP systems. In this article, we will explore these 12 rules developed by Codd. Codd’s rules These are 12 rules for OLAP systems, as proposed by E.F. Codd − Multidimensional Conceptual View OLAP system should provide multidimensional conceptual view of ... Read More

Offset-Fetch is feature in MS SQL Server. It helps to retrieve subset of rows from result set. It consists of two components: OFFSET and FETCH. The OFFSET clause specifies the number of rows to skip from the beginning of the result set. FETCH clause determines the number of rows to retrieve. Syntax SELECT column1, column2, ... FROM table ORDER BY column OFFSET {integer_value} {ROWS | ROWS ONLY} FETCH {FIRST | NEXT} {integer_value} {ROWS | ROWS ONLY} ONLY; Explanation of Syntax SELECT column1, column2, ...: Specifies the columns to be selected from the table. FROM table Specifies the table from ... Read More