SQL Ledger: Cryptographically Verifiable Data in Azure SQL Database

被引:10
|
作者
Antonopoulos, Panagiotis [1 ]
Kaushik, Raghav [1 ]
Kodavalla, Hanuma [1 ]
Aceves, Sergio Rosales [1 ]
Wong, Reilly [1 ]
Anderson, Jason [1 ]
Szymaszek, Jakub [1 ]
机构
[1] Microsoft, Redmond, WA 98052 USA
关键词
Database Security; Integrity Protection; Data Verifiability; Ledger; Blockchain; Cryptographic Verifiability;
D O I
10.1145/3448016.3457558
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
SQL Ledger is a new technology that allows cryptographically verifying the integrity of relational data stored in Azure SQL Database and SQL Server. This is achieved by maintaining all historical data in the database and persisting its cryptographic (SHA-256) digests in an immutable, tamper-evident ledger. Digests representing the overall state of the ledger can then be extracted and stored outside of the RDBMS to protect the data from any attacker or high privileged user, including DBAs, system and cloud administrators. The ledger and the historical data are managed transparently, offering protection without any application changes. Historical data is maintained in a relational form to support SQL queries for auditing, forensics and other purposes. SQL Ledger provides cryptographic data integrity guarantees while maintaining the power, flexibility and performance of a commercial RDBMS. In contrast to Blockchain solutions that aim for full integrity, SQL Ledger offers a form of integrity protection known as Forward Integrity. The proposed technology is significantly cheaper and more secure than traditional solutions that establish trust based on audits or mediators, but also has substantial advantages over Blockchain solutions that are complex to deploy, lack data management capabilities and suffer in terms of performance due to their decentralized nature.
引用
收藏
页码:2437 / 2449
页数:13
相关论文
共 50 条
  • [21] Research on Data Transplantation between Chinese Database and SQL Server
    Hao, Zhongxiao
    Yu, Xinyu
    [J]. ICAIE 2009: PROCEEDINGS OF THE 2009 INTERNATIONAL CONFERENCE ON ARTIFICIAL INTELLIGENCE AND EDUCATION, VOLS 1 AND 2, 2009, : 10 - 14
  • [22] Data adapter for querying and transformation between SQL and NoSQL database
    Liao, Ying-Ti
    Zhou, Jiazheng
    Lu, Chia-Hung
    Chen, Shih-Chang
    Hsu, Ching-Hsien
    Chen, Wenguang
    Jiang, Mon-Fong
    Chung, Yeh-Ching
    [J]. FUTURE GENERATION COMPUTER SYSTEMS-THE INTERNATIONAL JOURNAL OF ESCIENCE, 2016, 65 : 111 - 121
  • [23] Uniform data access platform for SQL and NoSQL database systems
    Vathy-Fogarassy, Agnes
    Hugyak, Tamas
    [J]. INFORMATION SYSTEMS, 2017, 69 : 93 - 105
  • [24] Performance of OnPrem Versus Azure SQL Server: A Case Study
    Gyorodi, Robert
    Pavel, Marius Iulian
    Gyorodi, Cornelia
    Zmaranda, Doina
    [J]. IEEE ACCESS, 2019, 7 : 15894 - 15902
  • [25] FUNCTIONAL SQL (FSQL), AN SQL UPWARD-COMPATIBLE DATABASE PROGRAMMING LANGUAGE
    VALDURIEZ, P
    DANFORTH, S
    [J]. INFORMATION SCIENCES, 1992, 62 (03) : 183 - 203
  • [26] Migration from an SQL to a hybrid SQL/NoSQL data model
    Sokolova, Marina, V
    Gomez, Francisco J.
    Borisoglebskaya, Larisa N.
    [J]. JOURNAL OF MANAGEMENT ANALYTICS, 2020, 7 (01) : 1 - 11
  • [27] Impact of SQL Injection in Database Security
    Gupta, Himanshu
    Mondal, Subhash
    Ray, Srayan
    Giri, Biswajit
    Majumdar, Rana
    Mishra, Ved P.
    [J]. PROCEEDINGS OF 2019 INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE AND KNOWLEDGE ECONOMY (ICCIKE' 2019), 2019, : 296 - 299
  • [28] BILLS OF MATERIAL PROCESSING WITH A SQL DATABASE
    NANDAKUMAR, G
    [J]. COMPUTERS & INDUSTRIAL ENGINEERING, 1990, 18 (04) : 471 - 483
  • [29] Mutation Analysis for SQL Database Applications
    Cabeca, Andrea Goncalves
    Jino, Mario
    Leitao-Junior, Plinio S.
    [J]. 2009 FOURTH INTERNATIONAL CONFERENCE ON SOFTWARE ENGINEERING ADVANCES (ICSEA 2009), 2009, : 146 - +
  • [30] Restful State Machines and SQL Database
    Kufner, Josef
    Marik, Radek
    [J]. IEEE ACCESS, 2019, 7 : 144603 - 144617