{"id":"https://openalex.org/W1978969411","doi":"https://doi.org/10.1145/248603.248615","title":"Extraction of object-oriented structures from existing relational databases","display_name":"Extraction of object-oriented structures from existing relational databases","alternate_titles":[],"publication_year":1997,"publication_date":"1997-03-01","ids":{"openalex":"https://openalex.org/W1978969411","doi":"https://doi.org/10.1145/248603.248615","mag":"1978969411"},"language":"en","primary_location":{"id":"doi:10.1145/248603.248615","doi":"https://doi.org/10.1145/248603.248615","is_oa":true,"landing_page_url":"https://doi.org/10.1145/248603.248615","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/248603.248615","source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"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 SIGMOD Record","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W1978969411"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/248603.248615","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5068956924","display_name":"Shekar Ramanathan","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I99041443","display_name":"Mississippi State University","ror":"https://ror.org/0432jq872","country_code":"US","type":"education","lineage":["https://openalex.org/I4210141039","https://openalex.org/I99041443"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shekar Ramanathan","raw_affiliation_strings":["Department of Computer Science, Mississippi State University","Department of Computer Science, Mississippi State University#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Mississippi State University","institution_ids":["https://openalex.org/I99041443"]},{"raw_affiliation_string":"Department of Computer Science, Mississippi State University#TAB#","institution_ids":["https://openalex.org/I99041443"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110266967","display_name":"Julia E. Hodges","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I99041443","display_name":"Mississippi State University","ror":"https://ror.org/0432jq872","country_code":"US","type":"education","lineage":["https://openalex.org/I4210141039","https://openalex.org/I99041443"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Julia Hodges","raw_affiliation_strings":["Department of Computer Science, Mississippi State University","Department of Computer Science, Mississippi State University#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Mississippi State University","institution_ids":["https://openalex.org/I99041443"]},{"raw_affiliation_string":"Department of Computer Science, Mississippi State University#TAB#","institution_ids":["https://openalex.org/I99041443"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I99041443"],"apc_list":null,"apc_paid":null,"fwci":7.585,"has_fulltext":true,"cited_by_count":48,"citation_normalized_percentile":{"value":0.96979353,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":"26","issue":"1","first_page":"59","last_page":"64"},"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.9175000190734863,"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.9175000190734863,"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/T11450","display_name":"Model-Driven Software Engineering Techniques","score":0.03519999980926514,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T10260","display_name":"Software Engineering Research","score":0.031700000166893005,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/schema-mapping","display_name":"schema mapping","score":0.6190000176429749},{"id":"https://openalex.org/keywords/reverse-engineering","display_name":"reverse engineering","score":0.8259999752044678},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.6840000152587891},{"id":"https://openalex.org/keywords/object-oriented-databases","display_name":"object-oriented databases","score":0.843999981880188},{"id":"https://openalex.org/keywords/schema-extraction","display_name":"schema extraction","score":0.5559999942779541}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.804220974445343},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.7939426898956299},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.7286086082458496},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.7098492980003357},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6938582062721252},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.6584697961807251},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6303605437278748},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.5995739698410034},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5932636857032776},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.5756383538246155},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.552734911441803},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.5214928388595581},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.5070884227752686},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.47483617067337036},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.36304593086242676},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.32022127509117126},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.09311431646347046},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/248603.248615","doi":"https://doi.org/10.1145/248603.248615","is_oa":true,"landing_page_url":"https://doi.org/10.1145/248603.248615","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/248603.248615","source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"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 SIGMOD Record","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.144.359","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.144.359","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.acm.org/sigmod/record/issues/9703/rama.ps","raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/248603.248615","doi":"https://doi.org/10.1145/248603.248615","is_oa":true,"landing_page_url":"https://doi.org/10.1145/248603.248615","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/248603.248615","source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"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 SIGMOD Record","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W1978969411.pdf","grobid_xml":"https://content.openalex.org/works/W1978969411.grobid-xml"},"referenced_works_count":10,"referenced_works":["https://openalex.org/W80695334","https://openalex.org/W235942747","https://openalex.org/W1560504414","https://openalex.org/W1561277784","https://openalex.org/W1601529450","https://openalex.org/W1885904795","https://openalex.org/W1998046157","https://openalex.org/W2010499454","https://openalex.org/W2998778915","https://openalex.org/W6650865510"],"related_works":["https://openalex.org/W7098356427","https://openalex.org/W2130593498","https://openalex.org/W1599476819","https://openalex.org/W1969092043","https://openalex.org/W3216057461","https://openalex.org/W51593609","https://openalex.org/W1483308847","https://openalex.org/W2027426443","https://openalex.org/W1885904795","https://openalex.org/W203463940"],"abstract_inverted_index":{"Due":[0],"to":[1,23,46,61],"the":[2,12,32],"wide":[3],"use":[4,57],"of":[5,14,20,31,58,106],"object-oriented":[6,24,98],"technology":[7],"in":[8,28,94],"software":[9],"development":[10],"and":[11],"existence":[13],"many":[15,50],"relational":[16,21,52,78,88,107],"databases,":[17],"reverse":[18],"engineering":[19],"schemas":[22,25],"is":[26,42,91],"gaining":[27],"interest.":[29],"One":[30],"major":[33],"problems":[34],"with":[35],"existing":[36,77],"approaches":[37],"for":[38],"this":[39],"schema":[40,69,89,99],"mapping":[41,70],"that":[43,72,90],"they":[44],"fail":[45],"take":[47],"into":[48,96,102],"consideration":[49,103],"modern":[51],"database":[53,108],"design":[54,109],"alternatives":[55],"(e.g.,":[56],"binary":[59],"data":[60],"store":[62],"multiple-valued":[63],"attributes).":[64],"This":[65],"paper":[66],"presents":[67],"a":[68,87],"procedure":[71,85],"can":[73],"be":[74],"applied":[75],"on":[76],"databases":[79],"without":[80],"changing":[81],"their":[82],"schema.":[83],"The":[84],"maps":[86],"at":[92],"least":[93],"2NF":[95],"an":[97],"by":[100],"taking":[101],"various":[104],"types":[105],"optimizations.":[110]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1978969411","counts_by_year":[{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":2}],"updated_date":"2026-11-17T12:49:18.490984","created_date":"2016-06-24T00:00:00"}
