Abstract: In accordance with embodiments, there are provided mechanisms and methods for validating queries. These mechanisms and methods for validating queries can enable embodiments to provide more reliable and faster execution of queries both in development and in production. In an embodiment and by way of example, a method for validating queries is provided. The method embodiment includes capturing a query that is directed to a multi-tenant database. A plan is determined by which the query will be applied to the database. The plan is statically analyzed for performance. Then a performance measure is applied to the query.

Abstract: Some embodiments of a system and a method to detect contention for resource in a cluster file system have been presented. For instance, a processing device may measure time spent performing actual operations by each of a set of nodes in a cluster file system when a respective node holds a lock on a resource and time spent performing overhead operations by the set of nodes without synchronization of clocks across the cluster file system. Then the processing device can determine latency and throughput of the cluster file system based on the time spent performing actual operations and the time spent performing overhead operations.

Abstract: Apparatus, methods and computer-readable medium for displaying information related to performance of a given database statement which accesses a plurality of multi-partition objects during a time interval. In some embodiments, the method comprises: a) determining, for a given database statement that accesses a plurality of index or table partitions during the time interval, for each accessed partition of a plurality of partitions, a respective aggregate wait time associated with said accessed partition; b) in accordance with the determined wait times for the given database statement, presenting, to a user, a description of performance of the database during the time interval.

Abstract: A method in a data processing system for detecting and reducing database contention and deadlock caused from within an application server. A determination is made as to whether a set of parameters in a statistical model indicates contention. If the set of parameters in the statistical model indicates contention, an application server administrator is notified of the contention and the number of threads in an application server pool is reduced. If the set of parameters in the statistical model indicates contention is reduced, the number of threads in the application server pool is increased.

Abstract: Architecture for uninterrupted access to business data by enabling work on rich client machines to be stored in a local business data cache that is always available. A dispatching mechanism executes read/write requests against the local cache transparently to a client application, an automatic synchronization mechanism propagates changes bi-directionally when the client goes online and a live connection with the corresponding backend data source is available. A declarative data access model is employed based on operation stereotyping and grouping that enables client applications to transparently execute create, read, update, delete, query (CRUDQ) and association operations against the local cache as if executed against the actual business data source. The architecture supports the offline creation of entities and sets of related entities when the entity identifiers are generated by the business data source and offline navigation of entity associations when foreign keys are not present in the related entities.

Abstract: A content management system (CMS) uses an element deletion mechanism to maintain referential integrity of dynamically assembled elements in a repository. Element properties such as probability, popularity and recent usage that are not explicit relationships between parent documents and child elements are logged. A deletion policy is then defined in terms of the logged element properties. When a request to delete an element is received, the deletion mechanism checks the logged properties against the deletion policy. If the element's logged properties satisfy the deletion policy, the element is deleted from the repository. If the element's logged properties do not satisfy the deletion policy, the element is not deleted. In this manner referential integrity may be enforced for elements that are dynamically assembled.

Abstract: One or more usage models are provided for a database. Each usage model includes a set of rules that are used to analyze database performance. A usage model in one or more usage models is determined. Database information is determined based on the usage model. The database information is then analyzed based on rules associated with the usage model. One or more performance problems are determined based on the analysis.

Abstract: Various embodiments of the invention provide systems and methods for estimating a frequency of errors for data processing operators, but without human inspection of documents typed by the operators and without comparing documents typed by the operators against known transcriptions.

Abstract: A method for distinguishing information elements on a display is disclosed, the method comprising associating a characterization attribute to a group of information elements selected from a plurality of information, associating at least one visual distinctive feature with the characterization attribute, and displaying, on the display, at least one information element from the group of information elements associated with the characterization attribute on an information element vector along a specific sequence, the at least one information element being displayed with the associated at least one visual distinctive feature, the at least one visual distinctive feature influencing the visual appearance of the at least one information element.

