Tagged articles
24 articles
Page 1 of 1
21CTO
21CTO
Aug 8, 2024 · Databases

Why SQL Will Outlast NoSQL: Lessons from 20 Years of Database Evolution

Despite the hype around NoSQL, this article argues that SQL and relational databases remain the superior choice for transactional data, tracing two decades of research, highlighting the limitations of NoSQL, and showing how modern databases now incorporate the best features of both worlds.

ACIDData PersistenceDatabase Architecture
0 likes · 9 min read
Why SQL Will Outlast NoSQL: Lessons from 20 Years of Database Evolution
ITPUB
ITPUB
Jan 18, 2024 · Databases

Why the Database Market Is Booming: Cloud, AI, and Vector DB Trends

The global database market is accelerating beyond $1 trillion, driven by cloud adoption, AI workloads, and the rise of vector and NoSQL databases, while traditional relational vendors slow, creating a unique growth dynamic for enterprises seeking the right data solutions.

Market TrendsNoSQLRelational Databases
0 likes · 7 min read
Why the Database Market Is Booming: Cloud, AI, and Vector DB Trends
Programmer DD
Programmer DD
Dec 5, 2023 · Databases

Master the Basics of SQL: Understanding Tables, Keys, and Queries

This article introduces SQL as the standard language for relational databases, explains how data is organized into tables with primary and foreign keys, and walks through essential keywords like SELECT, WHERE, and JOIN to query and relate data effectively.

Foreign KeyJOINRelational Databases
0 likes · 5 min read
Master the Basics of SQL: Understanding Tables, Keys, and Queries
Architects Research Society
Architects Research Society
Nov 26, 2023 · Big Data

Data Lake vs Data Warehouse: Key Differences and How to Choose

Data lakes and data warehouses serve different purposes in big‑data architectures; this article explains their definitions, core attributes, five major distinctions—including data retention, type support, user coverage, adaptability, and insight speed—and offers guidance on selecting or combining the two approaches.

AnalyticsData ArchitectureData Lake
0 likes · 12 min read
Data Lake vs Data Warehouse: Key Differences and How to Choose
Efficient Ops
Efficient Ops
Aug 9, 2023 · Databases

Elevating DBA Skills: Practical Insights from a Bank’s Database Team

This article explores how bank DBAs continuously improve their capabilities through standardized daily inspections, automated environment provisioning, careful upgrade planning, development support, and disciplined incident response, while also encouraging a broader understanding of diverse database technologies and core relational concepts.

Database AdministrationRelational DatabasesSQL Performance
0 likes · 9 min read
Elevating DBA Skills: Practical Insights from a Bank’s Database Team
ITPUB
ITPUB
Nov 5, 2022 · Databases

Why the Relational Database Empire Fell and the Rise of NoSQL: A Historical Journey

This article chronicles the 30‑year dominance of relational databases, the challenges posed by object‑oriented and high‑concurrency workloads, and how four alternative data‑store families—Redis, MongoDB, Neo4j, and HBase/Cassandra—gave birth to the modern NoSQL movement.

Database HistoryNoSQLRelational Databases
0 likes · 8 min read
Why the Relational Database Empire Fell and the Rise of NoSQL: A Historical Journey
Top Architect
Top Architect
Feb 15, 2021 · Databases

The 50‑Year Evolution of Relational Databases and SQL

This article traces the fifty‑year history of relational databases, from early storage systems and the IDS and CODASYL network model to Codd’s relational model, the rise of SQL, its standards, competitors, and the principles that have kept SQL dominant in modern data management.

CoddData ModelsDatabase History
0 likes · 13 min read
The 50‑Year Evolution of Relational Databases and SQL
Programmer DD
Programmer DD
Dec 4, 2020 · Databases

What Do the 2020 DB-Engines Rankings Reveal About Today’s Most Popular Databases?

The 2020 DB-Engines ranking, based on search engine visibility, developer discussions, job postings, professional platform usage, and social media mentions, ranks 363 databases, highlighting Oracle, MySQL and SQL Server as the dominant relational leaders while showcasing the rapid rise of various NoSQL categories.

2020DB-Engines rankingNoSQL
0 likes · 6 min read
What Do the 2020 DB-Engines Rankings Reveal About Today’s Most Popular Databases?
Java High-Performance Architecture
Java High-Performance Architecture
Jun 30, 2020 · Databases

Mastering SQL: The 6-Step Process Behind Every SELECT Query

This article walks through the complete lifecycle of a SQL SELECT statement—using simple Citizen and City tables—to illustrate the six processing stages (FROM/JOIN, WHERE, GROUP BY, HAVING, SELECT, ORDER BY/LIMIT), showing how each clause transforms the data step by step.

Database FundamentalsQuery ExecutionRelational Databases
0 likes · 5 min read
Mastering SQL: The 6-Step Process Behind Every SELECT Query
AntTech
AntTech
Feb 24, 2020 · Databases

The Enduring Dominance of Relational Databases and the Rise of Distributed OceanBase

This article reviews the historical evolution, market size, and technical advantages of relational databases, explains the shift from centralized to distributed architectures, and highlights OceanBase's recent breakthroughs and community events as a modern distributed relational solution.

Cloud NativeDatabase MarketOceanBase
0 likes · 8 min read
The Enduring Dominance of Relational Databases and the Rise of Distributed OceanBase
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Feb 3, 2020 · Databases

