System and method for identifying a workload type for a given workload of database requests

System and method for identifying a workload type for a given workload of database requests

Workload type to be managed by a database management system (DBMS) is a key consideration in tuning the DBMS. Allocations for resources, such as main memory, can be very different depending on whether the workload type is Online Transaction Processing (OLTP) or Decision Support System (DSS). The DBM...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: LIGHTSTONE SAM S, VAN BOESCHOTEN ROBIN D, SCHIEFER BERNHARD K, ELNAFFAR SAID, HORMAN RANDALL W, MARTIN PAT
Format: Patent
Sprache:eng
Schlagworte:
CALCULATING
COMPUTER SYSTEMS BASED ON SPECIFIC COMPUTATIONAL MODELS
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page
container_issue
container_start_page
container_title
container_volume
creator LIGHTSTONE SAM S
VAN BOESCHOTEN ROBIN D
SCHIEFER BERNHARD K
ELNAFFAR SAID
HORMAN RANDALL W
MARTIN PAT
description Workload type to be managed by a database management system (DBMS) is a key consideration in tuning the DBMS. Allocations for resources, such as main memory, can be very different depending on whether the workload type is Online Transaction Processing (OLTP) or Decision Support System (DSS). The DBMS also experiences changes in workload type during the normal processing cycle of the DBMS. It would be preferable for the database administrators to recognize the significant shifts of workload type that demand reconfiguring the DBMS to maintain acceptable levels of performance. Disclosed is a workload type classifier module, used by a DBMS, for recognizing workload types so that the DBMS may then manage or adjust its performance and reconfigure its resources accordingly. The classifier may be constructed based on the most significant workload characteristics that differentiate OLTP from DSS. The classifier is then used for identifying changes in workload types contained in a workload.
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US2004225631A1</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US2004225631A1</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US2004225631A13</originalsourceid><addsrcrecordid>eNqNyr0KwjAUhuEuDqLewwFnoT_aXURxr04O5Wi-1GCbxOSo5O4FEVyd3uF5x9mpSVEwEFtFA-TqFGkXyChYMToZ2xHTy4Vb71iRJI-PM3XmCfsTp0mx8JkjKOD-QJQ4zUaa-4jZt5NsvtseNvsFvGsRPV9gIe2xKfN8WZaruirWRfXf9QZAdzwy</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>System and method for identifying a workload type for a given workload of database requests</title><source>esp@cenet</source><creator>LIGHTSTONE SAM S ; VAN BOESCHOTEN ROBIN D ; SCHIEFER BERNHARD K ; ELNAFFAR SAID ; HORMAN RANDALL W ; MARTIN PAT</creator><creatorcontrib>LIGHTSTONE SAM S ; VAN BOESCHOTEN ROBIN D ; SCHIEFER BERNHARD K ; ELNAFFAR SAID ; HORMAN RANDALL W ; MARTIN PAT</creatorcontrib><description>Workload type to be managed by a database management system (DBMS) is a key consideration in tuning the DBMS. Allocations for resources, such as main memory, can be very different depending on whether the workload type is Online Transaction Processing (OLTP) or Decision Support System (DSS). The DBMS also experiences changes in workload type during the normal processing cycle of the DBMS. It would be preferable for the database administrators to recognize the significant shifts of workload type that demand reconfiguring the DBMS to maintain acceptable levels of performance. Disclosed is a workload type classifier module, used by a DBMS, for recognizing workload types so that the DBMS may then manage or adjust its performance and reconfigure its resources accordingly. The classifier may be constructed based on the most significant workload characteristics that differentiate OLTP from DSS. The classifier is then used for identifying changes in workload types contained in a workload.</description><edition>7</edition><language>eng</language><subject>CALCULATING ; COMPUTER SYSTEMS BASED ON SPECIFIC COMPUTATIONAL MODELS ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2004</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20041111&amp;DB=EPODOC&amp;CC=US&amp;NR=2004225631A1$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,780,885,25563,76418</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20041111&amp;DB=EPODOC&amp;CC=US&amp;NR=2004225631A1$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>LIGHTSTONE SAM S</creatorcontrib><creatorcontrib>VAN BOESCHOTEN ROBIN D</creatorcontrib><creatorcontrib>SCHIEFER BERNHARD K</creatorcontrib><creatorcontrib>ELNAFFAR SAID</creatorcontrib><creatorcontrib>HORMAN RANDALL W</creatorcontrib><creatorcontrib>MARTIN PAT</creatorcontrib><title>System and method for identifying a workload type for a given workload of database requests</title><description>Workload type to be managed by a database management system (DBMS) is a key consideration in tuning the DBMS. Allocations for resources, such as main memory, can be very different depending on whether the workload type is Online Transaction Processing (OLTP) or Decision Support System (DSS). The DBMS also experiences changes in workload type during the normal processing cycle of the DBMS. It would be preferable for the database administrators to recognize the significant shifts of workload type that demand reconfiguring the DBMS to maintain acceptable levels of performance. Disclosed is a workload type classifier module, used by a DBMS, for recognizing workload types so that the DBMS may then manage or adjust its performance and reconfigure its resources accordingly. The classifier may be constructed based on the most significant workload characteristics that differentiate OLTP from DSS. The classifier is then used for identifying changes in workload types contained in a workload.</description><subject>CALCULATING</subject><subject>COMPUTER SYSTEMS BASED ON SPECIFIC COMPUTATIONAL MODELS</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2004</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNyr0KwjAUhuEuDqLewwFnoT_aXURxr04O5Wi-1GCbxOSo5O4FEVyd3uF5x9mpSVEwEFtFA-TqFGkXyChYMToZ2xHTy4Vb71iRJI-PM3XmCfsTp0mx8JkjKOD-QJQ4zUaa-4jZt5NsvtseNvsFvGsRPV9gIe2xKfN8WZaruirWRfXf9QZAdzwy</recordid><startdate>20041111</startdate><enddate>20041111</enddate><creator>LIGHTSTONE SAM S</creator><creator>VAN BOESCHOTEN ROBIN D</creator><creator>SCHIEFER BERNHARD K</creator><creator>ELNAFFAR SAID</creator><creator>HORMAN RANDALL W</creator><creator>MARTIN PAT</creator><scope>EVB</scope></search><sort><creationdate>20041111</creationdate><title>System and method for identifying a workload type for a given workload of database requests</title><author>LIGHTSTONE SAM S ; VAN BOESCHOTEN ROBIN D ; SCHIEFER BERNHARD K ; ELNAFFAR SAID ; HORMAN RANDALL W ; MARTIN PAT</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US2004225631A13</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2004</creationdate><topic>CALCULATING</topic><topic>COMPUTER SYSTEMS BASED ON SPECIFIC COMPUTATIONAL MODELS</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>LIGHTSTONE SAM S</creatorcontrib><creatorcontrib>VAN BOESCHOTEN ROBIN D</creatorcontrib><creatorcontrib>SCHIEFER BERNHARD K</creatorcontrib><creatorcontrib>ELNAFFAR SAID</creatorcontrib><creatorcontrib>HORMAN RANDALL W</creatorcontrib><creatorcontrib>MARTIN PAT</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>LIGHTSTONE SAM S</au><au>VAN BOESCHOTEN ROBIN D</au><au>SCHIEFER BERNHARD K</au><au>ELNAFFAR SAID</au><au>HORMAN RANDALL W</au><au>MARTIN PAT</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>System and method for identifying a workload type for a given workload of database requests</title><date>2004-11-11</date><risdate>2004</risdate><abstract>Workload type to be managed by a database management system (DBMS) is a key consideration in tuning the DBMS. Allocations for resources, such as main memory, can be very different depending on whether the workload type is Online Transaction Processing (OLTP) or Decision Support System (DSS). The DBMS also experiences changes in workload type during the normal processing cycle of the DBMS. It would be preferable for the database administrators to recognize the significant shifts of workload type that demand reconfiguring the DBMS to maintain acceptable levels of performance. Disclosed is a workload type classifier module, used by a DBMS, for recognizing workload types so that the DBMS may then manage or adjust its performance and reconfigure its resources accordingly. The classifier may be constructed based on the most significant workload characteristics that differentiate OLTP from DSS. The classifier is then used for identifying changes in workload types contained in a workload.</abstract><edition>7</edition><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_epo_espacenet_US2004225631A1
source esp@cenet
subjects CALCULATING
COMPUTER SYSTEMS BASED ON SPECIFIC COMPUTATIONAL MODELS
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title System and method for identifying a workload type for a given workload of database requests
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-08T21%3A16%3A37IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=LIGHTSTONE%20SAM%20S&rft.date=2004-11-11&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS2004225631A1%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true