Matches in SemOpenAlex for { <https://semopenalex.org/work/W4206093259> ?p ?o ?g. }
Showing items 1 to 54 of
54
with 100 items per page.
- W4206093259 endingPage "0" @default.
- W4206093259 startingPage "0" @default.
- W4206093259 abstract "In database management systems (DBMSs), query workloads can be classified as online transactional processing (OLTP) or online analytical processing (OLAP). These often run within separate DBMSs. In hybrid transactional and analytical processing (HTAP), both workloads may execute within the same DBMS. This article shows that it is possible to run separate OLTP and OLAP DBMSs, and still support timely business decisions from analytical queries running off fresh transactional data. Several setups to manage OLTP and OLAP workloads are analysed. Then, benchmarks on two industry standard DBMSs empirically show that, under an OLTP workload, a row-store DBMS sustains a 1000 times higher throughput than a columnar DBMS, whilst OLAP queries are more than 4 times faster on a columnar DBMS. Finally, a reactive streaming ETL pipeline is implemented which connects these two DBMSs. Separate benchmarks show that OLTP events can be streamed to an OLAP database within a few seconds." @default.
- W4206093259 created "2022-01-26" @default.
- W4206093259 date "2021-10-01" @default.
- W4206093259 modified "2023-09-28" @default.
- W4206093259 title "HTAP With Reactive Streaming ETL" @default.
- W4206093259 doi "https://doi.org/10.4018/jcit.20211001oa05" @default.
- W4206093259 hasPublicationYear "2021" @default.
- W4206093259 type Work @default.
- W4206093259 citedByCount "0" @default.
- W4206093259 crossrefType "journal-article" @default.
- W4206093259 hasBestOaLocation W42060932592 @default.
- W4206093259 hasConcept C111919701 @default.
- W4206093259 hasConcept C135572916 @default.
- W4206093259 hasConcept C157764524 @default.
- W4206093259 hasConcept C191087605 @default.
- W4206093259 hasConcept C201932085 @default.
- W4206093259 hasConcept C2778476105 @default.
- W4206093259 hasConcept C41008148 @default.
- W4206093259 hasConcept C555944384 @default.
- W4206093259 hasConcept C72108876 @default.
- W4206093259 hasConcept C75949130 @default.
- W4206093259 hasConcept C77088390 @default.
- W4206093259 hasConceptScore W4206093259C111919701 @default.
- W4206093259 hasConceptScore W4206093259C135572916 @default.
- W4206093259 hasConceptScore W4206093259C157764524 @default.
- W4206093259 hasConceptScore W4206093259C191087605 @default.
- W4206093259 hasConceptScore W4206093259C201932085 @default.
- W4206093259 hasConceptScore W4206093259C2778476105 @default.
- W4206093259 hasConceptScore W4206093259C41008148 @default.
- W4206093259 hasConceptScore W4206093259C555944384 @default.
- W4206093259 hasConceptScore W4206093259C72108876 @default.
- W4206093259 hasConceptScore W4206093259C75949130 @default.
- W4206093259 hasConceptScore W4206093259C77088390 @default.
- W4206093259 hasIssue "4" @default.
- W4206093259 hasLocation W42060932591 @default.
- W4206093259 hasLocation W42060932592 @default.
- W4206093259 hasOpenAccess W4206093259 @default.
- W4206093259 hasPrimaryLocation W42060932591 @default.
- W4206093259 hasRelatedWork W1487822231 @default.
- W4206093259 hasRelatedWork W1575027207 @default.
- W4206093259 hasRelatedWork W180585608 @default.
- W4206093259 hasRelatedWork W2067405892 @default.
- W4206093259 hasRelatedWork W2084383859 @default.
- W4206093259 hasRelatedWork W2382554682 @default.
- W4206093259 hasRelatedWork W2989435254 @default.
- W4206093259 hasRelatedWork W2997368697 @default.
- W4206093259 hasRelatedWork W3166336118 @default.
- W4206093259 hasRelatedWork W4235259909 @default.
- W4206093259 hasVolume "23" @default.
- W4206093259 isParatext "false" @default.
- W4206093259 isRetracted "false" @default.
- W4206093259 workType "article" @default.