Abstract: A system and method are disclosed to facilitate a database tuning as a service offered by a cloud platform as a service provider. A throttling detection engine, associated with a database service instance, may periodically determine if an automated database tuning process should be performed. When it is determined that the automated database tuning process should be performed, the throttling detection engine may transmit database performance metrics. A database tuner as a service, coupled to the throttling detection engine, may access aggregated database performance metrics of the database service instance and determine a set of tunable parameters associated with the database service instance. The database tuner as a service may then execute the automated database tuning process to recommend, using an intelligent algorithm, a new set of configurations for the set of tunable parameters to be applied to the database service instance.

Abstract: Recovery of an in-memory database is initiated. Thereafter, pages for recovery having a size equal to or below a pre-defined threshold are copied to a superblock. For each copied page, encryption information is added to a superblock control block for the superblock. The copied pages are encrypted within the superblock using the corresponding encryption information added to the super block control block. The superblock is then flushed from memory (e.g., main memory, etc.) of the database to physical persistence.

Abstract: A system includes a model repository comprising a plurality of models respectively being adapted to perform, when used by an analytical program, a computational task, in which a first database table is created in the database, the first database table having a predefined table structure that corresponds to the analytical program, a best-model of the plurality of models is stored in the first database table, and a request of a client device to perform the computational task and comprising input data is received. If the received request does not comprise a model-ID, the analytical program reads the model currently stored in the first table and uses the read model for performing the computational task on the input data.

Abstract: Various examples are directed to systems and methods for managing a warehouse. For example, a set of candidate routes through the warehouse may be generated based at least in part on graph data describing a plurality of nodes comprising a depot node, and a plurality of internode paths. Orders may be assigned to routes from the set of candidate routes to minimize a total duration for the routes. A set of tasks may be generated, where a first task of the set of tasks comprises a route and an order of the plurality of orders matched to the route. Tasks from the set of tasks may be assigned to picking agents to minimize a duration of the longest task from the set of tasks.

Abstract: A system, a method, and a computer program product for performing component integration. A first computing system generates a computing component for integration with a second computing system. The first computing system provides the computing component to the second computing system. The second computing system configures the computing component for operation by the first computing system with at least one computing component of the second computing system. The first computing system operates the configured computing component in the second computing system.

Abstract: Disclosed herein are system, method, and computer program product embodiments for the performing of a user authentication task in a virtual environment, for secure authentication of a user utilizing three dimensions. An embodiment operates by using a group of objects shown in a field of view to the user, wherein the user selects a subset of these group of objects by using a virtual environment device to constitute a password. Such a password, because it is chosen in three dimensions and wherein user movement in three-dimensions may be analyzed per an individual user profile according to machine learning logic, is efficient and secure.

Abstract: Systems and methods are provided for receiving a request for documentation related to functionality of an application, accessing a test automate generated from a recording of actions using the functionality of the application, and parsing the test automate to determine one or more steps in a process and, for each step in the process, a list of the actions for the step and corresponding data. The system and methods further provide for generating a file comprising the one or more steps and the list of actions and corresponding data for each step, determining a selected template for generating documentation for the functionality of the application and generating a populated template by populating one or more steps and corresponding list of actions in the selected template using the file comprising the one or more steps and the list of actions and corresponding data for each step.

Abstract: In an executing database instance including a plurality of database nodes, creation of a backup of the executing database instance includes creation of a current savepoint in one of the plurality of database nodes by storing first modified pages of a cache of the database node in a datastore of the database node, transmitting a confirmation after storing the first modified pages, repeatedly identifying second modified pages of the cache and storing the identified second modified pages in the datastore, receiving an instruction to enter a critical phase and stopping the repeated identifying and storing in response to the instruction, blocking updates to the database node and transmitting a second confirmation, and receiving a second instruction and, in response to receiving the second instruction, identifying third modified pages of the cache and storing the third modified pages of the cache in the datastore.

Abstract: Systems and methods are provided for determining, for each position of a pointer during a selection of a first graphical element, whether the position of the pointer corresponds to a boundary position in a GUI, and based on determining that the position of the pointer corresponds to the boundary position in the GUI, setting a position of the first graphical element to the boundary position even though the pointer continues to move beyond the boundary position during selection of the first graphical element. The systems and methods further provide for determining that the pointer position has moved beyond a predetermined threshold position for the boundary position and causing the first graphical element to move from the boundary position to the same position as the pointer and continue to move with the pointer during selection of the first graphical element.

Abstract: An updater platform may create a listening delegator process, associated with a listener file descriptor, within a deployment (without implementing an accept protocol). The platform may execute an original instance of an application process within the deployment and intercept a socket creation call from the original instance of the application process and replace it with the listener file descriptor. As a result, incoming connection requests are received by the listening delegator process and forwarded to the original instance of the application process. The platform may then determine that a configuration update is to be made to the application process and start an additional instance of the application process, with the updated configuration, within the deployment, such that incoming connection requests are received by the listening delegator process and forwarded to the additional instance of the application process. The platform may then switch off the original instance of the application process.

