{"id":"https://openalex.org/W3165129262","doi":"https://doi.org/10.23919/fruct52173.2021.9435500","title":"The Effect of Partitioning and Indexing on Data Access Time","display_name":"The Effect of Partitioning and Indexing on Data Access Time","publication_year":2021,"publication_date":"2021-05-12","ids":{"openalex":"https://openalex.org/W3165129262","doi":"https://doi.org/10.23919/fruct52173.2021.9435500","mag":"3165129262"},"language":"en","primary_location":{"id":"doi:10.23919/fruct52173.2021.9435500","is_oa":false,"landing_page_url":"https://doi.org/10.23919/fruct52173.2021.9435500","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2021 29th Conference of Open Innovations Association (FRUCT)","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doaj.org/article/c923744549194d70a42569b5eb1b7218","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5009134515","display_name":"Veronika \u0160algov\u00e1","orcid":null},"institutions":[{"id":"https://openalex.org/I3122011922","display_name":"University of \u017dilina","ror":"https://ror.org/031wwwj55","country_code":"SK","type":"education","lineage":["https://openalex.org/I3122011922"]}],"countries":["SK"],"is_corresponding":false,"raw_author_name":"Veronika Salgova","raw_affiliation_strings":["University of \u017dilina, \u017dilina, Slovakia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of \u017dilina, \u017dilina, Slovakia","institution_ids":["https://openalex.org/I3122011922"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5016665318","display_name":"Karol Matia\u0161ko","orcid":"https://orcid.org/0000-0001-7173-2661"},"institutions":[{"id":"https://openalex.org/I3122011922","display_name":"University of \u017dilina","ror":"https://ror.org/031wwwj55","country_code":"SK","type":"education","lineage":["https://openalex.org/I3122011922"]}],"countries":["SK"],"is_corresponding":false,"raw_author_name":"Karol Matiasko","raw_affiliation_strings":["University of \u017dilina, \u017dilina, Slovakia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of \u017dilina, \u017dilina, Slovakia","institution_ids":["https://openalex.org/I3122011922"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I3122011922"],"apc_list":null,"apc_paid":null,"fwci":0.8139,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.64095046,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"301","last_page":"306"},"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.9998999834060669,"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.9998999834060669,"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.9998000264167786,"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"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9933000206947327,"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/search-engine-indexing","display_name":"Search engine indexing","score":0.8712148666381836},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8511786460876465},{"id":"https://openalex.org/keywords/access-method","display_name":"Access method","score":0.8159228563308716},{"id":"https://openalex.org/keywords/data-access","display_name":"Data access","score":0.7502131462097168},{"id":"https://openalex.org/keywords/access-time","display_name":"Access time","score":0.726112961769104},{"id":"https://openalex.org/keywords/database-index","display_name":"Database index","score":0.69569993019104},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.597509503364563},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.5378251671791077},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4946875274181366},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.47635817527770996},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4662166237831116},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.4575568437576294},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.40986883640289307},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.34926456212997437},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.11348995566368103},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.07124766707420349}],"concepts":[{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.8712148666381836},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8511786460876465},{"id":"https://openalex.org/C70000936","wikidata":"https://www.wikidata.org/wiki/Q4672467","display_name":"Access method","level":2,"score":0.8159228563308716},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.7502131462097168},{"id":"https://openalex.org/C194080101","wikidata":"https://www.wikidata.org/wiki/Q46306","display_name":"Access time","level":2,"score":0.726112961769104},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.69569993019104},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.597509503364563},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.5378251671791077},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4946875274181366},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.47635817527770996},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4662166237831116},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.4575568437576294},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.40986883640289307},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.34926456212997437},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.11348995566368103},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.07124766707420349},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.23919/fruct52173.2021.9435500","is_oa":false,"landing_page_url":"https://doi.org/10.23919/fruct52173.2021.9435500","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2021 29th Conference of Open Innovations Association (FRUCT)","raw_type":"proceedings-article"},{"id":"pmh:oai:doaj.org/article:c923744549194d70a42569b5eb1b7218","is_oa":true,"landing_page_url":"https://doaj.org/article/c923744549194d70a42569b5eb1b7218","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proceedings of the XXth Conference of Open Innovations Association FRUCT, Vol 29, Iss 1, Pp 301-306 (2021)","raw_type":"article"}],"best_oa_location":{"id":"pmh:oai:doaj.org/article:c923744549194d70a42569b5eb1b7218","is_oa":true,"landing_page_url":"https://doaj.org/article/c923744549194d70a42569b5eb1b7218","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proceedings of the XXth Conference of Open Innovations Association FRUCT, Vol 29, Iss 1, Pp 301-306 (2021)","raw_type":"article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W203994246","https://openalex.org/W1828830091","https://openalex.org/W1982525351","https://openalex.org/W2118995957","https://openalex.org/W2516325541","https://openalex.org/W2517928160","https://openalex.org/W2527247821","https://openalex.org/W2587546647","https://openalex.org/W2901432962","https://openalex.org/W2965573702","https://openalex.org/W2966199271","https://openalex.org/W3005462316","https://openalex.org/W3036497122","https://openalex.org/W3109300389","https://openalex.org/W3129399395","https://openalex.org/W3130910804","https://openalex.org/W4232054743","https://openalex.org/W6677581237"],"related_works":["https://openalex.org/W3165129262","https://openalex.org/W4206506422","https://openalex.org/W1552854834","https://openalex.org/W3138885233","https://openalex.org/W3005462316","https://openalex.org/W4288916633","https://openalex.org/W2098819332","https://openalex.org/W4388620453","https://openalex.org/W2905752331","https://openalex.org/W4311300652"],"abstract_inverted_index":{"An":[0],"increasing":[1],"amount":[2],"of":[3,58,60,84,93,127,142,145],"data":[4,25,39,112,132],"is":[5,26,33,63,101,104,136],"stored":[6],"and":[7,30,49,87,129,150],"managed":[8],"in":[9,91,138],"today's":[10],"information":[11],"systems.":[12],"For":[13],"this":[14],"purpose,":[15],"relational":[16],"databases":[17],"are":[18],"used":[19],"very":[20],"often.":[21],"Fast":[22],"access":[23,40,69,109,133],"to":[24,68,108],"becoming":[27],"increasingly":[28],"important":[29],"great":[31],"emphasis":[32],"placed":[34],"on":[35,131],"its":[36],"improvement.":[37],"The":[38],"time":[41,94],"can":[42,73],"be":[43,74],"significantly":[44],"improved":[45],"by":[46],"creating":[47],"partitions":[48,146],"index":[50],"structures,":[51],"or":[52,66,95],"their":[53],"combinations.":[54],"From":[55],"the":[56,82,111,116,125],"point":[57],"view":[59],"efficiency,":[61,89],"it":[62],"not":[64],"appropriate":[65],"necessary":[67],"all":[70],"data.":[71],"They":[72],"divided":[75],"into":[76],"smaller":[77],"parts,":[78],"which":[79,135],"will":[80],"facilitate":[81],"execution":[83],"certain":[85],"operations":[86],"bring":[88],"whether":[90],"terms":[92],"performance.":[96],"As":[97],"far":[98],"as":[99],"indexing":[100,130],"concerned,":[102],"there":[103],"also":[105],"an":[106],"opportunity":[107],"only":[110],"sought,":[113],"thus":[114],"avoiding":[115],"Table":[117],"Access":[118],"Full":[119],"method.":[120],"This":[121],"paper":[122],"deals":[123],"with":[124],"effect":[126],"partitioning":[128],"time,":[134],"compared":[137],"seven":[139],"different":[140,143],"scenarios":[141],"combinations":[144],"created":[147],"over":[148],"tables":[149],"indexes.":[151]},"counts_by_year":[{"year":2024,"cited_by_count":3}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}