Query Throughput

Query Throughput

In Computer Science, Query Throughput (QthD) is a measurement used to determine the performance of a database system. The throughput metric is a classical throughput measure characterizing the ability of the system to support a multi-user workload in a balanced way.

Background

A number of query users (S) is chosen, each of which execute the full set of 17 queries in a different orderFact|date=February 2007. In the background there is an update stream that runs a series of insert/delete operations (one pair for each query user). The choice of the number of users is at the discretion of the test sponsor.

The throughput metric is computed as the total amount of work (S×17), converted to hours from seconds (3600 seconds per hour), scaled by the database volume (SF) and divided by the total elapsed time (Ts) required between the first query starting and the last query or update function completing.

Therefore the complete formulation is:

: mathit{QthD} = frac{S imes 17 imes 3600}{T_s} imes mathit{SF}

Note that if the test sponsor chooses S=1 for the throughput test, for ease of benchmarking it is permissible to omit the throughput test and compute the throughput metric using timings obtained during the power test. Similarly, it is permissible to schedule the insert/delete activity for the throughput test after all the queries complete.Fact|date=February 2007

ee also

See Transaction Processing Performance Council (TPC).


Wikimedia Foundation. 2010.

Игры ⚽ Поможем написать реферат

Look at other dictionaries:

  • Transactions Per Second — In a very generic sense, the term Transactions Per Second refers to the number of atomic actions performed by certain entity per second. In a more restricted view, the term is usually used by DBMS vendor and user community to refer to the number… …   Wikipedia

  • Arzneimittelforschung — Als Pharmaforschung wird die in Pharmaunternehmen und Universitäten betriebene gezielte Suche nach neuen Wirkstoffen, neuen Wirkstoffkombinationen, neuen galenischen Formen, neuen Anwendungsgebieten für bestehende Arzneimittel und die Entwicklung …   Deutsch Wikipedia

  • Klinische Entwicklung — Als Pharmaforschung wird die in Pharmaunternehmen und Universitäten betriebene gezielte Suche nach neuen Wirkstoffen, neuen Wirkstoffkombinationen, neuen galenischen Formen, neuen Anwendungsgebieten für bestehende Arzneimittel und die Entwicklung …   Deutsch Wikipedia

  • Stuart Schreiber — Stuart L. Schreiber (b. February 6, 1956) is a scientist at Harvard University and the Broad Institute of Harvard and MIT. He has been a pioneer in a field of research named chemical biology for over 20 years. His name is closely associated with… …   Wikipedia

  • Protein nuclear magnetic resonance spectroscopy — (usually abbreviated protein NMR) is a field of structural biology in which NMR spectroscopy is used to obtain information about the structure and dynamics of proteins. The field was pioneered by, among others, Kurt Wüthrich, who shared the Nobel …   Wikipedia

  • Synthetic genetic array — analysis (SGA) is a high throughput technique for exploring synthetic lethal and synthetic sick genetic interactions (SSL). SGA allows for the systematic construction of double mutants using a combination of recombinant genetic techniques, mating …   Wikipedia

  • RAID — This article is about the data storage technology. For other uses, see Raid (disambiguation). RAID, an acronym for Redundant Array of Independent Disks (originally Redundant Array of Inexpensive Disks),[1] is a storage… …   Wikipedia

  • Expressed sequence tag — An expressed sequence tag or EST is a short sub sequence of a transcribed spliced nucleotide sequence (either protein coding or not). They may be used to identify gene transcripts, and are instrumental in gene discovery and gene sequence… …   Wikipedia

  • Netezza — Type Subsidiary of IBM Industry Data Warehousing Founded 2000 Headquarters Marlborough, Massachusetts, United States Key people Jitendra Saxena, Founder Foster Hi …   Wikipedia

  • George Yancopoulos — George D. Yancopoulos born 1959 in Middle Village, New York; Chief scientific officer and president of Regeneron Pharmaceuticals, Inc.. Dr. Yancopoulos has been elected to both the National Academy of Sciences and the American Academy of Arts and …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”