Abstract: Techniques and solutions are described for defining transformation specifications in a programming-language independent language and converting such specifications to one or more executable formats. The language can provide for defining rules and actions. Rules can refer to (e.g., be based at least in part on) data targets, such as attributes of a schema, whose identifiers are to be read or updated, or to other rules. Rules can be reused, and can recursively refer to one another, such that a large number of complex schema transformations can be accomplished using a series of first order logic statements. Actions can define what, and how, values will be changed when a predicate rule is satisfied. A transformation specification in the language can be parsed and selectively complied to one or more executable formats, including in programming languages such as the structured query language. Disclosed technologies can facilitate data transformations by non-technical users.

Abstract: A method, a system, and a computer program product for generating code from an XML schema description. A source extendible markup language (XML) schema description for an object is received. Based on the received XML schema description, a XML schema description model having a plurality of model elements is computed. Each model element in the plurality of model elements corresponds to an element in the XML schema description for the object. Based on the computed XML schema description model, a computing code for implementation in a plurality of target computing environments is generated.

Abstract: Disclosed herein are system, method, and device embodiments for optimizing uploads for an offline scenario by merging requests. An embodiment operates by performing a plurality of modification operations over application storage, generating a first queue entry within a normal operations queue corresponding to a first modification operation of the plurality of modification operations, generating a second queue entry corresponding to a second modification operation of the plurality of modification operations, generating an optimized operations queue including an optimized queue entry combining the first queue entry and the second queue entry, and synchronizing the application storage with a remote storage system based on the optimized operations queue.

Abstract: The present disclosure involves systems, software, and computer implemented methods for creating line item information from tabular data. One example method includes receiving event data values at a system. Column headers of columns in the event data values are identified. At least one column header is not included in standard line item terms used by the system. Column values of the columns in the event data values are identified. The identified column headers and the identified column values are processed using one or more models to map each column to a standard line item term used by the system. The processing includes using context determination and content recognition to identify standard line item terms. An event is created in the system, including the creation of line items from the identified column value. Each line item includes standard line item terms mapped to the columns.

Abstract: Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.

Abstract: A data storage and retrieval system for a computer memory configured according to a columnar document store adapted to contain one or more documents. The columnar document store includes a dictionary containing one or more identifiers, each of the identifiers being associated in the dictionary with a value ID. The document store further includes a data structure having fields and containing at least a first column. The first column is associated with a first identifier of the one or more identifiers, and the first identifier is associated with a first set of values in a first set of documents which contain the first identifier. The first column includes a value ID of the first identifier, one or more document IDs, each identifying a document in the first set of documents, and the first set of values.

Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives, from a requestor, a query for data comprising a condition on a column of a table. The table includes a plurality of records divided into a plurality of zones. The program further determines a set of zones in the plurality of zones that include records that satisfy the condition based on metadata associated with each zone in the plurality of zones comprising a data interval of an expression on data values in the column of the table. The program also determines a result set of records in the table that satisfy the condition based on records in the set of zones. The program further sends the result set of records to the requestor.

Abstract: Techniques and solutions are described for performing analytics on, or generating displays based on, data retrieved from a plurality of data sources, where the data sources can use one or both of different execution formats or different data schemas. For selected data, one or more analytic queries are generated. Analytic query results are provided in a standardized schema. A blend query is executed against data from the plurality of data sources, including the analytic query results in the standardized schema. Disclosed technologies can facilitate the use of data maintained in different formats or maintained in data sources that have different execution formats or protocols without requiring data replication among the data sources. The disclosed technologies can also provide a platform to which new data sources can easily be added, and can facilitate the use of multiple data sources by non-technical users.

Abstract: A method, a system, and a computer program product for performing testing of continuous log replays in a database system. A redo log generated for a data record in a database is received. The redo log is indicative of a change in persistency of the data record in the database. Based on the change in persistency recorded in the redo log, a redo handler in the plurality of handlers is selected for execution of a replay of the received redo log. Using the selected redo log, replay of the redo log is executed to generate a state of the data record prior to the change in persistency recoded in the redo log.

Abstract: A method for messaging in a hybrid multi-cloud computing environment may include receiving, from a multi-cloud controller, a message. The hybrid multi-cloud computing environment may include multiple cloud platforms hosted on private, on premise infrastructure as well as public, third-party infrastructure. The multi-cloud controller may send the message to control an operation of the cloud platform. In response to receiving the message from the multi-cloud controller, the message may be deposited in message queue. The cloud platform may send a request to retrieve data destined for the cloud platform. The message from the message queue may be sent to the cloud platform in response to the request. Related systems and articles of manufacture, including computer program products, are also provided.

