Stored procedures are generated to perform incremental updates to a materialized view for a database. When a request to create a materialized view is received, one or more internal tables are created from the database. A stored procedure is generated that when executed will update the materialized view of the database. The stored procedure may obtain changes to the database that were not included in the internal tables and update the internal tables to include the obtained changes. The stored procedure may be performed automatically and in response to requests.

A computer system includes a processor, a file system having a query application and a query interface, a database, and a query interface extension executing on the processor. The database includes a plurality of business intelligence (BI) data objects. Each of the BI data objects is associated with one or more data parameters. The query interface extension intercepts a data call from the query application to the query interface for data corresponding to one or more of the BI data objects. The data call includes one or more selected parameters. The data call is parsed to ascertain the one or more selected parameters. Data corresponding to the one or more BI data objects is obtained from the database based on the one or more selected parameters. A data prediction result is appended to the obtained data.

A computer system includes a processor and a database. The database includes a plurality of business intelligence (BI) data objects. Each of the BI data objects is associated with one or more data parameters. The processor is programmed with computer-executable instructions that cause the processor to run user code associated with a runtime environment that is hosted on the database. The user code includes executable source code that is not an intrinsic part of the database. The user code is created and deployed into the database and is configured to intercept a data call from a query application to a query interface for data corresponding to one or more of the BI data objects. The data call includes one or more selected parameters. The data call is parsed to ascertain the one or more selected parameters. Data corresponding to the one or more BI data objects is obtained from the database based on the one or more selected parameters. A data prediction result is appended to the obtained data.

Provided are methods and systems comprising receiving a plurality of data tables, wherein each data table comprises at least one row, generating a first handle for a first value in a table of the plurality of tables, wherein the first handle comprises an indication of whether a row in each of the plurality of tables is associated or not associated with the first value, and performing one or more operations on the first handle.

For equipment tutorial review audit, a processor synchronizes a plurality of equipment tutorials to a mobile device. Each equipment tutorial corresponds to an equipment instance of a plurality of equipment instances of specific equipment and each equipment instance corresponds to an equipment reference code. The processor receives a first equipment reference code for a first equipment instance at the mobile device. The processor retrieves a first equipment tutorial of the plurality of equipment tutorials that is indexed to the first equipment reference code at the mobile device. The processor displays the first equipment tutorial on the mobile device. In addition, the processor records a review of the first equipment tutorial by an operator to an audit report.

A computer-implemented method for calling a REST webservice for interacting with a database that stores database information, the method comprising: presenting to a user a list of pre-existing events, wherein each of the pre-existing events provides a trigger in response to activity in the database; receiving a user selection of one of the presented pre-existing events; receiving a user selection of one or more actions to be taken in response to the selected pre-existing event providing a trigger; and when the selected pre-existing event happens, calling a REST webservice by sending data to a receiver based on the selected pre-existing event and the one or more selected actions.

A system and method for point-in-time revisioning of a database includes a user database configured to store records related to a gaming environment, a point-in-time (PIT) database configured to revise stored records, a computing system configured to communicate with the PIT database, and an application executable by a processor of a user computing device and to communicate with the computing system, wherein the application is configured to have the processor execute instructions to receive a record to be saved by the PIT database, apply PIT revision of the record to be saved with the PIT database, transmit the revisioned record to be saved to the user database, request the current revision of the saved record by the user, and receive the revised record from the PIT database, and transmit the current revision of the saved record to the user.

Techniques for implementing a multi-wire protocol and multi-dialect database engine are described. A database engine exposes multiple interfaces in the form of ports that support different database wire protocols. The database engine supports multiple query dialects that can be passed over any one of the supported wire protocols. The database engine can support multiple different query dialects within a single database session.

A method includes receiving an execution request, where the execution request is used to request to execute a task including at least two stored procedures, requesting at least two threads, and dispatching each stored procedure in the task to one of the at least two threads for execution, receiving Structured Query Language (SQL) statements sent by the at least two threads when the at least two threads execute the stored procedures included in the task, and grouping and caching the received SQL statements based on a same access characteristic, and for an SQL statement cache group that satisfies a preset trigger condition, calling an SQL statement execution engine to execute an SQL statement in the SQL statement cache group.

A system and method are described to create and use an Integrated Object Environment (IOE) running in a graph database environment. Uses include storing, revealing and maintaining value and risk of information assets, such as the topology of an analytical infrastructure in query-driven, graph database. A graphical user interface is described to permit importation, viewing, modification and querying in the IOE.