{"id":"https://openalex.org/W2151827032","doi":"https://doi.org/10.1109/icde.2010.5447776","title":"Reverse engineering models from databases to bootstrap application development","display_name":"Reverse engineering models from databases to bootstrap application development","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W2151827032","doi":"https://doi.org/10.1109/icde.2010.5447776","mag":"2151827032"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2010.5447776","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2010.5447776","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 IEEE 26th International Conference on Data Engineering (ICDE 2010)","raw_type":"proceedings-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/A5032641644","display_name":"Ankit Malpani","orcid":null},"institutions":[{"id":"https://openalex.org/I24676775","display_name":"Indian Institute of Technology Madras","ror":"https://ror.org/03v0r5n49","country_code":"IN","type":"facility","lineage":["https://openalex.org/I24676775"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Ankit Malpani","raw_affiliation_strings":["Indian Institute of Technology Madras, India"],"affiliations":[{"raw_affiliation_string":"Indian Institute of Technology Madras, India","institution_ids":["https://openalex.org/I24676775"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5108676493","display_name":"Philip A. Bernstein","orcid":"https://orcid.org/0000-0001-5781-1558"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Philip A. Bernstein","raw_affiliation_strings":["Microsoft Research Limited, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Research Limited, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030628433","display_name":"Sergey Melnik","orcid":"https://orcid.org/0000-0002-4784-9736"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sergey Melnik","raw_affiliation_strings":["Google, Inc., USA"],"affiliations":[{"raw_affiliation_string":"Google, Inc., USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5031461945","display_name":"James F. Terwilliger","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"James F. Terwilliger","raw_affiliation_strings":["Microsoft Research Limited, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Research Limited, USA","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5032641644"],"corresponding_institution_ids":["https://openalex.org/I24676775"],"apc_list":null,"apc_paid":null,"fwci":1.7806,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.86611513,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1177","last_page":"1180"},"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.9994000196456909,"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.9994000196456909,"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.9973999857902527,"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/T10703","display_name":"Business Process Modeling and Analysis","score":0.9947999715805054,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7950763702392578},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6838833093643188},{"id":"https://openalex.org/keywords/executable","display_name":"Executable","score":0.6392290592193604},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5898677110671997},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.579690158367157},{"id":"https://openalex.org/keywords/reverse-engineering","display_name":"Reverse engineering","score":0.5328346490859985},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.5302982330322266},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.5298823118209839},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.5222029089927673},{"id":"https://openalex.org/keywords/inheritance","display_name":"Inheritance (genetic algorithm)","score":0.5111532807350159},{"id":"https://openalex.org/keywords/conceptual-model","display_name":"Conceptual model","score":0.4576164782047272},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.44715145230293274},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.44436460733413696},{"id":"https://openalex.org/keywords/data-model","display_name":"Data model (GIS)","score":0.4378805458545685},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.4375040531158447},{"id":"https://openalex.org/keywords/object","display_name":"Object (grammar)","score":0.41210103034973145},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3516058325767517},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.33050304651260376},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1524895429611206}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7950763702392578},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6838833093643188},{"id":"https://openalex.org/C160145156","wikidata":"https://www.wikidata.org/wiki/Q778586","display_name":"Executable","level":2,"score":0.6392290592193604},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5898677110671997},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.579690158367157},{"id":"https://openalex.org/C207850805","wikidata":"https://www.wikidata.org/wiki/Q269608","display_name":"Reverse engineering","level":2,"score":0.5328346490859985},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.5302982330322266},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.5298823118209839},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.5222029089927673},{"id":"https://openalex.org/C2780902518","wikidata":"https://www.wikidata.org/wiki/Q6033780","display_name":"Inheritance (genetic algorithm)","level":3,"score":0.5111532807350159},{"id":"https://openalex.org/C13606891","wikidata":"https://www.wikidata.org/wiki/Q2623243","display_name":"Conceptual model","level":2,"score":0.4576164782047272},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.44715145230293274},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.44436460733413696},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.4378805458545685},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4375040531158447},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.41210103034973145},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3516058325767517},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.33050304651260376},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1524895429611206},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2010.5447776","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2010.5447776","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 IEEE 26th International Conference on Data Engineering (ICDE 2010)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.46000000834465027}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W1978969411","https://openalex.org/W2002958129","https://openalex.org/W2063970868","https://openalex.org/W2064853889","https://openalex.org/W2153670461","https://openalex.org/W2158864412","https://openalex.org/W2294859229","https://openalex.org/W4250168293","https://openalex.org/W6697509678"],"related_works":["https://openalex.org/W4297044271","https://openalex.org/W4248533530","https://openalex.org/W2079106548","https://openalex.org/W2356642811","https://openalex.org/W2403346309","https://openalex.org/W2040840314","https://openalex.org/W296732031","https://openalex.org/W4321463817","https://openalex.org/W2606498729","https://openalex.org/W3175115603"],"abstract_inverted_index":{"Object-relational":[0],"mapping":[1],"systems":[2],"have":[3],"become":[4],"often-used":[5],"tools":[6,39,44],"to":[7,11,25,96],"provide":[8],"application":[9,33],"access":[10],"relational":[12],"databases.":[13],"In":[14],"a":[15,27,49,55,81],"database-first":[16],"development":[17],"scenario,":[18],"the":[19,23,32,71],"onus":[20],"is":[21,110],"on":[22,107],"developer":[24],"construct":[26],"meaningful":[28],"object":[29],"layer":[30],"for":[31,112],"because":[34],"shipping":[35],"tools,":[36],"as":[37],"ORM":[38],"only":[40],"ship":[41],"database":[42],"reverse-engineering":[43],"that":[45,58,69,73],"generate":[46],"objects":[47],"with":[48,66,84],"trivial":[50],"one-to-one":[51],"mapping.":[52,101],"We":[53],"built":[54],"tool,":[56],"EdmGen++,":[57],"combines":[59],"pattern-finding":[60],"rules":[61],"from":[62],"conceptual":[63,82],"modelling":[64],"literature":[65],"configurable":[67],"conditions":[68],"increase":[70],"likelihood":[72],"found":[74],"patterns":[75],"are":[76],"semantically":[77],"relevant.":[78],"EdmGen++":[79,106],"produces":[80],"model":[83],"inheritance":[85],"in":[86],"Microsoft's":[87,92],"Entity":[88,93],"Data":[89],"Model,":[90],"which":[91],"Framework":[94],"uses":[95],"support":[97],"an":[98],"executable":[99],"object-to-relational":[100],"The":[102],"execution":[103],"time":[104],"of":[105],"customer":[108],"databases":[109],"reasonable":[111],"design-time.":[113]},"counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}