{"id":"https://openalex.org/W1563672557","doi":"https://doi.org/10.1145/1017914.1017915","title":"An approach to analyzing the information content of existing databases","display_name":"An approach to analyzing the information content of existing databases","publication_year":1989,"publication_date":"1989-07-01","ids":{"openalex":"https://openalex.org/W1563672557","doi":"https://doi.org/10.1145/1017914.1017915","mag":"1563672557"},"language":"en","primary_location":{"id":"doi:10.1145/1017914.1017915","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1017914.1017915","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1017914.1017915","source":{"id":"https://openalex.org/S4210234096","display_name":"ACM SIGMIS Database the DATABASE for Advances in Information Systems","issn_l":"1532-0936","issn":["1532-0936","2331-1622"],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMIS Database: the DATABASE for Advances in Information Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/1017914.1017915","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5037816423","display_name":"Danielle Boulanger","orcid":null},"institutions":[{"id":"https://openalex.org/I203339264","display_name":"Universit\u00e9 de Lyon","ror":"https://ror.org/01rk35k63","country_code":"FR","type":"education","lineage":["https://openalex.org/I203339264"]}],"countries":["FR"],"is_corresponding":true,"raw_author_name":"Danielle Boulanger","raw_affiliation_strings":["University of Lyon"],"affiliations":[{"raw_affiliation_string":"University of Lyon","institution_ids":["https://openalex.org/I203339264"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110377345","display_name":"Sal March","orcid":null},"institutions":[{"id":"https://openalex.org/I130238516","display_name":"University of Minnesota","ror":"https://ror.org/017zqws13","country_code":"US","type":"education","lineage":["https://openalex.org/I130238516"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Salvatore T. March","raw_affiliation_strings":["University of Minnesota, Minneapolis, MN","University of Minnesota , Minneapolis, Mn"],"affiliations":[{"raw_affiliation_string":"University of Minnesota, Minneapolis, MN","institution_ids":["https://openalex.org/I130238516"]},{"raw_affiliation_string":"University of Minnesota , Minneapolis, Mn","institution_ids":["https://openalex.org/I130238516"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5037816423"],"corresponding_institution_ids":["https://openalex.org/I203339264"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.10863619,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":"20","issue":"2","first_page":"1","last_page":"8"},"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.9983999729156494,"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.9983999729156494,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9904000163078308,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9868000149726868,"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/computer-science","display_name":"Computer science","score":0.8711764216423035},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6640690565109253},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.6165990829467773},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5472922921180725},{"id":"https://openalex.org/keywords/database-administrator","display_name":"Database administrator","score":0.4980173110961914},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.44657814502716064},{"id":"https://openalex.org/keywords/semi-structured-data","display_name":"Semi-structured data","score":0.43027007579803467},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.4243320822715759},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.41862866282463074},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.40969398617744446},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.3469366133213043},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.13839101791381836}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8711764216423035},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6640690565109253},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.6165990829467773},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5472922921180725},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.4980173110961914},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.44657814502716064},{"id":"https://openalex.org/C40077939","wikidata":"https://www.wikidata.org/wiki/Q2336004","display_name":"Semi-structured data","level":3,"score":0.43027007579803467},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.4243320822715759},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.41862866282463074},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.40969398617744446},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3469366133213043},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.13839101791381836},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1017914.1017915","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1017914.1017915","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1017914.1017915","source":{"id":"https://openalex.org/S4210234096","display_name":"ACM SIGMIS Database the DATABASE for Advances in Information Systems","issn_l":"1532-0936","issn":["1532-0936","2331-1622"],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMIS Database: the DATABASE for Advances in Information Systems","raw_type":"journal-article"},{"id":"mag:1563672557","is_oa":false,"landing_page_url":"http://dl.acm.org/citation.cfm?id=71294.71295","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":"Database","raw_type":null}],"best_oa_location":{"id":"doi:10.1145/1017914.1017915","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1017914.1017915","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1017914.1017915","source":{"id":"https://openalex.org/S4210234096","display_name":"ACM SIGMIS Database the DATABASE for Advances in Information Systems","issn_l":"1532-0936","issn":["1532-0936","2331-1622"],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMIS Database: the DATABASE for Advances in Information Systems","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.5099999904632568,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W1563672557.pdf","grobid_xml":"https://content.openalex.org/works/W1563672557.grobid-xml"},"referenced_works_count":18,"referenced_works":["https://openalex.org/W43035074","https://openalex.org/W125258800","https://openalex.org/W155731118","https://openalex.org/W1493271160","https://openalex.org/W1496821575","https://openalex.org/W1581093035","https://openalex.org/W1976687592","https://openalex.org/W2021611189","https://openalex.org/W2023663289","https://openalex.org/W2037817502","https://openalex.org/W2040286084","https://openalex.org/W2057773300","https://openalex.org/W2105155294","https://openalex.org/W2110810394","https://openalex.org/W2945526390","https://openalex.org/W6603244032","https://openalex.org/W6630708041","https://openalex.org/W6680456638"],"related_works":["https://openalex.org/W2335156424","https://openalex.org/W233107109","https://openalex.org/W1505684859","https://openalex.org/W1579035201","https://openalex.org/W2052160115","https://openalex.org/W1943213095","https://openalex.org/W1554471037","https://openalex.org/W2917641211","https://openalex.org/W2114684560","https://openalex.org/W1590548082","https://openalex.org/W2911768431","https://openalex.org/W2059306300","https://openalex.org/W2756524134","https://openalex.org/W2144632243","https://openalex.org/W2612066497","https://openalex.org/W115407445","https://openalex.org/W2606807332","https://openalex.org/W165101881","https://openalex.org/W3213424333","https://openalex.org/W2582799616"],"abstract_inverted_index":{"Traditionally,":[0],"application":[1,23],"databases":[2,49,60,135],"have":[3],"been":[4],"developed":[5],"for":[6],"efficiency":[7],"of":[8,14,58,96,113],"computer":[9,72],"operations.":[10],"The":[11,54,75,129],"logical":[12,38],"structure":[13],"the":[15,20,37,94,97,109],"data":[16,39],"is":[17,77],"buried":[18],"in":[19,117,126,134],"database":[21,86],"schemas,":[22],"programs,":[24],"and":[25,27,56,88,104],"users'":[26],"programmers'":[28],"minds.":[29],"To":[30],"manage":[31],"information":[32],"as":[33],"a":[34,62,71],"corporate":[35,59],"resource":[36],"structures":[40],"must":[41],"be":[42,51],"made":[43],"explicit.":[44],"In":[45],"this":[46,66,127],"way":[47],"organizational":[48],"can":[50],"conceptually":[52],"integrated.":[53],"magnitude":[55],"complexity":[57],"makes":[61],"manual":[63],"approach":[64,76,130],"to":[65,139],"task":[67],"infeasible.":[68],"We":[69],"propose":[70],"aided":[73],"approach.":[74],"based":[78],"on":[79,122],"extracting":[80],"implicit":[81],"functional":[82],"dependencies":[83],"from":[84,108,136],"existing":[85],"schemas":[87],"forming":[89],"an":[90],"Entity-Relationship":[91],"representation.":[92],"Where":[93],"semantics":[95],"schema":[98],"are":[99,102],"unclear,":[100],"rules":[101],"applied":[103],"additional":[105],"input":[106],"sought":[107],"Data":[110],"Administrator.":[111],"Because":[112],"its":[114],"widespread":[115],"use":[116],"production":[118],"systems,":[119],"we":[120],"focus":[121],"CODASYL":[123],"Network":[124],"DBMSs":[125],"paper.":[128],"also":[131],"has":[132],"applications":[133],"one":[137],"DBMS":[138],"another.":[140]},"counts_by_year":[{"year":2016,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}