Abstract: An apparatus for analyzing and displaying usage condition of information. The apparatus analyzes and displays the usage condition outside of an information distributing system by which the information is transmitted; and includes: a usage condition collecting unit that acquires a usage condition information as to the usage condition of the information outside of the information distributing system to be evaluated; and a usage condition displaying unit that displays the usage conditions based on the usage condition information.

Abstract: Exemplary method, system, and computer program embodiments for facilitating information between at least one host and a storage controller operational in a data storage subsystem are provided. In one embodiment, a pseudo-volume, mappable to the at least one host and mountable as a filesystem, is initialized. The pseudo-volume is adapted for performing at least one of providing diagnostic and statistical data representative of the data storage subsystem to the at least one host, and facilitating control of at least one parameter of the storage controller.

Abstract: A computer process, called VGRAM, improves the performance of these string search algorithms in computers by using a carefully chosen dictionary of variable-length grams based on their frequencies in the string collection. A dynamic programming algorithm for computing a tight lower bound on the number of common grams shared by two similar strings in order to improve query performance is disclosed. A method for automatically computing a dictionary of high-quality grams for a workload of queries. Improvement on query performance is achieved by these techniques by a cost-based quantitative approach to deciding good grams for approximate string queries. An approach for answering approximate queries efficiently based on discarding gram lists, and another is based on combining correlated lists. An indexing structure is reduced to a given amount of space, while retaining efficient query processing by using algorithms in a computer based on discarding gram lists and combining correlated lists.

Abstract: A system and method for checkpoint tuning in a computer environment comprising a processor coupled to a statistical database and at least one database or table manager and data log files. The data log files store data relating to the operations of the database or table manager. The processor executes a module that captures data comprising the number of operations, the time taken by the checkpoint process, folded journal entries, long running transactions, and the ratio of WRITE:READ operations. The processor then stores the captured data and processes the collected data, generating statistics therefrom. The statistical data is stored in the statistical database. The system selects checkpoint intervals based on the data statistics; and implements the checkpoint intervals.

Abstract: Disclosed is a technique for maintaining statistics. A query is received. Column group generation is performed to form one or more column groups. Column group refinement is performed based on statistics data generated for a previously received query. A statistics check is automatically performed. A statistics collection command is generated to obtain statistics.

Abstract: A method for transmitting data in an xDSL system is disclosed. In an exemplary embodiment, the method includes defining a data transmission unit (DTU) to be sent in an xDSL data stream, defining a retransmit container as a time slot that corresponds to a sent DTU, maintaining a copy of the sent DTUs and an index of corresponding retransmit containers in retransmission buffer, transmitting the DTUs in the xDSL data stream, determining whether a transmitted DTU should be retransmitted, identifying each corrupted DTU by its corresponding retransmit container, and retransmitting an uncorrupted copy of the DTU as identified by the corresponding retransmit container. The retransmission is deferred until the DTU is at a predefined position in the retransmission buffer.

Abstract: The present invention is related to data storage and transmission. Data is compressed and stored by a controller computer instead of having a client computer gather, compress and store the data. This allows for data to be retrieved from the data stores and displayed for user retrieval, even when communication failures have occurred.

Abstract: A mechanism minimizes the management issues of the participant objects of the logical target set, such as an application set. The mechanism maps the current physical implementation. The mechanism then identifies the target and extraneous object set locations to facilitate isolation. Thereafter, the mechanism optimizes the logical target set placement for best manageability and performance. The mechanism minimizes the management issues by providing a small application footprint. This is accomplished by placing the object set on the fewest necessary volumes to facilitate both application performance and independence of administrative action.

Abstract: An embodiment of the invention provides a technique that allows the collection, storage, and manipulation of data collected in a computer network.

Abstract: An ordering of operations in log records includes: performing update operations on a shared database object by a node; writing log records for the update operations into a local buffer by the node, the log records each including a local virtual timestamp; determining that a log flush to write the log records in the local buffer to a persistent storage is to be performed; in response, sending a request from the node to a log flush sequence server for a log flush sequence number; receiving the log flush sequence number by the node; inserting the log flush sequence number into the log records in the local buffer; and performing the log flush to write the log records in the local buffer to the persistent storage, where the log records written to the persistent storage comprises the local virtual timestamps and the log flush sequence number.

