中国综合性科技类核心期刊(北大核心)

中国科学引文数据库来源期刊(CSCD)

美国《化学文摘》(CA)收录

美国《数学评论》(MR)收录

俄罗斯《文摘杂志》收录

Message Board

Respected readers, authors and reviewers, you can add comments to this page on any questions about the contribution, review, editing and publication of this journal. We will give you an answer as soon as possible. Thank you for your support!

Name
E-mail
Phone
Title
Content
Verification Code
Issue 5
Sep.  2018
Turn off MathJax
Article Contents
HUANG Jian-wei, ZHANG Zhao, QIAN Wei-ning. Primary key management in distributed log-structured database systems[J]. Journal of East China Normal University (Natural Sciences), 2018, (5): 79-90, 119. doi: 10.3969/j.issn.1000-5641.2018.05.007
Citation: HUANG Jian-wei, ZHANG Zhao, QIAN Wei-ning. Primary key management in distributed log-structured database systems[J]. Journal of East China Normal University (Natural Sciences), 2018, (5): 79-90, 119. doi: 10.3969/j.issn.1000-5641.2018.05.007

Primary key management in distributed log-structured database systems

doi: 10.3969/j.issn.1000-5641.2018.05.007
  • Received Date: 2018-07-04
  • Publish Date: 2018-09-25
  • At present, there are a large number of writing-intensive loads (e.g., secondkilling of e-commerce, social user-generated data streams) in many applications such as e-commerce, social networking, mobile Internet and so on, which makes log-structured storage a popular technique for back-end storage of modern database systems. However, log-structured storage only supports the append operation, efficient primary key management (primary key generation and update) functions can improve the performance of database append operations. In the distributed and concurrent environment, implementing primary key maintenance faces challenges, such as primary key unique constraints, transactional maintenance, and high-performance requirements. In light of the characteristics of log-structured storage, this paper explores how to implement efficient primary key management in distributed log-structured database systems. First, we propose two kinds of concurrency control models for WAR (Write After Read) operations; second, we adopt these two models to design efficient primary key management algorithms; and finally, we integrate these algorithms into our distributed log-structured database, CEDAR, and verify the effectiveness of the proposed methods by a series of experiments.
  • loading
  • [1]
    ROSENBLUM M, OUSTERHOUT J K. The design and implementation of a log-structured file system[J]. ACM Transaction on Computer Systems, 1992, 10(1):26-52. doi:  10.1145/146941.146943
    [2]
    CHANG F, DEAN J, GHEMAWAT S, et al. Bigtable: A distributed storage system for structured data[C]//Symposium on Operating Systems Design and Implementation. USENIX Association, 2006: 205-218.
    [3]
    Hbase.[EB/OL].[2018-07-02]. http://hbase.apache.org/.
    [4]
    Cassandra.[EB/OL].[2018-07-02]. http://cassandra.apache.org/.
    [5]
    CDEAR.[EB/OL].[2018-07-02]. https://github.com/daseECNU/Cedar/.
    [6]
    O'NEIL P, CHENG E, GAWLICK D, et al. The log-structured merge-tree (LSM-tree)[J]. Acta Informatica, 1996, 33(4):351-385. doi:  10.1007/s002360050048
    [7]
    Mysql Cluster.[EB/OL].[2018-07-02]. https://www.mysql.com/products/cluster/.
    [8]
    STONEBRAKER M, WEISBERG A. The voltdb main memory DBMS[J]. IEEE Data Eng Bull, 2013, 36(2):21-27. http://www.researchgate.net/publication/297362705_The_voltdb_main_memory_dbms
    [9]
    OceanBase.[EB/OL].[2018-07-02]. https://github.com/alibaba/oceanbase/.
    [10]
    GARCIA-MOLINA H, ULLMAN J D, WIDOM J D. Database System Implementation[M]. London:Prentice Hall, 1999:576-601.
    [11]
    The Open Group. Distributed TP: The XA Specification[EB/OL].[2018-07-02]. https://publications.opengroup.org/c193.
    [12]
    KUNG H T. On optimistic methods for concurrency control[C]//International Conference on Very Large Data Bases. IEEE, 1981: 351-351. http://www.eecs.harvard.edu/~htk/publication/1981-tods-kung-robinson.pdf
    [13]
    CHOI H J, JEONG B S. A timestamp-based optimistic concurrency control for handling mobile transactions[C]//International Conference on Computational Science and Its Applications. Berlin: Springer-Verlag, 2006: 796-805. https://www.researchgate.net/publication/221433246_A_Timestamp-Based_Optimistic_Concurrency_Control_for_Handling_Mobile_Transactions
    [14]
    ESWARAN K P, GRAY J N, LORIE R A, et al. The notions of consistency and predicate locks in a database system[J]. Readings in Artificial Intelligence & Databases, 1989, 19(11):523-532. doi:  10.1145-360363.360369/
    [15]
    Sysbench.[EB/OL].[2018-07-02]. https://dev.mysql.com/downloads/benchmarks.html.
  • 加载中

Catalog

    通讯作者: 陈斌, bchen63@163.com
    • 1. 

      沈阳化工大学材料科学与工程学院 沈阳 110142

    1. 本站搜索
    2. 百度学术搜索
    3. 万方数据库搜索
    4. CNKI搜索

    Figures(9)  / Tables(4)

    Article views (247) PDF downloads(213) Cited by()
    Proportional views

    /

    DownLoad:  Full-Size Img  PowerPoint
    Return
    Return