53 results about "Federated databases" patented technology

Method, system, and program product for configuring and using a federated database management system. The design of the metadata and queries includes the steps of first determining schema and metadata configurations of the data source servers. The next step is enumerating available resources, and enumerating security and confidentiality requirements. These are used for calculating an optimal federated database management system design based on the schema and metadata, the enumerated available resources, and the enumerated security and confidentiality requirements; and designing an optimal federated database management system.

A method and system for method for accelerating execution of a query on a federated database system is disclosed. The federated database system is associated with an external data source, which is used by the query. The query is performed based upon a query execution plan. The method and system include generating an optimizer query for the external data source utilized by the query. The optimizer query is based on the query and obtains data related to the external data source. The method and system further include providing the optimizer query to the external data source and collecting at least one resultant from the optimizer query for use in generating a future query execution plan.

Method, system, and program product for configuring and using a federated database and data structure management system with error prone data. The design of the metadata and queries includes the steps of first determining schema and metadata configurations of the data source servers. The next step is enumerating available resources, and enumerating security and confidentiality requirements. These are used for calculating an optimal federated database management system design based on the schema and metadata, the enumerated available resources, and the enumerated security and confidentiality requirements; and designing an optimal federated database management system with provision for exception detection and error handling.

The invention relates to an identity management platform, service server, unified entry system and method. The platform comprises an information receiving module, a validation module, an inquiry module, and an information sending module. The service server comprises an information receiving module, and inquiry module, an information sending module. The unified entry system comprises identity management platform, service server and identity federated database. The terminal adds identity tab code information in service request information when performing service access; service server inquires user identity information and complete terminal entry. The invention does not need fussy identity authentication course for service access after performing one-time identity authentication when accessing to IMS core net, thereby reducing fussy operation when user access and guaranteeing safety and reliability of user identity etc.

Embodiments of the invention provide techniques for performing federated queries of data records stored in multiple data sources. In one embodiment, an aliased key table may be configured to store relationships between key fields of multiple data sources. The aliased key table may specify a mapping function to translate a value of one key field to an equivalent value of a second key field. The mapping function may be used with a mapping table storing sets of key values of different data sources, with each set corresponding to a given entity. In another embodiment, the mapping function may call a web service configured to translate key values. In yet another embodiment, federated queries may be specified in terms of attributes, which may be matched to key values.

A method for propagating a query in a system made up of a number connectable database management system nodes, where each node is associated at least one database, includes: selecting a first node from the number of nodes; generating at least one connection operable to propagate a query from the first node to a first subset of the number of nodes; generating at least one connection operable to propagate a query from a second node in the first subset to a second subset of the plurality of nodes; where at least one node in the second subset is different from nodes in the first subset.

According to the method for establishing a log point an information technology infrastructure is provided. Transactions are performed by at least two database units of the information technology infrastructure. Then, “suspending prepare to commit”-requests are sent from said coordinating device to said database units. The log writes of all database units are suspended and recorded, whereas these log points form a global log point. Finally the log writes of all database units and all the suspended transactions are resumed.

A distributed replicated database system having a plurality of federated database systems and methods of updating and reading database records from the distributed replicated database system are disclosed. Each federated database system contains a complete copy of a database. Moreover, each federated database system comprises at least one server divided into at least one logical partition. A logical partition contains records of the database and all logical partitions in a federated database system cumulatively stores all records in the database. A data structure is maintained which indicates whether the records in a given logical partition are up-to-date. When an update or insert request is received, the data structure is modified to indicate that all logical partitions storing a copy of the record to be updated, or partitions into which the new record is to be inserted, are not up-to-date. When the record has been updated or inserted, the data structure is modified to indicate that the logical partition storing the record is up-to-date. When a read request is received, the record is read from an up-to-date logical partition storing the record.

Methods and systems are provided, for persistent querying in a federated database system. A federated database system has a plurality of connectable database management system nodes, each database node having at least one database. Persistent querying includes: receiving a query at a first database node and propagating the query from the first database node to other database nodes in the federated database system. A responding database node satisfying the query: obtains a query results set; defines a topic identifier for the query; and publishes subsequent messages relating to the topic identifier when data updates are available. The first database node receives query results sets from one or more responding nodes and the first database node subscribes to topic identifiers for publications of subsequent messages from the responding database nodes. Subsequent messages are published relating to the query along the connection through which the query is returned.

Embodiments of the invention provide techniques for performing federated queries of data records stored in multiple data sources. In one embodiment, an aliased key table may be configured to store relationships between key fields of multiple data sources. The aliased key table may specify a mapping function to translate a value of one key field to an equivalent value of a second key field. The mapping function may be used with a mapping table storing sets of key values of different data sources, with each set corresponding to a given entity. In another embodiment, the mapping function may call a web service configured to translate key values. In yet another embodiment, federated queries may be specified in terms of attributes, which may be matched to key values.

Querying data stores in a federation of data stores. A first search filter is accessed. The first search filter is constructed with one or more nested logical AND, OR, or NOT operands. The first search filter is normalized to a normalized search filter that is logically equivalent to the first search filter. The normalized search filter includes 3 or 4 levels. All first level operands are logically ORed. All second level operands are logically ANDed. All third level operands are at least one of parameters or logical NOTs. Any fourth level operands are parameters. The normalized search filter is used to search a plurality of data stores in a federation of data stores for information by searching different data stores for at least two or more of the top level operands.

The invention discloses a Cronobacter sakazakii CRISPR typing method. The method is as follows: performing DNA sequencing on CRISPR1, CRISPR2, CRISPR3 and CRISPR6 locus sequences of Cronobacter sakazakii, extracting spacer sequences of the four locus sequences, and determining CRISPR type of the Cronobacter sakazakii based on the combination of the four spacer sequences. The method is simple, rapid and low-cost, the resolution of the method is higher than the resolution of MLST typing method, and the Cronobacter sakazakii CRISPR typing method has no environmental pollution, and has low requirements on laboratory equipment and software, CRISPR molecules preserve a lot of information such as historically infected phage and plasmid, by joint with a database, national and even global standardization molecule traceability can be realized, and the method can be extended to the fields of food, inspection and quarantine.

Systems and methods are provided for data federation query suggestion. An example system includes a query constraint database including at least one query constraint and a query constraint resolving module that receives from a user a query to search a federated database using a federated database search engine and determines if the query satisfies at least one query constraints. The system further includes a query suggestion module that determines a query suggestion if the query does not satisfy at least one query constraints.