Usage driven indexing in a spreadsheet based data store

Aspects described herein implement a usage-driven indexing scheme on a spreadsheet-based workbook. One aspect describes a system for implementing an indexing scheme in a spreadsheet workbook. The system comprises a processor configured to identify a plurality of cells stored in the plurality of tabl...

Full description

Saved in:
Bibliographic Details
Main Authors Pedapati, Venkata Rao, Fonseca Maich, Helbert, Randschau, Raphael Fabian Nicolai, Wee, Wilfred Xavier Zhi Zhiang
Format Patent
LanguageEnglish
Published 26.09.2023
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:Aspects described herein implement a usage-driven indexing scheme on a spreadsheet-based workbook. One aspect describes a system for implementing an indexing scheme in a spreadsheet workbook. The system comprises a processor configured to identify a plurality of cells stored in the plurality of tables, identify one or more table columns of the plurality of tables to index based on a usage parameter identified from a previously received query, generate an index for individual table columns of the identified table columns, receive the query including an operator and an identifier for at least one of the table columns, determine that the at least one of the table columns identified in the query has an index associated therewith, identify the index associated with the at least one of the table columns identified in the query, and identify a result to the query based on the identified index and the operator.
Bibliography:Application Number: US202017039986