{"id":"https://openalex.org/W2625932614","doi":"https://doi.org/10.17706/jsw.12.6.426-438","title":"RDB2 Model: A Relational Databases Retro-Design Tool Enriched by the Extraction of Constraints","display_name":"RDB2 Model: A Relational Databases Retro-Design Tool Enriched by the Extraction of Constraints","publication_year":2017,"publication_date":"2017-06-01","ids":{"openalex":"https://openalex.org/W2625932614","doi":"https://doi.org/10.17706/jsw.12.6.426-438","mag":"2625932614"},"language":"en","primary_location":{"id":"doi:10.17706/jsw.12.6.426-438","is_oa":true,"landing_page_url":"https://doi.org/10.17706/jsw.12.6.426-438","pdf_url":"http://www.jsoftware.us/vol12/261-JSW15231.pdf","source":{"id":"https://openalex.org/S114141714","display_name":"Journal of Software","issn_l":"1796-217X","issn":["1796-217X"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318660","host_organization_name":"Academy Publisher","host_organization_lineage":["https://openalex.org/P4310318660"],"host_organization_lineage_names":["Academy Publisher"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Software","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"http://www.jsoftware.us/vol12/261-JSW15231.pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5069356673","display_name":"Widad Jakjoud","orcid":null},"institutions":[{"id":"https://openalex.org/I4210145365","display_name":"Universit\u00e9 Hassan 1er","ror":"https://ror.org/03cdvht47","country_code":"MA","type":"education","lineage":["https://openalex.org/I4210145365"]}],"countries":["MA"],"is_corresponding":true,"raw_author_name":"Widad Jakjoud","raw_affiliation_strings":["Laboratory LITEN, University Hassan 1, 26000 Settat, Morocco"],"affiliations":[{"raw_affiliation_string":"Laboratory LITEN, University Hassan 1, 26000 Settat, Morocco","institution_ids":["https://openalex.org/I4210145365"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5042785802","display_name":"Mohamed Bahaj","orcid":"https://orcid.org/0000-0003-0483-8807"},"institutions":[{"id":"https://openalex.org/I4210145365","display_name":"Universit\u00e9 Hassan 1er","ror":"https://ror.org/03cdvht47","country_code":"MA","type":"education","lineage":["https://openalex.org/I4210145365"]}],"countries":["MA"],"is_corresponding":false,"raw_author_name":"Mohamed Bahaj","raw_affiliation_strings":["Laboratory LITEN, University Hassan 1, 26000 Settat, Morocco"],"affiliations":[{"raw_affiliation_string":"Laboratory LITEN, University Hassan 1, 26000 Settat, Morocco","institution_ids":["https://openalex.org/I4210145365"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5069356673"],"corresponding_institution_ids":["https://openalex.org/I4210145365"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0808401,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"12","issue":"6","first_page":"426","last_page":"438"},"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.9944000244140625,"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.9944000244140625,"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.978600025177002,"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.9718999862670898,"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.9348633289337158},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6302303075790405},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6127752065658569},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.47642311453819275},{"id":"https://openalex.org/keywords/extraction","display_name":"Extraction (chemistry)","score":0.47117406129837036},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4616360366344452},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3451022505760193},{"id":"https://openalex.org/keywords/chemistry","display_name":"Chemistry","score":0.05110931396484375},{"id":"https://openalex.org/keywords/chromatography","display_name":"Chromatography","score":0.0476343035697937}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9348633289337158},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6302303075790405},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6127752065658569},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.47642311453819275},{"id":"https://openalex.org/C4725764","wikidata":"https://www.wikidata.org/wiki/Q844704","display_name":"Extraction (chemistry)","level":2,"score":0.47117406129837036},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4616360366344452},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3451022505760193},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.05110931396484375},{"id":"https://openalex.org/C43617362","wikidata":"https://www.wikidata.org/wiki/Q170050","display_name":"Chromatography","level":1,"score":0.0476343035697937}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.17706/jsw.12.6.426-438","is_oa":true,"landing_page_url":"https://doi.org/10.17706/jsw.12.6.426-438","pdf_url":"http://www.jsoftware.us/vol12/261-JSW15231.pdf","source":{"id":"https://openalex.org/S114141714","display_name":"Journal of Software","issn_l":"1796-217X","issn":["1796-217X"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318660","host_organization_name":"Academy Publisher","host_organization_lineage":["https://openalex.org/P4310318660"],"host_organization_lineage_names":["Academy Publisher"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Software","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.17706/jsw.12.6.426-438","is_oa":true,"landing_page_url":"https://doi.org/10.17706/jsw.12.6.426-438","pdf_url":"http://www.jsoftware.us/vol12/261-JSW15231.pdf","source":{"id":"https://openalex.org/S114141714","display_name":"Journal of Software","issn_l":"1796-217X","issn":["1796-217X"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318660","host_organization_name":"Academy Publisher","host_organization_lineage":["https://openalex.org/P4310318660"],"host_organization_lineage_names":["Academy Publisher"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Software","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2625932614.pdf","grobid_xml":"https://content.openalex.org/works/W2625932614.grobid-xml"},"referenced_works_count":19,"referenced_works":["https://openalex.org/W9091155","https://openalex.org/W142231902","https://openalex.org/W1484123365","https://openalex.org/W1491535504","https://openalex.org/W1498996471","https://openalex.org/W1534315740","https://openalex.org/W1568412184","https://openalex.org/W1582340086","https://openalex.org/W1594555416","https://openalex.org/W1602650507","https://openalex.org/W1998046157","https://openalex.org/W2056168203","https://openalex.org/W2094448563","https://openalex.org/W2140904634","https://openalex.org/W2163011370","https://openalex.org/W2255298453","https://openalex.org/W4249121902","https://openalex.org/W4299625886","https://openalex.org/W6680900030"],"related_works":["https://openalex.org/W2267077731","https://openalex.org/W1966209153","https://openalex.org/W1510134535","https://openalex.org/W2386578196","https://openalex.org/W3091612633","https://openalex.org/W2483382562","https://openalex.org/W2085988990","https://openalex.org/W1528519853","https://openalex.org/W2608242168","https://openalex.org/W2376710457"],"abstract_inverted_index":{"In":[0],"this":[1,67],"paper,":[2],"we":[3],"present":[4],"a":[5,9,14,26,48,72],"method":[6,24,44],"that":[7],"retro-designs":[8],"relational":[10,33,61,82],"database":[11,34,62],"to":[12,54],"generate":[13],"conceptual":[15,27,73,90],"model":[16,28,39,91],"by":[17,70,92],"extracting":[18],"data":[19,57,68,99],"structures":[20],"and":[21,63,84],"constraints:":[22],"Our":[23],"extracts":[25],"directly":[29],"from":[30],"an":[31],"existing":[32],"without":[35],"using":[36],"the":[37,51,56,60,64,79,85,89,94],"ER":[38],"(Entity":[40],"/":[41],"Relationship).":[42],"The":[43,75],"is":[45,53],"proposed":[46],"as":[47],"two-step":[49],"process,":[50],"first":[52],"extract":[55],"structure":[58,69],"of":[59,66,81,88,96],"conceptualization":[65],"generating":[71],"model.":[74],"second":[76],"stage":[77],"involves":[78],"extraction":[80],"constraints":[83],"semantic":[86],"enrichment":[87],"improving":[93],"understanding":[95],"relationships":[97],"between":[98],"structures.":[100]},"counts_by_year":[],"updated_date":"2026-01-13T01:12:25.745995","created_date":"2017-06-23T00:00:00"}