0 views collected around this technical thread.
This article introduces core relational database concepts, covering tables, data models and ER diagrams, the fundamentals of SQL, and the first three normal forms, providing clear explanations and examples to build a solid foundation for further database study.
This guide introduces Lealone, a Java open‑source high‑performance relational database for OLTP, outlines its key features, provides step‑by‑step instructions for downloading, starting, and using the server and client, shows JDBC CRUD examples, GUI client setup, and links to the author's technical blogs and source notes.
This article provides a comprehensive analysis of the Chinese database industry, covering global trends such as the dominance of relational databases and the rise of NoSQL, the impact of cloud vendors and open‑source, domestic market opportunities, classifications of database types, and profiles of leading Chinese vendors, highlighting how big‑data and AI are reshaping demand and creating growth prospects for home‑grown solutions.
This whitepaper explains the definition and history of in‑memory databases, discusses their performance advantages and persistence challenges, outlines the technology’s maturity and bottlenecks, classifies key products, and provides technical and non‑technical criteria for selecting the most suitable solution for high‑concurrency, low‑latency workloads.
This article provides a comprehensive overview of relational database fundamentals, covering common DBMS products, SQL language components, integrity constraints, transactions, locking, views, stored procedures, indexes, normalization, key differences, constraints, optimization techniques, storage engines, and performance strategies for high‑traffic sites.
The article explains why relational databases, especially PostgreSQL combined with TimescaleDB, are better suited than NoSQL for handling complex, time‑series IoT data, offering robust SQL ecosystems, schema design, data integrity, and reduced data silos for multi‑user access.
This article chronicles the ten‑year evolution of OceanBase, a distributed relational database created by Sun Zhenkun and his team, detailing early challenges, technical breakthroughs, benchmark victories like TPC‑C world records, and its impact on Alibaba’s financial systems.
The article traces how each mobile generation—from 1G’s early relational databases to 2G’s open‑source RDBMS, 3G’s scalable NoSQL, 4G’s NewSQL hybrids, and the emerging 5G era demanding ultra‑low latency, cloud‑native, AI‑driven real‑time analytics—shapes database architecture and future trends.
The article chronicles OceanBase’s evolution from a research project to a commercial distributed relational database, detailing the technical challenges of meeting strict transaction, consistency, and availability requirements, the innovative solutions adopted, key milestones, and its impact on Alibaba’s ecosystem and the broader market.
The article summarizes a 2017 BDTC conference talk by Ant Financial senior researcher Yang Zhenkun, detailing the challenges of traditional relational databases and presenting OceanBase's distributed, high‑availability, cost‑effective solutions for large‑scale financial systems.
This article explains the inner workings of relational databases, covering their core components, query optimization flow, indexing, merge sort, transaction handling, concurrency control, and lock management, while illustrating concepts with examples and diagrams.
This article introduces MySQL and MongoDB, compares their characteristics, and demonstrates simple CRUD commands for each, helping developers understand when to choose a relational versus a non‑relational database based on business needs.