Microstrategy, Inc.

Jun Yuan

Benjamin Z Li

Jeffrey A Bedell

William Hurwood

Sadanand Sahasrabudhe

Scott Cappiello

Xun Feng

Fabrice Martin

Xinyi Wang

Rixin Liao

Yuliyan Kiryakov

Gang Liang

Ramkumar Ramachandran

Luis V Orozco

Ashutosh K Jhaveri

Michael Jerry Saylor

Abhimanyu Warikoo

Steven S Trundle

Glenn J Boysko

Ramprasad Polana

Eduardo Carranza

Michael Codini

Wenfeng Li

Yinong Chen

Gaurav Rewari

Database report generation technology for handling a single logical query that requires data that is physically located in two different sources. The system uses intelligent push-down joins, which move data from one source to the other and join data within that source. The system dynamically determines which direction to move data depending on how the data is used in a query.

Data source joins

Dynamic sourcing, in which a data request that is associated with a query is received and a parameter of data needed for satisfaction of the query is identified. Parameter information defining data available in at least one cube stored in a cache is accessed and the parameter is compared with the parameter information. Based on comparison results, it is determined whether one or more cubes in the cache include sufficient data to satisfy the query. In response to a determination that one or more cubes include sufficient data to satisfy the query, a response to the data request is generated by executing the query against the one or more cubes. In response to a determination that the cubes do not include sufficient data to satisfy the query, a response to the data request is generated by executing at least a portion of the query against a database system.

Dynamic sourcing

A technique for exporting results from a reporting system report in a format type including a datamart, PDF file, flat file, Excel&#x2122; file, HTML file, and XML file or in another relational database management system (RDBMS) format. In one embodiment, the technique is realized through a method and a system for automatically exporting results from a business intelligence, OLAP, or other reporting system. One embodiment of the present invention involves a method of enabling a user to designate a report desired for execution as an export-report. When the report is processed, the report is exported into a datamart or other format and made available for access by the user through one or more different types of user devices. The user may then further manipulate or export the results from the datamart to a file type as desired.

System and method for exporting report results from a reporting system

A selection engine for a cooperative processing network, in which databases compute portions of searches and analyses which they may most efficiently compute. A data mining network may contain large scale databases, analytic engines which communicate with the databases, and other resources, each capable of performing or executing certain functions, such as statistical functions. When a user desires to run a specified report against the databases, those functions that can be computed locally in the database are trapped and computed therein, whereas other functions, such as advanced statistical functions, may be distributed to remote analytic engines or other resources in the network. A management module may coordinate the transmission and assembly of the data, including to order dependencies. The management module may contain a selection engine to allocate computations to databases or other resources as a default, to test for load balancing before choosing a compute site, or apply other criteria.

System and method for function selection in analytic processing

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

Systems and methods are provided for filtering data in a database using an execution plan. The execution plan has a first processing pass against the database that calculates a filter set using a filter criteria, and a second processing pass against the filter set that calculates a report result.

Systems and methods for set filtering of data

A technique for limiting access to the resources of a system is disclosed. In one embodiment, wherein the system has a server for processing requests, and wherein the server supports a plurality of projects, the technique includes receiving a request to access the resources of the system. The request is denied based upon an application level and a setting level, wherein the application level is associated with one of a plurality of functional layers within the system that is affected by the request, and wherein the setting level is a limiting value associated with one of the server alone and the server with one or more of the plurality of projects. The limiting value limits an operation on one of the plurality of functional layers, thereby limiting access to the resources of the system.

Technique for limiting access to the resources of a system

A system and method for efficient data retrieval and processing in an online analytical processing system, a reporting system, a business intelligence system, or a data mining system. The system provides for retrieval and processing of a data result set from a plurality of data sources. The system includes a query structure assembly module, a syntax assembly module, and a process optimization module. The query structure assembly module defines a query structure based upon query assembly rules and a desired data set (such as the set of data for a particular OLAP report). The syntax assembly module defines one or more query language statements based upon the defined query structure. The process optimization module evaluates processing options based upon a database schema associated with the data sources. One or more query language statements may be assembled by the system and run against the data sources to return the desired data result set. A method and medium having processor readable code therein are also described.

System and method for efficient date retrieval and processing

Security filters that manage user access to data based on user identification and other data when a user attempts to access information via a query or other mechanisms. Security filters may be implemented to prevent users from viewing or otherwise accessing certain data in a database or other source of information in a reporting or other system. The level of access authorized by a security filter may be based on a user's role, capabilities, or other criteria. For example, a regional manager may have a security filter that allows a user to view data from the user's particular region regardless of the report the user runs. A security filter may include a filter expression, a top level and a bottom level where each component may be further define a user's ability to access certain data.

Method and system for implementing security filters for reporting systems

The invention provides a configuration tool to allow a user to build a custom-selected data object hierarchy, for business intelligence or other purposes. Under conventional data storage technologies, the physical layout of the disk drive or other media has dictated what logical views and searches a user could run on the underlying data. For instance, levels could not be readily skipped or many-to-many data object relationships were difficult to maintain. In the invention, a user may select and connect a set of data objects into a hierarchy of their choosing, to permit desired reports and other manipulations on the data to be performed. The hierarchy may be edited, and entry points may be defined. Different levels of security may be applied to the different levels of the hierarchy. Multiple hierarchies or representations may be built for one database or other data source.

System and method for user defined data object hierarchy

A system for collaborative processing, comprising a controlling module with access to at least one relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database. The controlling module is capable of iteratively processing a multi-step calculation including generating SQL statements to the relational database, passing preliminary results to an external analytical engine and saving data back into the relational database for further processing until the multi-step calculation is performed.

Growing community of inventors

Sterling, VA, United States of America

Jun Yuan