{"id":"https://openalex.org/W2018295154","doi":"https://doi.org/10.1016/j.infsof.2004.09.013","title":"Designing secure databases","display_name":"Designing secure databases","alternate_titles":[],"publication_year":2004,"publication_date":"2004-11-16","ids":{"openalex":"https://openalex.org/W2018295154","doi":"https://doi.org/10.1016/j.infsof.2004.09.013","mag":"2018295154"},"language":"en","primary_location":{"id":"doi:10.1016/j.infsof.2004.09.013","doi":"https://doi.org/10.1016/j.infsof.2004.09.013","is_oa":false,"landing_page_url":"https://doi.org/10.1016/j.infsof.2004.09.013","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,"listed_in":["ccf-b","cwts-core","dongbi-c","jufo-3","norway-2","poland-140","russia-white-list-1","vabb-shw"],"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"},"parent_works":[],"lineage":["https://openalex.org/W2018295154"],"child_works_count":0,"type":"article","is_traditional":true,"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/A5053366224","display_name":"Eduardo Fern\u00e1ndez\u2010Medina","orcid":"https://orcid.org/0000-0003-2553-9320","observed_orcids":["https://orcid.org/0000-0003-2553-9320"]},"institutions":[{"id":"https://openalex.org/I79189158","display_name":"University of Castilla-La Mancha","ror":"https://ror.org/05r78ng12","country_code":"ES","type":"education","lineage":["https://openalex.org/I79189158"]}],"countries":["ES"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Eduardo Fern\u00e1ndez-Medina","raw_affiliation_strings":["Escuela Superior de Inform\u00e1tica, Alarcos Research Group, University of Castilla-La Mancha, Paseo de la Universidad 4, 13071 Ciudad Real, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Escuela Superior de Inform\u00e1tica, Alarcos Research Group, University of Castilla-La Mancha, Paseo de la Universidad 4, 13071 Ciudad Real, Spain","institution_ids":["https://openalex.org/I79189158"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5083263115","display_name":"Mario G. Piattini","orcid":"https://orcid.org/0000-0002-7212-8279","observed_orcids":["https://orcid.org/0000-0002-7212-8279"]},"institutions":[{"id":"https://openalex.org/I79189158","display_name":"University of Castilla-La Mancha","ror":"https://ror.org/05r78ng12","country_code":"ES","type":"education","lineage":["https://openalex.org/I79189158"]}],"countries":["ES"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Mario Piattini","raw_affiliation_strings":["Escuela Superior de Inform\u00e1tica, Alarcos Research Group, University of Castilla-La Mancha, Paseo de la Universidad 4, 13071 Ciudad Real, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Escuela Superior de Inform\u00e1tica, Alarcos Research Group, University of Castilla-La Mancha, Paseo de la Universidad 4, 13071 Ciudad Real, Spain","institution_ids":["https://openalex.org/I79189158"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5053366224"],"corresponding_institution_ids":["https://openalex.org/I79189158"],"apc_list":{"value":3830,"currency":"USD","value_usd":3830},"apc_paid":null,"fwci":2.5989,"has_fulltext":false,"cited_by_count":59,"citation_normalized_percentile":{"value":0.91639589,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":86,"max":98},"biblio":{"volume":"47","issue":"7","first_page":"463","last_page":"477"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10927","display_name":"Access Control and Trust","score":0.986299991607666,"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/T10927","display_name":"Access Control and Trust","score":0.986299991607666,"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/T10734","display_name":"Information and Cyber Security","score":0.003000000026077032,"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/T13999","display_name":"Digital Rights Management and Security","score":0.0010999999940395355,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/database-security","display_name":"database security","score":0.7860000133514404},{"id":"https://openalex.org/keywords/multilevel-security","display_name":"multilevel security","score":0.7919999957084656},{"id":"https://openalex.org/keywords/mandatory-access-control","display_name":"mandatory access control","score":0.9769999980926514},{"id":"https://openalex.org/keywords/data-classification","display_name":"data classification","score":0.8050000071525574},{"id":"https://openalex.org/keywords/security-constraints","display_name":"security constraints","score":0.8920000195503235},{"id":"https://openalex.org/keywords/constraint-languages","display_name":"constraint languages","score":0.7639999985694885},{"id":"https://openalex.org/keywords/database-life-cycle","display_name":"database life cycle","score":0.5879999995231628},{"id":"https://openalex.org/keywords/requirements-gathering","display_name":"requirements gathering","score":0.6269999742507935},{"id":"https://openalex.org/keywords/database-analysis","display_name":"database analysis","score":0.6079999804496765}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7577062845230103},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.700512170791626},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.6762552261352539},{"id":"https://openalex.org/C187959359","wikidata":"https://www.wikidata.org/wiki/Q17113749","display_name":"Physical data model","level":5,"score":0.6379139423370361},{"id":"https://openalex.org/C2778553114","wikidata":"https://www.wikidata.org/wiki/Q1035293","display_name":"Database security","level":2,"score":0.605486273765564},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.5905221104621887},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.5390156507492065},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5294351577758789},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.48394396901130676},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.45096850395202637},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.42638108134269714},{"id":"https://openalex.org/C527821871","wikidata":"https://www.wikidata.org/wiki/Q228502","display_name":"Access control","level":2,"score":0.41318023204803467},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.296689510345459}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1016/j.infsof.2004.09.013","doi":"https://doi.org/10.1016/j.infsof.2004.09.013","is_oa":false,"landing_page_url":"https://doi.org/10.1016/j.infsof.2004.09.013","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,"listed_in":["ccf-b","cwts-core","dongbi-c","jufo-3","norway-2","poland-140","russia-white-list-1","vabb-shw"],"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"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.102.1166","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.102.1166","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://alarcos.inf-cr.uclm.es/per/efmedina/Investigacion/JCR1.PDF","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G370228524","display_name":null,"funder_award_id":"PCC-03-003-1","funder_id":"https://openalex.org/F4320327216","funder_display_name":"Junta de Comunidades de Castilla-La Mancha"},{"id":"https://openalex.org/G5757558237","display_name":null,"funder_award_id":"TIC2003-07804-C05-03","funder_id":"https://openalex.org/F4320323737","funder_display_name":"Ministerio de Ciencia y Tecnolog\u00eda"}],"funders":[{"id":"https://openalex.org/F4320323737","display_name":"Ministerio de Ciencia y Tecnolog\u00eda","ror":null},{"id":"https://openalex.org/F4320327216","display_name":"Junta de Comunidades de Castilla-La Mancha","ror":"https://ror.org/02jv91m18"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":49,"referenced_works":["https://openalex.org/W4179883","https://openalex.org/W178707257","https://openalex.org/W179340165","https://openalex.org/W1485658078","https://openalex.org/W1493729940","https://openalex.org/W1507924933","https://openalex.org/W1524147119","https://openalex.org/W1526723412","https://openalex.org/W1526993786","https://openalex.org/W1532064934","https://openalex.org/W1540492331","https://openalex.org/W1542384821","https://openalex.org/W1563495900","https://openalex.org/W1563639236","https://openalex.org/W1571983209","https://openalex.org/W1575391024","https://openalex.org/W1577049629","https://openalex.org/W1577672332","https://openalex.org/W1596127723","https://openalex.org/W1897671555","https://openalex.org/W1964985226","https://openalex.org/W1985049490","https://openalex.org/W2042103942","https://openalex.org/W2044748399","https://openalex.org/W2063393232","https://openalex.org/W2070958191","https://openalex.org/W2099293367","https://openalex.org/W2105539612","https://openalex.org/W2114917462","https://openalex.org/W2116352900","https://openalex.org/W2127714279","https://openalex.org/W2140037779","https://openalex.org/W2144642244","https://openalex.org/W2157329240","https://openalex.org/W2159765281","https://openalex.org/W2164551036","https://openalex.org/W2171113940","https://openalex.org/W2339106955","https://openalex.org/W2615164812","https://openalex.org/W2751199251","https://openalex.org/W2753439427","https://openalex.org/W3000135916","https://openalex.org/W3134318995","https://openalex.org/W3160272394","https://openalex.org/W4237375826","https://openalex.org/W4242182825","https://openalex.org/W4285719527","https://openalex.org/W7046327627","https://openalex.org/W7052713486"],"related_works":["https://openalex.org/W1573273842","https://openalex.org/W1499443802","https://openalex.org/W2055163222","https://openalex.org/W1554302796","https://openalex.org/W2165238332","https://openalex.org/W2036859137","https://openalex.org/W2940018161","https://openalex.org/W2358911408","https://openalex.org/W2346164627","https://openalex.org/W1480490382"],"abstract_inverted_index":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2018295154","counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":6},{"year":2014,"cited_by_count":7},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":4}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
