{"id":"https://openalex.org/W2932651700","doi":"https://doi.org/10.4225/03/5b1f4b20c2ffc","title":"Parallel query optimisation in clustered node distributed relational database systems","display_name":"Parallel query optimisation in clustered node distributed relational database systems","alternate_titles":[],"publication_year":2019,"publication_date":"2019-01-01","ids":{"openalex":"https://openalex.org/W2932651700","doi":"https://doi.org/10.4225/03/5b1f4b20c2ffc","mag":"2932651700"},"language":"en","primary_location":{"id":"pmh:oai:figshare.com:article/19548631","doi":null,"is_oa":false,"landing_page_url":"https://figshare.com/articles/thesis/Parallel_query_optimisation_in_clustered_node_distributed_relational_database_systems/19548631","pdf_url":null,"source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Thesis"},"parent_works":[],"lineage":["https://openalex.org/W2932651700"],"child_works_count":0,"type":"dissertation","is_traditional":true,"indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.4225/03/5b1f4b20c2ffc","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5078804750","display_name":"Greg Sinclair","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I56590836","display_name":"Monash University","ror":"https://ror.org/02bfwt286","country_code":"AU","type":"education","lineage":["https://openalex.org/I56590836"]}],"countries":["AU"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Sinclair, Greg","raw_affiliation_strings":["Monash University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Monash University","institution_ids":["https://openalex.org/I56590836"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5078804750"],"corresponding_institution_ids":["https://openalex.org/I56590836"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9932000041007996,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9932000041007996,"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"}},{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.004699999932199717,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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.0005000000237487257,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.847000002861023},{"id":"https://openalex.org/keywords/symmetric-multiprocessors","display_name":"symmetric multiprocessors","score":0.7710000276565552},{"id":"https://openalex.org/keywords/massively-parallel-computers","display_name":"massively parallel computers","score":0.9950000047683716},{"id":"https://openalex.org/keywords/parallel-architecture","display_name":"parallel architecture","score":0.6520000100135803}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8036198616027832},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.611937403678894},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.6011269092559814},{"id":"https://openalex.org/C190475519","wikidata":"https://www.wikidata.org/wiki/Q544384","display_name":"Massively parallel","level":2,"score":0.6009858250617981},{"id":"https://openalex.org/C2777541480","wikidata":"https://www.wikidata.org/wiki/Q2051600","display_name":"Parallel database","level":2,"score":0.5583298206329346},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5469919443130493},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.545717716217041},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5218509435653687},{"id":"https://openalex.org/C62611344","wikidata":"https://www.wikidata.org/wiki/Q1062658","display_name":"Node (physics)","level":2,"score":0.5107126235961914},{"id":"https://openalex.org/C4822641","wikidata":"https://www.wikidata.org/wiki/Q846651","display_name":"Multiprocessing","level":2,"score":0.4836191236972809},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.4590098261833191},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3362169563770294},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.290169358253479},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.23640140891075134},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1615709662437439},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1573607623577118},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C66938386","wikidata":"https://www.wikidata.org/wiki/Q633538","display_name":"Structural engineering","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"pmh:oai:figshare.com:article/19548631","doi":null,"is_oa":false,"landing_page_url":"https://figshare.com/articles/thesis/Parallel_query_optimisation_in_clustered_node_distributed_relational_database_systems/19548631","pdf_url":null,"source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Thesis"},{"id":"pmh:oai:figshare.com:article/6486464","doi":null,"is_oa":false,"landing_page_url":"https://figshare.com/articles/thesis/Parallel_query_optimisation_in_clustered_node_distributed_relational_database_systems/6486464","pdf_url":null,"source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Thesis"},{"id":"mag:2932651700","doi":null,"is_oa":false,"landing_page_url":"https://bridges.monash.edu/articles/Parallel_query_optimisation_in_clustered_node_distributed_relational_database_systems/6486464","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},{"id":"doi:10.4225/03/5b1f4b20c2ffc","doi":"https://doi.org/10.4225/03/5b1f4b20c2ffc","is_oa":true,"landing_page_url":"https://doi.org/10.4225/03/5b1f4b20c2ffc","pdf_url":null,"source":{"id":"https://openalex.org/S7407052105","display_name":"Monash University","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"doi:10.4225/03/5b1f4b20c2ffc","doi":"https://doi.org/10.4225/03/5b1f4b20c2ffc","is_oa":true,"landing_page_url":"https://doi.org/10.4225/03/5b1f4b20c2ffc","pdf_url":null,"source":{"id":"https://openalex.org/S7407052105","display_name":"Monash University","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W204077658","https://openalex.org/W131781224","https://openalex.org/W2090529051","https://openalex.org/W1153349592","https://openalex.org/W2002998768","https://openalex.org/W2500553209","https://openalex.org/W140037469","https://openalex.org/W4236208624","https://openalex.org/W1997020216","https://openalex.org/W1989152133"],"abstract_inverted_index":{"This":[0],"thesis":[1],"investigates":[2],"how":[3],"parallel":[4,17,38],"query":[5],"optimisation":[6],"techniques":[7],"for":[8],"relational":[9],"database":[10],"systems":[11],"can":[12],"be":[13],"utilised":[14],"on":[15],"varying":[16],"architectures.":[18,53],"Three":[19],"architectures":[20],"are":[21],"discussed:":[22],"Symmetrric":[23],"MultiProcessor":[24],"(SMP),":[25],"Clustered":[26],"Node":[27],"Processor":[28,33],"(CNP)":[29],"and":[30],"Massively":[31],"Parallel":[32],"(MPP).":[34],"All":[35],"exhibit":[36],"certain":[37],"properties,":[39],"but":[40],"vary":[41],"according":[42],"to":[43,51],"the":[44],"specific":[45],"architecture.":[46],"Particular":[47],"attention":[48],"is":[49],"devoted":[50],"CNP":[52],"[...]":[54]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2932651700","counts_by_year":[],"updated_date":"2026-11-20T13:11:24.684918","created_date":"2019-04-11T00:00:00"}
