{"id":"https://openalex.org/W2099610280","doi":"https://doi.org/10.1109/wcre.1993.287769","title":"An approach for reverse engineering of relational databases","display_name":"An approach for reverse engineering of relational databases","publication_year":2002,"publication_date":"2002-12-30","ids":{"openalex":"https://openalex.org/W2099610280","doi":"https://doi.org/10.1109/wcre.1993.287769","mag":"2099610280"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1109/wcre.1993.287769","pdf_url":null,"source":{"id":"https://openalex.org/S4210227819","display_name":"Proceedings - Working Conference on Reverse Engineering","issn_l":"1095-1350","issn":["1095-1350","2375-5369"],"is_oa":false,"is_in_doaj":false,"is_indexed_in_scopus":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-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/A5017680640","display_name":"William Premerlani","orcid":null},"institutions":[{"id":"https://openalex.org/I1332737386","display_name":"General Electric (United States)","ror":"https://ror.org/013msgt25","country_code":"US","type":"funder","lineage":["https://openalex.org/I1332737386"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"W.J. Premerlani","raw_affiliation_strings":["General Electric CO (Schenectady, NY)"],"affiliations":[{"raw_affiliation_string":"General Electric CO (Schenectady, NY)","institution_ids":["https://openalex.org/I1332737386"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5057914126","display_name":"M. Blaha","orcid":"https://orcid.org/0009-0009-1236-4585"},"institutions":[{"id":"https://openalex.org/I1332737386","display_name":"General Electric (United States)","ror":"https://ror.org/013msgt25","country_code":"US","type":"funder","lineage":["https://openalex.org/I1332737386"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"M.R. Blaha","raw_affiliation_strings":["GE Corp. Res. & Dev., Schenectady, NY, USA"],"affiliations":[{"raw_affiliation_string":"GE Corp. Res. & Dev., Schenectady, NY, USA","institution_ids":["https://openalex.org/I1332737386"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.763,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":45,"citation_normalized_percentile":{"value":0.897969,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":92},"biblio":{"volume":null,"issue":null,"first_page":"151","last_page":"160"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995,"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.9995,"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.9979,"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.9906,"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/reverse-engineering","display_name":"Reverse engineering","score":0.5967088},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.517974},{"id":"https://openalex.org/keywords/information-engineering","display_name":"Information engineering","score":0.41081122}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.77211595},{"id":"https://openalex.org/C45357846","wikidata":"https://www.wikidata.org/wiki/Q2001982","display_name":"Notation","level":2,"score":0.60761994},{"id":"https://openalex.org/C207850805","wikidata":"https://www.wikidata.org/wiki/Q269608","display_name":"Reverse engineering","level":2,"score":0.5967088},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.54269266},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.517974},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.51074386},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4523788},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.43743694},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.43686274},{"id":"https://openalex.org/C5283578","wikidata":"https://www.wikidata.org/wiki/Q60596709","display_name":"Information engineering","level":3,"score":0.41081122},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.40317327},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3631463},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.33727345},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3347933},{"id":"https://openalex.org/C180198813","wikidata":"https://www.wikidata.org/wiki/Q121182","display_name":"Information system","level":2,"score":0.22464973},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.108771145},{"id":"https://openalex.org/C94375191","wikidata":"https://www.wikidata.org/wiki/Q11205","display_name":"Arithmetic","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C119599485","wikidata":"https://www.wikidata.org/wiki/Q43035","display_name":"Electrical engineering","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1109/wcre.1993.287769","pdf_url":null,"source":{"id":"https://openalex.org/S4210227819","display_name":"Proceedings - Working Conference on Reverse Engineering","issn_l":"1095-1350","issn":["1095-1350","2375-5369"],"is_oa":false,"is_in_doaj":false,"is_indexed_in_scopus":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality education","score":0.54}],"grants":[],"datasets":[],"versions":[],"referenced_works_count":6,"referenced_works":["https://openalex.org/W1521935994","https://openalex.org/W1581093035","https://openalex.org/W1919904258","https://openalex.org/W2099293367","https://openalex.org/W2127972622","https://openalex.org/W4251962945"],"related_works":["https://openalex.org/W325713583","https://openalex.org/W2591891926","https://openalex.org/W2512945146","https://openalex.org/W2483382562","https://openalex.org/W2460926837","https://openalex.org/W2153455914","https://openalex.org/W2079588361","https://openalex.org/W2000469556","https://openalex.org/W1905261690","https://openalex.org/W1501673548"],"abstract_inverted_index":{"A":[0,62],"process":[1,65,86],"for":[2,16,44,59,74,98],"reverse":[3],"engineering":[4],"of":[5,89,105,111],"relational":[6],"databases":[7],"is":[8,47,71],"proposed.":[9,72],"Object-oriented":[10],"models":[11,51],"provide":[12,55],"a":[13,56],"natural":[14],"language":[15],"facilitating":[17],"the":[18,26,29,34,69,108],"re-engineering":[19],"process.":[20],"An":[21],"object-oriented":[22],"model":[23],"can":[24],"describe":[25],"existing":[27],"software,":[28],"reverse-engineered":[30],"semantic":[31,109],"intent,":[32],"and":[33,54,79,107],"forward-engineered":[35],"new":[36],"system.":[37],"The":[38,85],"Object":[39],"Modeling":[40],"Technique":[41],"(OMT)":[42],"notation":[43],"modeling":[45],"data":[46],"adopted.":[48],"Graphical":[49],"OMT":[50],"are":[52,83,100],"intuitive":[53],"rigorous":[57],"basis":[58],"specifying":[60],"software.":[61],"more":[63],"robust":[64],"than":[66,93],"advanced":[67],"in":[68],"literature":[70],"Guidelines":[73],"coping":[75],"with":[76],"design":[77],"optimizations":[78],"unfortunate":[80],"implementation":[81],"decisions":[82],"provided.":[84],"emphasizes":[87],"analysis":[88],"candidate":[90],"keys":[91],"rather":[92],"primary":[94],"keys.":[95],"Three":[96],"sources":[97],"information":[99],"incorporated:":[101],"schema,":[102],"observed":[103],"patterns":[104],"data,":[106],"understanding":[110],"application":[112],"intent.<":[113],">":[116]},"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2099610280","counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":3},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":2}],"updated_date":"2025-03-23T15:36:18.821130","created_date":"2016-06-24"}