169 results about "Relation (database)" 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 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.

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.

A method and system for managing data and organizational constraints is provided. Data is collected and stored as records in a database and multi-dimensional matrices known as parameters are associated with each of the sets of records. The parameters are then processed using various formulae and functions and the results of the processing are kept separate from the parameters themselves allowing for a flexible and fast response to any change in any of the parameters. The dimensions of each parameter are defined to include zero or more properties configured to access the multi-dimensional matrices and each parameter is defined in relation to each of the dimensions of the parameter. The set of dependencies among the parameters form part of a large constraint propagation network so that any change to a value of one of the parameters will be propagated throughout the network.

The invention provides an IEC 61850 universal database information model and a design method for an interface of the IEC 61850 universal database information model. The database model consists of an information model, an equipment model and an application model, wherein the information model obeys IEC 61850; the equipment model obeys IEC 61970; the information model comprises engineering instantiation configuration information of intelligent electronic equipment; and the engineering instantiation configuration information comprises a model type database table, a data type database table, a template type database table and a communication type database table. By a database design with three layers of frameworks, so that a standard model is multiplexed; a database can be automatically established by directly adopting a security coding device (SCD) model file, and an incidence relation among the information model, the equipment model and the application model can be automatically constructed; therefore, the engineering debugging period and the maintenance cost can be obviously reduced; the database information model based on the universal data type is constructed; a search mode quoted by a data object based on a character string format is designed; moreover, an open access interface is supplied; and the IEC 61850 universal database information model is suitable for different database platforms.

The invention discloses a dynamic hierarchical integrated data accessing method capable of guaranteeing semantic correctness and aims to solve the problem about how to provide data access with completely correct semantics under condition of integration of large-scale relation databases. The technical scheme includes that the dynamic hierarchical integrated data accessing method includes firstly, expanding to obtain a description logic subset DL-Lite, then layering the ontology TBox on the basis of the description logics, and establishing LAV (local as view) mapping and O-GAV (object-global as view) mapping between the relation database and the ontology; expanding and rewriting query request by means of SuperRef algorithm according to the T<Q> in layering of the TBox, and establishing a dynamic ABox A<Q> according to query results; and finally, refining the ABox A<Q>, and feeding back query response results. The dynamic hierarchical integrated data accessing method can provide data with the completely correct semantics for users and meet the requirement for correctness of the semantics in integrated data access. Further, calculating complexity can be reduced and expanding, query and rewriting efficiency can be improved.

The invention provides an event portrait-oriented text analysis method for a dialogue system. The event portrait-oriented text analysis method comprises the following steps of: 1, extracting an event relationship; 2, event extraction and structuring; 3, event similarity calculation and fusion; 4, event trigger word extraction and argument extraction. According to the method, the method for constructing the event graph is fully researched, the logic structure relation between events is described by adopting a knowledge graph structure, and meanwhile, in order to describe the events more clearly, the multi-dimensional attributes of the events are portrayed. The invention provides a system structure constructed by a affair graph. The structure comprises text corpus collection, event relation extraction template construction, event extraction and structuring, event similarity calculation and fusion, event trigger word extraction and argument extraction model construction, event relation pair construction and graph database storage. In addition, by utilizing the system structure, a sequential affair map, a causal affair map, a conditional affair map, a turning affair map and a concurrent affair map are constructed.

The invention discloses a multi-source data and time sequence processing method and device for construction of an industry knowledge graph. The method comprises the following steps: constructing an ontology layer of the knowledge graph, wherein the ontology layer comprises ontologies, ontology attributes and an ontology relation; extracting entities and entity attributes from multiple data sources, and conducting inconsistency check on the entities; conducting inconsistency check on the entity attributes of all the entities, wherein an entity relationship between the entities inherits the ontology relationship between the ontologies corresponding to the entities; and establishing indexes of a knowledge graph database and a time sequence database. The method has the advantages that throughthe uniqueness of a standard naming table and the relational database, entity conflict resolution accuracy is ensured to the greatest extent; by utilizing the advantage that the knowledge graph has the ontology layer, accurate classification of the entity attributes is realized by establishing similar labels, and fusion efficiency is effectively improved; and the problem that the knowledge graph is difficult to process time sequence data is solved by establishing indexes between knowledge graph database ontologies and a time sequence database form.

