This article surveys two decades of database system architecture innovations—including columnar stores, cloud databases, data lakes, NewSQL, hardware accelerators, and blockchain databases—highlighting their motivations, trade‑offs, and the shifting landscape that shapes modern DBMS design.
The article chronicles Michael Stonebraker’s pioneering journey from early relational databases like Ingres to PostgreSQL’s open‑source success, his critique of NoSQL, the rise of cloud‑compatible PostgreSQL services, and his latest DBOS concept that reimagines operating systems as database‑driven platforms.
Celebrating Michael Stonebraker’s 80th birthday, this article chronicles his pioneering work from Ingres to PostgreSQL, his influence on open‑source databases, the rise of cloud‑compatible DBMS, and his bold vision of a database‑centric operating system reshaping the future of data management.
ClickHouse is an MPP column‑oriented DBMS that combines full DBMS functionality, advanced columnar storage with high compression, SIMD‑based vectorized execution, a rich relational SQL interface, diverse table engines, multi‑master clustering, and flexible sharding and distributed query capabilities, making it exceptionally fast for analytical workloads.
ClickHouse is a high‑performance MPP column‑store DBMS that combines complete DBMS functions, column‑oriented storage with aggressive compression, SIMD‑based vectorized execution, flexible table engines, multithreading, distributed processing, a multi‑master architecture, and SQL compatibility to deliver fast online analytical queries on massive data sets.
This article examines the fundamental differences between traditional disk‑based DBMS and modern in‑memory databases, covering buffer management, lock versus latch mechanisms, logging and recovery, performance overhead, historical evolution, and architectural innovations that enable high‑performance memory‑resident data processing.
This article provides a comprehensive overview of database technology, covering relational and NoSQL systems, the historical evolution from navigational to self‑driving databases, current market size and growth, leading vendors, and the accelerating shift toward cloud‑based database services.
This article provides a detailed introduction to databases and DBMS, explains relational and NoSQL models, traces the evolution from navigational to autonomous databases, analyzes global and Chinese market sizes and leading vendors, and discusses the growing shift toward cloud‑based database services.
The article examines the 2019 DB-Engines ranking that crowned MySQL as the DBMS of the Year, discusses its historical development, compares it with Oracle and SQL Server, analyzes the rise of NoSQL systems, and explores the implications of hybrid features in modern relational databases.
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.
The article presents a detailed interview with Yan Huqing, the lead of the open‑source DBLE project, covering his background, the upcoming Shanghai 3306π meetup agenda, and practical advice on using Dble for sharding, read‑write splitting, and advanced monitoring in distributed database environments.
This comprehensive guide explains what databases are, their evolution, key models, core DBMS components, and provides step‑by‑step instructions for installing, configuring, and securing MySQL on Linux, along with essential SQL commands and concepts.