Abstract: The present invention provides a method for updating data sources. The method may include identifying a plurality of data sources, identifying a plurality of overlapping attribute segments to use for comparing the data sources, calculating a factor as a function of each of the plurality of overlapping attribute segments, and using the factors to update a first group of values in the second data source to reduce bias. Further, at least a first data source is more accurate than a second data source.

Abstract: A method for detecting an event and/or behavior of interest based on monitoring data and selectively storing portions of the monitoring data associated with the event and/or behavior of interest. Preferably, the method includes defining a hierarchy of event and/or behavior types so that the storing of a first behavior/event type is preferred over a second behavior/event type, especially when storing capacity is scarce. A data management apparatus including a logic device and a long-term storage memory apparatus, the logic device for detecting an event and/or behavior of interest based on monitoring data and selectively storing portions of the monitoring data associated with the event and/or behavior of interest on the long-term memory storage apparatus.

Abstract: A method and a system to organize a data set into groups of data subsets in multiple passes using different parameters and to automatically name the groups is disclosed. For example, a data set is retrieved in accordance with a search query submitted by a user. The data set is organized into clusters based on a statistic(s) of the data set. The data set is then organized into groups of data subsets based on an attribute(s) indicated by the data set. Each of the groups are automatically named based on a property shared by data units of the group. The name(s) of a group may be mined from the data units of the group, retrieved from a structure that maps to attribute values indicated by the data units of the group, etc.

Abstract: The subject disclosure pertains to systems and methods that generate a simulation database based upon a source database. The simulation database can be populated using a schema and statistics obtained from the source database. After population, the simulation database can be statistically similar to the source database, facilitating testing, analysis, support and database design. More particularly, data distribution histograms can be used to generate data to populate the simulation database. At the same time, the referential integrity can be maintained.

Abstract: A system that incorporates teachings of the present disclosure may include, for example network device having a controller to receive multiple streams of content for portions of a multimedia work (MMW), perform a high level analysis for features in each of the streams for the MMW, perform a specialized analysis on the portion having a detected general feature to generate a content analysis output, correlate the content analysis output with other content analysis of the MMW, and output a weighted content description based on the correlation function. Other embodiments are disclosed.

Abstract: An apparatus and program product that build column statistics utilizing at least one skew value. The column statistics built using skew values, instead of column statistics built only through random sampling, may be used to more accurately reflect skew values across join networks, and thus enable a query optimizer to better select an access plan that is optimal under current runtime conditions.

Abstract: Cost-based optimizer functionality for an XML database repository provides means for optimizing the execution of database queries that access XML resources in the database repository. Statistics about XML resources that are stored in the database repository are gathered, stored and utilized by a query optimizer to compute computational costs associated with each of multiple methods of accessing particular XML resources requested in a database query. Hence, the optimizer is able to select the most efficient query execution plan based on the costs of possible access paths. In one embodiment, specific statistics about the hierarchical structure of XML resources stored in the XML database repository are gathered, stored in a relational table in the database management system, and used to compute the selectivity of query predicates and the index cost associated with traversing one or more indexes to access requested XML resources.

Abstract: A system and method identifies the times that certain applications are started and stopped on a computer system and such information about several computer systems is collected using a central computer system to allow decisions regarding software may be made based on usage of those certain applications.

Abstract: A search platform that can generate intellectual property intelligence within an organization using a patent search engine. The patent search engine can monitor and log activity of users in connection with patent-related activities, such as searching, commenting on, and reviewing patent documents associated with a shared workspace of the organization. Based on this captured activity, the search engine can provide the organization with statistical information in patent-related activities occurring within the organization.

