Matches in SemOpenAlex for { <https://semopenalex.org/work/W2275101365> ?p ?o ?g. }
Showing items 1 to 76 of
76
with 100 items per page.
- W2275101365 abstract "As data volume grows rapidly and queries become more complex, database engine has to deal with larger amount of temporary data when performing operators such as sort and join. Generally, these temporary data are organized as small temporary files stored in HDD. Due to the poor access performance on HDD, processing time of I/O operations on these files has a direct impact on the response time of queries. Compared to HDD, solid-state drive (SSD) offers more random IOPS and comparable sequential bandwidth. So, using SSD to replace HDD may be an ideal pattern when dealing with temporary data. In this paper, we find out that query processing performing improvement is unsatisfactory if we store temporary files in SSD directly. Thus, we propose a SSD aware temporary data management policy called STDM. STDM takes both the I/O behaviors of temporary data and SSD physical characteristics into account. Temporary data are cached in memory at first, and then written to SSD in an append-only fashion. In this way, we reduce random writes and take full advantage of fast random reads on SSD. We implement a prototype based on PostgreSQL and evaluate its performance on TPC-H benchmark. Experiment result shows that STDM improves query processing performance dramatically compared to the traditional method for organizing temporary data." @default.
- W2275101365 created "2016-06-24" @default.
- W2275101365 creator A5030376340 @default.
- W2275101365 creator A5031593368 @default.
- W2275101365 creator A5040775204 @default.
- W2275101365 creator A5051428213 @default.
- W2275101365 date "2014-01-01" @default.
- W2275101365 modified "2023-09-22" @default.
- W2275101365 title "SSD-Aware Temporary Data Management Policy for Improving Query Performance" @default.
- W2275101365 cites W1981029608 @default.
- W2275101365 cites W1984282814 @default.
- W2275101365 cites W1990946453 @default.
- W2275101365 cites W2058178853 @default.
- W2275101365 cites W2107200720 @default.
- W2275101365 cites W2140472670 @default.
- W2275101365 cites W2152563679 @default.
- W2275101365 cites W2160607819 @default.
- W2275101365 cites W2171148344 @default.
- W2275101365 cites W2248060424 @default.
- W2275101365 doi "https://doi.org/10.1007/978-3-319-08010-9_44" @default.
- W2275101365 hasPublicationYear "2014" @default.
- W2275101365 type Work @default.
- W2275101365 sameAs 2275101365 @default.
- W2275101365 citedByCount "0" @default.
- W2275101365 crossrefType "book-chapter" @default.
- W2275101365 hasAuthorship W2275101365A5030376340 @default.
- W2275101365 hasAuthorship W2275101365A5031593368 @default.
- W2275101365 hasAuthorship W2275101365A5040775204 @default.
- W2275101365 hasAuthorship W2275101365A5051428213 @default.
- W2275101365 hasConcept C111919701 @default.
- W2275101365 hasConcept C115537543 @default.
- W2275101365 hasConcept C124101348 @default.
- W2275101365 hasConcept C13280743 @default.
- W2275101365 hasConcept C1668388 @default.
- W2275101365 hasConcept C185798385 @default.
- W2275101365 hasConcept C205649164 @default.
- W2275101365 hasConcept C41008148 @default.
- W2275101365 hasConcept C77088390 @default.
- W2275101365 hasConcept C88548561 @default.
- W2275101365 hasConceptScore W2275101365C111919701 @default.
- W2275101365 hasConceptScore W2275101365C115537543 @default.
- W2275101365 hasConceptScore W2275101365C124101348 @default.
- W2275101365 hasConceptScore W2275101365C13280743 @default.
- W2275101365 hasConceptScore W2275101365C1668388 @default.
- W2275101365 hasConceptScore W2275101365C185798385 @default.
- W2275101365 hasConceptScore W2275101365C205649164 @default.
- W2275101365 hasConceptScore W2275101365C41008148 @default.
- W2275101365 hasConceptScore W2275101365C77088390 @default.
- W2275101365 hasConceptScore W2275101365C88548561 @default.
- W2275101365 hasLocation W22751013651 @default.
- W2275101365 hasOpenAccess W2275101365 @default.
- W2275101365 hasPrimaryLocation W22751013651 @default.
- W2275101365 hasRelatedWork W1839347941 @default.
- W2275101365 hasRelatedWork W18491896 @default.
- W2275101365 hasRelatedWork W1987432376 @default.
- W2275101365 hasRelatedWork W2050810837 @default.
- W2275101365 hasRelatedWork W2152563679 @default.
- W2275101365 hasRelatedWork W2267550052 @default.
- W2275101365 hasRelatedWork W2562914768 @default.
- W2275101365 hasRelatedWork W2587463792 @default.
- W2275101365 hasRelatedWork W2785920376 @default.
- W2275101365 hasRelatedWork W2800512929 @default.
- W2275101365 hasRelatedWork W2889788596 @default.
- W2275101365 hasRelatedWork W2900408204 @default.
- W2275101365 hasRelatedWork W2944068645 @default.
- W2275101365 hasRelatedWork W2949505856 @default.
- W2275101365 hasRelatedWork W3041842376 @default.
- W2275101365 hasRelatedWork W3080945869 @default.
- W2275101365 hasRelatedWork W63154812 @default.
- W2275101365 hasRelatedWork W2310402921 @default.
- W2275101365 hasRelatedWork W2864262286 @default.
- W2275101365 hasRelatedWork W3027377508 @default.
- W2275101365 isParatext "false" @default.
- W2275101365 isRetracted "false" @default.
- W2275101365 magId "2275101365" @default.
- W2275101365 workType "book-chapter" @default.