Research and implementation of HTAP for distributed database

Data processing can be roughly divided into two categories, online transaction processing OLTP(on-line transaction processing) and online analytical processing OLAP(on-line analytical processing). OLTP is the main application of traditional relational databases, and it is some basic daily transactio...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Xibei Gongye Daxue Xuebao Jg. 39; H. 2; S. 430 - 438
Hauptverfasser: Jing, Changhong, Liu, Wenjie, Gao, Jintao, Pei, Ouya
Format: Journal Article
Sprache:Chinesisch
Englisch
Veröffentlicht: EDP Sciences 01.04.2021
Schlagworte:
data analysis
distributed database
htap
olap
ISSN:1000-2758, 2609-7125
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Abstract Data processing can be roughly divided into two categories, online transaction processing OLTP(on-line transaction processing) and online analytical processing OLAP(on-line analytical processing). OLTP is the main application of traditional relational databases, and it is some basic daily transaction processing, such as bank pipeline transactions and so on. OLAP is the main application of the data warehouse system, it supports some more complex data analysis operations, focuses on decision support, and provides popular and intuitive analysis results. As the amount of data processed by enterprises continues to increase, distributed databases have gradually replaced stand-alone databases and become the mainstream of applications. However, the current business supported by distributed databases is mainly based on OLTP applications, lacking OLAP implementation. This paper proposes an implementation method of HTAP for distributed database CBase, which provides an implementation method of OLAP analysis for CBase, and can easily deal with data analysis of large amounts of data. 数据处理可大致分为2类，联机事务处理OLTP（on-line transaction processing）和联机分析处理OLAP（on-line analytical processing）。OLTP是传统关系型数据库的主要应用，支持一些基本的日常的事务处理，如银行流水交易等。OLAP是数据仓库系统的主要应用，支持一些较为复杂的数据分析操作，专注于决策支持，提供出通俗直观的分析结果。随着企业处理数据量的不断增加，分布式数据库已经逐渐取代单机数据库，成为应用的主流。但目前分布式数据库支持的业务主要以OLTP应用为主，缺少OLAP实现。提出了一种面向分布式数据库CBase的HTAP的实现方法，为CBase提供了一种OLAP分析的实现方式，可以轻松应对大数据量的数据分析。
AbstractList Data processing can be roughly divided into two categories, online transaction processing OLTP(on-line transaction processing) and online analytical processing OLAP(on-line analytical processing). OLTP is the main application of traditional relational databases, and it is some basic daily transaction processing, such as bank pipeline transactions and so on. OLAP is the main application of the data warehouse system, it supports some more complex data analysis operations, focuses on decision support, and provides popular and intuitive analysis results. As the amount of data processed by enterprises continues to increase, distributed databases have gradually replaced stand-alone databases and become the mainstream of applications. However, the current business supported by distributed databases is mainly based on OLTP applications, lacking OLAP implementation. This paper proposes an implementation method of HTAP for distributed database CBase, which provides an implementation method of OLAP analysis for CBase, and can easily deal with data analysis of large amounts of data.
Data processing can be roughly divided into two categories, online transaction processing OLTP(on-line transaction processing) and online analytical processing OLAP(on-line analytical processing). OLTP is the main application of traditional relational databases, and it is some basic daily transaction processing, such as bank pipeline transactions and so on. OLAP is the main application of the data warehouse system, it supports some more complex data analysis operations, focuses on decision support, and provides popular and intuitive analysis results. As the amount of data processed by enterprises continues to increase, distributed databases have gradually replaced stand-alone databases and become the mainstream of applications. However, the current business supported by distributed databases is mainly based on OLTP applications, lacking OLAP implementation. This paper proposes an implementation method of HTAP for distributed database CBase, which provides an implementation method of OLAP analysis for CBase, and can easily deal with data analysis of large amounts of data. 数据处理可大致分为2类，联机事务处理OLTP（on-line transaction processing）和联机分析处理OLAP（on-line analytical processing）。OLTP是传统关系型数据库的主要应用，支持一些基本的日常的事务处理，如银行流水交易等。OLAP是数据仓库系统的主要应用，支持一些较为复杂的数据分析操作，专注于决策支持，提供出通俗直观的分析结果。随着企业处理数据量的不断增加，分布式数据库已经逐渐取代单机数据库，成为应用的主流。但目前分布式数据库支持的业务主要以OLTP应用为主，缺少OLAP实现。提出了一种面向分布式数据库CBase的HTAP的实现方法，为CBase提供了一种OLAP分析的实现方式，可以轻松应对大数据量的数据分析。
Author Jing, Changhong
Pei, Ouya
Liu, Wenjie
Gao, Jintao
Author_xml – sequence: 1
  givenname: Changhong
  surname: Jing
  fullname: Jing, Changhong
