Database management system for optimizing queries via multiple optimizers

A large highly parallel database management system includes thousands of nodes storing huge volume of data. The database management system includes multiple query optimizers for determining low cost execution plans for queries. The database management system is adapted to receive a data query. An ex...

Full description

Saved in:
Bibliographic Details
Main Authors Arnold, Jason, Kondiles, George
Format Patent
LanguageEnglish
Published 30.04.2024
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

Abstract A large highly parallel database management system includes thousands of nodes storing huge volume of data. The database management system includes multiple query optimizers for determining low cost execution plans for queries. The database management system is adapted to receive a data query. An execution plan generator component of the database management system generates an initial execution plan for the query. The initial execution plan is fed as input to more than one query optimizers. Each optimizer starts with the initial execution plan, generates alternative execution plans, and determines a satisfactory execution plan that incurs the lowest cost. The database management system compares the selected execution plans by the optimizers and selects one with the lowest cost. The multiple query optimizers run in parallel.
AbstractList A large highly parallel database management system includes thousands of nodes storing huge volume of data. The database management system includes multiple query optimizers for determining low cost execution plans for queries. The database management system is adapted to receive a data query. An execution plan generator component of the database management system generates an initial execution plan for the query. The initial execution plan is fed as input to more than one query optimizers. Each optimizer starts with the initial execution plan, generates alternative execution plans, and determines a satisfactory execution plan that incurs the lowest cost. The database management system compares the selected execution plans by the optimizers and selects one with the lowest cost. The multiple query optimizers run in parallel.
Author Arnold, Jason
Kondiles, George
Author_xml – fullname: Arnold, Jason
– fullname: Kondiles, George
BookMark eNqNyrsOAUEUh_EpKNze4XgAiaFgW7dQo94c8t_NJHMz56yEp9fQq77i9w1NL6aIgTntWPnGAgocuUVAVJKXKAI1qVDK6oJ7u9jSo0NxEHo6ptB5ddnj5ygyNv2GvWDy7chMD_vL9jhDTjUk8x0RWl_P1lYru67mm8Xyn-cDcZQ3kg
ContentType Patent
DBID EVB
DatabaseName esp@cenet
DatabaseTitleList
Database_xml – sequence: 1
  dbid: EVB
  name: esp@cenet
  url: http://worldwide.espacenet.com/singleLineSearch?locale=en_EP
  sourceTypes: Open Access Repository
DeliveryMethod fulltext_linktorsrc
Discipline Medicine
Chemistry
Sciences
Physics
ExternalDocumentID US11971890B2
GroupedDBID EVB
ID FETCH-epo_espacenet_US11971890B23
IEDL.DBID EVB
IngestDate Fri Aug 30 05:40:22 EDT 2024
IsOpenAccess true
IsPeerReviewed false
IsScholarly false
Language English
LinkModel DirectLink
MergedId FETCHMERGED-epo_espacenet_US11971890B23
Notes Application Number: US202217806119
OpenAccessLink https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20240430&DB=EPODOC&CC=US&NR=11971890B2
ParticipantIDs epo_espacenet_US11971890B2
PublicationCentury 2000
PublicationDate 20240430
PublicationDateYYYYMMDD 2024-04-30
PublicationDate_xml – month: 04
  year: 2024
  text: 20240430
  day: 30
PublicationDecade 2020
PublicationYear 2024
RelatedCompanies Ocient Inc
RelatedCompanies_xml – name: Ocient Inc
Score 3.532014
Snippet A large highly parallel database management system includes thousands of nodes storing huge volume of data. The database management system includes multiple...
SourceID epo
SourceType Open Access Repository
SubjectTerms CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Title Database management system for optimizing queries via multiple optimizers
URI https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20240430&DB=EPODOC&locale=&CC=US&NR=11971890B2
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV1LS8NAEB5Kfd40KlofrCC5BZM2seYQhCQNVegD20hvZbPZQApNiokK_npnt0nrRa8zsOwOzMw3zwW4o6ZN40470rjNEs2MDZFoQn20KGeJ0aY8oWJ2eDB86Ifmy8yaNWBRz8LIPaFfcjkiahRDfS-lvV5tk1i-7K0s7qMUSflTMHV8tYqO22JXjK76rtMbj_yRp3qeE07U4asjqmXGo627aK53EEZ3ZdD25oqplNVvlxIcwe4YT8vKY2jwTIEDr_55TYH9QVXwVmBPdmiyAomVFhYn8OzTkgr3Q5ab5hWyXslMEIOSHM3AMv1Gp0TQ6otYmHymlNS9gzUfgd8p3Aa9qdfX8HbzjSjm4WT7kM4ZNLM84-dATIObAjmwiCLi7-q2zmJD59TSY2ZQ276A1t_ntP5jXsKhEOu6fnIFzfL9g1-jGy6jGym_Hy8ljnI
link.rule.ids 230,309,783,888,25577,76883
linkProvider European Patent Office
linkToHtml http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV1LT8JAEJ4QfOBNUYP4WhPTW2NbitJDY9IWAkoLkWK4ke12m2BCIbZq4q93dqHgRa8zyWZ3kpn55rkAt9S0aNwwIpVbLFHNWBeJJtTHJuUs0Q3KEypmh_3gvjs2nybNSQneilkYuSf0Sy5HRI1iqO-5tNfLbRLLk72V2V00Q9LisRPanrKOjg2xK0ZTPMduDwfewFVc1x6PlODFFtUyvWVpDprrHYTYLRkqvTpiKmX526V0DmF3iKel-RGUeFqFilv8vFaFfX9d8K7CnuzQZBkS11qYHUPPozkV7ofMN80rZLWSmSAGJQs0A_PZNzolglZfxMLkc0ZJ0TtY8BH4ncBNpx26XRVvN92IYjoebR_SOIVyukh5DYipc1MgBxZRRPwPmqWxWNc4bWox06llnUH973Pq_zGvodIN_f603wuez-FAiHhVS7mAcv7-wS_RJefRlZTlDwXIkWI
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Apatent&rft.title=Database+management+system+for+optimizing+queries+via+multiple+optimizers&rft.inventor=Arnold%2C+Jason&rft.inventor=Kondiles%2C+George&rft.date=2024-04-30&rft.externalDBID=B2&rft.externalDocID=US11971890B2