Methods, systems, and apparatuses for providing access to records of a database stored on a database server in a cloud database platform are described herein. A data sharing platform may determine a shared view definition for access to the database. The data sharing platform may determine rules that specify criteria that limit access to the records stored by the database. The one or more first rules may be received via a user interface. The data sharing platform may perform, based on the rules, a data access certification process on the records stored by the database to generate a table of certification results. The data sharing platform may generate, based on the table of certification results, and without modifying the records stored by the database, a limited consumer view definition. Based on updates to the records, a new limited consumer view definition may be generated.

An approach is provided in which the approach segments each one of multiple components corresponding to multiple component levels in an SQL database system into multiple functions. The approach combines a first one of the multiple functions with a second one of the multiple functions into an image, and invokes the image to process an SQL query using the first function and the second function.

A method for accessing data stored in a database may include receiving a query to generate, based on blended data, a visualization. The blended data may include a first set of data from a first data source and a second set of data from a second data source. The query may also include a payload. The method may also include accessing the first set of data by injecting, into the payload, the first permission, and transmitting, to the first data source, the payload including the first permission. The method may also include accessing the second set of data by injecting, into the payload, the second permission, and transmitting, to the second data source, the payload including the first permission, the first set of data, and the second permission. The method may also include causing, using the blended data, presentation of the visualization. Related systems and articles of manufacture are provided.

A method and a corresponding system for deploying changes in a computer system, in particular an industrial computer system, includes a database and an old version of the system to be updated. The method includes providing a new version of the system and providing a merge view capable of reading data from the database and furnishing the data to the new version. The database contains at least an old table readable by the old version and the merge view can read data from the old table and furnish them to the new version.

A process for recommending pre-constructed queries in data analytics includes writing different records to a correlation data structure correlating different data classifications of data to different queries and, subsequent to the writing, establishing a communicative connection by a data analytics application to an underlying database. Thereafter, a data model for data in the database may be constructed in the data analytics application and at least one of the different queries may be selected in the correlation data structure that correlates to the classification of the data in the data model. Finally, the selected one of the different queries may be displayed in the data analytics application to an end user so as to provide an intelligent recommendation for the addition of the selected one of the different queries without requiring the end user to alone and without assistance discover the suitability of the selected one of the different queries.

Some embodiments provide a method for quantifying the workload placed on a database by an application. The method identifies a first group of database queries that the application directed towards the database. The method produces a second group of queries by removing, from the first group of queries, queries that are duplicates based on the semantic structure of the queries. Based on a set of properties of the second group of queries, the method computes a complexity indicator that represents a complexity expression of the second group of queries.

Aspects of the present disclosure address systems, methods, and devices for tracking object dependencies in a cloud database system. An object dependency created between a referencing object and a referenced object is detected. Based on detecting the object dependency, a dependency record is generated. The dependency record includes dependency information describing the object dependency between the reference object and the referenced object. The dependency record is stored in a database of dependency records.

A method and apparatus for carrying out a database select, or query, on a data storage device, upon data stored on that device. Data is received from a host and compressed on the data storage device using a compression code developed on the data storage device for the data. When the host issues a database select request on the compressed data, the compression code is distributed to processing cores of the data storage device and compiled, including the select request, into machine code. The machine code is used to decompress the compressed data while filtering the data with the select request. The filtering result is returned to the host.

A computing device generates and displays a data visualization in a data visualization user interface. The data visualization includes a plurality of visual data marks representing data from a data source. The computing device detects a first user input to select a visual data mark of the plurality of visual data marks. In response to detecting the first user input, the computing device identifies a first aggregated data value, for the visual data mark, corresponding to a first data field in the data source. The computing device retrieves a first disaggregated set of data rows corresponding to the first aggregated data value, from a first table, in the data source, containing the first data field. The computing device displays, in the data visualization user interface, a plurality of data rows from the first disaggregated set of data rows.

Generating a subsetting traversal plan includes receiving a set of source tables. It further includes sorting the set of source tables based at least in part on dependency relationships among tables in the set of source tables. It further includes generating a traversal order based at least in part on the sorting of the set of source tables. It further includes providing the traversal order as output.