Mastering Database Normalization: From 1NF to 3NF with Real Examples

This article explains the six relational database normal forms, illustrates how to identify entities, attributes, keys, and prime versus non‑prime attributes, and walks through step‑by‑step examples that transform a denormalized employee‑performance table into 1NF, 2NF, and 3NF compliant structures while addressing redundancy and anomalies.

1NF2NF3NF
0 likes · 12 min read
Mastering Database Normalization: From 1NF to 3NF with Real Examples
21CTO
21CTO
Jan 9, 2020 · Databases

Why MySQL Won 2019 DBMS of the Year and What It Means for Database Trends

The 2019 DB-Engines ranking crowned MySQL as the most popular DBMS, with Oracle and Microsoft SQL Server following, and discusses how relational databases dominate while NoSQL systems remain vital, highlighting evolving features and the implications for future database technology choices.

DBMSDatabase RankingsNoSQL
0 likes · 9 min read
Why MySQL Won 2019 DBMS of the Year and What It Means for Database Trends
UCloud Tech
UCloud Tech
Dec 4, 2019 · Databases

Unlocking Cloud Databases: Foundations, Architecture, and Real-World Applications

This article introduces cloud database services, compares relational and non‑relational options, outlines traditional database challenges, highlights the key benefits of cloud databases, explains high‑availability MySQL and read‑write separation architectures, and lists common industry use cases.

Read-Write SeparationRelational Databasescloud database
0 likes · 6 min read
Unlocking Cloud Databases: Foundations, Architecture, and Real-World Applications
Architects' Tech Alliance
Architects' Tech Alliance
Aug 4, 2019 · Databases

How Relational Databases Work: Architecture, Query Processing, and Transaction Management

This article explains the inner workings of relational databases, covering their architecture, indexing, time‑complexity analysis, query optimization, merge sort, client and query managers, caching strategies, transaction handling, ACID properties, concurrency control, and lock management.

Database ArchitectureRelational Databasesindexing
0 likes · 14 min read
How Relational Databases Work: Architecture, Query Processing, and Transaction Management
21CTO
21CTO
Feb 12, 2019 · Databases

From MariaDB CTO to Neo4j: Ivan Zoratti’s Journey into Graph Databases

Former MariaDB CTO Ivan Zoratti shares his 35‑year tech career, the evolution from MySQL to MariaDB, why he transitioned to Neo4j, and his insights on graph versus relational databases, highlighting the innovations and future potential of graph technology.

MariaDBNeo4jRelational Databases
0 likes · 12 min read
From MariaDB CTO to Neo4j: Ivan Zoratti’s Journey into Graph Databases
Alibaba Cloud Developer
Alibaba Cloud Developer
Sep 30, 2017 · Databases

How PolarDB Redefines Cloud‑Native Relational Databases

This article traces the evolution of relational databases, explains the rise of cloud‑native computing, and details how Alibaba Cloud’s PolarDB combines storage‑compute separation, RDMA networking, shared‑disk architecture, and advanced replication techniques to deliver high‑performance, scalable, and cost‑effective database services.

Distributed SystemsParallel RaftRDMA
0 likes · 23 min read
How PolarDB Redefines Cloud‑Native Relational Databases
ITPUB
ITPUB
Sep 11, 2017 · Databases

8 Surprising MySQL Gotchas Every Developer Should Know

The article lists eight common frustrations with MySQL—from deep‑rooted bugs and rigid relational schemas to confusing storage engines and missing native JSON support—explaining why these issues still trouble developers despite MySQL’s popularity.

Database BugsJSON supportNoSQL
0 likes · 11 min read
8 Surprising MySQL Gotchas Every Developer Should Know
ITPUB
ITPUB
Sep 3, 2016 · Databases

8 MySQL Gotchas That Will Make You Rethink Relational Databases

The article lists eight common complaints about MySQL—from deep‑rooted bugs and inflexible relational schemas to confusing forks, storage‑engine chaos, profit‑driven licensing, weak native JSON support, and proprietary extensions—highlighting why many developers consider alternatives.

Database BugsJSONRelational Databases
0 likes · 9 min read
8 MySQL Gotchas That Will Make You Rethink Relational Databases
21CTO
21CTO
Mar 31, 2016 · Big Data

Why Hadoop Isn’t the Silver Bullet for Big Data: Insights from Facebook

The article examines common misconceptions about Hadoop, compares it with relational databases, and shares Facebook's data‑analysis practices, highlighting when Hadoop is appropriate and the broader considerations of using open‑source big‑data frameworks.

HadoopMapReduceRelational Databases
0 likes · 8 min read
Why Hadoop Isn’t the Silver Bullet for Big Data: Insights from Facebook
ITPUB
ITPUB
Mar 9, 2016 · Databases

8 Critical Drawbacks of MySQL You Should Know

The article enumerates eight fundamental issues with MySQL—including deep‑seated bugs, rigid relational schemas, complex JOIN handling, confusing branch and storage‑engine choices, profit‑driven licensing, lack of native JSON support, and proprietary modules—while urging developers to consider more flexible alternatives.

JSONRelational DatabasesStorage Engines
0 likes · 9 min read
8 Critical Drawbacks of MySQL You Should Know