{"id":"https://openalex.org/W1524108946","doi":"https://doi.org/10.1109/icde.1986.7266201","title":"Optimal granularity and degree of multiprogramming in a distributed database system","display_name":"Optimal granularity and degree of multiprogramming in a distributed database system","publication_year":1986,"publication_date":"1986-02-01","ids":{"openalex":"https://openalex.org/W1524108946","doi":"https://doi.org/10.1109/icde.1986.7266201","mag":"1524108946"},"language":"en","primary_location":{"id":"doi:10.1109/icde.1986.7266201","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.1986.7266201","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"1986 IEEE Second International Conference on Data Engineering","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5009021497","display_name":"K. H. Pun","orcid":null},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"K. H. Pun","raw_affiliation_strings":["Department of Computer Science, University of Illinois at Urbana-Champaign, 1304 West Springfield, Urbana, Illinois 61801, U.S.A"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Illinois at Urbana-Champaign, 1304 West Springfield, Urbana, Illinois 61801, U.S.A","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5002605044","display_name":"Geneva G. Belford","orcid":null},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"G. G. Belford","raw_affiliation_strings":["Department of Computer Science, University of Illinois at Urbana-Champaign, 1304 West Springfield, Urbana, Illinois 61801, U.S.A"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Illinois at Urbana-Champaign, 1304 West Springfield, Urbana, Illinois 61801, U.S.A","institution_ids":["https://openalex.org/I157725225"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5009021497"],"corresponding_institution_ids":["https://openalex.org/I157725225"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.11916947,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"13","last_page":"20"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.996399998664856,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9951000213623047,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-multitasking","display_name":"Computer multitasking","score":0.9080380201339722},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8498554825782776},{"id":"https://openalex.org/keywords/granularity","display_name":"Granularity","score":0.8034995794296265},{"id":"https://openalex.org/keywords/distributed-database","display_name":"Distributed database","score":0.7100396156311035},{"id":"https://openalex.org/keywords/concurrency-control","display_name":"Concurrency control","score":0.6936737895011902},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.630850613117218},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.6263181567192078},{"id":"https://openalex.org/keywords/two-phase-locking","display_name":"Two-phase locking","score":0.6043717861175537},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.5352991223335266},{"id":"https://openalex.org/keywords/lock","display_name":"Lock (firearm)","score":0.5042318105697632},{"id":"https://openalex.org/keywords/scheduling","display_name":"Scheduling (production processes)","score":0.49831366539001465},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.3823803961277008},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3768090009689331},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.23347654938697815},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.21896511316299438}],"concepts":[{"id":"https://openalex.org/C154556556","wikidata":"https://www.wikidata.org/wiki/Q192969","display_name":"Computer multitasking","level":2,"score":0.9080380201339722},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8498554825782776},{"id":"https://openalex.org/C177774035","wikidata":"https://www.wikidata.org/wiki/Q1246948","display_name":"Granularity","level":2,"score":0.8034995794296265},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.7100396156311035},{"id":"https://openalex.org/C84511453","wikidata":"https://www.wikidata.org/wiki/Q2914952","display_name":"Concurrency control","level":3,"score":0.6936737895011902},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.630850613117218},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.6263181567192078},{"id":"https://openalex.org/C131346163","wikidata":"https://www.wikidata.org/wiki/Q2290484","display_name":"Two-phase locking","level":5,"score":0.6043717861175537},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5352991223335266},{"id":"https://openalex.org/C174839445","wikidata":"https://www.wikidata.org/wiki/Q1134386","display_name":"Lock (firearm)","level":2,"score":0.5042318105697632},{"id":"https://openalex.org/C206729178","wikidata":"https://www.wikidata.org/wiki/Q2271896","display_name":"Scheduling (production processes)","level":2,"score":0.49831366539001465},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3823803961277008},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3768090009689331},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.23347654938697815},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.21896511316299438},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/icde.1986.7266201","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.1986.7266201","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"1986 IEEE Second International Conference on Data Engineering","raw_type":"proceedings-article"},{"id":"pmh:oai:hub.hku.hk:10722/151784","is_oa":false,"landing_page_url":"http://hdl.handle.net/10722/151784","pdf_url":null,"source":{"id":"https://openalex.org/S4377196271","display_name":"The HKU Scholars Hub (University of Hong Kong)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I889458895","host_organization_name":"University of Hong Kong","host_organization_lineage":["https://openalex.org/I889458895"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Conference_Paper"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2529514079","https://openalex.org/W2132007926","https://openalex.org/W1524108946","https://openalex.org/W2145951631","https://openalex.org/W2129824310","https://openalex.org/W2170688408","https://openalex.org/W1826152083","https://openalex.org/W4244671419","https://openalex.org/W2553577944","https://openalex.org/W2114047527"],"abstract_inverted_index":{"The":[0],"optimal":[1,100],"choices":[2,101],"of":[3,6,13,17,102,107],"granularity":[4,103],"(size":[5],"a":[7,24,30,46,56,64,123],"physical":[8],"lock)":[9],"and":[10,69,79,92,104],"the":[11,43,61,77,80,99,105],"degree":[12,106],"multiprogramming":[14,108],"(maximum":[15],"number":[16],"transactions":[18],"allowed":[19],"to":[20,115],"run":[21],"concurrently)":[22],"for":[23,33,45,63],"single-site":[25],"database":[26,48],"system":[27,49,70],"(SDBS)":[28],"using":[29],"locking":[31,82],"mechanism":[32],"concurrency":[34],"control":[35],"have":[36,75],"been":[37,53],"investigated":[38],"by":[39],"many":[40],"researchers,":[41],"but":[42],"case":[44],"distributed":[47],"(DDBS)":[50],"has":[51],"not":[52],"examined.":[54],"Using":[55],"simulation":[57],"model,":[58],"we":[59,74],"study":[60],"problem":[62],"DDBS":[65],"in":[66,109,118,122],"various":[67],"application":[68],"environments.":[71],"In":[72],"particular,":[73],"considered:":[76],"preclaim,":[78],"claim-as-needed":[81],"policies;":[83],"three":[84],"different":[85,89,94,110],"granule":[86],"placements;":[87],"two":[88,93],"transaction":[90],"sizes;":[91],"communication":[95],"delays.":[96],"Conclusions":[97],"concerning":[98],"environments":[111],"are":[112],"then":[113],"drawn":[114],"provide":[116],"guidelines":[117],"achieving":[119],"good":[120],"performance":[121],"DDBS.":[124]},"counts_by_year":[],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}