Processing

Please wait...

Settings

Settings

Goto Application

1. WO2020112692 - INDEXES ON NON-MATERIALIZED VIEWS

Publication Number WO/2020/112692
Publication Date 04.06.2020
International Application No. PCT/US2019/063103
International Filing Date 25.11.2019
IPC
G06F 16/22 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
22Indexing; Data structures therefor; Storage structures
G06F 16/2453 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
24Querying
245Query processing
2453Query optimisation
CPC
G06F 16/1815
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
10File systems; File servers
18File system types
1805Append-only file systems, e.g. using logs or journals to store data
1815Journaling file systems
G06F 16/221
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
22Indexing; Data structures therefor; Storage structures
221Column-oriented storage; Management thereof
G06F 16/2228
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
22Indexing; Data structures therefor; Storage structures
2228Indexing structures
G06F 16/2282
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
22Indexing; Data structures therefor; Storage structures
2282Tablespace storage structures; Management thereof
G06F 16/24524
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
2452Query translation
24524Access plan code generation and invalidation; Reuse of access plans
G06F 16/2453
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
2453Query optimisation
Applicants
  • AMAZON TECHNOLOGIES, INC. [US]/[US]
Inventors
  • CERTAIN, Tate Andrew
  • PAPAKONSTANTINOU, Yannis
  • VERMEULEN, Allan, Henry
  • DE KADT, Christopher, Richard, Jacques
Agents
  • ADAMS, Scott S.
  • ADAMS, Dylan O.
  • ALBERT, Philip H.
  • BRUNNER, Jaron K.
  • BUNTS, James
  • BYER, Benjamin J.
  • CHANG, Jack
  • CHOU, Timothy
  • COLBURN, Heather M.
  • DAGGETT, David K.
  • DAVISON, Barry L.
  • DONOHUE, Michael J.
  • JOHNSON, Bruce L.
  • MCCUNE, Connor L.
  • MOERSFELDER, Matthew E.
  • RABURN, Greg A.
  • ROGGE, Mark H.
  • RONDEAU, JR., George C.
  • SCHLEIFER, David C.
  • VAGNER, Allison
  • VAN DYKE, Colin
  • WILLIAMS, Matthew D.
  • WYCKOFF, Tim R.
Priority Data
16/200,60026.11.2018US
Publication Language English (EN)
Filing Language English (EN)
Designated States
Title
(EN) INDEXES ON NON-MATERIALIZED VIEWS
(FR) INDEX SUR DES VUES NON MATÉRIALISÉES
Abstract
(EN)
A database management system receives a request to create an index for a virtual view of a database table. In response to the request, the database management system identifies relationships between the columns of the virtual view and columns of the database table. The database management system generates an index on the database table, where columns are included in the generated index based on the identified relationships and the definition of the virtual view. Queries of the virtual view are assisted by the generated index of the underlying table.
(FR)
Selon l'invention, un système de gestion de base de données reçoit une demande de création d'un index pour une vue virtuelle d'une table de base de données. En réponse à la demande, le système de gestion de base de données identifie des relations entre les colonnes de la vue virtuelle et des colonnes de la table de base de données. Le système de gestion de base de données génère un index sur la table de base de données, des colonnes étant incluses dans l'index généré sur la base des relations identifiées et de la définition de la vue virtuelle. Des interrogations de la vue virtuelle sont aidées par l'index généré de la table sous-jacente.
Also published as
Latest bibliographic data on file with the International Bureau