Abstract: A method is provided that may include generating, based on a rule, an abstract syntax tree structure including a plurality of nodes, each of the plurality of nodes being associated with a portion of the rule; traversing a subset of the plurality of nodes and executing logic associated with each node of the subset; generating a plurality of execution events during the execution of the logic associated with each node of the subset; receiving a request to replay at least a part of the plurality of execution events; generating a user interface view to enable presentation of the rule as a plurality of nodes; and stepping through the plurality of execution events by selecting an execution event from the plurality of execution events and updating a presentation of a respective node identified by the selected execution event. Related systems, methods, and articles of manufacture are also disclosed.

Abstract: A system includes reception of a database query, the query comprising a first query statement to insert rows of a source table into a target table, generation a second query statement and a third query statement based on the first query statement, the second query statement to insert rows of a first partition of the source table into the target table and the third query statement to insert rows of a second partition of the source table into the target table, generation of a first query operator executable to perform the second query statement, generation of a second query operator executable to perform the third query statement, transmission of the first executable query operator to a second database server node storing the first partition of the source table, and transmission of the second executable query operator to a third database server node storing the second partition of the source table.

Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives a first request for a visualization of data. In response to the first request, the program further retrieves the data from a storage of a computing system. The program also generates the visualization based on the data from the storage of the computing system. The program further stores the data in a storage of the device. The program also receives a second request for the visualization of the data. The program further determines that the device is unable to communicate with the computing system. In response to the determination, the program also retrieves the data from the storage of the device. The program further generates the visualization based on the data retrieved from the storage of the device.

Abstract: The embodiments in this disclosure include a system for receiving search requests for one or more items from a client device having access to a local database that stores primary catalogs containing items of contracted entities. If the items are not found in the primary catalogs, the system may be configured to execute an API for processing the search request by routing the search request to a proxy vendor computer in a cloud network. The cloud network may be configured to store vendor master records for one or more non-contracted entities. The proxy vendor computer can conduct a text search of secondary catalogs associated with non-contracted entities, and can transmit search results to the client device for the requested items. The items may correspond to one or more vendor master records associated with a non-contracted entity and may have a matching entry in one or more of the secondary catalogs.

Abstract: Systems and methods are disclosed for automatically detecting a connection status in an asynchronous processing request. An example method includes obtaining, at a processing client and responsive to a first request from a requesting client to perform a plurality of database operations in a single transaction, a connection identifier for a connection to a database on a database server, the connection to be used to execute the plurality database operations and storing the connection identifier in a row of a status table. In some implementations the existence of the row indicates the status of the connection is active. In some implementations the row includes a flag indicating the status. The method also includes providing the connection identifier to the requesting client, receiving a second request from the requesting client, the second request being for a status of the connection, determining the status using the status table.

Abstract: Disclosed embodiments include generating code from a database query and providing a framework to develop complex data structures and the functions that access those data structures outside of the generated code to access the complex data structures. These data structure functions can be precompiled in order to save compilation time at query runtime, and linked to the generated code in a way that the framework can still inline function calls and apply various optimizations on the linked code.

Abstract: A system includes determination of a first partition-wise operation on a first database table partition of a first table located at a first server node and a first database table partition of a second table located at a second server node, determination of a first cost to execute the first partition-wise operation on the first server node, and a second cost to execute the first partition-wise operation on the second server node, determination of a second partition-wise operation on a result of the first partition-wise operation, determination of a third cost to execute the second partition-wise operation on the first server node based on the first cost and the second cost, and a fourth cost to execute the second partition-wise operation on the second server node based on the first cost and the second cost, determination of one of the first server node and the second server node to execute the second partition-wise operation based on the third cost and the fourth cost, and determination of one of the first ser

Abstract: Various embodiments of systems and methods for internet of things (IoT) data analysis are described herein. In an aspect, the method includes receiving user's input for data fields which are configured for retrieving data from a data repository. The data repository stores data related to one or more IoT devices. A structured query language (SQL) statement corresponding to the received user's input is generated. Based upon the generated SQL statement, data from the data repository is retrieved. A visual representation for displaying the retrieved data is identified. The retrieved data is rendered based upon the identified visual representation.

Abstract: Addressed herein is the problem of expressing and evaluating computations on hierarchies represented as database tables. Engine support for such computations is very limited today, and so they are usually outsourced into stored procedures or client code. Structural grouping is applied to relational algebra to provide concise syntax to express a class of useful computations. Algorithms are also provided to evaluate such structural groupings efficiently by exploiting available indexing schemes. Related apparatus, systems, techniques and articles are also described.

Abstract: In one aspect, there is provided a method. The method may include adding a tuple phrase to a phrase index as part of a lazy creation of the phrase index. The adding may include adding the tuple phrase to a dictionary mapped to the phrase index, adding to the phrase index a document identifier and a positional information for the tuple phrase, and adapting a first threshold and a second threshold value, the first threshold representing a threshold lower estimate of query processing burden associated with a least burdensome tuple phrase in the dictionary and the second threshold representing a top estimate of query processing burden associated with a most burdensome tuple phrase in the dictionary. The method may further include sending a query response including a generated query result corresponding to the tuple phrase.