Abstract: Example embodiments of a system and method for asynchronous data item loading for a dropdown list of a user interface are described. In an example embodiment, a user input directed to a dropdown list control to cause presentation of at least one of the data items of the dropdown list is received. In response to the user input, a determination is made as to whether the data items are available for presentation. If not, the user input is queued in an event queue, the data items are requested from another computing system via a communication network, and a busy indicator is presented on the user interface in conjunction with the dropdown list control to indicate that the data items are not available for presentation. In response to receiving the data items, the busy indicator is removed, and the user input queued in the event queue is processed.

Abstract: Methods, systems, and computer-readable storage media for evaluating a validity of an extended status and action management (SAM) schema. In some implementations, actions include receiving the extended SAM schema, the extended SAM schema being an extension of a core SAM schema, providing one or more goals, goals representing an intention of the core SAM schema, receiving one or more action chains, action chains representing one or more actions of the extended SAM schema that are to be automatically executed, the one or more actions being associated with triggerability flags, a triggerability flag indicating whether a respective action is only triggerable using a respective action chain, and processing the one or more goals, the one or more action chains and the triggerability flags using a computer-executable model checking tool for evaluating the validity of the extended SAM schema.

Abstract: A query identifier is generated for a query received in a database. The received query identifier is matched with query identifiers stored in a dynamic table. It is determined whether an execution plan is available based on matching the query identifiers in the dynamic table. For the matching query identifier, it is determined whether dynamic search criteria are met. Upon determining that the dynamic search criteria are met, a memory address corresponding to the query identifier is retrieved from the dynamic table. Based on the available diagonal search execution plan, the dynamic diagonal search is performed in the table from the memory address to retrieve search result. The dynamic diagonal search involves incrementing a data pointer to access the memory address in a diagonal manner in the table.

Abstract: The present disclosure describes methods, systems, and computer program products for data-centric integration modeling in an application integration system. One computer-implemented method includes receiving, by operation of an integration system, a logic integration program comprising a plurality of logic integration patterns that are defined in a data-centric logic integration language; generating a logical model graph based on the logic integration program, the logical model graph being runtime-independent; converting the logical model graph into a physical model graph, the physical model graph being runtime-specific; and generating logic integration runtime codes executable by the integration system based on the physical model graph.

Abstract: Techniques and solutions are described for facilitating the conversion of tables, having primary data and an append specifying a format of append data, from a first format to a second format. A runtime object and a data dictionary entry can be created for a primary table in the second format, and at least a portion of primary data transferred to the primary table in the second format. A database layer object corresponding to the first table in the first format can be associated with a temporary runtime object and a temporary data dictionary entry so that append data can be transferred to an append table in the second format. Operations directed to the primary table in the second format can be modified to also be directed to the append table, such as using a JOIN view.

Abstract: Various embodiments of systems and methods to determine data retention rules for data entities are described herein. In one aspect, the data entities are obtained. Usage statuses of the data entities are determined. One or more purpose of data corresponding to the one or more data entities is received. Further, legal entities corresponding to the one or more data entities are identified based on line organization attributes and the usage statuses. Process object attributes associated with the one or more data entities are identified based on the legal entities. Retention rules for the one or more data entities are determined based on the one or more purpose of data, the legal entities and the process object attributes.

Abstract: The present disclosure relates to a computer system comprising a database including, a reallocation scheduling module, the reallocation scheduling module configured to obtain an objective function including one or more integer-valued decision variables and automatically determine a proposed reallocation scheme for each of one or more items between a plurality of locations based on the objective function, wherein determining the reallocation scheme includes finding values of one or more decision variables that optimize the objective function while obeying the one or more constraints, wherein determining a proposed reallocation scheme includes solving an integer quadratic programming problem.

Abstract: Disclosed herein are system, method, and computer program product embodiments for utilizing a transaction control block for providing reader-writer access to transaction commit status. An embodiment operates by receiving a row read request and determining that the row is versioned. The system determines that a first timestamp information for a row destroy transaction associated with the row exists in a transaction control block and retrieves the first timestamp information from the transaction control block.

Abstract: A system includes reception of a request to modify the data of a database, the request including first data, execution of processing to fulfill the request, determination, during execution of the processing, that a validation exit is associated with a current state of the processing, storage of the first data in a local temporary table in response to the determination, passage of the local temporary table to the validation exit, and execution of the validation exit to validate the first data based on the local temporary table and on the data of the database.

Abstract: Recovery of a database system by taking the database system offline is initiated. Thereafter, recovery operations specified by a redo log of the database system are replayed. During such replay, updates to pages implicated by the recovery operations are blocked. In parallel to such blocking, modified pages are adaptively flushed to physical disk storage using a factor that is based on a number of pages written to the physical disk storage and a number of write I/O operations as part of the flushing of the modified pages. Subsequently, the database system is brought online after all of the recovery operations are replayed.

Abstract: A system includes reception of a first request for a lock on a lock object, storage of a first entry associated with the first request and the lock object in a queue, determination of a first queue position associated with the first entry based on a first priority level of the first request and on a priority level of each of a plurality of entries in the queue associated with the lock object, determination of whether a predetermined expiration time associated with the first request has expired, and, if it is determined that the predetermined expiration time has expired, deletion of the first entry from the queue.

