{"id":"https://openalex.org/W2784372759","doi":"https://doi.org/10.1145/3194164.3194170","title":"Prioritizing technical debt in database normalization using portfolio theory and data quality metrics","display_name":"Prioritizing technical debt in database normalization using portfolio theory and data quality metrics","publication_year":2018,"publication_date":"2018-05-27","ids":{"openalex":"https://openalex.org/W2784372759","doi":"https://doi.org/10.1145/3194164.3194170","mag":"2784372759"},"language":"en","primary_location":{"id":"doi:10.1145/3194164.3194170","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3194164.3194170","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2018 International Conference on Technical Debt","raw_type":"proceedings-article"},"type":"preprint","indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/1801.06989","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5036794666","display_name":"Mashel Albarak","orcid":null},"institutions":[{"id":"https://openalex.org/I79619799","display_name":"University of Birmingham","ror":"https://ror.org/03angcq70","country_code":"GB","type":"education","lineage":["https://openalex.org/I79619799"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Mashel Albarak","raw_affiliation_strings":["University of Birmingham, UK and King Saud University, KSA","University of Birmingham, UK and King Saud University, KSA#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Birmingham, UK and King Saud University, KSA","institution_ids":["https://openalex.org/I79619799"]},{"raw_affiliation_string":"University of Birmingham, UK and King Saud University, KSA#TAB#","institution_ids":["https://openalex.org/I79619799"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5031155155","display_name":"Rami Bahsoon","orcid":"https://orcid.org/0000-0002-1139-5795"},"institutions":[{"id":"https://openalex.org/I79619799","display_name":"University of Birmingham","ror":"https://ror.org/03angcq70","country_code":"GB","type":"education","lineage":["https://openalex.org/I79619799"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Rami Bahsoon","raw_affiliation_strings":["University of Birmingham, UK","University of Birmingham UK#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Birmingham, UK","institution_ids":["https://openalex.org/I79619799"]},{"raw_affiliation_string":"University of Birmingham UK#TAB#","institution_ids":["https://openalex.org/I79619799"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5036794666"],"corresponding_institution_ids":["https://openalex.org/I79619799"],"apc_list":null,"apc_paid":null,"fwci":0.2201,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":{"value":0.57853578,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"31","last_page":"40"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9983000159263611,"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/T12127","display_name":"Software System Performance and Reliability","score":0.9983000159263611,"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/technical-debt","display_name":"Technical debt","score":0.900627076625824},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6892153024673462},{"id":"https://openalex.org/keywords/normalization","display_name":"Normalization (sociology)","score":0.5930922031402588},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5061647295951843},{"id":"https://openalex.org/keywords/data-quality","display_name":"Data quality","score":0.49971771240234375},{"id":"https://openalex.org/keywords/portfolio","display_name":"Portfolio","score":0.466182678937912},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.42810964584350586},{"id":"https://openalex.org/keywords/metric","display_name":"Metric (unit)","score":0.4200289249420166},{"id":"https://openalex.org/keywords/debt","display_name":"Debt","score":0.41831791400909424},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3871457576751709},{"id":"https://openalex.org/keywords/finance","display_name":"Finance","score":0.2052089273929596},{"id":"https://openalex.org/keywords/economics","display_name":"Economics","score":0.10278013348579407},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.09187781810760498},{"id":"https://openalex.org/keywords/operations-management","display_name":"Operations management","score":0.0810118317604065}],"concepts":[{"id":"https://openalex.org/C159198006","wikidata":"https://www.wikidata.org/wiki/Q1532172","display_name":"Technical debt","level":4,"score":0.900627076625824},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6892153024673462},{"id":"https://openalex.org/C136886441","wikidata":"https://www.wikidata.org/wiki/Q926129","display_name":"Normalization (sociology)","level":2,"score":0.5930922031402588},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5061647295951843},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.49971771240234375},{"id":"https://openalex.org/C2780821815","wikidata":"https://www.wikidata.org/wiki/Q5340806","display_name":"Portfolio","level":2,"score":0.466182678937912},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.42810964584350586},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.4200289249420166},{"id":"https://openalex.org/C120527767","wikidata":"https://www.wikidata.org/wiki/Q3196867","display_name":"Debt","level":2,"score":0.41831791400909424},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3871457576751709},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.2052089273929596},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.10278013348579407},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.09187781810760498},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0810118317604065},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.0},{"id":"https://openalex.org/C529173508","wikidata":"https://www.wikidata.org/wiki/Q638608","display_name":"Software development","level":3,"score":0.0},{"id":"https://openalex.org/C19165224","wikidata":"https://www.wikidata.org/wiki/Q23404","display_name":"Anthropology","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/3194164.3194170","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3194164.3194170","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2018 International Conference on Technical Debt","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:1801.06989","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1801.06989","pdf_url":"https://arxiv.org/pdf/1801.06989","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.1801.06989","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.1801.06989","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"},{"id":"mag:2784372759","is_oa":false,"landing_page_url":null,"pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":null}],"best_oa_location":{"id":"pmh:oai:arXiv.org:1801.06989","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1801.06989","pdf_url":"https://arxiv.org/pdf/1801.06989","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[{"score":0.49000000953674316,"id":"https://metadata.un.org/sdg/17","display_name":"Partnerships for the goals"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2784372759.pdf","grobid_xml":"https://content.openalex.org/works/W2784372759.grobid-xml"},"referenced_works_count":27,"referenced_works":["https://openalex.org/W1606072989","https://openalex.org/W1826514372","https://openalex.org/W1942656133","https://openalex.org/W1964639690","https://openalex.org/W1965658570","https://openalex.org/W1968024235","https://openalex.org/W1969254353","https://openalex.org/W1985281788","https://openalex.org/W2022424113","https://openalex.org/W2028836139","https://openalex.org/W2041034497","https://openalex.org/W2060038150","https://openalex.org/W2088108067","https://openalex.org/W2088569554","https://openalex.org/W2185907055","https://openalex.org/W2324136837","https://openalex.org/W2404303593","https://openalex.org/W2526133847","https://openalex.org/W2548459597","https://openalex.org/W2559773154","https://openalex.org/W2566179807","https://openalex.org/W2748830514","https://openalex.org/W2963592076","https://openalex.org/W2998678832","https://openalex.org/W3146212093","https://openalex.org/W4232474910","https://openalex.org/W4233021613"],"related_works":["https://openalex.org/W3034823781","https://openalex.org/W3210064151","https://openalex.org/W2897680932","https://openalex.org/W2107019679","https://openalex.org/W2035005585","https://openalex.org/W2182070661","https://openalex.org/W2883702103","https://openalex.org/W2294833667","https://openalex.org/W2611931666","https://openalex.org/W2144241057","https://openalex.org/W1807304362","https://openalex.org/W2754717618","https://openalex.org/W2053135266","https://openalex.org/W3104590834","https://openalex.org/W3023664246","https://openalex.org/W2127024819","https://openalex.org/W3105083100","https://openalex.org/W2788138948","https://openalex.org/W2075710532","https://openalex.org/W2280448054"],"abstract_inverted_index":{"Database":[0],"normalization":[1,15,251],"is":[2,39,94,165],"the":[3,26,78,89,92,114,120,126,142,156,180,184,214,219,226,255,258],"one":[4],"of":[5,14,34,53,125,144,158,179,201,222,257],"main":[6],"principles":[7],"for":[8,75,87,195],"designing":[9],"relational":[10],"databases.":[11,43],"The":[12,240],"benefits":[13],"can":[16,46,58,246],"be":[17,59,111,210,247],"observed":[18,129],"through":[19],"improving":[20,254],"data":[21,131,136,145,149],"quality":[22,132,256],"and":[23,97,123,133,172,186,218,253],"performance,":[24],"among":[25],"other":[27],"qualities.":[28,55],"We":[29,67,168,198],"explore":[30],"a":[31,65,95,103,151,189,234],"new":[32],"context":[33],"technical":[35],"debt":[36,45,122,252],"manifestation,":[37],"which":[38],"linked":[40],"to":[41,61,73,106,113,154,191,205],"ill-normalized":[42,127],"This":[44],"have":[47],"long-term":[48],"impact":[49,157],"causing":[50],"systematic":[51],"degradation":[52,57,171],"database":[54,93],"Such":[56],"liken":[60],"accumulated":[62],"interest":[63,124],"on":[64,119,130,163,183,213],"debt.":[66],"claim":[68],"that":[69,109,208,243],"debts":[70],"are":[71,139],"likely":[72,220],"materialize":[74],"tables":[76,90,108,138,162,185,207],"below":[77],"fourth":[79,84,115],"normal":[80,85,116],"form.":[81],"Practically,":[82],"achieving":[83],"form":[86,117],"all":[88],"in":[91,225,249],"costly":[96],"idealistic":[98],"exercise.":[99],"Therefore,":[100],"we":[101,187,232],"propose":[102,188],"pragmatic":[104],"approach":[105],"prioritize":[107,206],"should":[110,209],"normalized":[112,211],"based":[118,212],"metaphoric":[121],"tables,":[128],"performance.":[134],"For":[135],"quality,":[137,150],"prioritized":[140],"using":[141,175],"risk":[143,221],"inconsistency":[146],"metric.":[147],"Unlike":[148],"suitable":[152],"metric":[153],"estimate":[155,169,192],"weakly":[159],"or":[160],"un-normalized":[161],"performance":[164,170],"not":[166],"available.":[167],"its":[173],"costs":[174],"Input/Output":[176],"(I/O)":[177],"cost":[178,194,217,223],"operations":[181],"performed":[182],"model":[190],"this":[193],"each":[196],"table.":[197],"make":[199],"use":[200,233],"Modern":[202],"Portfolio":[203],"Theory":[204],"estimated":[215],"I/O":[216],"accumulation":[224],"future.":[227],"To":[228],"evaluate":[229],"our":[230,244],"methods,":[231],"case":[235],"study":[236],"from":[237],"Microsoft,":[238],"AdventureWorks.":[239],"results":[241],"show":[242],"methods":[245],"effective":[248],"reducing":[250],"database.":[259]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2019,"cited_by_count":1}],"updated_date":"2026-03-21T08:13:44.787528","created_date":"2022-10-04T00:00:00"}