Abstract:
Methods, systems, and computer program products for processing a query to determine query results. The query may be analyzed to determine a constant column pair corresponding to the query. The column constant pair may be analyzed with respect to a column constant pair associated with a partitioned data set in order to route the query to a subset of the data set. Data sets may be partitioned into subsets by analyzing historical queries to determine a partitioning column constant pair with respect to the data set that is used to partition the data of the data set into subsets. The query processing may include both query routing and data set partitioning.
Abstract:
An example method of processing a query at a plurality of storage devices includes receiving a dual query from a client and generating a synchronous query and an asynchronous query based on the dual query. The dual query includes a set of conditions for selecting data from a set of database tables. The method further includes sending the synchronous query to a first storage device, sending the asynchronous query to a second storage device, and receiving a result set of the synchronous query. The result set of the synchronous query includes data selected from a set of database records in a set of primary database tables, which is stored in the first storage device and is a subset of the set of database tables. The method further includes marking a database record. A marked database record indicates usage of the data selected from the database record within a time period.
Abstract:
A mechanism for managing data operations in an integrated database system. The method includes receiving a request to perform a data operation and retrieving a data set from a primary data source (PDS) in view of the request. The method also includes storing the data set in a temporary data store (TDS). The method further includes performing the data operation on the stored data set in the TDS.
Abstract:
A mechanism for managing data in relational database management systems (RDBMS). The method includes receiving a structured query language (SQL) query to be executed on a relational database management system (RDBMS). The RDBMS includes a schema of tables divided into a plurality of partitions and the SQL query includes an operation of data to be executed on the RDBMS. The method also includes determining whether the SQL query is a valid SQLT query. The SQL query is a valid SQLT query when the SQL query includes a join operation applied to data from tables in a same partition of the plurality of partitions.
Abstract:
A mechanism for preventing overload of application is disclosed. A method includes receiving a query submitted by a user, the query includes user identification (ID) and an operation to be processed by an application. The method also includes filtering user records to identify subset of the user records associated with the user ID and determining quality of service (QoS) ranking from the subset of the user records associated with the user ID. The method also includes submitting the query to the application when the determined QoS ranking is assigned with high ranking. The method also includes filtering query records to identify subset of the query records associated with the query when the determined QoS ranking is assigned with low ranking. The method further includes determining quality string (QS) rating associated with the subset of query records and providing a decision on the query in view of the determined QS rating.
Abstract:
A processing device receives a request from a client for a specific service. Responsive to determining that the specific service is not running, the processing device converts a previously instantiated generic service into the specific service. To perform the conversion, the processing device assigns the generic service from a service pool for the specific service and renames the generic service based on a name of the specific service. The processing device additionally queries a directory service for specific service logic associated with the specific service. The processing device receives at least one of the specific service logic or a reference to the specific service logic from the directory service, and updates the generic service to include at least one of the specific service logic or the reference to the specific service logic.
Abstract:
A method and system for password mediation including receiving, within an operating system network stack of a client device, a hypertext transfer protocol (HTTP) request message issued by a client application executing on the client device, the HTTP request message indicating an operation to be performed for a user of the client application at a destination system; requesting, by the client device, security information for the user with respect to the destination system; modifying, by the client device, the received HTTP request message to include the security information; and sending, by the client device, the modified HTTP request message to the destination system.
Abstract:
A mechanism for managing data operations in an integrated database system. The method includes receiving a request to perform a data operation and retrieving a data set from a primary data source (PDS) in view of the request. The method also includes storing the data set in a temporary data store (TDS). The method further includes performing the data operation on the stored data set in the TDS.
Abstract:
Various examples are directed to systems and methods for managing a database to include data from an external data source. A database engine may receive a request to add a reference column to a database described by a database schema. The request may comprise a location parameter describing a location of the external data source comprising data for populating the reference column and a data identifying parameter describing data at the external data source for populating the reference column. The database engine may modify the database schema to include the reference column, send a query to the external data source to obtain at least one data item for populating the reference column, and populate the reference column with the at least one data item.
Abstract:
A mechanism for managing data in relational database management systems (RDBMS). The method includes receiving a structured query language (SQL) query to be executed on a relational database management system (RDBMS). The RDBMS includes a schema of tables divided into a plurality of partitions and the SQL query includes an operation of data to be executed on the RDBMS. The method also includes determining whether the SQL query is a valid SQLT query. The SQL query is a valid SQLT query when the SQL query includes a join operation applied to data from tables in a same partition of the plurality of partitions.