Tagged articles
5 articles
Page 1 of 1
Tencent Cloud Developer
Tencent Cloud Developer
Sep 4, 2019 · Databases

Lightweight and Efficient Temporal Database Management System in TDSQL (T‑TDSQL) – VLDB 2019 Industry Track Paper

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.

Hybrid Transactional Analytical ProcessingPerformance EvaluationTDSQL
0 likes · 12 min read
Lightweight and Efficient Temporal Database Management System in TDSQL (T‑TDSQL) – VLDB 2019 Industry Track Paper
ITPUB
ITPUB
Jul 3, 2018 · Databases

How T‑TDSQL Implements Dual‑Temporal Data Management in Distributed Environments

This article details the architecture and implementation techniques of T‑TDSQL’s dual‑temporal database system, covering full‑state data reading, history‑table creation, snapshot query syntax, transaction snapshot attributes, visibility algorithms, transaction‑state management, index design, and valid‑time creation, query, update, and delete operations.

MVCCTDSQLTemporal Database
0 likes · 17 min read
How T‑TDSQL Implements Dual‑Temporal Data Management in Distributed Environments
ITPUB
ITPUB
Jun 14, 2018 · Databases

How T‑TDSQL Enables Real‑Time Incremental Reconciliation and Temporal Flashback

This article explains how T‑TDSQL leverages full‑temporal storage and snapshot‑difference techniques to perform incremental data extraction, precise account reconciliation, online flashback, and data replay, illustrating the underlying SQL commands, error‑handling tables, and practical benefits for internet finance workloads.

Data ReconciliationData ReplayIncremental Computation
0 likes · 14 min read
How T‑TDSQL Enables Real‑Time Incremental Reconciliation and Temporal Flashback
ITPUB
ITPUB
Jun 5, 2018 · Databases

How T‑TDSQL Enables Full‑Temporal Data Management in Distributed Databases

T‑TDSQL, a temporal extension of Tencent's TDSQL, introduces a full‑temporal data model, scalable distributed architecture, MVCC‑based history visibility algorithms, and rich temporal features that address financial audit, data lineage, and high‑performance analytics for massive historical datasets.

MVCCTDSQLTemporal Database
0 likes · 15 min read
How T‑TDSQL Enables Full‑Temporal Data Management in Distributed Databases