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
RDBMS Articles
Page 4 of 8
Model Planning for Data Analytics
Model planning is the process of selecting the right analytical models and techniques to analyze data effectively. It is a critical step in data analytics that ensures accurate, actionable insights for business decisions. Data Analytics Process Collection Raw sources Preparation Clean, validate Modeling Select model ...
Read MoreMethodologies of Large Scale Distributed Systems
Large-scale distributed systems handle massive data volumes, many concurrent users, and demanding performance requirements. Building them requires methodologies that help developers efficiently manage complexity, scalability, and fault tolerance. Companies like Google, Amazon, and Facebook use these systems extensively. Architecture of Distributed Systems Distributed systems consist of multiple nodes connected via a network, each running part of the distributed software. Understanding domain requirements, security, compliance, and future integrations is critical from the start. Node 1 Node 2 Node 3 ...
Read MoreMigrating Amazon RDS from one Region to another
Amazon RDS (Relational Database Service) is a fully-managed tool for maintaining databases. Migrating an RDS database from one region to another involves creating a snapshot, copying it to the target region, and restoring a new instance from it. Source (us-east-1) RDS Instance DB Snapshot Copy Snapshot ...
Read MoreHow do Document Databases Work?
Document databases are a type of NoSQL database that store data as documents (typically JSON or BSON) instead of rows and columns. Each document is a self-contained unit with flexible structure, making them more adaptable than relational databases for evolving data models. Relational (Tables) ID Name Age Fixed rows & columns vs Document (JSON) {"name":"John", ...
Read MoreDifference between NoSQL and RDBMS
RDBMS stores data in structured tables with fixed schemas using SQL. NoSQL is a non-relational approach with flexible schemas, designed for large-scale distributed data. Companies like Amazon, Facebook, and Google pioneered NoSQL to handle massive data volumes that traditional RDBMS struggled with. RDBMS ID Name Age Fixed Schema | Vertical Scaling vs NoSQL ...
Read MoreWhat is NoSQL and is it the next big trend in databases?
A NoSQL ("non SQL" or "non relational") database stores and retrieves data using models other than relational tables. NoSQL databases are structured as key-value pairs, documents, columns, or graphs − designed for large-scale data, high performance, and flexible schemas. Why NoSQL? Applications like Facebook, Google, and Amazon need to handle massive data volumes that traditional RDBMS struggles with. NoSQL allows adding new data fields without redesigning the entire schema − ideal for agile development. SQL vs NoSQL Example SQL requires predefined tables and schema changes for new features ? CREATE TABLE users (id INT ...
Read MoreDifference between DBMS and RDBMS
A DBMS (Database Management System) is software used to create, update, delete, and maintain a database with controlled access to data. An RDBMS (Relational Database Management System) is an enhanced type of DBMS based on the relational model, storing data in tables with defined relationships. What is a DBMS? DBMS stores data in the form of files using navigational or hierarchical structures. There is no relationship between data elements, so it does not support distributed databases. DBMS is often used in small organizations to deal with small amounts of data handled by a single user. Examples include file ...
Read MoreExamples of E-R model
The ER (Entity-Relationship) model represents real-life scenarios as entities. The properties of these entities are their attributes, and their connections are shown as relationships. ER models help visualize how data is structured in a database system. Hospital ER Model This ER model has three entities − Patient, Doctor, and Tests ? Patient ID (PK), Name Age, Visit_date Doctor ID (PK), Name Specialization Tests ...
Read MoreExtended Entity-Relationship (EE-R) Model
The Extended Entity-Relationship (EE-R) Model is a high-level data model that incorporates extensions to the original ER model to represent complex database requirements. In addition to basic ER concepts, EE-R includes − Subclasses and Super classes Specialization and Generalization Category or Union type Aggregation Subclasses and Super Class A super class contains common attributes shared by all its subtypes. Sub classes are groups of entities with unique attributes that inherit properties from the super class ? Shape ...
Read MoreHierarchical Database Model
A hierarchical model represents data in a tree-like structure where each record has a single parent. A sort field keeps sibling nodes in order. This model was designed for early mainframe systems like IBM's Information Management System (IMS), supporting one-to-one and one-to-many relationships. Data is structured as an inverted tree − a single root table at the top, with other tables as branches. Records are accessed by navigating down through the structure using pointers combined with sequential accessing. Agents Database Example The following diagram shows a typical hierarchical database ? ...
Read More