Embodiments disclosed herein provide for systems and methods of a reporting engine framework that dynamically generates a database query. The systems and methods provide for generating the database query via an intuitive user interface, wherein the user interface interacts with a plurality of application program interfaces to retrieve and generate data associated with the database to be queried.

A spreadsheet supports formulas in cells that trigger queries of a data source. The parameters for queries can include or depend on values in other cells in the spreadsheet. Thus, the precise query submitted to the data source is dynamic, being dependent on the data and formulas in the spreadsheet. Furthermore, on receiving the query results, they are added to cells in the spreadsheet, which can be parameters for other queries defined in other cells. Changing the value of a single cell can automatically trigger an update of an arbitrarily deep hierarchy of calculations that can include an arbitrary number of data source queries.

A method including receiving, by one or more processing circuits, building data, generating, by the one or more processing circuits, a first digital twin based on the building data, wherein a first system stores the first digital twin and a second system stores a second digital twin generated based on the building data, where the first digital twin includes a relationship that forms a connection between the first digital twin and the second digital twin by linking a first entity of the first entities of the first digital twin and a second entity of the second entities of the second digital twin, and performing, by the one or more processing circuits, one or more operations based on at least one of the first digital twin, the second digital twin, or the relationship that forms the connection between the first digital twin and the second digital twin.

A method including obtaining resource overheads according to feature information of a received query request; according to the resource overheads and a compute node resource, dynamically adjusting a compute node in a resource pool; and querying, by using the compute node, data corresponding to the query request. A compute node in a resource pool may be dynamically adjusted, so that the compute node in the resource pool may process all the received query requests, and therefore, the processing efficiency and a resource utilization rate of the compute node are more effectively improved, such that the compute node may more efficiently perform parallel processing on the multiple query requests, and the utilization rates of a CPU resource, a memory resource and a network bandwidth resource are increased, thus achieving better effect from the perspectives of overall computing resource and user query load and improving the usage experience of a user.

A processor may receive a request with a column-oriented operation. The query request may be related to updates to a row-oriented database based on the query request previously performed on the row-oriented database. The processor may determine the amount of time for replicating the updates to a column-oriented database. If the amount of time for replicating the updates to the column-oriented database is greater than a threshold amount of time, then the processor may create a transient file with the updates. The transient file may be in a format that is recognized by the column-oriented database. The processor may query the column-oriented database based on the query request and the transient file.

Disclosed herein are system, method, and computer-readable device embodiments of a no-code, enterprise application software (EAS) system. The system may include a database configured to store a data model including one or more parties, governors and steps. The database may be further configured to store a plurality of rules in a rules table. The system may also include a rules engine, coupled to the database, where the rules engine is configured to query a rules table utilizing a compound index to locate a rule to execute and execute the rule. Further included in the system may be a query engine coupled to the database for converting user defined queries into database-specific queries and a report engine coupled to the database for generating reports based on the data stored in the database.

A method includes registering a type of data file. Registering the type of data file includes storing metadata describing the type of data file, the metadata including a file storage service and a parser for the type of data file. The method includes receiving a first data file of the type from a first domain, the first data file having raw data, storing the first data file, storing one or more access rules and a lineage of the first data file, parsing the first data file using the parser to generate a content from the raw data, storing the content separately from the raw data, providing the first data file and the content to a search service, and automatically updating one or more second data files from one or more other domains based on the content of the first data file using the search service and the lineage.

A method includes generating a representation of each of a plurality of dialects of structured query language (SQL) statements, and receiving a first SQL statement. The first SQL statement is in a first dialect of the plurality of dialects. The method further includes generating a first output corresponding to the first SQL statement. The first output has a plurality of first data structures arranged in a first tree structure. Each of the plurality of first data structures corresponds to a portion of the first SQL statement. The method further include receiving a second SQL statement, the second SQL statement is in a second dialect of the plurality of dialects, and generating a second output corresponding to the second SQL statement. The second output has a plurality of second data structures arranged in a second tree structure. Each of the plurality of second data structures corresponds to a portion of the second SQL statement. A first data structure of the plurality of first data structures is the same as a second data structure of the plurality of second data structures.

Various methods, apparatuses/systems, and media for application of an N-dimensional hypercube datatype for automatically generating a data structure are provided. A database stores a plurality of data each associated with a corresponding application and each including metadata describing information about the data. A processor creates taxonomies describing data concepts associated with the metadata and store the taxonomies onto the database; receive the metadata and the taxonomies from the database via a communication network; automatically generate a cube set including a set of N-dimensional hypercubes from the received metadata to represent the metadata describing the information about the data; automatically generate a map from the cube set to express data quality checks and rules that apply to nodes in the map; and apply the data quality checks and rules to the received metadata to automatically generate a data structure.

An engine-mounted component life cycle data tracking system is provided. The system includes a plurality of RFID tags associated with, positioned proximate to, and configured to transmit and store identification, repair history, and dynamic data regarding a different engine component of a plurality of engine components, wherein the dynamic data includes engine usage, component usage, and/or component fault information. The system further includes an aircraft-mounted controller that includes non-transient computer readable storage media. The controller is configured to: store identification and repair history data retrieved from the RFID tags in the storage media; store dynamic data for the plurality of engine components in the storage media after each engine cycle; and transmit dynamic data to the RFID tags after each engine cycle for storage. After each engine cycle, the aircraft-mounted controller includes in its storage media the identification, repair history and dynamic data for the plurality of engine component.