Computer implemented methods for storing ad hoc relations between previously unrelated database objects assigned to different database structures using an electronic computing device are presented, the methods including: causing the electronic computing device to define at least three database structures: structure A, structure B and structure C, where each of the at least three database structures each includes a number of objects, where there exists at least one relation between objects of structure A and objects of structure B, and where there exists at least one relation between objects of structure B and objects of structure C; filtering data of structure A; accessing structure B using a first selected relation between structure A and structure B; storing information about filtering of structure A and information on a first selected path between structure A and structure B; filtering results obtained from structure B.

The invention is a system for integrating data sets organized in one organization type with data sets organized in a second organization type so that data queries submitted to be processed in the manner of the first organization type can be translated into queries usable by the data set in the second data organization type and the results returned to satisfy the first query.

Techniques and solutions are described for receiving query results from one or more query services. A system implementing disclosed techniques can receive an identifier for the query used by a query service and an identifier for the query used by the issuing computer system. The query service and the computer system that issued the query can use different schemas for query results. A mapping can be established that maps elements of one schema to the other schema. This mapping, and a mapping of the query identifiers, can be used to convert query results to a format useable by the computing system that issued the query. By converting query results from multiple query services, which may have different formats, to a common format of the issuing computing system, the use of multiple query services is facilitated.

This invention is a system for integrating data sets organized in one organization type with data sets organized in a second organization type so that data queries submitted to be processed in the manner of the first organization type can be translated into queries usable by the data set in the second data organization type and the results returned to satisfy the first query.

A computing network data layer architecture or system includes an open data layer module comprising a translation layer. Translation flags are within the translation layer and each flag is associated with a database language of an underlying database that can be coupled architecture or system. The open data layer module is disposed at the lowermost layer of the architecture directly above the underlying backend database. The open data layer module allows for a system to replace or modify its backend databases without affecting the higher level visualization framework or user interface such that a user of the system is unaware which database is utilized or after one database has been replaced or swapped for another even though the databases may be disparate hand have different database language requirements.

A method and system for managing dynamic configuration changes in software applications is disclosed. The method includes converting an application object data from a first data format to a second data format readable by a framework. The method further includes creating a first table that includes mapping between an entity key, a plurality of queries, and a blueprint each associated with the application object. The blueprint is in the second data format. The method includes creating a second table that includes mapping between the entity key, at least one attribute associated with the application object, and at least one column in a database. The method further includes creating a mapped operation by mapping the application object data to a query, the blueprint, and a column from the at least column, based on the first table and the second table. The method includes executing the mapped operation on the database.

Computer implemented methods for storing ad hoc relations between previously unrelated database objects assigned to different database structures using an electronic computing device are presented, the methods including: causing the electronic computing device to define at least three database structures: structure A, structure B and structure C, where each of the at least three database structures each includes a number of objects, where there exists at least one relation between objects of structure A and objects of structure B, and where there exists at least one relation between objects of structure B and objects of structure C; filtering data of structure A; accessing structure B using a first selected relation between structure A and structure B; storing information about filtering of structure A and information on a first selected path between structure A and structure B; filtering results obtained from structure B.

Approaches presented herein enable optimization of a cache of compiled XML Path Language (XPath) expressions by removing variability from XPath expressions. More specifically, XPath expressions are identified that are the same but for one or more hardcoded values. These hardcoded values are identified and replaced in an identified XPath expression with an identifier to form a cache optimized XPath expression that lacks the hardcoded value variability of the identified XPath expressions. This cache optimized XPath expression is inserted into a definition of a cache optimized function. The optimized XPath expression receives values as arguments of the cache optimized Xpath function and passes the received values to the variable identifier in the cache optimized XPath expression. The identified XPath expressions can then be rewritten as calls to the cache optimized function. Therefore, only the cache optimized XPath expression, instead of several of the identified XPath expressions, is stored in the cache.

An XML data manipulation method and apparatus, belonging to the field of data processing. The method comprises: obtaining a structured query language (SQL) manipulation instruction for extensible markup language (XML) data, and checking the SQL manipulation instruction (101); if checking is successful, recognizing the SQL manipulation instruction, and recognizing conditions included in the SQL manipulation instruction (102); transforming a keyword in the SQL manipulation instruction into an XML statement, and transforming the conditions included in the SQL manipulation instruction into XML conditions (103); and manipulating the XML data according to the XML statement and the XML conditions, and returning a manipulation result (104). Thus, by transforming a keyword in an SQL manipulation instruction into an XML statement, transforming the conditions included in the SQL manipulation instruction into XML conditions, and manipulating XML data according to the XML statement and the XML conditions, manipulation of the data in an XML format by means of the SQL is realized, so that data stored in the XML format can be conveniently and rapidly manipulated, thereby improving the efficiency of data manipulation and facilitating use for a user.

The current disclosure generally relates to database management systems (DBMSs) and may be generally directed to methods and systems of using artificial intelligence (i.e. machine learning and/or anticipation functionalities, etc.) to learn a user's use of a DBMS, store this knowledge in a knowledgebase, and anticipate the user's future operating intentions. The current disclosure may also be generally directed to associative methods and systems of constructing DBMS commands. The current disclosure may also be generally directed to methods and systems of using a simplified DBMS command language (SDCL) for associative DBMS command construction. The current disclosure may also be generally directed to artificially intelligent methods and systems for associative DBMS command construction. The current disclosure may also be generally directed to methods and systems for associative DBMS command construction through voice input. Other methods, systems, features, elements and/or their embodiments are also disclosed.