Abstract: Embodiments of the present disclosure pertain to matching transactional data. In one embodiment, the present disclosure includes a computer implemented method comprising receiving transactional data for a first user and second data for the first user, selecting transactional data records for the first user from a data store of transactional data for a plurality of users, determining a plurality of similarities between fields of the transactional data and second data, determining a likelihood of a match between a transactional data field and a second data field based on the plurality of similarities using a machine learning model, and in accordance therewith, identifying one record in the transactional data records for the first user that generates said likelihood of the match above a first threshold, and replacing values second data fields with corresponding values in the one record.

Abstract: A method, a system, and a computer program product for analysis of query filtering mechanisms for table fragments. A query plan for execution of a query is generated. The query requires access to at least one table stored in a database system. The query includes one or more filter predicates. The table is partitioned into a plurality of fragments. A determination whether a fragment in the table is compressed and whether the fragment is associated with an index is made. A filter predicate is selected for processing the fragment. For the selected filter predicate, a filter evaluation of the selected filter predicate for the fragment is determined. The filter evaluation of the selected predicate is executed for the fragment.

Abstract: Methods and systems are disclosed for managing replication of metadata in a master-slave database environment. While metadata is managed on a master node using database tables with transaction guarantees, metadata copies on the slave node are managed using a lightweight key-value store. In exemplary embodiments, master metadata database tables are mapped to respective key-value structures at one or more slave nodes. The key-value structures have entries pointing to respective metadata objects, which include copies of metadata items stored in the master metadata database tables. The key-value structures can be hierarchically organized under a parent key-value structure. Metadata object versions can be organized as a linked list to facilitate multi-version concurrency control. Methods are disclosed for building the key-value store, for retrieving metadata from the store, for updating the store, for providing multi-version concurrency control, and for pruning obsolete metadata versions. Variants are disclosed.

Abstract: User-generated input is received that triggers deletion of a configuration object used by a computing system. In response, all active processes using the configuration object are identified so that subsequently initiated processes are prevented from using the configuration object. It is then determined when all active processes using the configuration object have completed. In response to such determination, the configuration object is deleted. Related apparatus, systems, techniques and articles are also described.

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing extension points to alter a data source in a data pipeline. By providing a before-state-change extension point, a data orchestration system may allow connected clients to aggregate delta from a changed state source, allowing the data orchestration system to include only changed or added data in a transferred data state. By providing an after-state-change extension point, a data orchestration system may harness additional customizations, for example, effectively and efficiently handle changes to the state made by a viewing client following the transmission of a delta of changes.

Abstract: Techniques and solutions are provided for a source quality check service configured to analyze source text and identify issues in the source text. The source quality check service may identify the issues by performing a selected subset of checks with a centralized source quality check engine, and may be called from within one or more of an Integrated Development Environment (IDE), a build process, and/or a translation process to perform the selected subset of checks. The source quality check service may be further configured to output a report of the identified one or more issues.

Abstract: A visual depiction of a hierarchy stored at a server computer can be presented at a client computer that interacts with the server computer as operations are performed on the hierarchy. Efficient execution of operations and determination of which nodes are visible within the hierarchy can be supported without sending the entire hierarchy back and forth between the client and the server. Drill state in the user interface can be preserved during operations. The server can support multiple clients interacting with the hierarchy at the same time.

Abstract: A computer implemented method for manipulating data comprises receiving log transaction information from a primary database system at a secondary database system and parsing the log transaction information to identify data objects that have been modified on the primary database system. The secondary database system determines whether the data objects are present in main memory on the secondary database system and whether the log transaction corresponds to a data manipulation language (DML) query or a data definition language (DDL) query. If the data objects are not in the main memory and the query is a DML query, they are copied from persistence data volumes to the main memory. The data objects in main memory are modified by replaying the log transactions on the data objects in the main memory. Then, the data objects in the persistence data volumes are modified. Related apparatus, systems, techniques and articles are also described.

Abstract: A system and method to receive, by a cloud infrastructure database service provider, a request for a new database service from an entity external to the cloud infrastructure, the request including an indication the requested database service is to be created using a master copy of a database service; create, in response to the request, a partially initialized database service and a recovery job to access a resource external to the cloud infrastructure; receive, by the partially initialized database service, a master copy of the requested database service from the external resource, the master copy including data content; and fully initialize the database service using at least some of the data content included in the master copy of the requested database service.

Abstract: A temporary page is allocated in which pages are loaded into main memory and having associated physical disk storage. The temporary page is also flagged as being temporary. Subsequently, a savepoint is initiated for the database so that, during the savepoint, the temporary page can be modified without acquiring a consistent change while preventing other non-temporary pages from being modified. Later, the savepoint can be finalized to enable the database to be rolled back to a point in time corresponding to the savepoint as part of a recovery process.