1456 results about "Relvar" patented technology

A system and method lets a user create or import ontologies and create databases and related application software. These databases can be specially tuned to suit a particular need, and each comes with the same error-detection rules to keep the data clean. Such databases may be searched based on meaning, rather than on words-that-begin-with-something. And multiple databases, if generated from the same basic ontology can communicate with each other without any additional effort. Ontology management and generation tools enable enterprises to create databases that use ontologies to improve data integration, maintainability, quality, and flexibility. Only the relevant aspects of the ontology are targeted, extracting out a sub-model that has the power of the full ontology restricted to objects of interest for the application domain. To increase performance and add desired database characteristics, this sub-model is translated into a database system. Java-based object-oriented and relational application program interfaces (APIs) are then generated from this translation, providing application developers with an API that exactly reflects the entity types and relations (classes and methods) that are represented by the database. This generation approach essentially turns the ontology into a set of integrated and efficient databases.

The present invention provides a system and method for dynamic object-driven database manipulation and mapping system which relates in general to correlating or translating one type of database to another type of database or to an object programming application. Correlating or translating involves relational to object translation, object to object translation, relational to relational, or a combination of the above. Thus, the present invention is directed to dynamic mapping of databases to selected objects. Also provided are systems and methods that optionally include caching components, security features, data migration facilities, and components for reading, writing, interpreting and manipulating XML and XMI data files.

The invention relates to a system and method for creating, editing, using one or more multi-relational ontologies and applying knowledge contained in one or more ontologies to one or more applications. The system may extract concepts, relationships, assertions and other information from a domain specific corpus of documents. The system may also create rule-based assertions that are then curated and published as one or more ontologies that can be used in various ways.

According to the present invention there is provided a method for establishing a data warehouse capable from a plurality of source databases including at least one relational database and at least one object-oriented database, comprising the steps of: integrating the schema of said plurality of source databases into a global schema, including resolving semantic conflicts between said source databases, and establishing a frame metadata model for describing data stored in said local databases, said frame metadata model including means for describing any constraints developed during schema integration and further including means for describing relationships between data stored in local object-oriented databases.

A method and system for persisting an object in a relational database schema by creating a new relational table at application program run-time for each class of objects to be persisted. The method may generate a schema map object for each class of objects to be persisted. The schema map object may be generated in response to the first transaction in which an object of a certain class is to be persisted and remains in memory for persisting, querying, restoring or deleting objects of that class. The schema map object determines the fields of each class of objects to be persisted, defines one or more columns in the table in accordance with the data types of the fields, and controls the passing of data between the table and the object fields.

The present invention relates to the usage pattern, commonly found in many software applications, of defining sets of objects based on object attributes. A specifically designed set definition language for defining sets, called SDL, is described and a software system that implements this language efficiently on top of a standard relational database management system (RDBMS) is presented. The unique features of the SDL language are the implicit constraints that are enforced on the relational data that belong to the objects. Unique to the SDL system is also the logical metadata of dimensions that enables the SDL system to enforce these constraints across relations. The SDL system utilizes several optimization techniques to enable efficient implementation on top of RDBMS. It is also shown how the SDL language and the SQL language can be merged with bidirectional inlining using syntactic gates. Query composition tools are also described that facilitate the creation of SDL expressions.

The invention discloses a distributed database synchronization system which comprises database nodes and a management node, wherein the database nodes outwards provide distributed database access, updating and inquiry services on the basis of Web services; all the database nodes have no master-slave difference, and are independently in charge of providing distributed database services; all the database nodes have no direct relationships and periodically obtain a synchronization configuration table and a network member configuration table from the management node, and establish a synchronization relationship with other database nodes; and a Web-service-based synchronization module is adopted in all the database nodes, the traditional database is encapsulated by using the synchronization module for providing one group of API (Application Program Interface) function for the outside. Data transmission is carried out by using the Web-service-based SOAP (Simple Object Access Protocol). The distributed database synchronization system can adapt to various complex heterogeneous networks, and can be used for solving the problems of incompatibility and incapability of mutual synchronization of data among various traditional databases.

A database querying system to facilitate the retrieval of desired data from a database including information categories, the system including a plurality of object data items categorized in one information category and a plurality of object data items categorized in another information category. A processor assembly responsive to a user query is also provided and is structured to identify the desired data from the user query. A relationship category defined by relationships between the object data items of the information categories is further provided, the user query including a relationship identifier corresponding the relationship category so as to simplify syntax of the user query. Interpretation of relational-database query and data manipulation languages against non-relational schemas, including conceptual, semantic, object-relational, or object-oriented database schemas, by regarding the schemas as representing virtual relational databases with every class replaced by a virtual table comprised of all the attributes reachable from the class by a chain of relations. The interpretation allows concise and simple querying of non-relational and relational databases in a languages originally intended only for relational databases. The system further provides for wrapping of a relational database into a semantic conceptual schema so as to allow formulation of queries in SQL against the wrapping schema, reducing the size of SQL queries.

The present invention provides a system and method for dynamic object-driven database manipulation and mapping system which relates in general to correlating or translating one type of database to another type of database or to an object programming application. Correlating or translating involves relational to object translation, object to object translation, relational to relational, or a combination of the above. Thus, the present invention is directed to dynamic mapping of databases to selected objects. Also provided are systems and methods that optionally include caching components, security features, data migration facilities, and components for reading, writing, interpreting and manipulating XML and XMI data files.

