摘要:
One embodiment is a method to manage queries in a database. The method identifies a query that executes on the database for an elapsed time that is greater than a threshold and then implements a remedial action when the query executes on the database for an execution time that is greater than an estimated execution time.
摘要:
One embodiment is a method to manage queries in a database. The method identifies a query that executes on the database for an elapsed time that is greater than a threshold and then implements a remedial action when the query executes on the database for an execution time that is greater than an estimated execution time.
摘要:
One embodiment is a method to manage queries in a database. The method identifies a query that executes on the database for an elapsed time that is greater than a threshold and then implements a remedial action when the query executes on the database for an execution time that is greater than an estimated execution time.
摘要:
A method and system of valuing transformation between XML documents. Specifically, one embodiment of the present invention discloses a method for calculating a transformation cost for a transformation operation that transforms a source node in a source XML document to a target node in a target XML document. A data loss and potential data loss is measured for the transformation operation. Also, the operands in the transformation operation are scaled to measure their impact on the data loss and potential data loss. A transformation cost is calculated by considering the data loss, potential data loss, and scaling.
摘要:
One embodiment is a method that generates query vectors from query plans and performance vectors from data collected while executing queries in a database. The method then uses a machine learning technique (MLT) to compute distances between two query vectors and two performance vectors and to predict performance of executing a new single query in isolation in the database.
摘要:
One embodiment is a method that generates query vectors from query plans and performance vectors from data collected while executing multiple queries in a database. A machine learning technique (MLT) computes distances between two query vectors and two performance vectors and then predicts performance of plural queries executing in the database.
摘要:
One embodiment is a method that generates query vectors from query plans and performance vectors from data collected while executing multiple queries in a database. A machine learning technique (MLT) computes distances between two query vectors and two performance vectors and then predicts performance of plural queries executing in the database.
摘要:
One embodiment is a method that obtains query plans for queries in the workload. The query plans include a tree of operators and estimated cardinalities for nodes in the tree. The method then groups the operators for the queries and characterizes the workload in terms of grouped operators to predict performance of the queries before the queries execute in a database.
摘要:
A system and method for resource handling provides for receiving a query and providing a response. The query is used to search resources locally available. Metadata is associated with each of the resources. The resources and the metadata are both analyzed with respect to the query such that a response indicative of a match between at least two of the resources and the query is a ranked search result included in the response. The invention is exemplified in an adaptation to peer-to-peer network applications.
摘要:
A computer language for facilitating communication between web services, where web services may use disparate input and output document formats, and system using same. A Conversation Definition Language (CDL) is extended with transformational information to a Transformational Conversation Definition Language (TCDL). The CDL defines document types, transitions and interactions of a conversation between two or more web services. In a preferred embodiment, the transformational information is a subset of the interaction information. Stylesheets are used to define the semantics of the required transformation and the appropriate stylesheets are identified in the TCDL file. A conversation controller component reads the TCDL files that correspond to a given conversation and utilizes the transformation information, when necessary to transform documents between web services without human intervention.