Abstract: A method and system are presented for quantifying a data page repetition pattern for a database index in a database management system. In one embodiment, the method includes identifying a database index to provide a basis for collecting a data page repetition statistic, the database index having a database index key. The method may also include collecting the data page repetition statistic based on the database index key, wherein the data page repetition statistic quantifies a data page repetition pattern associated with database queries that reference sequential entries of the database index. The method may further include optimizing a data page access process based on the data page repetition statistic. In a further embodiment, the method may utilize both cluster ratio and data page repetition statistics to evaluate data page I/O and CPU cost.

Abstract: A data storage management system for managing a plurality of remotely located, independent data storage systems includes a central monitoring system and a plurality of agent systems, each in communication with a respective remotely located customer data storage system. Each remote agent system collects data from a respective customer data storage system that relates to the performance/status of the data storage system. Each agent system converts the collected data to a standardized format and then stores the collected data at the central monitoring system. The central monitoring system continuously and automatically monitors activities at the remote data storage systems and, using pattern recognition and data correlation techniques, can predict when system faults are developing at these remote data storage systems. Data storage management experts staffing the command center can initiate corrective action before a customer's data is adversely impacted.

Abstract: A method for inferring a probability of a first inference. The inference is related to identification of a cause of an outcome in a healthcare setting. A fact, related to the query, is related to the healthcare setting. The fact further relates to a network of interactions associated with the outcome. Each datum of the database conforms to the dimensions of the database. Each datum of the plurality of data has associated metadata and an associated key. The associated metadata includes data regarding cohorts associated with the corresponding datum, data regarding hierarchies associated with the corresponding datum, data regarding a corresponding source of the datum, and data regarding probabilities associated with integrity, reliability, and importance of each associated datum. The query establishes a frame of reference for the search. The database returns a probability of the correctness of the first inference based on the query and on the data.

Abstract: A method and system is provided to access one or more historical incident databases, for example, CDC, CPSC, DTI, AAPCC and the like, for standardizing the potentially differing categories and coding among the databases. The standardizing includes recoding of the categories by providing a unified set of categories reflective of similar categories found among the one or more databases, if any. Submission of search queries allows users to obtain unified data across the databases so that incident history statistics for one or more products tracked by commonly available databases may be easily acquired. The resulting reports and statistics may be used by various entities to understand historical incidents from multiple perspectives including, for example, injury and fatality statistics as a function of age group, type of injury, time periods, diagnosis, injury outcome, severity, and the like. Data may be presented in standardized formats or in any of the native database formats.

Abstract: Techniques are provided for efficiently collecting statistics for hierarchically-organized collections of data. A database system leverages container-level modification time stamps and stored subtree-level change information to gather statistical information from only those resources in a hierarchical collection for which the statistics have changed since the last time that statistics were gathered for the collection. A lockless data structure is also described for storing the subtree-level change information in which an identifier corresponding to each subtree in a collection containing a changed resource may be stored. This data structure may be a table that is distinct from one or more tables representing the collection. In one embodiment of the invention, the immediate parent resource of a particular modified resource may be omitted from the subtree table by leveraging modification time stamps while gathering statistics based on tracked subtree-level information.

Abstract: A portal uses portlets to provide a session to a user. Based on portlet events that occur in the session, portlet log entries are sent from the portlets to a log server. The log server stores log entries comprising the portlet log entries and the portal log entries. A customer service representative in communication with the user is provided a display of an activity of the user in the session based on the log entries from the log server.

Abstract: Described is a technology by which directly ascertainable properties of a processor are collected, and used as a key to access other information about the processor, such as age-related information maintained in a separate lookup table. If a matching entry is not found, the property information may be added to an unknown list and/or used to dynamically update the lookup table. A data structure such as a record comprises a set of fields including fields containing data representative of properties of a processor, a key value determined from the data in at least some of the fields and an identifier that identifies the processor relative to other processors of other computing devices. The fields may include manufacturer data, brand identifier data, cache information, normalized processor speed data, mobile chip information and/or CPU model data.

