A performance comparison of multimicro and mainframe database architectures
The performance of a hypothetical multiprocessor back-end database machine is compared to that of a mainframe database system. The hypothetical database machine uses standard microprocessors and disks as well as processors and disks projected to be available in the future. The class of workloads con...
Gespeichert in:
| Veröffentlicht in: | IEEE transactions on software engineering 1988-04, Vol.14 (4), p.522-531 |
|---|---|
| Hauptverfasser: | , |
| Format: | Artikel |
| Sprache: | eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| container_end_page | 531 |
|---|---|
| container_issue | 4 |
| container_start_page | 522 |
| container_title | IEEE transactions on software engineering |
| container_volume | 14 |
| creator | Heidelberger, P. Lakshmi, M.S. |
| description | The performance of a hypothetical multiprocessor back-end database machine is compared to that of a mainframe database system. The hypothetical database machine uses standard microprocessors and disks as well as processors and disks projected to be available in the future. The class of workloads considered is high-volume transaction processing. Analytic queueing models of the two architectures are constructed and used in parametric performance studies. The performance sensitivities with respect to transactions complexity, the amount of overhead required to implement the distributed database function, the amount of skew in the data access pattern, and the buffer miss ratio are determined.< > |
| doi_str_mv | 10.1109/32.4675 |
| format | Article |
| fullrecord | <record><control><sourceid>proquest_RIE</sourceid><recordid>TN_cdi_ieee_primary_4675</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><ieee_id>4675</ieee_id><sourcerecordid>1142647</sourcerecordid><originalsourceid>FETCH-LOGICAL-c327t-44b1b706bd5693783bac72cdd0634433301ca0722635c4e3367dffbc6ef571ee3</originalsourceid><addsrcrecordid>eNpdkDtPwzAQgC0EEuUhVsYIIZhS7Jwf8VhVvEQlFpgjxzkLV3lhJwP_noRWHZhuuE-f7j5CrhhdMkb1A2RLLpU4IgumQacgMnpMFpTqPBUi16fkLMYtpVQoJRbkbZX0GFwXGtNaTGzX9Cb42LVJ55JmrAffeBu6xLRV0hjfumAaTCozmNJETEywX35AO4wB4wU5caaOeLmf5-Tz6fFj_ZJu3p9f16tNaiFTQ8p5yUpFZVkJqUHlUBqrMltVVALnAECZNVRlmQRhOQJIVTlXWolOKIYI5-Ru5-1D9z1iHIrGR4t1bVrsxlhkXAsFPJ_Am3_gthtDO91WMD3HUFJO0P0Omt6MMaAr-uAbE34KRou5aAFZMRedyNu9zkRr6ilFa3084GpqymAWXu8wj4iH7Z_hF7WOfC8</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype><pqid>195589766</pqid></control><display><type>article</type><title>A performance comparison of multimicro and mainframe database architectures</title><source>IEEE Electronic Library (IEL)</source><creator>Heidelberger, P. ; Lakshmi, M.S.</creator><creatorcontrib>Heidelberger, P. ; Lakshmi, M.S.</creatorcontrib><description>The performance of a hypothetical multiprocessor back-end database machine is compared to that of a mainframe database system. The hypothetical database machine uses standard microprocessors and disks as well as processors and disks projected to be available in the future. The class of workloads considered is high-volume transaction processing. Analytic queueing models of the two architectures are constructed and used in parametric performance studies. The performance sensitivities with respect to transactions complexity, the amount of overhead required to implement the distributed database function, the amount of skew in the data access pattern, and the buffer miss ratio are determined.< ></description><identifier>ISSN: 0098-5589</identifier><identifier>EISSN: 1939-3520</identifier><identifier>DOI: 10.1109/32.4675</identifier><identifier>CODEN: IESEDJ</identifier><language>eng</language><publisher>New York, NY: IEEE</publisher><subject>Applied sciences ; Architecture ; Computer science; control theory; systems ; Costs ; Database machines ; Database systems ; Delay ; Disk drives ; Distributed databases ; Exact sciences and technology ; Information systems. Data bases ; Mainframes ; Mathematical analysis ; Memory organisation. Data processing ; Microprocessors ; Minicomputers ; Performance analysis ; Processing speed ; Queries ; Queueing analysis ; Relational data bases ; Relational databases ; Response time ; Software ; Transaction databases ; Workloads</subject><ispartof>IEEE transactions on software engineering, 1988-04, Vol.14 (4), p.522-531</ispartof><rights>1989 INIST-CNRS</rights><rights>Copyright Institute of Electrical and Electronics Engineers, Inc. (IEEE) Apr 1988</rights><lds50>peer_reviewed</lds50><woscitedreferencessubscribed>false</woscitedreferencessubscribed><citedby>FETCH-LOGICAL-c327t-44b1b706bd5693783bac72cdd0634433301ca0722635c4e3367dffbc6ef571ee3</citedby></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://ieeexplore.ieee.org/document/4675$$EHTML$$P50$$Gieee$$H</linktohtml><link.rule.ids>314,776,780,792,27901,27902,54733</link.rule.ids><linktorsrc>$$Uhttps://ieeexplore.ieee.org/document/4675$$EView_record_in_IEEE$$FView_record_in_$$GIEEE</linktorsrc><backlink>$$Uhttp://pascal-francis.inist.fr/vibad/index.php?action=getRecordDetail&idt=7005136$$DView record in Pascal Francis$$Hfree_for_read</backlink></links><search><creatorcontrib>Heidelberger, P.</creatorcontrib><creatorcontrib>Lakshmi, M.S.</creatorcontrib><title>A performance comparison of multimicro and mainframe database architectures</title><title>IEEE transactions on software engineering</title><addtitle>TSE</addtitle><description>The performance of a hypothetical multiprocessor back-end database machine is compared to that of a mainframe database system. The hypothetical database machine uses standard microprocessors and disks as well as processors and disks projected to be available in the future. The class of workloads considered is high-volume transaction processing. Analytic queueing models of the two architectures are constructed and used in parametric performance studies. The performance sensitivities with respect to transactions complexity, the amount of overhead required to implement the distributed database function, the amount of skew in the data access pattern, and the buffer miss ratio are determined.< ></description><subject>Applied sciences</subject><subject>Architecture</subject><subject>Computer science; control theory; systems</subject><subject>Costs</subject><subject>Database machines</subject><subject>Database systems</subject><subject>Delay</subject><subject>Disk drives</subject><subject>Distributed databases</subject><subject>Exact sciences and technology</subject><subject>Information systems. Data bases</subject><subject>Mainframes</subject><subject>Mathematical analysis</subject><subject>Memory organisation. Data processing</subject><subject>Microprocessors</subject><subject>Minicomputers</subject><subject>Performance analysis</subject><subject>Processing speed</subject><subject>Queries</subject><subject>Queueing analysis</subject><subject>Relational data bases</subject><subject>Relational databases</subject><subject>Response time</subject><subject>Software</subject><subject>Transaction databases</subject><subject>Workloads</subject><issn>0098-5589</issn><issn>1939-3520</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>1988</creationdate><recordtype>article</recordtype><sourceid>8G5</sourceid><sourceid>BENPR</sourceid><sourceid>GUQSH</sourceid><sourceid>M2O</sourceid><recordid>eNpdkDtPwzAQgC0EEuUhVsYIIZhS7Jwf8VhVvEQlFpgjxzkLV3lhJwP_noRWHZhuuE-f7j5CrhhdMkb1A2RLLpU4IgumQacgMnpMFpTqPBUi16fkLMYtpVQoJRbkbZX0GFwXGtNaTGzX9Cb42LVJ55JmrAffeBu6xLRV0hjfumAaTCozmNJETEywX35AO4wB4wU5caaOeLmf5-Tz6fFj_ZJu3p9f16tNaiFTQ8p5yUpFZVkJqUHlUBqrMltVVALnAECZNVRlmQRhOQJIVTlXWolOKIYI5-Ru5-1D9z1iHIrGR4t1bVrsxlhkXAsFPJ_Am3_gthtDO91WMD3HUFJO0P0Omt6MMaAr-uAbE34KRou5aAFZMRedyNu9zkRr6ilFa3084GpqymAWXu8wj4iH7Z_hF7WOfC8</recordid><startdate>19880401</startdate><enddate>19880401</enddate><creator>Heidelberger, P.</creator><creator>Lakshmi, M.S.</creator><general>IEEE</general><general>Institute of Electrical and Electronics Engineers</general><general>IEEE Computer Society</general><scope>IQODW</scope><scope>AAYXX</scope><scope>CITATION</scope><scope>3V.</scope><scope>7WY</scope><scope>7WZ</scope><scope>7X7</scope><scope>7XB</scope><scope>87Z</scope><scope>88E</scope><scope>88F</scope><scope>88I</scope><scope>88K</scope><scope>8AL</scope><scope>8FE</scope><scope>8FG</scope><scope>8FI</scope><scope>8FJ</scope><scope>8FK</scope><scope>8FL</scope><scope>8G5</scope><scope>ABJCF</scope><scope>ABUWG</scope><scope>AFKRA</scope><scope>ARAPS</scope><scope>AZQEC</scope><scope>BENPR</scope><scope>BEZIV</scope><scope>BGLVJ</scope><scope>CCPQU</scope><scope>DWQXO</scope><scope>FRNLG</scope><scope>FYUFA</scope><scope>F~G</scope><scope>GHDGH</scope><scope>GNUQQ</scope><scope>GUQSH</scope><scope>HCIFZ</scope><scope>JQ2</scope><scope>K60</scope><scope>K6~</scope><scope>K7-</scope><scope>K9.</scope><scope>L.-</scope><scope>L6V</scope><scope>M0C</scope><scope>M0N</scope><scope>M0S</scope><scope>M1P</scope><scope>M1Q</scope><scope>M2O</scope><scope>M2P</scope><scope>M2T</scope><scope>M7S</scope><scope>MBDVC</scope><scope>P5Z</scope><scope>P62</scope><scope>PQBIZ</scope><scope>PQBZA</scope><scope>PQEST</scope><scope>PQQKQ</scope><scope>PQUKI</scope><scope>PRINS</scope><scope>PTHSS</scope><scope>Q9U</scope><scope>7SC</scope><scope>8FD</scope><scope>L7M</scope><scope>L~C</scope><scope>L~D</scope></search><sort><creationdate>19880401</creationdate><title>A performance comparison of multimicro and mainframe database architectures</title><author>Heidelberger, P. ; Lakshmi, M.S.</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-c327t-44b1b706bd5693783bac72cdd0634433301ca0722635c4e3367dffbc6ef571ee3</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>1988</creationdate><topic>Applied sciences</topic><topic>Architecture</topic><topic>Computer science; control theory; systems</topic><topic>Costs</topic><topic>Database machines</topic><topic>Database systems</topic><topic>Delay</topic><topic>Disk drives</topic><topic>Distributed databases</topic><topic>Exact sciences and technology</topic><topic>Information systems. Data bases</topic><topic>Mainframes</topic><topic>Mathematical analysis</topic><topic>Memory organisation. Data processing</topic><topic>Microprocessors</topic><topic>Minicomputers</topic><topic>Performance analysis</topic><topic>Processing speed</topic><topic>Queries</topic><topic>Queueing analysis</topic><topic>Relational data bases</topic><topic>Relational databases</topic><topic>Response time</topic><topic>Software</topic><topic>Transaction databases</topic><topic>Workloads</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Heidelberger, P.</creatorcontrib><creatorcontrib>Lakshmi, M.S.</creatorcontrib><collection>Pascal-Francis</collection><collection>CrossRef</collection><collection>ProQuest Central (Corporate)</collection><collection>ABI/INFORM Collection</collection><collection>ABI/INFORM Global (PDF only)</collection><collection>Health & Medical Collection</collection><collection>ProQuest Central (purchase pre-March 2016)</collection><collection>ABI/INFORM Global (Alumni Edition)</collection><collection>Medical Database (Alumni Edition)</collection><collection>Military Database (Alumni Edition)</collection><collection>Science Database (Alumni Edition)</collection><collection>Telecommunications (Alumni Edition)</collection><collection>Computing Database (Alumni Edition)</collection><collection>ProQuest SciTech Collection</collection><collection>ProQuest Technology Collection</collection><collection>Hospital Premium Collection</collection><collection>Hospital Premium Collection (Alumni Edition)</collection><collection>ProQuest Central (Alumni) (purchase pre-March 2016)</collection><collection>ABI/INFORM Collection (Alumni Edition)</collection><collection>Research Library (Alumni Edition)</collection><collection>Materials Science & Engineering Collection</collection><collection>ProQuest Central (Alumni Edition)</collection><collection>ProQuest Central UK/Ireland</collection><collection>Advanced Technologies & Aerospace Collection</collection><collection>ProQuest Central Essentials</collection><collection>ProQuest Central</collection><collection>Business Premium Collection</collection><collection>Technology Collection</collection><collection>ProQuest One Community College</collection><collection>ProQuest Central Korea</collection><collection>Business Premium Collection (Alumni)</collection><collection>Health Research Premium Collection</collection><collection>ABI/INFORM Global (Corporate)</collection><collection>Health Research Premium Collection (Alumni)</collection><collection>ProQuest Central Student</collection><collection>Research Library Prep</collection><collection>SciTech Premium Collection</collection><collection>ProQuest Computer Science Collection</collection><collection>ProQuest Business Collection (Alumni Edition)</collection><collection>ProQuest Business Collection</collection><collection>Computer Science Database</collection><collection>ProQuest Health & Medical Complete (Alumni)</collection><collection>ABI/INFORM Professional Advanced</collection><collection>ProQuest Engineering Collection</collection><collection>ABI/INFORM Global</collection><collection>Computing Database</collection><collection>Health & Medical Collection (Alumni Edition)</collection><collection>Medical Database</collection><collection>Military Database</collection><collection>Research Library</collection><collection>Science Database</collection><collection>Telecommunications Database</collection><collection>Engineering Database</collection><collection>Research Library (Corporate)</collection><collection>Advanced Technologies & Aerospace Database</collection><collection>ProQuest Advanced Technologies & Aerospace Collection</collection><collection>One Business (ProQuest)</collection><collection>ProQuest One Business (Alumni)</collection><collection>ProQuest One Academic Eastern Edition (DO NOT USE)</collection><collection>ProQuest One Academic</collection><collection>ProQuest One Academic UKI Edition</collection><collection>ProQuest Central China</collection><collection>Engineering Collection</collection><collection>ProQuest Central Basic</collection><collection>Computer and Information Systems Abstracts</collection><collection>Technology Research Database</collection><collection>Advanced Technologies Database with Aerospace</collection><collection>Computer and Information Systems Abstracts Academic</collection><collection>Computer and Information Systems Abstracts Professional</collection><jtitle>IEEE transactions on software engineering</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Heidelberger, P.</au><au>Lakshmi, M.S.</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>A performance comparison of multimicro and mainframe database architectures</atitle><jtitle>IEEE transactions on software engineering</jtitle><stitle>TSE</stitle><date>1988-04-01</date><risdate>1988</risdate><volume>14</volume><issue>4</issue><spage>522</spage><epage>531</epage><pages>522-531</pages><issn>0098-5589</issn><eissn>1939-3520</eissn><coden>IESEDJ</coden><abstract>The performance of a hypothetical multiprocessor back-end database machine is compared to that of a mainframe database system. The hypothetical database machine uses standard microprocessors and disks as well as processors and disks projected to be available in the future. The class of workloads considered is high-volume transaction processing. Analytic queueing models of the two architectures are constructed and used in parametric performance studies. The performance sensitivities with respect to transactions complexity, the amount of overhead required to implement the distributed database function, the amount of skew in the data access pattern, and the buffer miss ratio are determined.< ></abstract><cop>New York, NY</cop><pub>IEEE</pub><doi>10.1109/32.4675</doi><tpages>10</tpages></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | ISSN: 0098-5589 |
| ispartof | IEEE transactions on software engineering, 1988-04, Vol.14 (4), p.522-531 |
| issn | 0098-5589 1939-3520 |
| language | eng |
| recordid | cdi_ieee_primary_4675 |
| source | IEEE Electronic Library (IEL) |
| subjects | Applied sciences Architecture Computer science control theory systems Costs Database machines Database systems Delay Disk drives Distributed databases Exact sciences and technology Information systems. Data bases Mainframes Mathematical analysis Memory organisation. Data processing Microprocessors Minicomputers Performance analysis Processing speed Queries Queueing analysis Relational data bases Relational databases Response time Software Transaction databases Workloads |
| title | A performance comparison of multimicro and mainframe database architectures |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-30T04%3A36%3A29IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-proquest_RIE&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=A%20performance%20comparison%20of%20multimicro%20and%20mainframe%20database%20architectures&rft.jtitle=IEEE%20transactions%20on%20software%20engineering&rft.au=Heidelberger,%20P.&rft.date=1988-04-01&rft.volume=14&rft.issue=4&rft.spage=522&rft.epage=531&rft.pages=522-531&rft.issn=0098-5589&rft.eissn=1939-3520&rft.coden=IESEDJ&rft_id=info:doi/10.1109/32.4675&rft_dat=%3Cproquest_RIE%3E1142647%3C/proquest_RIE%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_pqid=195589766&rft_id=info:pmid/&rft_ieee_id=4675&rfr_iscdi=true |