The invention discloses a construction method and application of an SQL statement generation model of a natural Chinese language. The construction method comprises the following steps: S1, constructing the SQL statement generation model; and S2, taking the Chinese natural language question collected in the training set and the related database mode as input, taking the corresponding correct SQL statement as output, and training the SQL statement generation model by minimizing the difference between the SQL statement generated by the SQL statement generation model and the correct SQL statement. According to the invention, by combining type information of different data columns, an alignment relation and an implicit anaphora relation between a Chinese natural language question and a database mode are captured, and an explicit definition relation of the database mode and a link relation between the natural language question and the database mode are expressed in a directed graph mode; and by comprehensively considering the characteristics between the unstructured data and the structured data, the semantic features and the relationship features are combined for joint coding, so that the accuracy of the SQL statement generation model is greatly improved.

The invention discloses an entity relationship-based feature construction method, and the method comprises the steps: obtaining a main table in a relational database and a plurality of auxiliary tables associated with the main table, enabling the main table to be provided with a main key column and a plurality of external key columns, enabling each entry in the main table to correspond to one entity, and enabling the auxiliary tables to be associated with the main table through external keys of the main table; constructing a directed inter-table relational graph by taking the main table and the auxiliary table as nodes and taking the incidence relation between every two of the main table and the auxiliary table as an edge; taking a node corresponding to the main table as a starting point,and traversing the inter-table relation graph to acquire inter-table relation data of each entity in the main table and the corresponding auxiliary table; and performing conversion calculation on theinter-table relationship data based on a preset conversion function to construct features corresponding to each entity in the main table. The invention further discloses a feature construction deviceand equipment based on the entity relationship and a storage medium. According to the method, the feature data is acquired based on the inter-table relational graph, and the features of the data can be represented from multiple dimensions on the whole, so that the modeling success rate is improved.

The invention relates to a database record data query system based on record logical representation. The database record data query system comprises a logical record definition and mapping component, a named relation and limited class defining component, a logical record query component, a record relation expansion sub-process and a record database. Several thoughts and methods of logical representation are used for data query of a common database without using the complicated implementation technology of the logical representation. A user of data can define logical records aiming at the data in the database according to self needs, and converts record logical representation record query conditions or commands into database query SQL (structured query language) statements by corresponding relations between logical records and database records; and the user can self-define record named relations and record limited classes by recording named relation definition rules, and uses record naming and the record limited classes in record query condition expressions or commands to enable the expressions of the record query conditions to be simpler.

The invention relates to a method for generating an addition, deletion, modification and check service interface based on database metadata. The method specifically comprises the following steps: step 1, preparing data in the earlier stage of the metadata; 2, determining a table Id corresponding to the main table according to the UUID and the data table name; and step 3, generating a database metadata addition, deletion, modification and check API interface. The technical scheme has the advantages that the method adapts to scenes with complex inter-table relations; the method adapts to data structure change scenes; the user permission can be controlled by configuring the attribute of the API, the safety of the interface is ensured, the workload of manually and repeatedly compiling the SQL statement is reduced, and the development efficiency is improved.

The invention relates to a metadata generation system based on multi-source data. The system comprises an original database, a metadata database, a mapping table database, a processor and a memory in which a computer program is stored, the original database is used for storing original data acquired from N data sources {P1, P2,... PN}, Pn is the nth data source, and the value range of n is 1-N; the meta-database is used for storing a metadata record, the metadata record comprises M metadata fields {D1, D2,... DM}, Dm is the name of the mth metadata field of metadata, and the value range of m is 1-M; and the mapping table database is used for storing a mapping table Rn corresponding to each data source Pn, and the Rn is used for storing a mapping relation between an original data field of the Pn and {D1, D2,... DM}. The multi-source data can be quickly and accurately converted into the metadata with the same data structure, and the information extraction efficiency and accuracy of the multi-source data are improved.

The invention discloses a knowledge graph construction method and device, a computer system and a readable storage medium, and the method comprises the steps: obtaining normal basic information from adatabase, extracting keywords of the normal basic information, and carrying out the duplicate removal of the keywords to obtain normal information elements; mining two normal information elements with a normal directed association relationship in each normal information element, and determining the two normal information elements as normal directed association features; mining two normal information elements with a normal undirected association relationship in each normal information element, and identifying the two normal information elements as normal undirected association features; and according to the normal directed association features and the normal undirected association features, constructing a knowledge graph used for expressing association relationships among the normal information elements. According to the method, the knowledge graph reflecting the sufficient unnecessary condition relation and the sufficient necessary condition relation between the normal information elements is constructed, deep mining of the data relation is achieved, and an institution can identify risks of different area angles through the knowledge graph.