The invention belongs to the technical field of industrial big data application, and particularly relates to an industrial big data multidimensional analysis and visualization method based on a JSON document structure. The method comprises the following steps: by taking JSON as a basic carrier of data, constructing an industrial data mart in parallel by utilizing Spark and ElasticSearch through configuring a relational database and a file system data source and defining data conversion and data cleaning operations; configuring an overall process of data analysis in a graphical mode to construct an analysis data set of a multi-dimensional structure, and repeated association operation on massive data being avoided; and for a specific data analysis scene, customizing each dimension calculation index of the data analysis report in a visual dragging mode based on a pre-constructed multi-dimensional analysis data set, and generating an interactive graphic analysis report. According to the method, the JSON document format is used as a carrier of basic data, and the advantages of the JSON document format in storage and analysis are utilized, so that multi-dimensional analysis structure modeling and user-defined interactive analysis are more convenient and efficient.

An authoring tool (or process) to facilitate the performance of an annotation function and an indexing function. The annotation function may generate informational annotations and word annotations to a database design schema (e.g., an entity-relationship diagram or “ERD”). The indexing function may analyze the words of the annotations by classifying the words in accordance with a concordance and dictionary, and assign a normalized weight to each word of each of the annotations based on the classification(s) of the word(s) of the annotation. A query translator (or query translation process) to (i) accept a natural language query from a user interface process, (ii) convert the natural language query to a formal command query (e.g., an SQL query) using the indexed annotations generated by the authoring tool and the database design schema, and (iii) present the formal command query to a database management process for interrogating the relational database.

Predicate abduction involves identifying, from a database statement, predicates on attributes of dimensional data, and applying those predicates to corresponding measure data so that only measure values are fetched and returned for dimension values that satisfy the predicate. In contrast to processing joins of relational data, the subset of the measure data is determined without needing to join a fact table with a dimension table and, therefore, without processing every fact record to determine which measure values are associated with records that satisfy the condition. Buffer reuse involves storing in buffers the “domains” of queries being executed on multidimensional data. In response to detecting that execution of a database statement requires multiple iterations of extracting the same multidimensional data, the data is extracted during the first iteration and stored in a buffer so that, for each subsequent iteration, the data in the buffer is accessed rather than again extracting the data.

The invention discloses a resource description framework querying method and system based on a relational database, wherein the method includes the following steps: establishing a result variable table according to the SPARQL query statement input by a user, separating the SPARQL query statement to obtain each basic graphic pattern, and establishing the constant table, the variable table and the blank note table corresponding to the basic graphic patterns and a pattern string identifying the logical relation between the basic graphic patterns; generating a pattern tree based on the pattern string; generating the SQL subquery fragment for each basic graphic pattern according to the corresponding element structural table of each basic graphic pattern, and representing the relationship between the basic graphic patterns based on the pattern tree to connect the SQL subquery fragments into a whole SQL query statement section; utilizing the SQL query statement section obtained through conversion to query the RDF data in the relational database; and semantics wrapping the query result according to the limitation of the SPARQL result set and the user setting and returning the query result to the user.

In accordance with embodiments, there are provided mechanisms and methods for saving multiple rows together through an object relational mapping layer to a database. These mechanisms and methods for saving multiple rows together can enable embodiments to detect faults in the save operation(s) and recover. The ability of embodiments to detect faults in the save operation(s) and recover can enable embodiments to provide a robust forgiving published API that saves a set of rows together whenever possible.

Described herein are systems and methods for supporting SQL-based rich queries in a blockchain fabric. In accordance with an embodiment, the systems and methods provided herein provide the ability to execute SQL queries to allow for the creation of complex smart contracts much easier and more maintainable manner. Also, performance is improved both by pushing the data filtering back to the storage engine (rather than happening at the smart contract level), and by being able to rely on relational engines which support concurrent read and write data access. As well, the state of the world database can also provide for concurrent read/write access.

The invention provides an OLAP multi-dimensional analysis and data mining system. The system comprises a data model, a distributed OLAP engine, an OLAP analysis engine, a multi-dimensional report analysis interface, a data mining interface and a data visualization tool; the data model is dragged by a user through a visual interface to finish data modeling, and has unified model configuration; thesystem automatically performs model adaptation and enables the data model to be called by cooperation with internal other engines or tools; the distributed OLAP engine provides a multi-dimensional data model preprocessing capability for the OLAP system; the OLAP analysis engine supports a multi-dimensional query analysis engine of a big data platform and a relational database, and analyzes an MDXstatement to obtain a standard SQL; the multi-dimensional report analysis interface and the data mining interface have multi-dimensional data analysis and data mining functions and provide a report analysis method and a data mining algorithm model; and the data visualization tool provides a visual service for report analysis and data mining in the multi-dimensional report analysis interface and the data mining interface, and provides visual result social sharing and chart management functions.

This invention discloses a method and a device for optimizing query SQL request, in which, the method includes: standardizing the field names and bynames in the SQL sentences to eliminate the redundant associated relations in them, converting said SQL sentences into a grammar tree to be optimized for logic relation to be converted to standard SQL sentences.

The invention provides a method and a device for digging a relation keyword of a relevant entity word and an application thereof. The method for digging the relation keyword comprises the following steps of: digging a related entity word e2 of an entity word e1; storing the entity word e1 and the related entity word e2 in a database; in resource used for digging e2 and/ or a research result corresponding to a research query formed by e1 and e2, calculating all words within the set range of e1 and e2, wherein the calculation process comprises a step of calculating the occurrence time of each word within the distance range; grading each word by a calculation result; taking the words of which the grading value ranks within the top M as the relation keywords of e1 and e2; and recording the relation keywords in the database. By the relation keywords determined by the method disclosed by the invention, the relation between any two entity words can be described according to the practical situation of a text so as to improve the accuracy on describing the relationship between the entity words.