Processing

Please wait...

Settings

Settings

Goto Application

1. WO2020112663 - TASK SCHEDULING IN DATABASE SYSTEMS

Publication Number WO/2020/112663
Publication Date 04.06.2020
International Application No. PCT/US2019/063057
International Filing Date 25.11.2019
IPC
G06F 16/00 2019.01
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
CPC
G06F 16/2379
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
2379Updates performed during online database operations; commit processing
G06F 9/466
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
9Arrangements for program control, e.g. control units
06using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
46Multiprogramming arrangements
466Transaction processing
G06F 9/4881
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
9Arrangements for program control, e.g. control units
06using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
46Multiprogramming arrangements
48Program initiating; Program switching, e.g. by interrupt
4806Task transfer initiation or dispatching
4843by program, e.g. task dispatcher, supervisor, operating system
4881Scheduling strategies for dispatcher, e.g. round robin, multi-level priority queues
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/203,32228.11.2018US
Publication Language English (EN)
Filing Language English (EN)
Designated States
Title
(EN) TASK SCHEDULING IN DATABASE SYSTEMS
(FR) PLANIFICATION DE TÂCHES DANS DES SYSTÈMES DE BASE DE DONNÉES
Abstract
(EN)
Systems, methods, and devices for executing a task on database data in response to a trigger event are disclosed. A method includes executing a transaction on a table comprising database data, wherein executing the transaction comprises generating a new table version. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or more modifications made to the table by the transaction and storing the change tracking entry in a change tracking stream. The method includes executing a task on the new table version in response to a trigger event.
(FR)
L'invention concerne des systèmes, des procédés et des dispositifs d'exécution d'une tâche sur des données de base de données en réaction à un événement déclencheur. Un procédé comprend l'exécution d'une transaction sur une table comportant des données de base de données, l'exécution de la transaction comprenant la génération d'une nouvelle version de table. Le procédé comprend, en réaction à la réalisation complète de la transaction, la génération d'une entrée de suivi de changement comportant une indication d'une ou de plusieurs modifications apportées à la table par la transaction et le stockage de l'entrée de suivi de changement dans un flux de suivi de changement. Le procédé comprend l'exécution d'une tâche sur la nouvelle version de table en réaction à un événement déclencheur.
Also published as
Latest bibliographic data on file with the International Bureau