{"id":"https://openalex.org/W1977683474","doi":"https://doi.org/10.1142/s0218843095000123","title":"RELATIONAL DATABASE REVERSE ENGINEERING: A METHOD BASED ON QUERY ANALYSIS","display_name":"RELATIONAL DATABASE REVERSE ENGINEERING: A METHOD BASED ON QUERY ANALYSIS","publication_year":1995,"publication_date":"1995-06-01","ids":{"openalex":"https://openalex.org/W1977683474","doi":"https://doi.org/10.1142/s0218843095000123","mag":"1977683474"},"language":"en","primary_location":{"id":"doi:10.1142/s0218843095000123","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s0218843095000123","pdf_url":null,"source":{"id":"https://openalex.org/S17147961","display_name":"International Journal of Cooperative Information Systems","issn_l":"0218-8430","issn":["0218-8430","1793-6365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Cooperative Information Systems","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/A5064659680","display_name":"Jean-Marc Petit","orcid":"https://orcid.org/0000-0002-0015-745X"},"institutions":[{"id":"https://openalex.org/I48430043","display_name":"Institut National des Sciences Appliqu\u00e9es de Lyon","ror":"https://ror.org/050jn9y42","country_code":"FR","type":"education","lineage":["https://openalex.org/I203339264","https://openalex.org/I48430043"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"JEAN-MARC PETIT","raw_affiliation_strings":["Laboratoire d\u2019Ing\u00e9nierie des Syst\u00e8mes d\u2019Information, INSA Lyon, B\u00e2timent 501, F-69621 Villeurbanne, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Laboratoire d\u2019Ing\u00e9nierie des Syst\u00e8mes d\u2019Information, INSA Lyon, B\u00e2timent 501, F-69621 Villeurbanne, France","institution_ids":["https://openalex.org/I48430043"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051532575","display_name":"Farouk Toumani","orcid":"https://orcid.org/0000-0002-5086-3301"},"institutions":[{"id":"https://openalex.org/I48430043","display_name":"Institut National des Sciences Appliqu\u00e9es de Lyon","ror":"https://ror.org/050jn9y42","country_code":"FR","type":"education","lineage":["https://openalex.org/I203339264","https://openalex.org/I48430043"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"FAROUK TOUMANI","raw_affiliation_strings":["Laboratoire d\u2019Ing\u00e9nierie des Syst\u00e8mes d\u2019Information, INSA Lyon, B\u00e2timent 501, F-69621 Villeurbanne, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Laboratoire d\u2019Ing\u00e9nierie des Syst\u00e8mes d\u2019Information, INSA Lyon, B\u00e2timent 501, F-69621 Villeurbanne, France","institution_ids":["https://openalex.org/I48430043"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5039453119","display_name":"Jacques Kouloumdjian","orcid":null},"institutions":[{"id":"https://openalex.org/I48430043","display_name":"Institut National des Sciences Appliqu\u00e9es de Lyon","ror":"https://ror.org/050jn9y42","country_code":"FR","type":"education","lineage":["https://openalex.org/I203339264","https://openalex.org/I48430043"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"JACQUES KOULOUMDJIAN","raw_affiliation_strings":["Laboratoire d\u2019Ing\u00e9nierie des Syst\u00e8mes d\u2019Information, INSA Lyon, B\u00e2timent 501, F-69621 Villeurbanne, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Laboratoire d\u2019Ing\u00e9nierie des Syst\u00e8mes d\u2019Information, INSA Lyon, B\u00e2timent 501, F-69621 Villeurbanne, France","institution_ids":["https://openalex.org/I48430043"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.0134,"has_fulltext":false,"cited_by_count":20,"citation_normalized_percentile":{"value":0.79453855,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"04","issue":"02n03","first_page":"287","last_page":"316"},"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.9987000226974487,"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.9987000226974487,"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.9969000220298767,"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.9945999979972839,"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.8246111869812012},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.7653913497924805},{"id":"https://openalex.org/keywords/information-schema","display_name":"Information schema","score":0.651671826839447},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.623988151550293},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.5411699414253235},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5403968691825867},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5066269040107727},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.5010988712310791},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.4827677309513092},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.482538640499115},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.45998117327690125},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.45329588651657104},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.4435039162635803},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.41802743077278137},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3676679730415344},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.23148441314697266}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8246111869812012},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.7653913497924805},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.651671826839447},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.623988151550293},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.5411699414253235},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5403968691825867},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5066269040107727},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.5010988712310791},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.4827677309513092},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.482538640499115},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.45998117327690125},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.45329588651657104},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4435039162635803},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.41802743077278137},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3676679730415344},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.23148441314697266},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.0},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1142/s0218843095000123","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s0218843095000123","pdf_url":null,"source":{"id":"https://openalex.org/S17147961","display_name":"International Journal of Cooperative Information Systems","issn_l":"0218-8430","issn":["0218-8430","1793-6365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Cooperative Information Systems","raw_type":"journal-article"},{"id":"pmh:oai:HAL:hal-02079209v1","is_oa":false,"landing_page_url":"https://hal.science/hal-02079209","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Int. J. Cooperative Inf. Syst., 1995, 4, pp.287--316. ⟨10.1142/S0218843095000123⟩","raw_type":"Journal articles"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education","score":0.6600000262260437}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W166845585","https://openalex.org/W945629821","https://openalex.org/W2092058806","https://openalex.org/W2103472145","https://openalex.org/W1513459549","https://openalex.org/W2153512431","https://openalex.org/W1992271858","https://openalex.org/W4238907651","https://openalex.org/W2105315220","https://openalex.org/W2582962420"],"abstract_inverted_index":{"This":[0,202],"paper":[1],"introduces":[2],"a":[3,38,72,107,117,162],"method":[4,92,203],"of":[5,66,112,182,188],"reverse":[6],"engineering":[7],"for":[8],"operational":[9,210],"relational":[10,133],"databases.":[11],"The":[12,91],"conceptual":[13,73,118,137],"schemas":[14],"are":[15],"derived":[16,121],"using":[17],"information":[18],"extracted":[19],"from":[20,122,126,131],"data":[21],"dictionaries,":[22],"database":[23,44,128],"extensions":[24],"and":[25,106,130],"application":[26,86,101],"programs.":[27],"Its":[28],"main":[29,98],"strength":[30],"relies":[31],"on":[32,36,54,96,208],"the":[33,37,43,59,67,79,127,132,146,159,172,186,195],"assumptions":[34],"made":[35],"priori":[39],"knowledge":[40,68],"available":[41],"about":[42],"(only":[45],"[Formula:":[46,50,109,123],"see":[47,51,110,124],"text]":[48,52,111],"and/or":[49],"constraints":[53],"attribute(s))":[55],"as":[56,58],"well":[57],"user":[60,148,166,173,198],"competence.":[61],"We":[62,176],"argue":[63],"that":[64],"most":[65],"needed":[69],"to":[70,170],"build":[71],"schema,":[74],"if":[75],"not":[76],"described":[77],"in":[78,85,152],"Data":[80],"Description":[81],"Language,":[82],"is":[83,93,104,114,120,139,150,168,200],"embedded":[84],"programs":[87],"under":[88,165],"various":[89],"forms.":[90],"therefore":[94],"based":[95],"four":[97],"steps:":[99],"firstly,":[100],"program":[102],"analysis":[103],"performed":[105],"set":[108],"equi-joins":[113],"obtained;":[115],"secondly,":[116],"schema":[119,138,163],"text],":[125],"extension":[129],"schema;":[134],"thirdly,":[135],"this":[136,153],"validated":[140,207],"through":[141],"an":[142,209],"interactive":[143],"dialogue":[144],"with":[145],"expert":[147],"who":[149],"helped":[151],"task":[154,187],"by":[155,158],"indications":[156],"given":[157],"method.":[160],"Finally,":[161],"reorganization":[164],"control":[167],"achieved":[169],"match":[171],"requirements":[174],"better.":[175],"introduce":[177],"also":[178],"how":[179],"other":[180],"kinds":[181],"queries":[183],"can":[184],"help":[185],"semantics":[189],"discovery.":[190],"Additionally,":[191],"we":[192],"precisely":[193],"identify":[194],"phases":[196],"when":[197],"interaction":[199],"needed.":[201],"has":[204],"been":[205],"successfully":[206],"database.":[211]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}