Abstract: A method may include receiving a query including at least one unnest operation to unnest a plurality of elements from one or more JavaScript Object Notation (JSON) arrays. The at least one unnest operation may unnest the plurality of elements by generating a table in which each row of the table is populated by one of the plurality of elements. An execution plan may be generated to include a pre-filter operation to filter, prior to the at least one unnest operation, the plurality of elements included in the one or more JSON arrays. For example, the pre-filter operation may be performed by iterating through the elements from the one or more JSON arrays to identify one or more elements satisfying a predicate included in a where clause of the query. The query may be executed in accordance with the execution plan. Related systems and computer program products are also provided.

Abstract: Disclosed techniques and solutions can provide improved snapshot replication. Typically, an initial replica obtained using snapshot replication is periodically updated. However, the update process can unnecessarily consume computing resources if data in a source data object has not changed with respect to data in a replica data object. Disclosed techniques check to determine whether a snapshot replica is out of date before obtaining a new snapshot. The checks can be performed on manual request or on the occurrence of triggers, such as receiving a query that accesses the replica data object or according to a schedule. Information for current and prior versions of the remote data object can be compared to determine whether a replica is out of date, such as digest values of contents of the remote data object or timestamps associated with the remote data object.

Abstract: An open source library rating is generated for an open source library based on dependencies of the library, vulnerabilities of the library, an age of the library, a popularity of the library, a history of the library, or any suitable combination thereof. The rating of a specific version of a library may be generated based on a base score for all versions of the library and a version score for the specific version of the library. An authorization system receives a request from a developer to add a library to a software application. In response, the authorization system accesses a rating for the library. Based on the rating, the authorization system approves the request, denies the request, or recommends an alternative library.

Abstract: Systems and methods are provided for generating a combined list of attributes for at least one selected object by combining known attributes and a list of attributes for custom tables, determining a scrambling method for each attribute in the combined list of attributes for the at least one selected object, and scrambling each attribute of the combined list of attributes for the at least one selected object, according to the scrambling method for each attribute. The systems and methods further provided for generating a compliance report indicating what was changed in a system by the scrambling of each attribute and what scrambling methods were applied and allowing release of production data comprising the scrambled attributes for the at least one selected object, to a test system for use in testing functionality for an application or service.

Abstract: System, method, and various embodiments for a resource efficient schema object creation system are described herein. An embodiment operates by receiving a schema-change request at a first node of a cluster of computing nodes. The first node creates and populates a schema object in a shared storage, based on the schema-change request. An entry is generated in a reverse transaction log, the entry corresponding to the schema object stored in the shared storage device. A coordinator node is configured to read the entry from the reverse transaction log, update a schema, and generate an entry in a forward transaction log. The first node executes the entry in the forward transaction log, wherein the executing comprises updating a catalog of the first node to include the schema object stored in the shared storage, wherein upon a completion of the updating, the schema object is accessible by the first node.

Abstract: A method, a system, and computer program product for customer and vendor role data synchronization using a single logical unit of work are provided. A request to create a new data set, for a user is processed. The new data set includes general data compatible with a plurality of roles. A selection of a first role to customize the new data set is received. It is determined that the user is associated with a second role. An integration process including a validation of the new data set is triggered. In response to the validation of the new data set, the new data set is selectively stored in a database for execution of an application as second role data. The database stores the second role data in association with the second role.

Abstract: Provided are systems and methods for automatically detecting a change in screen content and generating a hint message in response. As another example, the system may auto-capture the detected change in the screen content instead of or in addition to the hint message. In one example, a method may include capturing user interface metadata of content being displayed by a client-side of the software application, activating a recorder that is configured to record events transmitted between the client-side and a server-side of the software application, receiving updated user interface metadata based on a user interaction on the client-side of the software application, determining that user interface content has changed based on a comparison of the captured user interface metadata to the updated user interface metadata, and displaying a hint message via the user interface of the client-side of the software application.

Abstract: Systems and methods include determination of a code package for publication to a repository, determination of an existing workflow, where the code package is to be published as a configuration of the existing workflow, determination of metadata of the existing workflow, determination of one or more applications associated with the configuration and, for each of the one or more applications, an edition associated with the configuration, and storage of the code package as the configuration in the repository in association with the metadata and identifiers of the one or more applications and associated editions.

Abstract: A system for migrating master data to a target system, comprising: at least one data processor; and at least one memory result in operations comprising: extracting the master data from a source database; validating the extracted master data at a database layer; mapping the validated master data to the target database specific datasets, and inserting the mapped master data into a target database, wherein the extraction, validation, mapping, and insertion are performed at the database layer.

Abstract: In an example embodiment, an efficient, automated method to generate password guesses is provided by leveraging online text sources along with natural language processing techniques. Specifically, semantic structures in passwords are exploited to aid system in generating better guesses. This not only helps cover instances where traditional password meters would indicate a password is safe when it is not, but also makes the solution robust against fast-evolving domains such as new slang in natural languages or new vocabulary arising from new products, product updates, and services.

