Microstrategy, Inc.

Yinong Chen

Benjamin Z Li

Jeffrey A Bedell

Jun Yuan

Fabrice Martin

Sadanand Sahasrabudhe

Ananya Ojha

Yuliyan Kiryakov

Shiliang Wang

Disclosed are methods, systems, and computer-readable medium for providing query results. The query results may be provided more accurately and faster than via distributed tables. Disclosed techniques include receiving a plurality of tables comprising attributes and attribute data, the attribute data comprising attribute forms and attribute related information, identifying attributes and corresponding attribute data from each of the plurality of tables, applying a categorization machine learning model to categorize each attribute data as an attribute form or an attribute related information, generating the lookup table based on the attributes and the corresponding attribute forms, generating the relationship table based on the attributes and the corresponding attribute related information, receiving a query for attribute data, and generating a query response based on at least one of the lookup table or the relationship table.

Systems and methods for providing faster data access using lookup and relationship tables

A system and method for syntax abstraction in query language generation in an online analytical processing system, a business intelligence system, a reporting system, or a data mining system. The system generates one or more query language statements that can be run against one or more data sources to return a desired data result set. The system includes a syntax pattern selector module and a statement assembly module. The syntax pattern selector module selects a syntax pattern corresponding to a desired function and a syntax standard. The statement assembly module populates the syntax pattern with an argument data set associated with the desired data set. The result is the generation of one or more query language statements with the correct function, syntax, and data parameters to return the desired data result set from the data sources. A method and medium having processor readable code therein are also described.

System and method for syntax abstraction in query language generation

Growing community of inventors

Sterling, VA, United States of America

Yinong Chen