– sequence: 2
  givenname: Wenjie
  surname: Liu
  fullname: Liu, Wenjie
– sequence: 3
  givenname: Jintao
  surname: Gao
  fullname: Gao, Jintao
– sequence: 4
  givenname: Ouya
  surname: Pei
  fullname: Pei, Ouya
BookMark eNp1kN1KAzEQhYNUsNY-gHf7Amtnkv0LeFOK2kJBkXodZjcTTWk3JbtFfHtrqyCCVwMHvo8z51IM2tCyENcINwg5Ttbt-24_kSBRaQmZgjMxlAXotESZD8QQASCVZV5diHHX-RpyjZDJKhuK22fumGLzllBrE7_dbXjLbU-9D20SXDJfTZ8SF2JifddHX-97tomlnmrq-EqcO9p0PP6-I_Fyf7eazdPl48NiNl2mDWoNaW51UyGrsmIuJVPpMmczJZVjh4VCmTEeShc5oCpqBKtc6QhkXTW2to7USCxOXhtobXbRbyl-mEDeHIMQXw3F3jcbNgVKZ22uiUqZFbUmqRRYjQ6KgisnD67y5Gpi6LrIzjT-9G4fyW8Mgvna1Bw3Nb82PZD4h_xp8j_zCSxGfCg
CitedBy_id crossref_primary_10_3389_fphy_2024_1484115
crossref_primary_10_1051_jnwpu_20244230453
crossref_primary_10_1051_jnwpu_20244220303
Cites_doi 10.1145/3035918.3035959
10.1109/SIU.2018.8404688
10.1109/IPDPSW.2016.138
10.1109/ICDE.2017.8
10.3233/MGS-190311
10.1109/ICDCS.2016.71
10.1109/ICDE.2018.00028
10.1145/3352700.3352709
10.1007/978-3-319-77525-8_257
ContentType Journal Article
DBID AAYXX
CITATION
DOA
DOI 10.1051/jnwpu/20213920430
DatabaseName CrossRef
DOAJ Directory of Open Access Journals
DatabaseTitle CrossRef
DatabaseTitleList
CrossRef
Database_xml – sequence: 1
  dbid: DOA
  name: DOAJ Directory of Open Access Journals
  url: https://www.doaj.org/
  sourceTypes: Open Website
DeliveryMethod fulltext_linktorsrc
EISSN 2609-7125
EndPage 438
ExternalDocumentID oai_doaj_org_article_612fdd59aa7246b9a2330d91f066e8f2
10_1051_jnwpu_20213920430
GroupedDBID AAYXX
AFFHD
AFKRA
ALMA_UNASSIGNED_HOLDINGS
BENPR
CCPQU
CITATION
PHGZM
PHGZT
PIMPY
GROUPED_DOAJ
ID FETCH-LOGICAL-c1990-5d9c81e378ee72ea7f4fd4323fef163124e1430650136b10d3f7fa02b8cdbdfa3
IEDL.DBID DOA
ISSN 1000-2758
IngestDate Tue Oct 14 18:53:49 EDT 2025
Sat Nov 29 03:57:37 EST 2025
Tue Nov 18 22:12:26 EST 2025
IsDoiOpenAccess true
IsOpenAccess true
IsPeerReviewed true
IsScholarly true
Issue 2
Language Chinese
English
License http://creativecommons.org/licenses/by/4.0
LinkModel DirectLink
MergedId FETCHMERGED-LOGICAL-c1990-5d9c81e378ee72ea7f4fd4323fef163124e1430650136b10d3f7fa02b8cdbdfa3
OpenAccessLink https://doaj.org/article/612fdd59aa7246b9a2330d91f066e8f2
PageCount 9
ParticipantIDs doaj_primary_oai_doaj_org_article_612fdd59aa7246b9a2330d91f066e8f2
crossref_citationtrail_10_1051_jnwpu_20213920430
crossref_primary_10_1051_jnwpu_20213920430
PublicationCentury 2000
PublicationDate 2021-04-00
2021-04-01
PublicationDateYYYYMMDD 2021-04-01
PublicationDate_xml – month: 04
  year: 2021
  text: 2021-04-00
PublicationDecade 2020
PublicationTitle Xibei Gongye Daxue Xuebao
PublicationYear 2021
Publisher EDP Sciences
Publisher_xml – name: EDP Sciences
References R2
R10
R3
R4
R5
R11
R6
R8
R9
Chaalal (R7) 2019; 1
Liu (R1) 2019; 47
References_xml – ident: R2
  doi: 10.1145/3035918.3035959