Abstract: To probe linear and non-linear relationships of entities in a network, in a graphical user interface, in a login session, a selection of an action on a first node is received. In response to the selection of the action on the first node, the action is automatically performed. A navigation breadcrumb is dynamically generated in the graphical user interface with a first navigation identifier corresponding to the action performed on the first node and a corresponding first state information of the nodes. In database tables in a database, the first state information of the nodes corresponding to the first navigation identifier is stored. Selection of the first navigation identifier on the navigation breadcrumb is received, and in response to the selection, the first state information of the nodes is retrieved from the database tables and displayed in a canvas in an area of focus.

Abstract: Technologies are provided for implementing logical data object (LDO) web services. A web service definition can be received that comprises a LDO view and one or more service operation definitions. A LDO web service can be generated based on the web service definition and registered with a service endpoint. Web service requests received at the registered endpoint can be processed using the LDO web service. The runtime engine can perform service operations defined in the web service definition using one or more instances of the LDO associated with the LDO service. The LDO view can include one or more custom LDO extension nodes and/or extension data elements. A design-time application can be provided that comprises a user interface for creating a LDO web service definition. The created web service definition can be transmitted to an application server where a LDO web service can be generated based on the definition.

Abstract: Systems and methods are provided herein for multi-pass duplicate identification using sorted neighborhoods. Data comprising a plurality of data records is received. Neighborhood records are generated by merging the plurality of data records with reference records stored in a remote data store. A resource identification field is assigned to each reference record. A pair distance, for each pair of neighborhood records having different resource identification fields, is determined by calculating a standard deviation of distances between each attribute of the pair scaled by a filled pairs quote value. Possible duplicate records are identified by evaluating each pair distance against a threshold, each possible duplicate having grouped attributes. Final duplicate records are identified by matching each group to a key.

Abstract: A system comprises generation of a parse tree comprising a plurality of query parse nodes, each of the plurality of query parse nodes corresponding to a respective one of a plurality of portions of a script definition, generation of a first intermediate representation tree comprising an intermediate representation node corresponding to a respective one of each of the plurality of query parse nodes, wherein an intermediate representation node represents a logical operation corresponding to the portion of the script definition of the query parse node which corresponds to the intermediate representation node, definition of links between each of the plurality of query parse nodes and its corresponding the intermediate representation node, determination of a second intermediate representation tree, the second intermediate representation tree resulting from an optimizer transformation executed on the first intermediate representation tree, generation of an intermediate representation node corresponding to a transfo

Abstract: System, method, and computer program product embodiments describe utilizing a page having a flexible layout for accessing content across multiple applications. In an embodiment, a display device displays a first content on a page associated with a set of layouts. The page uses a one-panel layout having one panel that that encompasses the first content. Responsive to detecting a selection of a portion of the first content within the one-panel layout, the display device receives a second content for displaying within the page. Then, the display devices renders the page using a two-panel layout having a first panel that is vertically adjacent to a second panel to display the first and second content alongside each other. The first and second panels respectively display the first and second content.

Abstract: A method of extending the functionality of an enterprise software suite is disclosed. A request is received from a client system to modify a programming object on a productive system deployed in the cloud environment. A logical unit of programming objects is identified on the productive system, the logical unit including the programming object. Copies of each of the programming objects in the logical unit of programming objects are created in a sandbox of a combined development and test system deployed in the cloud environment, the copies including a copy of the programming object. The copy of the programming object is modified in the sandbox. A result of the modifying of the copy of the programming object in the sandbox is communicated for presentation in a client system without modifying the programming object on the productive system.

Abstract: A computer-implemented method implemented by a database management system (DBMS). The DBMS includes a database with a data table with a plurality of data columns and a condition table with condition columns and a score column. The DBMS receives a request and extracts a data vector from each data column and a condition vector from each condition column. For each of the data vectors, the DBMS computes a match vector selectively including identifiers of the rows in the condition table whose condition value is identical to an attribute value of said data vector, then, the DBMS selectively returns the rows of the condition table whose respective identifier is contained in each of the computed match vectors as the result to the client application for enabling the client application to identify assignments of the data records and the score values of matching condition table rows.

Abstract: A computer-implemented method of user interface control includes receiving request to display data in a user interface and displaying data in a visible part of the user interface. Data requests in a hidden part of the user interface can be assigned to bins. Data requests assigned to a first bin can be transmitted to the backend computing system and a responsive output of the backend system can be displayed in the user interface. If the display request is still active and all of the data requests assigned to the first bin have been transmitted, data requests assigned to a second bin can be transmitted to the backend computing system and a responsive output of the backend computing system can be displayed in the user interface. Related apparatus, systems, techniques and articles are also described.

Abstract: Techniques are described for generically providing a solution to developers in supporting web service input calls to systems with dynamic definitions. An example method includes obtaining, from a repository, a list of code value and code description pairs associated with the particular data type. The obtained list is searched for a particular code description matching the string value of the identified input. In response to identifying a particular code description exactly matching the string value of the identified input, the string value of the identified input is associated to the particular code value corresponding to the particular code description. The particular backend application is then executed based on the particular code value associated with the string value of the identified input.