Abstract: A system, method, and computer-readable medium that provide mechanisms for tracking the number of queries received for processing for a workload to facilitate arrival rate qualifications to Throughput Service Level Goals are provided. A number of queries counter associated with a particular workload is incremented each time a query assigned to the particular workload is received thereby tracking the arrival rate of workload queries. When a system performance condition comprising a non-compliant system performance level with respect to a Throughput Service Level Goal is identified, the number of queries counter is compared with the Throughput Service Level Goal. If the arrival rate of queries for the workload is greater than the Throughput Service Level Goal of the workload, actions associated with non-compliance of the Throughput Service Level Goal may then be performed.

Abstract: Dimensional data with attributed categorical variables is mined against a continuous target with any data mining method by ranking variables. The ranked variables are used to generate a tree. A population and a target value, obtained from a top node of the tree, are stored. The top node is removed from the tree to create a new tree with a next top node. Obtaining and storing a next population and a next target value for the next top node, and removing the top node or top field to create a new tree, are repeated. The listing of sequential top node parameters is plotted on a tree cusp curve that provides a graphical user interface enabling identification of a field which affect a greatest or a least number of records, based upon a magnitude of departure of the field from a norm.

Abstract: A computer-implemented method includes calculating first statistics about a user-identified event within a first subset of a database of events; selecting a second subset of the database of events based on said first statistics; calculating second statistics about the user-identified event within the second subset of the database of events; merging the first and second statistics as statistics of the user-identified event within the entire database of events; and generating a result including at least a portion of the merged statistics of the user-identified event.

Abstract: The present invention provides methods and systems for evaluating the performance of a computer system to enable capacity planning. With respect to the present invention, performance data (metrics) collected from computing devices are used to generate performance results. A set of utilization factors are calculated to forecast computing needs without a long manual analysis of large volumes of data. A user has access to a graphical representation of the utilization factors to determine a forecast of capacity needs based on the information calculated.

Abstract: In an embodiment, estimated costs are used to pick the best refresh technique (e.g., method) for a given MV. In another embodiment, estimated costs are used to schedule the refresh of a set MVs in an order such that overall time to refresh is reduced, or in an order that uses the smallest overall time, for refreshing when compared to other alternative refresh schedules. In another embodiment, the estimated cost of refreshing each of a set of MVs is used to select the set of CPU resources to allocate to refreshing each MV. Based on the estimated costs, the allocation of CPU resources is chosen to be more optimal (e.g., use less CPU time) than other available sets of CPU resources. In an embodiment, when refreshing an MV, delayed index maintenance is chosen if a significant portion of the base table and/or the partitions of the table has changed.

Abstract: Database performance and availability monitoring of changes impacting database performance, availability and continuity to the underlying business may be performed. A method for doing so may include analytical and visual real-time analysis engines to identify and provide alert notifications on changes in database performance statistics (such as CPU consumption, physical I/O, etc.) related to a sample period of time on a single database or across multiple databases. Result data may be displayed through a series of charts and/or summary tables that may indicate whether correlations exist between unexpected database performance and relative changes in database performance statistical parameters.

Abstract: A solution is provided for determining traffic patterns involving a web page or property of interest in a computer network. This includes receiving path data regarding the web page or property of interest. Then, the number of visits to each of the other pages or properties visited by users in a session that included a visit to the web page or property of interest is counted. Then, from the path data and the counts, an aggregated data structure is constructed including, for each of the other web pages or properties visited by users in a session that included a visit to the web page or property of interest, visit count information and information regarding which web page or property within the network users visited next, if any. Then one or more metrics directed to traffic surrounding the web page or property of interest is provided using information from the aggregated data structure.

