{"id":"https://openalex.org/W2039045171","doi":"https://doi.org/10.1016/s0950-5849(02)00130-1","title":"Generating three-tier applications from relational databases: a formal and practical approach","display_name":"Generating three-tier applications from relational databases: a formal and practical approach","publication_year":2002,"publication_date":"2002-11-04","ids":{"openalex":"https://openalex.org/W2039045171","doi":"https://doi.org/10.1016/s0950-5849(02)00130-1","mag":"2039045171"},"language":"en","primary_location":{"id":"doi:10.1016/s0950-5849(02)00130-1","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0950-5849(02)00130-1","pdf_url":null,"source":{"id":"https://openalex.org/S205010575","display_name":"Information and Software Technology","issn_l":"0950-5849","issn":["0950-5849","1873-6025"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information and Software Technology","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/A5071978590","display_name":"Macario Polo","orcid":"https://orcid.org/0000-0001-6519-6196"},"institutions":[{"id":"https://openalex.org/I4210134847","display_name":"Centro Tecnol\u00f3gico de Investigaci\u00f3n, Desarrollo e Innovaci\u00f3n en tecnolog\u00edas de la Informaci\u00f3n y las Comunicaciones (TIC)","ror":"https://ror.org/02s69db58","country_code":"ES","type":"nonprofit","lineage":["https://openalex.org/I4210134847"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Macario Polo","raw_affiliation_strings":["Escuela Superior de Inform\u00e1tica, Paseo de la Universidad, 4, 13071 Ciudad Real, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Escuela Superior de Inform\u00e1tica, Paseo de la Universidad, 4, 13071 Ciudad Real, Spain","institution_ids":["https://openalex.org/I4210134847"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050727322","display_name":"Juan \u00c1ngel G\u00f3mez","orcid":null},"institutions":[{"id":"https://openalex.org/I4210134847","display_name":"Centro Tecnol\u00f3gico de Investigaci\u00f3n, Desarrollo e Innovaci\u00f3n en tecnolog\u00edas de la Informaci\u00f3n y las Comunicaciones (TIC)","ror":"https://ror.org/02s69db58","country_code":"ES","type":"nonprofit","lineage":["https://openalex.org/I4210134847"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Juan \u00c1ngel G\u00f3mez","raw_affiliation_strings":["Escuela Superior de Inform\u00e1tica, Paseo de la Universidad, 4, 13071 Ciudad Real, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Escuela Superior de Inform\u00e1tica, Paseo de la Universidad, 4, 13071 Ciudad Real, Spain","institution_ids":["https://openalex.org/I4210134847"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083263115","display_name":"Mario Piattini","orcid":"https://orcid.org/0000-0002-7212-8279"},"institutions":[{"id":"https://openalex.org/I4210134847","display_name":"Centro Tecnol\u00f3gico de Investigaci\u00f3n, Desarrollo e Innovaci\u00f3n en tecnolog\u00edas de la Informaci\u00f3n y las Comunicaciones (TIC)","ror":"https://ror.org/02s69db58","country_code":"ES","type":"nonprofit","lineage":["https://openalex.org/I4210134847"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Mario Piattini","raw_affiliation_strings":["Escuela Superior de Inform\u00e1tica, Paseo de la Universidad, 4, 13071 Ciudad Real, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Escuela Superior de Inform\u00e1tica, Paseo de la Universidad, 4, 13071 Ciudad Real, Spain","institution_ids":["https://openalex.org/I4210134847"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5025649517","display_name":"Francisco Ru\u00edz","orcid":"https://orcid.org/0000-0002-4923-7848"},"institutions":[{"id":"https://openalex.org/I4210134847","display_name":"Centro Tecnol\u00f3gico de Investigaci\u00f3n, Desarrollo e Innovaci\u00f3n en tecnolog\u00edas de la Informaci\u00f3n y las Comunicaciones (TIC)","ror":"https://ror.org/02s69db58","country_code":"ES","type":"nonprofit","lineage":["https://openalex.org/I4210134847"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Francisco Ruiz","raw_affiliation_strings":["Escuela Superior de Inform\u00e1tica, Paseo de la Universidad, 4, 13071 Ciudad Real, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Escuela Superior de Inform\u00e1tica, Paseo de la Universidad, 4, 13071 Ciudad Real, Spain","institution_ids":["https://openalex.org/I4210134847"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4210134847"],"apc_list":{"value":3830,"currency":"USD","value_usd":3830},"apc_paid":null,"fwci":1.1754,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.89553477,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"44","issue":"15","first_page":"923","last_page":"941"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9994000196456909,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9994000196456909,"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/T10639","display_name":"Advanced Software Engineering Methodologies","score":0.9987999796867371,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9979000091552734,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6783144474029541},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.67479407787323},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5684513449668884},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.4719768166542053},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.40204334259033203},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3546273112297058}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6783144474029541},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.67479407787323},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5684513449668884},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4719768166542053},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.40204334259033203},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3546273112297058}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/s0950-5849(02)00130-1","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0950-5849(02)00130-1","pdf_url":null,"source":{"id":"https://openalex.org/S205010575","display_name":"Information and Software Technology","issn_l":"0950-5849","issn":["0950-5849","1873-6025"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information and Software Technology","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.41999998688697815}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W120762690","https://openalex.org/W179340165","https://openalex.org/W613073579","https://openalex.org/W1483308847","https://openalex.org/W1498996471","https://openalex.org/W1535654799","https://openalex.org/W1602043292","https://openalex.org/W1811252456","https://openalex.org/W1903989540","https://openalex.org/W1974284377","https://openalex.org/W1998046157","https://openalex.org/W2019912855","https://openalex.org/W2049866033","https://openalex.org/W2056168203","https://openalex.org/W2063393232","https://openalex.org/W2071828424","https://openalex.org/W2092011463","https://openalex.org/W2122519137","https://openalex.org/W2132506979","https://openalex.org/W2161901678","https://openalex.org/W2912730774","https://openalex.org/W2913503634","https://openalex.org/W3000135916","https://openalex.org/W3012126848","https://openalex.org/W4206840478","https://openalex.org/W4243578856","https://openalex.org/W6628822170"],"related_works":["https://openalex.org/W2267077731","https://openalex.org/W1510134535","https://openalex.org/W2386578196","https://openalex.org/W2483382562","https://openalex.org/W3091612633","https://openalex.org/W2085988990","https://openalex.org/W1528519853","https://openalex.org/W2608242168","https://openalex.org/W2376710457","https://openalex.org/W1897774768"],"abstract_inverted_index":null,"counts_by_year":[{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-08-21T09:56:20.448147","created_date":"2025-10-10T00:00:00"}