Abstract: A method, a system, and computer program product for managing upgrades of cloud-based software applications are provided. A compatibility of planned changes to a cloud-based software application with a cloud-based system hosting the application is determined. An inclusion of a past mitigation in the planned changes to the cloud-based software application is verified. A test of the one or more planned changes to the cloud-based software application is executed. Modified planned changes to the cloud-based software application are generated based on a result of the test. An upgrade score of the modified planned changes to the cloud-based software application is determined and used for managing a deployment, to a productive system, of the modified planned changes to the cloud-based software application.

Abstract: In an example embodiment, asynchronous message processing is performed in a PLM system integration (PLMSI), at least for large message payloads. A processing decision is made as to whether to process a payload synchronously versus asynchronously. In the case of asynchronous processing, this processing can be started in a separate thread from the synchronous communication connection used to transmit the message and payload. The synchronous communication connection (which may be implemented in, for example, Hypertext Transfer Protocol (HTTP)) can be closed after the message was successfully received to prevent connection timeouts.

Abstract: Computer-readable media, methods, and systems are disclosed for validating data associated with schemas. A user defines the object model of at least one asset and a first schema is generated in accordance with the defined object model, and a unique fingerprint is generated. Data is collected from one or more devices in accordance with the object model. The collected data is serialized, and a second schema is generated. The second schema is ordered in accordance with the first schema and a unique fingerprint is generated. The fingerprint of the first schema is compared to the fingerprint of the second schema to provide an efficient review process for determining whether the schemas are equal, and the associated data may be validated. A fingerprint cache may be updated with fingerprints associated with a plurality of schemas, as well as version history of each schema, to provide an efficient review process.

Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives a set of master data for an entity from a master data system. The set of master data for the entity comprises a master data entity ID for uniquely identifying the entity. The program further receives a set of data associated with the entity from a set of applications configured to generate data associated with the entity and reference the entity using the master data entity ID when generating the of set data associated with the entity. The program also sends the set of master and the set of data associated with the entity to a search system for the search system to aggregate the set of master data for the entity and the set of data associated with the entity into a single record of data for the entity.

Abstract: In an example embodiment, a Language Server Protocol (LSP) is utilized to connect IDEs to test frameworks via a shared language server. More particularly, the shared language server is modified to permit feedback to be delivered regarding test results from the test framework to be delivered to the IDEs, either directly via a code action that supports direct feedback, or indirectly by causing the language server to write test results to the IDEs as code comments within the software code itself. The result is that a single test framework can be utilized by developers using completely different IDEs, without requiring a separate test framework to be developed for each IDE.

Abstract: Embodiments may facilitate event processing for an ABAP platform. A business object data store may include a RAP model, including a behavior definition, for a business object. A framework may automatically transform the behavior definition of the RAP model into a producer event via an event binding and a cloud event standardized format. Information about the producer event may then be passed to an ABAP application associated with a pre-configured destination at an enterprise business technology platform. In some embodiments, a standalone API enterprise hub data store may contain an event specification. An ABAP development tenant of a business technology platform may automatically parse the event specification and translate the parsed information into high-level programming language structures that reflect an event type at runtime. An event consumption model may then be generated based on the event type.

Abstract: Various examples are directed to systems and methods for executing a computer-automated process using trained machine learning (ML) models. A computing system may access first event data describing a first event. The computing system may execute a first ML model to determine an ML characterization of the first event using the first event data. The computing system may also apply a first rule set to the first event data to generate a rule characterization of the first event. The computing system may determine an output characterization of the first event based at least in part on the rule characterization of the first event and determine to deactivate the first rule set based at least in part on the ML characterization of the first event.

Abstract: Techniques and solutions are provided for determining the validity of encoded data. Data encoding techniques associated with a particular format can encode characters as a sequence of bytes, where the bytes can be of particular types. Particular sequences of byte types can be valid or invalid using a given encoding format. Lookup tables can be defined to examine bytes in a byte sequence to determine whether the sequence is valid or invalid. In a particular example, results of lookup operations can produce a result in the form of a sequence of bits, where values of the bits can be used to identify that a sequence is invalid, as well a particular type of encoding error. The techniques can be implemented in ways that are particularly efficient for a computing system, such as implementing lookup operations using SIMD (“Single Instruction, Multiple Data”) techniques.

Abstract: Root causes of network anomalies can be identified as follows. A subset of network entities that have experienced network anomalies during a time period are determined based on historical network data. A set of root cause candidates are selected among the plurality of network entities by iterating through the network topology, each root cause candidate being directly upstream of two or more network entities in the subset of network entities that have experienced network anomalies according to the network topology. Network entities that are root causes of the network anomalies are identified by removing root cause candidates that have a common upstream network entity that is also a root cause candidate from the set of root cause candidates leaving a set of remaining root cause candidates that are the root causes.

Abstract: The present disclosure provides techniques and solutions for automating the scheduling or execution of software tests defined for an increment to one or more software artifacts as the increment undergoes status changes during a development or release process. For example, tests can be executed or scheduled when an increment changes from a development landscape to a qualification landscape. A timeline scenario is defined that includes one or more timelines. The timelines include information useable to identify an increment and its associated tests, as well as configuration information for an entity where the tests will be executed. The increment is monitored, and tests specified in an appropriate timeline are executed or scheduled for execution when the timeline's associated status change is detected.