Patents
Literature
Hiro is an intelligent assistant for R&D personnel, combined with Patent DNA, to facilitate innovative research.
Hiro

175 results about "Relation (database)" patented technology

In relational database theory, a relation, as originally defined by E. F. Codd, is a set of tuples (d₁, d₂, ..., dₙ), where each element dⱼ is a member of Dⱼ, a data domain. Codd's original definition notwithstanding, and contrary to the usual definition in mathematics, there is no ordering to the elements of the tuples of a relation. Instead, each element is termed an attribute value. An attribute is a name paired with a domain (nowadays more commonly referred to as a type or data type). An attribute value is an attribute name paired with an element of that attribute's domain, and a tuple is a set of attribute values in which no two distinct elements have the same name. Thus, in some accounts, a tuple is described as a function, mapping names to values.

Ontology for database design and application development

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.
Owner:KYNDI

Set definition language for relational data

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.
Owner:DECODE GENETICS EHF

View navigation for creation, update and querying of data objects and textual annotations of relations between data objects

A method (and corresponding database system) for displaying in a view window information characterizing semantics of relations between objects. For each given relation between at least one subject object and at least one direct object, bi-directional modifier data is stored that represents first text characterizing semantics of a relationship of the at least one first object to the at least one second object, and represents second text characterizing semantics of a relationship of the at least one second object to the at least one first object. In response to predetermined user input associated with an object node displayed in the view window, a set of relations whose at least one subject object or at least one direct object is associated with the object node is identified. For at least one relation in the set of relations, the view window is updated to include a second node comprising a graphical representation of: the first text of the given relation in the event that the given object is a subject object in the given relation, or the second text of the given relation in the event that the given object is a direct object in the given relation. The second node may be a relation node associated with a given relation, or a mixed node associated with a relation-type pair. In response to predetermined input with a second node, the second node may be expanded to identify and display one or more object nodes (identifying direct object(s) of relations derived from expansion of a subject object associated therewith or identifying subject object(s) of relations derived from expansion of a direct object associated therewith). Preferably, this expansion routine is recursive in nature.The method (and database system) of the present invention may be used in a wide assortment of software applications, including enterprise applications (such as e-business applications, supply chain management applications, customer relationship management applications, decision support applications), the file system in operating systems, web browsers, e-mail applications and personal information management applications. Importantly, the method (and database system) provides an easy, user friendly and efficient mechanism to define, view and query the organization of the data elements (and the relationships therebetween) stored and accessed in such software applications, in a manner that conveys the real-world meaning of such relationships.
Owner:REVELINK

Database querying system and method

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.
Owner:GULA CONSULTING LLC

Method and system for migrating relational data to HBbase

The invention relates to a method and system for migrating relational data to the HBbase. The system comprises a relational data base, an HBase database, an SQL analysis module, a query conversion module and a data mode management module. As a mapping relation list is designed in the HBase database, a mapping relation of mode information in an original relation database and mode information in the HBase database is stored and mode information of a data form in the original relation database the is completely reserved, a mapping manner can be flexibly configured and more options are provided for users. Due to the efficient data organizing manner of the HBase, the access performance is greatly improved and the storage space is saved. Meanwhile, the data export function is provided and data interaction with other sub-systems is achieved. In addition, the data query function supports SQL query and converts an SQL query statement into a query statement of the HBase database, so that the users can transit to the HBbase database more smoothly.
Owner:INST OF INFORMATION ENG CAS

IEC 61850 universal database information model and design method for interface of IEC 61850 universal database information model

ActiveCN102799620AHigh degree of decouplingLift the structureData processing applicationsSpecial data processing applicationsTable (database)Data class
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.
Owner:CHINA ELECTRIC POWER RES INST +2

Statistical representation method supporting free combination and nesting of data in relational database

The invention discloses a statistical representation method supporting free combination and nesting of data in a relational database. The process comprises the steps of source table customization, statistical table customization and output customization. In the step of defining a statistical table by the adoption of the representation method, a database is selected, wherein the program display database contains all tables and fields, a user selects needed tables and fields, a program prompts the user to confirm the incidence relation among the tables, and a source table can be generated after the user clicks for determination; the user can organize various statistical tables according to his / her own demands with the source table. According to the representation method, by decomposing the statistical demands of the user, the method can be applied to realization of statistical table components and has unprecedentedly powerful functions, almost any statistical table can be realized by the adoption of the statistical representation method, the method can be applied to realization of a statistical table system, the statistical table customization process turns into a simple and clear process, and the method supports direct statistical analysis on arbitrary relevant data in the database by the user.
Owner:深圳市睿捷软件技术有限公司

Dynamic hierarchical integrated data accessing method capable of guaranteeing semantic correctness

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.
Owner:NAT UNIV OF DEFENSE TECH

