Tagged articles
relational
11 articles · Page 1 of 1
The article walks through a systematic method for selecting the right storage technology—relational OLTP, search engine, OLAP, or time‑series—based on query intent, data volume, latency tolerance, and consistency needs, using an e‑commerce “optimal store” scenario to illustrate the decision process and practical trade‑offs.
CDCOLAPread-model
0 likes · 30 min read

JSON has become the de‑facto format for data exchange, and modern relational databases like PostgreSQL and MySQL now support native JSON types alongside NoSQL solutions such as MongoDB, offering developers flexible storage, indexing, and query capabilities while balancing schema rigidity, performance, and scalability.
Data ModelingJSONNoSQL
0 likes · 7 min read

This article provides a concise yet comprehensive overview of relational, key‑value, document, search‑engine, time‑series, vector, spatial, graph, columnar, and multimodel databases, explaining their data models, typical queries, core advantages, and popular implementations to help developers choose the right storage solution for any project.
ColumnarGraphNoSQL
0 likes · 16 min read

This article introduces and compares major database categories—including relational, key‑value, document, columnar, graph, and time‑series databases—explaining their structures, typical use cases, and advantages, helping readers understand when to choose each type for various applications.
DocumentGraphKey-Value
0 likes · 7 min read


ITPUBJul 13, 2023 · Databases
This article provides a concise yet comprehensive overview of over ten database categories—including relational, key‑value, document, time‑series, vector, spatial, graph, columnar, and multi‑model systems—explaining their core concepts, typical use cases, popular implementations, and underlying storage mechanisms.
ColumnarGraphVector
0 likes · 16 min read

This article presents a comprehensive framework for selecting a storage solution, covering business and technical metrics, comparing relational databases with various NoSQL types, and offering concrete pros, cons, and scenario‑based recommendations to help engineers make informed data‑store decisions.
NoSQLStoragedatabase
0 likes · 18 min read

The February 2022 DB‑Engines ranking shows Snowflake’s rapid rise, a sharp decline for Oracle, MySQL and Microsoft SQL Server, stable positions for Elasticsearch, and detailed score trends across relational, key‑value, document, time‑series and graph databases, highlighting five popularity metrics used for the assessment.
ChinaDB-EnginesDocument
0 likes · 4 min read

The 2022 China Database Industry Analysis Report examines market growth, product diversity, and competitive dimensions, detailing relational, NoSQL, and NewSQL classifications, open‑source concepts, and the challenges and opportunities facing domestic database vendors amid rising investment and geopolitical pressures.
ChinaDatabase MarketNoSQL
0 likes · 9 min read

This article introduces the concept and components of database systems, classifies databases into relational, NoSQL, NewSQL and multi‑model types, explains the CAP theorem and its impact on consistency versus availability, and outlines current market trends and future directions in the database industry.
CAP theoremNoSQLdatabase
0 likes · 5 min read

This article explains the differences between structured, semi‑structured and unstructured data, walks through the evolution stages of relational database architectures, evaluates their advantages and drawbacks, and then compares major NoSQL families—KV, search, column‑oriented and document stores—to help engineers decide the right storage engine for their workloads.
NoSQLarchitecturedatabases
0 likes · 23 min read

This article explains the theoretical foundations of relational databases, outlines the essential storage, engine, and UI layers, and walks through a concrete minimal implementation using fixed‑length tables, B+‑tree indexes, simple SQL parsing with regular expressions, and a TCP‑based client interface.
B+TreeSQL parsingdatabase
0 likes · 12 min read
