Processing

Please wait...

Settings

Settings

Goto Application

1. WO2020097032 - TRACKING CHANGES IN DATABASE DATA

Publication Number WO/2020/097032
Publication Date 14.05.2020
International Application No. PCT/US2019/059798
International Filing Date 05.11.2019
IPC
G06F 7/00 2006.01
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
7Methods or arrangements for processing data by operating upon the order or content of the data handled
G06F 17/00 2019.01
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
17Digital computing or data processing equipment or methods, specially adapted for specific functions
G06Q 10/06 2012.01
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
QDATA PROCESSING SYSTEMS OR METHODS, SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTING PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTING PURPOSES, NOT OTHERWISE PROVIDED FOR
10Administration; Management
06Resources, workflows, human or project management, e.g. organising, planning, scheduling or allocating time, human or machine resources; Enterprise planning; Organisational models
Applicants
  • SNOWFLAKE INC. [US]/[US]
Inventors
  • 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/182,11206.11.2018US
Publication Language English (EN)
Filing Language English (EN)
Designated States
Title
(EN) TRACKING CHANGES IN DATABASE DATA
(FR) SUIVI DE MODIFICATIONS DE DONNÉES D'UNE BASE DE DONNÉES
Abstract
(EN)
Systems, methods, and devices for tracking changes to database data. A method includes determining a change to be executed on a micro-partition of a table of a database and executing the change on the table by generating a new micro-partition that embodies the change. The method includes updating a table history that includes a log of changes made to the table, wherein each change in the log of changes includes a timestamp, and wherein updating the table history includes inserting the change into the log of changes.
(FR)
L'invention concerne des systèmes, des procédés et des dispositifs permettant un suivi de modifications de données d'une base de données. Le procédé consiste à déterminer une modification devant être exécutée sur une micro-partition d'une table d'une base de données et à exécuter la modification sur la table en générant une nouvelle micro-partition qui incorpore la modification; à mettre à jour un historique de table qui comprend un journal des modifications apportées à la table, chaque modification dans le journal de modifications comprenant une estampille temporelle, et la mise à jour de l'historique de table comprenant l'insertion de la modification dans le journal des modifications.
Also published as
Latest bibliographic data on file with the International Bureau