{"id":"https://openalex.org/W2008129477","doi":"https://doi.org/10.1002/spe.4380171004","title":"A processing algorithm for master\u2014detail records in a relational database","display_name":"A processing algorithm for master\u2014detail records in a relational database","publication_year":1987,"publication_date":"1987-10-01","ids":{"openalex":"https://openalex.org/W2008129477","doi":"https://doi.org/10.1002/spe.4380171004","mag":"2008129477"},"language":"en","primary_location":{"id":"doi:10.1002/spe.4380171004","is_oa":false,"landing_page_url":"https://doi.org/10.1002/spe.4380171004","pdf_url":null,"source":{"id":"https://openalex.org/S122199241","display_name":"Software Practice and Experience","issn_l":"0038-0644","issn":["0038-0644","1097-024X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software: Practice and Experience","raw_type":"journal-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/A5077751717","display_name":"William I. Bullers","orcid":null},"institutions":[{"id":"https://openalex.org/I169521973","display_name":"University of New Mexico","ror":"https://ror.org/05fs6jp91","country_code":"US","type":"education","lineage":["https://openalex.org/I169521973"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"William I. Bullers","raw_affiliation_strings":["Anderson Schools of Management, University of New Mexico, Albuquerque, NM 87131, U.S.A","University of New Mexico-Albuquerque"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Anderson Schools of Management, University of New Mexico, Albuquerque, NM 87131, U.S.A","institution_ids":["https://openalex.org/I169521973"]},{"raw_affiliation_string":"University of New Mexico-Albuquerque","institution_ids":["https://openalex.org/I169521973"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5077751717"],"corresponding_institution_ids":["https://openalex.org/I169521973"],"apc_list":{"value":4650,"currency":"USD","value_usd":4650},"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.17980769,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"17","issue":"10","first_page":"701","last_page":"717"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"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/T11106","display_name":"Data Management and Algorithms","score":0.9984999895095825,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9679999947547913,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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-database","display_name":"Relational database","score":0.7608388066291809},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.753956139087677},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6380178928375244},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.6122202277183533},{"id":"https://openalex.org/keywords/implementation","display_name":"Implementation","score":0.6106659173965454},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.5272333025932312},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.5083805918693542},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.503858745098114},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.4508138597011566},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.44872891902923584},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.43514424562454224},{"id":"https://openalex.org/keywords/zero","display_name":"Zero (linguistics)","score":0.4317561388015747},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3527977764606476},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.34872353076934814},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2993207573890686},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.11972829699516296}],"concepts":[{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7608388066291809},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.753956139087677},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6380178928375244},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.6122202277183533},{"id":"https://openalex.org/C26713055","wikidata":"https://www.wikidata.org/wiki/Q245962","display_name":"Implementation","level":2,"score":0.6106659173965454},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.5272333025932312},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5083805918693542},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.503858745098114},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4508138597011566},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.44872891902923584},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.43514424562454224},{"id":"https://openalex.org/C2780813799","wikidata":"https://www.wikidata.org/wiki/Q3274237","display_name":"Zero (linguistics)","level":2,"score":0.4317561388015747},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3527977764606476},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.34872353076934814},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2993207573890686},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11972829699516296},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1002/spe.4380171004","is_oa":false,"landing_page_url":"https://doi.org/10.1002/spe.4380171004","pdf_url":null,"source":{"id":"https://openalex.org/S122199241","display_name":"Software Practice and Experience","issn_l":"0038-0644","issn":["0038-0644","1097-024X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software: Practice and Experience","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W165391855","https://openalex.org/W1525711345","https://openalex.org/W1573719111","https://openalex.org/W1970745732","https://openalex.org/W1990973142","https://openalex.org/W2003517056","https://openalex.org/W2028052727","https://openalex.org/W2044860716","https://openalex.org/W2048829837","https://openalex.org/W2056717387","https://openalex.org/W2056892625","https://openalex.org/W2087578516","https://openalex.org/W2103953153","https://openalex.org/W2122789628","https://openalex.org/W2138709157","https://openalex.org/W2165467455","https://openalex.org/W2185907055","https://openalex.org/W2207371067","https://openalex.org/W2313469048","https://openalex.org/W2334940765","https://openalex.org/W2337288897","https://openalex.org/W2489748212","https://openalex.org/W2922111407","https://openalex.org/W2966001939"],"related_works":["https://openalex.org/W2483382562","https://openalex.org/W3085968255","https://openalex.org/W4248533530","https://openalex.org/W2386848747","https://openalex.org/W4297044271","https://openalex.org/W73223004","https://openalex.org/W2626533837","https://openalex.org/W2393499861","https://openalex.org/W2392855649","https://openalex.org/W2376710457"],"abstract_inverted_index":{"Abstract":[0],"Large":[1],"numbers":[2],"of":[3,9,55,91],"data":[4],"processing":[5,8,86],"applications":[6],"require":[7],"master":[10,20],"records":[11],"and":[12,21,30,50,81],"their":[13,46],"associated":[14],"detail":[15,22],"records.":[16],"These":[17],"relationships":[18],"between":[19],"files":[23],"may":[24],"be":[25],"classified":[26],"as":[27],"one\u2010to\u2010many,":[28],"zero\u2010or\u2010one\u2010to\u2010many":[29,56],"many\u2010to\u2010many.":[31],"All":[32],"are":[33],"important":[34],"to":[35,48,84],"information":[36],"systems,":[37],"but":[38],"database":[39,101],"management":[40,102],"system":[41,103],"implementations":[42],"differ":[43],"widely":[44],"in":[45,58,62],"ability":[47],"represent":[49],"process":[51],"such":[52,76],"relationships.":[53],"Processing":[54],"relationships,":[57],"particular,":[59],"is":[60,79,87,95],"difficult":[61],"most":[63],"relational":[64,68],"databases.":[65],"An":[66,89],"obscure":[67],"algebra":[69],"operator,":[70],"left":[71,92],"outer":[72,93],"join,":[73],"that":[74],"provides":[75],"a":[77,100],"capability":[78],"described":[80],"its":[82],"importance":[83],"master\u2010detail":[85],"illustrated.":[88],"implementation":[90],"join":[94],"presented":[96],"for":[97],"dBase":[98],"III,":[99],"providing":[104],"some":[105],"relational\u2010like":[106],"capability.":[107]},"counts_by_year":[],"updated_date":"2026-08-21T09:56:20.448147","created_date":"2025-10-10T00:00:00"}