News Column

Patent Issued for Guiding the Development of Workload Group Definition Classifications

February 18, 2014



By a News Reporter-Staff News Editor at Information Technology Newsweekly -- Teradata US, Inc. (Dayton, OH) has been issued patent number 8645425, according to news reporting originating out of Alexandria, Virginia, by VerticalNews editors.

The patent's inventors are Brown, Douglas P. (Rancho Santa Fe, CA); Richards, Anita (San Juan Capistrano, CA); Ramesh, Bhashyam (San Diego, CA).

This patent was filed on February 25, 2004 and was published online on February 4, 2014.

From the background information supplied by the inventors, news correspondents obtained the following quote: "As database management systems continue to increase in function and to expand into new application areas, the diversity of database workloads, and the problem of administering those workloads, is increasing as well. In addition to the classic relational DBMS 'problem workload,' consisting of short transactions running concurrently with long decision support queries and load utilities, workloads with an even wider range of resource demands and execution times are expected in the future. New complex data types (e.g., Large Objects, image, audio, video) and more complex query processing (rules, recursion, user defined types, etc.) will result in widely varying memory, processor, and disk demands on the system."

Supplementing the background information on this patent, VerticalNews reporters also obtained the inventors' summary information for this patent: "In general, in one aspect, the invention features a method for guiding the development of workload group definition (WD) classifications for a database system having resources. The method includes providing WD classification information. A workload group is a set of system requests having characteristics defined by a WD. A WD classification identifies one or more WDs with similar performance requirements. If WD classification is not acceptable, the method performs one or more of the following functions until WD classification is acceptable: (a) splitting one or more WDs; and (b) merging two or more WDs.

"Implementations of the invention may include one or more of the following. The method may further include defining service level goals (SLGs) for WDs. Defining SLGs for WDs may include providing historical SLG-like information and accepting adjustments to the SLG-like information. Defining SLGs for WDs may further include defining additional SLGs and defining additional management control parameters. The method may further include defining parameters to dynamically adjust the allocation of system resources, defining exception actions, and defining delay rules to best reach the SLGs as defined. Defining parameters to dynamically adjust the allocation of system resources may include suggesting parameters to dynamically adjust the allocation of system resources and accepting adjustments to the parameters.

"Providing WD classification information may include providing a snapshot of system resource usage elements, aggregating on one or more likely classification elements. Aggregating may include aggregating on one or more of the following system resource usage elements: account, application. Aggregating may include aggregating on one or more of the following: who information, where information, what information. A request may be logged to a detailed log if the execution of the request is on one side of a threshold and otherwise to a summary log, and where aggregating may include aggregating based on presence in the detailed log or the summary log. A request may be logged to summary buckets depending on execution time of the request, and aggregating may include aggregating based on presence in summary buckets.

"Providing WD classification information may include mapping existing WD classification-like definitions to WD classifications. Providing WD classification information may include providing existing WD classifications. Splitting one or more WDs may include splitting one or more WDs for accounting purposes. Merging two or more WDs may include merging two or more WDs for accounting purposes. SLGs may have been defined for the WDs, statistics may have been collected regarding whether requests falling under the WDs have been meeting the SLGs. Who, what and where information may be associated with each request, and splitting one or more WDs may include for WDs covering requests that are not, in aggregate, meeting SLGs: using the who, what, and where information to cluster requests covered by those SLGs, and splitting the WDs based on those clusters. Using the who, what, and where information to cluster requests covered by those SLGs may include mapping the who, what and where information for SLG-failing requests into an N-grid and, using the N-grid, finding clusters of requests with the least in common with other groups of requests. The method may further include accepting a request for WD classification information.

"In general, in another aspect, the invention features a computer program, stored on a tangible storage medium, for use in administering the workload of a database system as it executes one or more requests. The program includes executable instructions that cause a computer to provide WD classification information. A workload group is a set of system requests having characteristics defined by a WD and a WD classification identifies one or more WDs with similar performance requirements. If WD classification is not acceptable, the program performs one or more of the following functions until WD classification is acceptable: a. it splits one or more WDs, and b. it merges two or more WDs.

"In general, in another aspect, the invention features a database system including a massively parallel processing system, which includes one or more nodes, a plurality of CPUs, each of the one or more nodes providing access to one or more CPUs, a plurality of data storage facilities each of the one or more CPUs providing access to one or more data storage facilities, and a process for execution on the massively parallel processing system for administering the workload of a database system as it executes one or more requests. The process includes providing WD classification information. A workload group is a set of system requests having characteristics defined by a WD. A WD classification identifies one or more WDs with similar performance requirements. If WD classification is not acceptable, the process performs one or more of the following functions until WD classification is acceptable: a. splitting one or more WDs; and b. merging two or more WDs."

For the URL and additional information on this patent, see: Brown, Douglas P.; Richards, Anita; Ramesh, Bhashyam. Guiding the Development of Workload Group Definition Classifications. U.S. Patent Number 8645425, filed February 25, 2004, and published online on February 4, 2014. Patent URL: http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&p=25&u=%2Fnetahtml%2FPTO%2Fsearch-bool.html&r=1205&f=G&l=50&co1=AND&d=PTXT&s1=20140204.PD.&OS=ISD/20140204&RS=ISD/20140204

Keywords for this news article include: Teradata US Inc, Information Technology, Information and Data Storage.

Our reports deliver fact-based news of research and discoveries from around the world. Copyright 2014, NewsRx LLC


For more stories covering the world of technology, please see HispanicBusiness' Tech Channel



Source: Information Technology Newsweekly


Story Tools