Abstract: A solution for handling objects in a nursery heap that includes a garbage collector monitoring engine, a size adjustor program, and/or a promotion program. The garbage collector monitoring engine can monitor occurrences of global garbage collection events performed by a global garbage collector program as well as occurrences of nursery garbage collection events performed by a nursery garbage collector. The size adjustor program can dynamically adjust a size of a nursery heap based upon programmatically deterministic events detected by the garbage collector monitoring engine. The promotion program can dynamically adjust conditions of promotion for nursery objects, wherein when additional space is needed in the nursery heap to reduce nursery garbage collection induced latency, the promotion program changes promotion criteria to ensure objects are promoted more frequently from the nursery heap.

Abstract: A query execution system is provided. The system includes a monitor component that detects data value changes in a database. An adjustment component initiates an intermediate query in view of detected data value changes, the intermediate query employed to adjust statistics related to a query plan optimization.

Abstract: A resume database system allows for resume records on the resume database system to be viewed by others via a Uniform Resource Locator, URL. In addition, in response to instructions from an authorized user of the resume database system, input from an unauthorized, but otherwise verified, source can be added to the database by the resume database system. The verified user accesses the resume database and completes any necessary forms via a web browser and submits the information. The authorized user defines the actions that the verified user is allowed to take. These actions include, for example, only being able to review resume information, or being able to add information to the resume database without needing training on the operation of the database. A resume database server system coordinates the activity of the authorized and verified users. Communications between all three users is accomplished via a computer network.

Abstract: A method and apparatus for ontology-based classification of media content are provided. With the method and apparatus, initial confidence values of classifiers in a hierarchical classification structure are modified based on relationships between classifiers. A confidence value for a classifier is boosted by a boosting factor based on a correspondence between the confidence value and confidence values of ancestor classifiers in the hierarchical classification structure. A confidence value for a classifier is modified by a confusion factor based on a correspondence between the confidence value of the classifier and the confidence values of mutually exclusive classifiers in the hierarchical classification structure. In this way, a more accurate representation of the actual confidence that media content falls within the classification associated with the classifier is obtained.

Abstract: A method, system and computer program product for confirming the validity of data returned from a data store. A data store contains a primary data set encrypted using a first encryption and a secondary data set using a second encryption. The secondary data set is a subset of the primary data set. A client issues a substantive query against the data store to retrieve a primary data result belonging to the primary data set. A query interface issues at least one validating query against the data store. Each validating query returns a secondary data result belonging to the secondary data set. The query interface receives the secondary data result and provides a data invalid notification if data satisfying the substantive query included in an unencrypted form of the secondary data result is not contained in an unencrypted form of the primary data result.

Abstract: A method, medium, and system classifying a music theme for music by using a corresponding music title, by generating a theme class vector in association with the music theme, generating a music title class vector in association with the music title, calculating similarity between the theme class vector and the music title class vector, and assigning a theme of the music title based on the similarity.

Abstract: A method and system to provide subjective evaluations for artifacts in a Universal Description Discovery and Integration (UDDI) registry (version 3 or later). An extension to a UDDI registry receives a request from a client to add a subjective evaluation to an artifact in the UDDI registry, the request including a key identifying the artifact and an evaluation value to be associated with the artifact. The extension stores an evaluation, including the artifact identifying key and the associated evaluation value. The extension receives a request from a client to find a specific type of artifact in the UDDI registry, the request including an evaluation qualifier. The extension receives from the registry a list of keys identifying artifacts responsive to the request. The extension then provides the client with a list of stored evaluation values associated with the artifact keys in the artifact list.

Abstract: A method and system for displaying database record organization characteristics of IMS databases. In one embodiment, the method involves receiving information associated with a plurality of database records from an IMS database (e.g., information associated with ranges of database records). The database information may comprise information concerning database record organization characteristics. A working storage array may be built to consolidate the information associated with the plurality of database records. A plurality of view envelopes may be constructed. The plurality of view envelopes, along with a legend, may be graphically displayed on a display. User input may be received to request “inspection”, “identification”, “inspection/identification”, or “detailed inspection” of a selected view envelope. Various methods may be used to “mark”, “unmark”, and “submit” at least one DBR to the mainframe computer system for reorganization.