{"id":"https://openalex.org/W2061570003","doi":"https://doi.org/10.1016/0169-023x(93)90002-7","title":"Access cost estimation for physical database design","display_name":"Access cost estimation for physical database design","publication_year":1993,"publication_date":"1993-10-01","ids":{"openalex":"https://openalex.org/W2061570003","doi":"https://doi.org/10.1016/0169-023x(93)90002-7","mag":"2061570003"},"language":"en","primary_location":{"id":"doi:10.1016/0169-023x(93)90002-7","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0169-023x(93)90002-7","pdf_url":null,"source":{"id":"https://openalex.org/S136993123","display_name":"Data & Knowledge Engineering","issn_l":"0169-023X","issn":["0169-023X","1872-6933"],"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":"Data & Knowledge Engineering","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/A5010984921","display_name":"Paolo Ciaccia","orcid":"https://orcid.org/0000-0002-1794-6244"},"institutions":[{"id":"https://openalex.org/I9360294","display_name":"University of Bologna","ror":"https://ror.org/01111rn36","country_code":"IT","type":"education","lineage":["https://openalex.org/I9360294"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Paolo Ciaccia","raw_affiliation_strings":["Dipartimento di Elettronica, Informatica e Sistemistica, Universit\u00e0 di Bologna - CIOC - C.N.R., Viale Risorgimento, 2, 40136 Bologna, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Dipartimento di Elettronica, Informatica e Sistemistica, Universit\u00e0 di Bologna - CIOC - C.N.R., Viale Risorgimento, 2, 40136 Bologna, Italy","institution_ids":["https://openalex.org/I9360294"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5056262479","display_name":"Dario Maio","orcid":"https://orcid.org/0000-0002-0094-0022"},"institutions":[{"id":"https://openalex.org/I9360294","display_name":"University of Bologna","ror":"https://ror.org/01111rn36","country_code":"IT","type":"education","lineage":["https://openalex.org/I9360294"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Dario Maio","raw_affiliation_strings":["Dipartimento di Elettronica, Informatica e Sistemistica, Universit\u00e0 di Bologna - CIOC - C.N.R., Viale Risorgimento, 2, 40136 Bologna, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Dipartimento di Elettronica, Informatica e Sistemistica, Universit\u00e0 di Bologna - CIOC - C.N.R., Viale Risorgimento, 2, 40136 Bologna, Italy","institution_ids":["https://openalex.org/I9360294"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5056262479"],"corresponding_institution_ids":["https://openalex.org/I9360294"],"apc_list":{"value":3000,"currency":"USD","value_usd":3000},"apc_paid":null,"fwci":1.9493,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.8725993,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"11","issue":"2","first_page":"125","last_page":"150"},"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.9995999932289124,"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.9995999932289124,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9950000047683716,"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/T11106","display_name":"Data Management and Algorithms","score":0.9933000206947327,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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.8088040351867676},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6749160885810852},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.6387296319007874},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5738507509231567},{"id":"https://openalex.org/keywords/cluster-analysis","display_name":"Cluster analysis","score":0.5655398368835449},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5193325281143188},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4740443229675293},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.47103574872016907},{"id":"https://openalex.org/keywords/sort","display_name":"sort","score":0.44662177562713623},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.44078752398490906},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.43606239557266235},{"id":"https://openalex.org/keywords/measure","display_name":"Measure (data warehouse)","score":0.43352261185646057},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.30903348326683044},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.30077165365219116},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.24812960624694824},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.21506547927856445},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.18665486574172974},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.13724592328071594},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.0952971875667572}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8088040351867676},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6749160885810852},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.6387296319007874},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5738507509231567},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.5655398368835449},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5193325281143188},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4740443229675293},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.47103574872016907},{"id":"https://openalex.org/C88548561","wikidata":"https://www.wikidata.org/wiki/Q347599","display_name":"sort","level":2,"score":0.44662177562713623},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.44078752398490906},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.43606239557266235},{"id":"https://openalex.org/C2780009758","wikidata":"https://www.wikidata.org/wiki/Q6804172","display_name":"Measure (data warehouse)","level":2,"score":0.43352261185646057},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.30903348326683044},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.30077165365219116},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.24812960624694824},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.21506547927856445},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.18665486574172974},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.13724592328071594},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0952971875667572},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1016/0169-023x(93)90002-7","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0169-023x(93)90002-7","pdf_url":null,"source":{"id":"https://openalex.org/S136993123","display_name":"Data & Knowledge Engineering","issn_l":"0169-023X","issn":["0169-023X","1872-6933"],"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":"Data & Knowledge Engineering","raw_type":"journal-article"},{"id":"pmh:oai:cris.unibo.it:11585/918328","is_oa":false,"landing_page_url":"https://hdl.handle.net/11585/918328","pdf_url":null,"source":{"id":"https://openalex.org/S4306402579","display_name":"Archivio istituzionale della ricerca (Alma Mater Studiorum Universit\u00e0 di Bologna)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210117483","host_organization_name":"Istituto di Ematologia di Bologna","host_organization_lineage":["https://openalex.org/I4210117483"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions","score":0.44999998807907104}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":31,"referenced_works":["https://openalex.org/W1606789201","https://openalex.org/W1977570286","https://openalex.org/W1993436282","https://openalex.org/W2000025733","https://openalex.org/W2008365755","https://openalex.org/W2020191321","https://openalex.org/W2027722859","https://openalex.org/W2049528741","https://openalex.org/W2058765797","https://openalex.org/W2073618455","https://openalex.org/W2079439222","https://openalex.org/W2082004608","https://openalex.org/W2083009278","https://openalex.org/W2093472843","https://openalex.org/W2108717033","https://openalex.org/W2116701720","https://openalex.org/W2123209274","https://openalex.org/W2141647322","https://openalex.org/W2144760473","https://openalex.org/W2150101660","https://openalex.org/W2155166680","https://openalex.org/W2163329495","https://openalex.org/W2185907055","https://openalex.org/W4239571647","https://openalex.org/W4293257135","https://openalex.org/W6662892419","https://openalex.org/W6671072477","https://openalex.org/W6671201711","https://openalex.org/W6677155105","https://openalex.org/W6682255681","https://openalex.org/W6684539355"],"related_works":["https://openalex.org/W2554271401","https://openalex.org/W2889903446","https://openalex.org/W2992414350","https://openalex.org/W3125756434","https://openalex.org/W2150741898","https://openalex.org/W4281289408","https://openalex.org/W2371929047","https://openalex.org/W2249768123","https://openalex.org/W185198413","https://openalex.org/W2955368753"],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2026-08-21T09:56:20.448147","created_date":"2025-10-10T00:00:00"}