G06F16/2443

SYSTEM AND METHOD FOR MANAGEMENT SYSTEM DATA AGGREGATION AND TRANSFORMATION USING CLIENT-SPECIFIC CRITERIA
20210224262 · 2021-07-22 · ·

A method may include receiving, at a first time, an instruction to execute a stored procedure at a database system, retrieving a schema of a structure of a database used by a management system of a client entity, determining an identity of a management system and a type of data to retrieve for the client entity. The method may also include, responsive to determining the identity and the type of data to retrieve, determining a criteria to use in a dynamic query based on the identity and the type of data to retrieve. The method may also include, responsive to determining the criteria, generating, in the stored procedure, the dynamic query comprising the criteria, and executing the stored procedure to retrieve raw data from the database used by the management system and transform the raw data to transformed data using the dynamic query.

Identifying related field sets based on related source types

Embodiments of the present invention are directed to identifying related data, in particular, data associated with different source types. In embodiments, a first source type related to a second source type associated with a search query is identified. Field set pairs are identified from a first data set associated with the first source type and a second data set associated with the second source type. Each field set pair can include one field set associated with the first source type and another field set associated with the second source type. For each field set pair, an extent of similarity is determined between the corresponding field sets. Based on the extent of similarities between the corresponding field sets, at least one pair of related field sets is identified. An indication of the at least one pair of related field sets is provided, for example, for presentation to a user.

IDENTIFYING RELATED FIELD SETS BASED ON RELATED SOURCE TYPES

Embodiments of the present invention are directed to identifying related data, in particular, data associated with different source types. In embodiments, a first source type related to a second source type associated with a search query is identified. Field set pairs are identified from a first data set associated with the first source type and a second data set associated with the second source type. Each field set pair can include one field set associated with the first source type and another field set associated with the second source type. For each field set pair, an extent of similarity is determined between the corresponding field sets. Based on the extent of similarities between the corresponding field sets, at least one pair of related field sets is identified. An indication of the at least one pair of related field sets is provided, for example, for presentation to a user.

DEPLOYING A SMART CONTRACT
20210271602 · 2021-09-02 · ·

Implementations of the present specification provide a method for deploying a smart contract. According to one implementation the method includes: receiving a transaction request for invoking a first contract; obtaining a first instruction code and a function index table, wherein the function index table is used to indicate a memory address of an instruction code corresponding to each of import and export functions in the first contract; determining a first memory address corresponding to the invocation function based on the function index table; and executing the first instruction code in the first memory address based on the determined first memory address.

VIRTUALIZATION OF CONFIGURATION DATA
20210149894 · 2021-05-20 ·

A method may include receiving a selection of a template defining a manner in which data is stored in one or more database tables operated upon by a software application while the software application performs a function. The selected template may be stored in a first database table. Customizations applied to the selected template are stored in a second database table. In response to the software application performing the function, a virtual customizing table may be generated to include a database view having the selected template from the first database table and the customizations from the second database table. The software application may perform the function based on the virtual customization table, which is not persisted at a database but is generated as needed. Related systems and articles of manufacture, including computer program products, are also provided.

Deploying a smart contract
11010303 · 2021-05-18 · ·

Implementations of the present specification provide a method for deploying a smart contract. According to one implementation the method includes: receiving a transaction request for invoking a first contract; obtaining a first instruction code and a function index table, wherein the function index table is used to indicate a memory address of an instruction code corresponding to each of import and export functions in the first contract; determining a first memory address corresponding to the invocation function based on the function index table; and executing the first instruction code in the first memory address based on the determined first memory address.

PROCESSING USER-DEFINED FUNCTIONS (UDFs) USING MULTIPLE EXECUTION ENVIRONMENTS
20230409552 · 2023-12-21 ·

A method includes detecting, by at least one hardware processor, an upload of a user application within a database system. The user application includes user-defined function (UDF) code. A plurality of dependencies of the user application is determined by the at least one hardware processor. A plurality of execution environments corresponding to the plurality of dependencies is generated by the at least one hardware processor. The plurality of execution environments is associated with a corresponding plurality of data types of the UDF. A database query is decoded. The database query specifies database data of a data type of the plurality of data types of the UDF. The database query is processed using at least one of the plurality of execution environments to generate results data. The at least one of the plurality of execution environments corresponds to the data type of the plurality of data types of the UDF.

Virtual file system for cloud-based shared content

A server in a cloud-based environment interfaces with storage devices that store shared content accessible by two or more users. Individual items within the shared content are associated with respective object metadata that is also stored in the cloud-based environment. Download requests initiate downloads of instances of a virtual file system module to two or more user devices associated with two or more users. The downloaded virtual file system modules capture local metadata that pertains to local object operations directed by the users over the shared content. Changed object metadata attributes are delivered to the server and to other user devices that are accessing the shared content. Peer-to-peer connections can be established between the two or more user devices. Object can be divided into smaller portions such that processing the individual smaller portions of a larger object reduces the likelihood of a conflict between user operations over the shared content.

File tree streaming in a virtual file system for cloud-based shared content

Systems for fast views of items in file directories or file folders when interacting with a cloud-based service platform. A server in a cloud-based environment interfaces with one or more storage devices to provide storage of shared content accessible by two or more user devices. A file tree request to view the file directory or file folder of a particular sought after item is issued from an application operating on one of the user devices. Additional file tree items in a file tree hierarchy are prefetched by the cloud-based service platform. The application closes the file tree metadata stream after receiving the portion of the file tree that pertains to the particular item and before receiving the entirety of the metadata pertaining to all of the file tree metadata of all of the items in the directory or folder that contains the particular sought after item.

DATABASE MODULARIZATION OF PLUGGABLE GUEST LANGUAGES

Herein are techniques that extend a software system to embed new guest programing languages (GPLs) that interoperate in a transparent, modular, and configurable way. In embodiments, a computer inserts an implementation of a GPL into a deployment of the system. A command registers the GPL, define subroutines for the GPL, generates a guest virtual environment, and adds a binding of a dependency to a guest module. In an embodiment, a native programing language invokes a guest programing language to cause importing intra- or inter-language dependencies. An embodiment defines a guest object that is implemented in a first GPL and accessed from a second GPL. In an embodiment, dependencies are retrieved from a virtual file system having several alternative implementation mechanisms that include: an archive file or an actual file system, and a memory buffer or a column of a database table.