PLACEMENT OF ADAPTIVE AGGREGATION OPERATORS AND PROPERTIES IN A QUERY PLAN

The subject technology receives a query plan, the query plan comprising a set of query operations, the set of query operations including at least one aggregation and at least one join operation. The subject technology analyzes the query plan to identify an aggregation that is redundant. The subject...

Full description

Saved in:
Bibliographic Details
Format Patent
LanguageEnglish
Published 24.04.2020
Online AccessGet full text

Cover

Abstract The subject technology receives a query plan, the query plan comprising a set of query operations, the set of query operations including at least one aggregation and at least one join operation. The subject technology analyzes the query plan to identify an aggregation that is redundant. The subject technology removes the aggregation based at least in part on the analyzing. The subject technology determines at least one aggregation property corresponding to at least one query operation of the query plan. The subject technology inserts at least one adaptive aggregation operator in the query plan based at least in part on the at least one aggregation property. The subject technology provides a modified query plan based at least in part on the inserted at least one adaptive aggregation operator in the query plan.
AbstractList The subject technology receives a query plan, the query plan comprising a set of query operations, the set of query operations including at least one aggregation and at least one join operation. The subject technology analyzes the query plan to identify an aggregation that is redundant. The subject technology removes the aggregation based at least in part on the analyzing. The subject technology determines at least one aggregation property corresponding to at least one query operation of the query plan. The subject technology inserts at least one adaptive aggregation operator in the query plan based at least in part on the at least one aggregation property. The subject technology provides a modified query plan based at least in part on the inserted at least one adaptive aggregation operator in the query plan.
BookMark eNrjYmDJy89L5WTwCvBxdHb1dfULUfB3U3B0cQwI8QxzVXB0dw9ydXcM8fT3U_APcA1yDPEPClZw9HNRCAgC8UM8XYMVPP0UHBUCQ12DIhWApvjxMLCmJeYUp_JCaW4GNTfXEGcP3dLigsSS1LyS4vjEgoKczOTEksz8vOJ4QzMLU3NzSwNjohUCANrFNQs
ContentType Patent
DBID EFI
DatabaseName USPTO Published Applications
DatabaseTitleList
Database_xml – sequence: 1
  dbid: EFI
  name: USPTO Published Applications
  url: http://www.uspto.gov/patft/index.html
  sourceTypes: Open Access Repository
DeliveryMethod fulltext_linktorsrc
ExternalDocumentID 20210089533
GroupedDBID EFI
ID FETCH-uspatents_applications_168577903
IEDL.DBID EFI
IngestDate Sun Mar 05 22:10:54 EST 2023
IsOpenAccess true
IsPeerReviewed false
IsScholarly false
Language English
LinkModel DirectLink
MergedId FETCHMERGED-uspatents_applications_168577903
OpenAccessLink https://patentcenter.uspto.gov/applications/16857790
ParticipantIDs uspatents_applications_16857790
PublicationCentury 2000
PublicationDate 20200424
PublicationDateYYYYMMDD 2020-04-24
PublicationDate_xml – month: 04
  year: 2020
  text: 20200424
  day: 24
PublicationDecade 2020
PublicationYear 2020
Score 3.0666056
Snippet The subject technology receives a query plan, the query plan comprising a set of query operations, the set of query operations including at least one...
SourceID uspatents
SourceType Open Access Repository
Title PLACEMENT OF ADAPTIVE AGGREGATION OPERATORS AND PROPERTIES IN A QUERY PLAN
URI https://patentcenter.uspto.gov/applications/16857790
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwhVw9T8MwED3RCgmYQID4KHADYgtKgmslo9U6aSpIQkhRmSo7mLFUbfr_OVsUlamrdT6fvLz37gvgXhEFUPqL1AnnsccaFnvKBMYzviY81BELtK3ovuR8NGHjaX_6OxRmZ2EWxLDmrW1MNMvH9WrRfrvuyn_V3IBHfbsmrwOdiNt9-TLJjuCArN3l1RZAJMewX7rTE9gz81MYl89i4PbkY5GgGIqyzt4lijStZOqyQliUshJ1Ub2hyIdY2n66qiZuhlmOAl8nsvpA8pKfwUMi68HI-3t4th3mbBPm0zl0ScqbC8CY2L4KAhUa0jEm9iOm4oa7FPtn2OjmEu52OLvaaXENh6HVhD7zQtaDbrtcmxsCzlbfup_6AW87csU
linkProvider USPTO
linkToPdf http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwhVzNT8IwFH9RNH6cNGr8pgfjrYaNsmzHBjYY4qhzGDwt7SgnHcSN-O_7WozhxrVpXpv2te_93scP4EGiCyDVHNGJ5wWUFSygUjua6pZCe6h85iiT0X1JvMGEDaed6V97tO2F-cJnRJe4l-ppVS3rhS2uxO99ffF0Tf5sOAJLwz7wU34u5EzM5gbEG54aUy25C3uoVW2j72EUH8MhCkLHrayrDdMRncC-sKOnsKPLMxiKEe9aBn0yjgjvcZHF7yHh_X4a9m28iIxFmPJsnL4RnvSIMJV2aYZeG4kTwsnrJEw_CEpJzuExCrPugP4vnG-mo3PH8zuG5699AQ0E-foSSIA4QDqOdDUiHB20fCaDwrPB95lbqOIKmluEXW-d0YQD0YvyUZw838CRa4Bji1GX3UKj_l7pO7Sutbq3h_YLGsZ9_w
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=PLACEMENT+OF+ADAPTIVE+AGGREGATION+OPERATORS+AND+PROPERTIES+IN+A+QUERY+PLAN&rft.date=2020-04-24&rft.externalDBID=n%2Fa&rft.externalDocID=20210089533