{"id":"https://openalex.org/W2026353622","doi":"https://doi.org/10.1016/0950-5849(96)01097-x","title":"Extending classical functional dependencies for physical database design","display_name":"Extending classical functional dependencies for physical database design","publication_year":1996,"publication_date":"1996-01-01","ids":{"openalex":"https://openalex.org/W2026353622","doi":"https://doi.org/10.1016/0950-5849(96)01097-x","mag":"2026353622"},"language":"en","primary_location":{"id":"doi:10.1016/0950-5849(96)01097-x","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0950-5849(96)01097-x","pdf_url":null,"source":{"id":"https://openalex.org/S205010575","display_name":"Information and Software Technology","issn_l":"0950-5849","issn":["0950-5849","1873-6025"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information and Software Technology","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/A5037961481","display_name":"Tok Wang Ling","orcid":"https://orcid.org/0000-0002-0496-0565"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Tok Wang Ling","raw_affiliation_strings":["Department of Information Systems & Computer Science, National University of Singapore, 119260 Singapore","Department of Information Systems and Computer Science, National University of Singapore, 119260 Singapore"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Information Systems & Computer Science, National University of Singapore, 119260 Singapore","institution_ids":["https://openalex.org/I165932596"]},{"raw_affiliation_string":"Department of Information Systems and Computer Science, National University of Singapore, 119260 Singapore","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110147715","display_name":"Cheng Hian Goh","orcid":null},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Cheng Hian Goh","raw_affiliation_strings":["Sloan School of Management, Massachusetts Institute of Technology, Cambridge, MA 02139, USA","Sloan School of Management, Massachusetts Institute of Technology, Cambridge, MA 02139 USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Sloan School of Management, Massachusetts Institute of Technology, Cambridge, MA 02139, USA","institution_ids":["https://openalex.org/I63966007"]},{"raw_affiliation_string":"Sloan School of Management, Massachusetts Institute of Technology, Cambridge, MA 02139 USA","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5019988958","display_name":"Mong Li Lee","orcid":"https://orcid.org/0000-0002-9636-388X"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Mong Li Lee","raw_affiliation_strings":["Department of Information Systems & Computer Science, National University of Singapore, 119260 Singapore","Department of Information Systems and Computer Science, National University of Singapore, 119260 Singapore"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Information Systems & Computer Science, National University of Singapore, 119260 Singapore","institution_ids":["https://openalex.org/I165932596"]},{"raw_affiliation_string":"Department of Information Systems and Computer Science, National University of Singapore, 119260 Singapore","institution_ids":["https://openalex.org/I165932596"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":3350,"currency":"USD","value_usd":3350},"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.18761949,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"38","issue":"9","first_page":"601","last_page":"608"},"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/T11719","display_name":"Data Quality and Management","score":0.9979000091552734,"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/T11106","display_name":"Data Management and Algorithms","score":0.9962000250816345,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.7586747407913208},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7231498956680298},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6772370338439941},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.6713845133781433},{"id":"https://openalex.org/keywords/dependency-theory","display_name":"Dependency theory (database theory)","score":0.602210521697998},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.6020862460136414},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.5630476474761963},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.513347327709198},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4521874487400055},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.37416744232177734}],"concepts":[{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.7586747407913208},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7231498956680298},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6772370338439941},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.6713845133781433},{"id":"https://openalex.org/C40683218","wikidata":"https://www.wikidata.org/wiki/Q5260625","display_name":"Dependency theory (database theory)","level":4,"score":0.602210521697998},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.6020862460136414},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.5630476474761963},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.513347327709198},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4521874487400055},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.37416744232177734}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1016/0950-5849(96)01097-x","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0950-5849(96)01097-x","pdf_url":null,"source":{"id":"https://openalex.org/S205010575","display_name":"Information and Software Technology","issn_l":"0950-5849","issn":["0950-5849","1873-6025"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information and Software Technology","raw_type":"journal-article"},{"id":"pmh:oai:scholarbank.nus.edu.sg:10635/99279","is_oa":false,"landing_page_url":"http://scholarbank.nus.edu.sg/handle/10635/99279","pdf_url":null,"source":{"id":"https://openalex.org/S7407052290","display_name":"National University of Singapore","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Scopus","raw_type":"Article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Responsible consumption and production","score":0.5400000214576721,"id":"https://metadata.un.org/sdg/12"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W1566656512","https://openalex.org/W1579617599","https://openalex.org/W1979491644","https://openalex.org/W1994410342","https://openalex.org/W2000773957","https://openalex.org/W2023663289","https://openalex.org/W2057491878","https://openalex.org/W2110810394","https://openalex.org/W2144192824","https://openalex.org/W2162621793","https://openalex.org/W2165467455","https://openalex.org/W2185907055","https://openalex.org/W2232207765","https://openalex.org/W2945526390","https://openalex.org/W6689392195"],"related_works":["https://openalex.org/W2027162968","https://openalex.org/W5016451","https://openalex.org/W1601072612","https://openalex.org/W2026353622","https://openalex.org/W2372251357","https://openalex.org/W1564781364","https://openalex.org/W204601728","https://openalex.org/W1820364323","https://openalex.org/W2153293871","https://openalex.org/W2535603002"],"abstract_inverted_index":null,"counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-06-23T06:36:01.041984","created_date":"2025-10-10T00:00:00"}