330 results about "Database schema" patented technology

A method and system for producing graphics. A hierarchical structure of a database is determined. A visual table, comprising a plurality of panes, is constructed by providing a specification that is in a language based on the hierarchical structure of the database. In some cases, this language can include fields that are in the database schema. The database is queried to retrieve a set of tuples in accordance with the specification. A subset of the set of tuples is associated with a pane in the plurality of panes.

A method, system and article of manufacture for generating a logical field specification for a logical field associated with a physical entity of data in a computer system, the physical entity of data having a particular physical data representation, the method comprising: providing a logical field specification template comprising a plurality of specification sub-fields, each specification sub-field designated by a sub-field descriptor; accessing the physical entity of data to determine data items associated with the sub-field descriptors; and linking each specification sub-field to a corresponding determined data item.

A method of optimizing an execution of a query on data may include steps of creating schema object(s) in a database schema, enable monitoring of the schema object(s) to monitor the amount of change of a predetermined characteristic of the schema object(s) over time and loading the data into the created schema object(s). It is then determined whether the amount of change of the predetermined characteristic exceeds a selectable threshold. Updated statistical information may be obtained only when the amount of change exceeds the threshold. The updated statistical information may then be provided to a query execution optimizer, which selects an execution plan based upon the updated statistical information when the amount of change exceeds the threshold or based upon previously provided statistical information when the amount of change does not exceed the threshold. The query may then be executed using the selected execution plan.

Methods and a system that provide a network of data sources in terms of a traditional database schema, convert traditional database queries into network messages, and route those messages to those data sources which have relevant data, in some instances through designated query nodes. In the present invention, those data sources accept the message, and then send reply messages to the originator of the query, or via designated join nodes in some embodiments. In some embodiments, the data sources may be able to perform local join operations. The system then collects these reply messages as appropriate at the designated join nodes, designated query nodes, and/or at the data sources, and the reply messages that meet the requirements of the query are sent back to the query originator. The query results provided to the query originator are presented as a traditional database result.

A management of distributed databases, and a method and an arrangement associated with managing database schemas and configuration of software that uses those schemas. A method and a system, which allows managing database schemas and application software in large distributed multi-database systems and avoiding problems that are related to the prior art systems preferably by using a configuration manager apparatus (231), which is external to the configuration and databases being managed (200) or by providing a mechanism for keeping multiple, possibly different database schemas and application software in synchronization. The external configuration management node (231) manages the configuration management replicas (203, 213, 223) in each part (201, 211, 221) of the distributed database system (200). These synchronized configuration management replicas comprise scripts that are used for creating and/or updating the schemas of the database nodes and configuration of software that uses these database nodes (202, 212, 222).

Database system for storing information technology (IT) management operational data and a method and apparatus for managing IT data are provided. The database utilizes an integrated database schema. IT operational data is stored into the database using the integrated database schema and the database is accessed by plural applications and/or products using the integrated database schema.

Full text searching may be made available for resources stored in a database according to a database schema. A method for conducting a search on structured data using a text search engine includes the steps of: modeling a resource stored in a relational data store as a web page; providing a locator to the resource; and providing the resource in a consumable format to the text search engine. The method may include the additional steps of: receiving a search on the resource; converting the search into a converted query consumable by the search engine; and providing the converted query to the search engine.

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 and correlating orders in a multilateral environment. The multilateral environment includes two or more trading partners trading goods and services. The system is based on a hub and spoke architecture. The hub presents to each of the partners using a partner system a user interface for receiving an order. The order when received is parsed into tags. Each tag represents a predefined field in an order such as price, quantity, delivery date and other contractual terms. These tags are placed into a database schema using a naming structure that is identical to the naming structure used for the tag values so that elements in the database schema can be populated directly from the tag values. Each partner in the value chain, which supplies a good and service for the order, forms one or more hierarchical contractual relationships. Contract tag values are retrieved for each trading partner in the hierarchical contractual relationship. The contract tag values are analyzed for compliance with the tag values for the order. The order is then sent to each of the trading partners in the value chain if the order complies with the contract tag values.

