Processing

Please wait...

Settings

Settings

Goto Application

1. WO2020117957 - TRANSACTIONAL STREAMING OF CHANGE TRACKING DATA

Publication Number WO/2020/117957
Publication Date 11.06.2020
International Application No. PCT/US2019/064507
International Filing Date 04.12.2019
IPC
G06F 16/21 2019.01
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
21Design, administration or maintenance of databases
G06F 16/00 2019.01
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
G06F 16/182 2019.01
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
10File systems; File servers
18File system types
182Distributed file systems
G06F 16/23 2019.01
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
23Updating
G06F 16/27 2019.01
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
CPC
G06F 16/1865
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
10File systems; File servers
18File system types
1865Transactional file systems
G06F 16/2322
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
23Updating
2308Concurrency control
2315Optimistic concurrency control
2322using timestamps
G06F 16/2358
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
23Updating
2358Change logging, detection, and notification
G06F 16/2365
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
23Updating
2365Ensuring data consistency and integrity
G06F 16/245
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
24Querying
245Query processing
G06F 16/278
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
278Data partitioning, e.g. horizontal or vertical partitioning
Applicants
  • SNOWFLAKE INC. [US]/[US]
Inventors
  • MURALIDHAR, Subramanian
  • CSERI, Istvan
  • GRABS, Torsten
  • DAGEVILLE, Benoit
Agents
  • SCHEER, Bradley W.
  • PERDOK, Monique M., Reg. No. 42,989
  • MCCRACKIN, Ann M., Reg. No. 42,858
  • BIANCHI, Timothy E., Reg. No. 39,610
  • BEEKMAN, Marvin L., Reg. No. 38,377
  • ARORA, Suneel, Reg. No. 42,267
  • BLACK, David W., Reg. No. 42,331
  • LANG, Roger, Reg. No. 58,829
Priority Data
16/213,55407.12.2018US
Publication Language English (EN)
Filing Language English (EN)
Designated States
Title
(EN) TRANSACTIONAL STREAMING OF CHANGE TRACKING DATA
(FR) DIFFUSION EN CONTINU TRANSACTIONNELLE DE DONNÉES DE SUIVI DE CHANGEMENT
Abstract
(EN)
Systems, methods, and devices for generating a transactional change tracking summary for a database. A method includes executing a transaction on a table of a database, wherein the table includes a micro-partition and the transaction is executed on the micro-partition. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or modifications made to the table by the transaction. The method includes storing the change tracking entry in a change tracking stream, wherein the change tracking stream includes one or more sequential change tracking entries that each correspond to a different transaction that is fully executed on the table.
(FR)
L'invention concerne des systèmes, des procédés et des dispositifs pour générer un résumé de suivi de changement transactionnel pour une base de données. Un procédé comprend l'exécution d'une transaction sur une table d'une base de données, la table comprenant une micro-partition et la transaction étant exécutée sur la micro-partition. Le procédé comprend, en réponse à la réalisation complète de la transaction, la génération d'une entrée de suivi de changement comprenant une indication d'une ou plusieurs modifications apportées à la table par la transaction. Le procédé comprend le stockage de l'entrée de suivi de changement dans un flux de suivi de changement, le flux de suivi de changement comprenant une ou plusieurs entrées de suivi de changement séquentiel qui correspondent chacune à une transaction différente qui est entièrement exécutée sur la table.
Also published as
Latest bibliographic data on file with the International Bureau