摘要:
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.
摘要:
Described herein is a method for scheduling memory usage of a workload, the method comprising: receiving the workload, wherein the workload includes a plurality of jobs; determining a memory requirement to execute each of the plurality of jobs; arranging the plurality of jobs in an order of the memory requirements of the plurality of jobs such that the job with the largest memory requirement is at one end of the order and the job with the smallest memory requirement is at the other end of the order; assigning in order a unique priority to each of the plurality of jobs in accordance with the arranged order such that the job with the largest memory requirement is assigned the highest priority for execution and the job with the smallest memory requirement is assigned the lowest priority for execution; and executing the workload by concurrently executing the jobs in the workload in accordance with the arranged order of the plurality of jobs and the unique priority assigned to each of the plurality of jobs.
摘要:
A system and method comprises selecting at least one metric from an alternative representation of a database to create a request based on the at least one metric, invoking an interpreter associated with the database to return data related to the at least one metric, and displaying the data.
摘要:
A computer-executable method receives at least one query that specifies requests involving blocks of data. Based on information associated with at least one query, a sequence is identified relating to an order in which the blocks are to be retrieved into a storage for processing the requests. An output is provided for the at least one query based on retrieving the blocks into the storage according to the identified sequence.
摘要:
The present invention pertains to a system for simulating business processes. The system has data warehouse for storing historical execution data from executions of a first business process. The system also has a business process simulator coupled to the data warehouse and for simulating a second business process using the historical execution data as input parameters and for outputting simulated business process data.
摘要:
A method and system for analyzing web access. First, a plurality of web log records are received. Next, multi-dimensional summary information is generated based on the web log records. Then, derivation and analysis are performed to discover usage patterns and rules for supporting business intelligence by using the multi-dimensional summary information.
摘要:
Probe-based query processing for a database system that loosely integrates a structured database and a text retrieval system is described. The query processing constructs a query plan that efficiently evaluates a conjunctive query having joins of structured and textual data by sending to the text retrieval system one or more text search/retrieve operations.
摘要:
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.
摘要:
Actions associated with visualizing an input data set using plural graphs are monitored. At least one of the graphs is produced based on selection from another of the graphs. A relationship tree that represents relationships of the graphs is created based on monitoring the actions. Output information including description data and image data is provided, where the description data contains at least a portion of the relationship tree. The output information enables interactive navigation through the plural graphs without accessing the input data set.
摘要:
Attributes in data records are identified. Episodes corresponding to the respective attributes include respective data records. The episodes are scored, where scoring of a particular one of the episodes is based on relative time densities between successive data records of the particular episode. A visualization of at least some of the episodes to provide an alert of time-dense episodes.