– ident: R8
  doi: 10.1109/SIU.2018.8404688
– volume: 47
  start-page: 121
  issue: 2
  year: 2019
  ident: R1
  publication-title: Journal of Huazhong University
– ident: R11
  doi: 10.1109/IPDPSW.2016.138
– ident: R9
  doi: 10.1109/ICDE.2017.8
– ident: R3
– volume: 1
  start-page: 237
  year: 2019
  ident: R7
  publication-title: Multiagent and Grid Systems
  doi: 10.3233/MGS-190311
– ident: R4
  doi: 10.1109/ICDCS.2016.71
– ident: R6
  doi: 10.1109/ICDE.2018.00028
– ident: R10
  doi: 10.1145/3352700.3352709
– ident: R5
  doi: 10.1007/978-3-319-77525-8_257
SSID ssib059104284
ssib001129888
ssib046626106
ssib036436219
ssib044765131
ssib044604139
ssib051375596
ssib002258180
Score 2.169185
Snippet Data processing can be roughly divided into two categories, online transaction processing OLTP(on-line transaction processing) and online analytical processing...
SourceID doaj
crossref
SourceType Open Website
Enrichment Source
Index Database
StartPage 430
SubjectTerms data analysis
distributed database
htap
olap
Title Research and implementation of HTAP for distributed database
URI https://doaj.org/article/612fdd59aa7246b9a2330d91f066e8f2
Volume 39
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
journalDatabaseRights – providerCode: PRVHPJ
  databaseName: ROAD: Directory of Open Access Scholarly Resources
  customDbUrl:
  eissn: 2609-7125
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssib044765131
  issn: 1000-2758
  databaseCode: M~E
  dateStart: 20180101
  isFulltext: true
  titleUrlDefault: https://road.issn.org
  providerName: ISSN International Centre
– providerCode: PRVPQU
  databaseName: AUTh Library subscriptions: ProQuest Central
  customDbUrl:
  eissn: 2609-7125
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssib059104284
  issn: 1000-2758
  databaseCode: BENPR
  dateStart: 20180201
  isFulltext: true
  titleUrlDefault: https://www.proquest.com/central
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: Publicly Available Content Database
  customDbUrl:
  eissn: 2609-7125
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssib059104284
  issn: 1000-2758
  databaseCode: PIMPY
  dateStart: 20180201
  isFulltext: true
  titleUrlDefault: http://search.proquest.com/publiccontent
  providerName: ProQuest
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwrV1NS8NAEF2kevAiior1o-zBkxCabPYjAS-ttPQgpUiF3sJudhcr2kptFfz1ziRNGy968Zhks0kmQ96bzOwbQq6F4VI4xwItmAu4NTIwysaBAffgRnGbu0Jd_14Nh8lkko5qrb6wJqyUBy4N1wYE9taKVGvFuDSpZhCB2zTygJUu8cXXF1hPLZgqiADAWFIX4mICFzVX2zHgsGRbITOIiUJe08fkXEkRbfNjXALvr-Uj4ZgCKr7dBtAFHl-ksHGpNgMWXqVQRdR-nn2-rfA3A1wC16KGP0Cw1iugALX-ITlYs1HaKa1wRHa-no7JbVWNR_XM0ulrVWGOr5DOPR2MOyMKXJdaFN3FflnOUqw0RUQ8IY_93vhuEKybLAR5BEgUCJvmSeRilTinmNPKc295zGLvPHA1gH8HlAqJXBRLE4U29srrkJkkt8Z6HZ-Sxmw-c2eESs1yIXnoeW658AzsrFkIMzrUeVWqScLqqbN8rUCOjTBesiITLiASQUNlNUM1yc3mlLdSfuO3wV005WYgKmcXO8CfsrU_ZX_50_l_THJB9vG-ygqfS9JYLlbuiuzlH8vp-6JFdru94eihVbjsNwMM4A8
linkProvider Directory of Open Access Journals
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Research+and+implementation+of+HTAP+for+distributed+database&rft.jtitle=Xibei+Gongye+Daxue+Xuebao%2FJournal+of+Northwestern+Polytechnical+University&rft.au=Jing%2C+Changhong&rft.au=Liu%2C+Wenjie&rft.au=Gao%2C+Jintao&rft.au=Pei%2C+Ouya&rft.date=2021-04-01&rft.issn=1000-2758&rft.eissn=2609-7125&rft.volume=39&rft.issue=2&rft.spage=430&rft.epage=438&rft_id=info:doi/10.1051%2Fjnwpu%2F20213920430&rft.externalDBID=n%2Fa&rft.externalDocID=10_1051_jnwpu_20213920430
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=1000-2758&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=1000-2758&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=1000-2758&client=summon