A 75-question closed-book diagnostic mock exam for software architects covering computer architecture, databases, networking, operating systems, security, project management, and architecture design to validate knowledge retention without reference materials.
In a candid interview, database pioneer Mike Stonebraker recounts the academic and commercial journeys of Ingres and Postgres, critiques industry giants, explores his DebOS project that reimagines OS kernels as databases, and shares hard‑won insights on AI‑driven Text‑to‑SQL and career advice for the next generation.
The article traces the progression from the human DIKW information hierarchy to its computer‑world counterpart, illustrates how a homestay platform’s data architecture evolves through relational, NoSQL, search, and data‑warehouse layers, and introduces the next‑generation distributed Data Warebase that unifies structured, semi‑structured, and vectorized knowledge to meet modern AI‑driven business demands.
This curated bibliography compiles seminal database‑system papers—spanning foundational relational theory, system design for RDBMS and NoSQL, SQL engine optimization, storage structures, transaction and scheduling mechanisms, plus workload, networking, quality, and tuning research—each entry listing title, authors, year and a PDF link for scholars and practitioners.
The AiKeSheng Open Source Community announces a giveaway of a comprehensive MySQL‑based database systems textbook sponsored by Tsinghua University Press, detailing its four‑part structure, extensive learning resources, and participation rules for the July 2023 event.
Percolator implements a two‑phase commit transaction protocol with a client coordinator, a timestamp oracle, and storage (Bigtable or TiKV’s RocksDB), providing snapshot‑isolated ACID semantics via lock, write, and data columns; TiKV adds parallel prewrite, short‑value storage, point‑read shortcuts, calculated commit timestamps, and single‑region one‑phase commits to boost performance while keeping the design simple and scalable, though high contention can cause retries and read‑wait delays.
Explore the three pivotal stages of database development—from early manual management, through file-system storage, to modern database systems—highlighting their advantages, challenges, and the evolution of data independence, scalability, security, and integration with emerging technologies.
This article explores the concurrency control strategies, persistence mechanisms, and compiled query processing techniques used by modern memory databases, comparing systems like Hekaton, Hyper, HANA, and others while highlighting performance trade‑offs and architectural considerations.
This article explains how modern in‑memory database systems structure data into fixed‑ and variable‑length blocks, choose partitioned or non‑partitioned architectures, handle row versus column storage, and implement cache‑aware index structures such as CSB+-Tree, PB+-Tree, Bw‑Tree, Adaptive Radix, OLFIT and Skiplists, illustrated with Hekaton, H‑Store/VoltDB, HyPer and SAP HANA examples.
The VLDB 2019 Industry Track paper presents T‑TDSQL, a lightweight full‑temporal extension of Tencent’s distributed OLTP database TDSQL that separates current and historical data, uses a hybrid storage model, rewrites temporal predicates, and achieves under 10% performance overhead while halving business execution time in production.
Alibaba’s senior engineers share their curated list of essential technical books—from software testing and design patterns to AI, machine learning, reinforcement learning, Rust programming, and database architecture—explaining why each title is valuable for developers seeking deeper knowledge and practical insights.
The article provides a comprehensive overview of SIGMOD 2018 in Houston, summarizing keynotes, best paper, emerging database trends such as cloud, new hardware, autonomous and AI‑enhanced systems, and detailed analyses of eight industry papers presented at the conference.
Attending VLDB 2017 in Munich, the report summarizes the conference’s broad coverage of database research—from new hardware‑accelerated prototypes and Spark‑based big‑data processing to Oracle and SAP HANA case studies, keynotes, notable papers, and reflections on industry trends and Chinese contributions.
This article examines the evolution of write-ahead logging in relational databases, compares MySQL and PostgreSQL implementations, highlights the scalability limits of centralized WAL designs, and explores how distributed logging with global timestamps, dependency tracking, and hole‑avoidance techniques could dramatically improve single‑node database throughput.
The article reviews best‑practice designs for massive O2O e‑commerce storage, summarizing a Jan 30 technical salon where Meituan’s Cheng Zhenqiang detailed KV storage optimization, Alibaba Cloud’s Zhang Zirong explained high‑performance server architecture tuning, and Meituan Cloud’s Li Kai presented a unified distributed storage system with cross‑data‑center availability, erasure coding, and metadata management.