DB2 database data synchronization method, device and system

The embodiment of the invention discloses a DB2 database data synchronization method, device and system. The method comprises the steps of obtaining a data synchronization request for a to-be-synchronized source library and a corresponding to-be-synchronized target library; if the request is a full-amount synchronization request, performing full-amount synchronization on the target library according to the data of the source library; if the request is an incremental synchronization request, acquiring log data generated by the source library in real time, analyzing the log data, and performingincremental synchronization on the target library according to an analysis result. According to the method, full-amount and incremental synchronization of the DB2 database can be realized, and the incremental synchronization mode of the method does not invade the source library and does not influence the service; besides, by expanding the cluster, sub-library and sub-table scene synchronization and sub-library and sub-table synchronization monitoring and coordination can be achieved, mapping relation configuration is conducted on the source library and the target library through middleware, data synchronization from the source library M to the target library N can be achieved, and more complex synchronization scenes are met; furthermore, the full-quantity and incremental synchronization process of the method supports breakpoint resume.
Owner:SUNING CLOUD COMPUTING CO LTD

Multi-source data and time sequence processing method and device for construction of industry knowledge graph

PendingCN110990585ASolve the difficult problem of processing time series dataGuaranteed accuracyDatabase management systemsRelational databasesTable (database)Theoretical computer science
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.
Owner:SHANGHAI GEOTECHN INVESTIGATIONS & DESIGN INST

Construction method and application of SQL statement generation model of natural Chinese language

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.
Owner:HUAZHONG UNIV OF SCI & TECH

Entity relationship-based feature construction method, device and equipment, and storage medium

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.
Owner:PING AN TECH (SHENZHEN) CO LTD

Knowledge graph construction method and device, computer system and readable storage medium

PendingCN111309827ARealize deep diggingAvoid the problem of not being able to accurately identify risks in different angle areasFinanceRelational databasesFeature miningRelation (database)
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.
Owner:PING AN MEDICAL & HEALTHCARE MANAGEMENT CO LTD

Large-scale knowledge graph storage scheme based on distributed key value library

The invention discloses a large-scale knowledge graph storage scheme based on a distributed key value library. A "KG over SQL" unified storage scheme or a "KG over KV" unified storage scheme is adopted; the unified storage scheme of "KG over SQL" comprises the following steps: reading knowledge graph data; extracting metadata in the mapping knowledge domain, and generating a corresponding SQL statement; extracting data in the knowledge graph, storing the data in a data structure, and generating a corresponding SQL statement; executing an SQL statement through an external SQL interface of the Cockroach DB database, and establishing a relation table; mapping the data in the relation table into a key value pair form by using an original data coding mapping scheme in a Cockroach DB database, and storing the data in a Cockroach DB bottom layer; By means of the "KG over KV" unified storage scheme, knowledge graph data are read, a knowledge graph is converted into a graph containing index nodes, index node graph data are stored in a data structure, and the data are mapped into a key value pair form through an optimized data coding mapping scheme and stored in a Cockroach DB bottom layer. According to the method, efficient data storage compatible with the RDF graph model and the attribute graph model can be realized.
Owner:TIANJIN UNIV

Determining correct answers to tax and accounting issues arising from business transactions and generating accounting entries to record those transactions using a computerized logic implementation

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.
Owner:ORPHYS HENRY A

Knowledge database construction method based on knowledge module and query method and system

The invention discloses a knowledge database construction method based on a knowledge module and a query method and system. The knowledge database construction method based on the knowledge module comprises the steps that 1, a plurality of subject knowledge trees are constructed, wherein the number of the subject knowledge trees is the same as that of subjects; 2, according to the known knowledge context cohesion relations shown in first-stage catalogues of different courses, address pointers of all nodes in the subject knowledge trees are used for correlating child nodes of sub-trees of all the subject knowledge tress conforming to the relations, a plurality of catalogue knowledge data chain tables are stored into a knowledge database, and finally the whole knowledge database is constructed. Knowledge can be obtained, organized and shown in a visual mode, and a foundation is laid for a follow-up user for improving query requirement accuracy and query efficiency.
Owner:SHANDONG UNIV OF SCI & TECH

Service for verifying consistency of replicated data

Any external application using data access functionality can use the attribute consistency service to update and synchronize attribute value for an entity. The application can access the relations of an entity, which are stored in an entity reference database. In case of inconsistent attribute values, a master attribute value is determined which is then written to the defined attributes of the applications.The consistency of data stored in various IT systems can be ensured prior to attempting to access it. Errors by calling a service or functionality that would require access to data that is not available or that is inconsistent are therefore avoided.
Owner:ABB RES LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products