Pertinent natural language authority documents are translated into corresponding statements in a system of predicate logic which statements are encoded into relations in a programming language. The authority documents are indexed into an electronic database to facilitate subsequent searching. User-entered query terms and/or query terms derived from pertinent prose are obtained, specifying at least one of a tax problem and an accounting problem; based on same, the electronic database is searched to locate applicable authority(ies). A comparison and inference engine executing on at least one hardware processor is activated to apply applicable relations in the programming language to a problem ascertainable from the query, to obtain a conclusion by applying derivation rules in the system of predicate logic. The conclusion is presented to a decision maker.

The invention relates to an interlocking logic relationship visual information processing method based on a knowledge graph. According to the method, an interlocking logic expression relation stored in a text file is read through a python language, a triad module is extracted, triads are variables, relations among the variables and variables, the triads are stored in a graphic database, and an interlocking logic relation graph database is formed and used for inquiring the interlocking variables and logic relations. Compared with the prior art, the mapping knowledge domain technology is used inthe railway signal industry for the first time and is applied to visual expression of the interlocking logic relationship in the interlocking system for the first time, and reference is provided forapplication of the interlocking system and other aspects of the railway signal industry.

The invention discloses a search method and system based on relation attributes. The method comprises the steps of providing a part catalogue by a complete system manufacturer; extracting and concluding a slave attribute and adjacency data relation chain, constructing a part number index database according to the slave attribute and adjacency data relation chain; when a user uses search by takingthe relation attribute as a daily expression habit, firstly retrieving and confirming a part number of a product through a system, and then accurately matching through the part number to obtain a result capable of meeting the replaceability or interchangeability requirements of the user; the user does not need to have hard professional knowledge and skills, so that the problem that in the prior art, due to the lack of relational attribute data, search can only recommend a possibility result taking confidence as a basis, the user has to face an embarrassing situation without selection under thecondition of lack of professional knowledge, and then a transaction cannot be achieved is solved. When a user directly inputs the part number, a result capable of meeting the replaceability or interchangeability requirement of the user can be directly and accurately matched through the part number.

The invention provides a method for managing spatio-temporal data. The method can be applied to a distributed system comprising a coordination node and a plurality of working nodes. The method comprises: expressing spatio-temporal data through a binary spatio-temporal diagram model G=(VL, VO, E) to directly reflect the incidence relation of the data in time and space, the VL being a set of position vertexes containing position information, the VO being a set of object vertexes not containing position information, and the E being a set of spatio-temporal edges connecting related vertexes. For spatio-temporal data expressed by adopting a binary spatio-temporal graph model, differentiated division and storage schemes are adopted for object vertexes, position vertexes and edges by utilizing the characteristics of spatio-temporal query: the object vertexes are subjected to hash division and stored into a distributed database; all position vertexes are sent to each working node and stored ina memory of the working node; and the space-time edges are divided by adopting two dimensions of object-time and space-time, and a column compression storage scheme is adopted for the divided space-time edge data.

The embodiment of the invention discloses a data attribute query method and device which are used for improving the convenience of data attribute query. The method comprises the steps that according to a database table and a service module, determining the incidence relation between attribute nodes in the service module, an attribute data table of a query object belonging to the service module is stored in the database table, and each attribute node represents one attribute of the query object; configuring entry information of each attribute node according to the association relationship among the attribute nodes; determining a query path of each attribute according to the entry information of each attribute node; if a query instruction for the target attribute of the query object is received, dynamically acquiring a query path corresponding to the target attribute of the query object, and the query instruction at least comprises an identification code of the query object, an identification code of a target attribute node and a query condition; and obtaining a target attribute value of the query object according to the query path corresponding to the target attribute of the query object.

The invention provides a data asset library access method and device based on a knowledge graph, and the method comprises the steps: carrying out the bidirectional construction of a data association model of a data asset library according to the relation between data entities of a first existing system and the data of an SGCIM unified information model and an existing business system; and accessing data in a data asset library by constructing a unified access ontology, wherein a knowledge base of the access ontology is perfected based on a knowledge graph. According to the data asset library access method and device based on the knowledge graph provided by the invention, the unified access ontology is constructed, so that unified management of data access can be realized without combiningall databases in management of the data asset library.