The invention discloses a data partitioning method for a distributed parallel database system. The method comprises the following steps of: establishing a fact table and a dimension table according to the constructed distributed parallel database system; inserting records of the dimension table and the fact table on different nodes according to a partitioning rule; copying the records of the dimension table to the nodes of the fact table; and deleting and updating the data. When a data set or data stream is imported or inserted into the distributed database system in a partitioning way, the relation between tables defined by a database schema can be met on each node, particularly the primary key-foreign key restrictive condition, so the data on each node has local completeness of the data. For the query processing on the connection between the tables by using the primary key-foreign key restrictive condition, the data of each node has the local completeness on the query, so dynamic repartitioning of data between the nodes is not needed; and thus the method has the advantages of preventing time-consuming network transmission of the data, shortening the query response time and improving the query efficiency.

A computing system uses neural networks to translate natural language queries to database queries. The computing system uses a plurality of machine learning based models, each machine learning model for generating a portion of the database query. The machine learning models use an input representation generated based on terms of the input natural language query, a set of columns of the database schema, and the vocabulary of a database query language, for example, structured query language SQL. The plurality of machine learning based models may include an aggregation classifier model for determining an aggregation operator in the database query, a result column predictor model for determining the result columns of the database query, and a condition clause predictor model for determining the condition clause of the database query. The condition clause predictor is based on reinforcement learning.

A method of accommodating at least one difference between a first database schema and a second database schema is provided. The method includes receiving a request from a first application program that is operationally dependent upon the first database schema, the request being received at a second application program that is operationally dependent upon the second database schema. Thereafter, the method identifies if there is a difference between the first database schema and the second database schema. When there is a difference, the method identifies the difference between the first database schema and the second database schema to identify at least one different schema definition element and associates the different schema definition element with a reserved element. The reserved element may have a corresponding reserved element provided in the first database schema. A response is then communicated to the first application program including the reserved element.

In accordance with methods and systems consistent with the present invention, an improved object-relational mapping tool is provided that generates source code containing classes which preserve both changes to the database schema as well as customizations to a preexisting version of the classes. This functionality alleviates the programmer from having to recreate their changes to the classes when the database changes, thus saving significant development time over conventional systems.

A system and method for bridging requests for access to resources between requestors in a distributed network and an authenticator servicing the distributed network is provided. The bridging mechanism has security features including a naming service for machine authentication and machine process rules to authorize what process machines can perform. The security proxy bridge intercepts an access request, and checks the IP address for machine authentication as well as the machine process rules and if both verifications are successful, the bridge then forwards the request for access to the authenticator. The security proxy framework utilizes a data structure that provides a method for storing selected security information stored as data records supporting an authentication and authorization system for users to access resources on multiple components of a distributed network supporting multiple business units of an enterprise. Primary authentication information stored herein includes general user information, security, and contact information.

System and techniques are described which apply a method for automatic database schema migration. An initial database is installed, according to rules that define tables of data, in an adaptive private network (APN) having a centralized management system including a network control node (NCN) coupled through the APN to a plurality of client nodes, wherein the NCN provides timing and control to the client nodes. An update to the initial database is received, wherein the initial database includes a first table of data stored in a first set of columns and the updated database includes a modified first table having a second set of columns that has a different number of columns as compared to the first table is automatically detected. One or more columns from the second set of columns that are different than the first set of columns are updated for data content.

A database schema for storing application data in a relational database backing store of a directory service. The application data has at least some entries with multiple value attributes. According to the invention, the application data is profiled to determine how it may be optimally stored in the backing store. Preferably, single entries having single value attributes are stored in a merged attribute table, while entries having multiple value attributes are stored in per attribute tables. According to the optimization, a majority of the attributes are single valued and are stored in the merged table, and the per attribute tables thus store a relatively smaller number of exceptions. This database schema enhances processing of conventional directory service queries into the backing store.