Data driven indexing in a spreadsheet based data store

• Main Authors: Pedapati, Venkata Rao, Fonseca Maich, Helbert, Randschau, Raphael Fabian Nicolai, Wee, Wilfred Xavier Zhi Zhiang
• Format: Patent
• Language: English
• Published: 30.08.2022
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

Aspects described herein implement a data-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 data store, a user interface, and a processor configured to identify a plurality of cells stored in the plurality of tables, analyze individual cells of the plurality of cells to identify at least one formula or expression therein that involve table columns of the plurality of tables stored in the data store, identify the table columns based on parsing the identified at least one formula or expression, generate an index for individual table columns of the identified table columns, receive the query from the user interface, the query including an operator and an identifier for at least one of the table columns, identify and return a result to the query based on the identified index and the operator.