Blockchain Tables in Oracle Database: Technology Convergence

October 1, 2019 | 4 minute read
Mark Rakhmilevich
Vice President, Blockchain Product Management
Text Size 100%:

When Oracle announced Machine Learning capabilities in Oracle Database a few years ago, some people undoubtedly questioned the wisdom of putting AI/ML in a traditional database system. A couple years later and we see real-world customers reporting significant benefits of the Autonomous Database (ADW and ATP varieties) that provide greater performance and security while drastically lowering labor costs. Beyond using AI/ML to improve the database operations, Oracle Machine Learning has enabled SQL and PL/SQL access to scalable in-database implementations of machine learning algorithms using Apache Zeppelin-based notebook technology. This enables data scientists, citizen data scientists, and data analysts to work with machine learning solutions from preparation through deployment – all in the Autonomous Database. 

Technology convergence isn’t limited to AI/ML. A few month after last summer’s release of our enterprise-grade Oracle Blockchain Platform (OBP) built on Linux Foundation’s Hyperledger Fabric open source project, some customers raised requirements about performing analytics on blockchain ledger transactions. At the OOW 2018, Oracle demonstrated, and soon thereafter released, the rich history database feature for OBP, which asynchronously streams blockchain state and transaction history into ADW and other Oracle databases using pre-built schema to enable rich analytics and BI capabilities on near real-time blockchain updates.  More convergence and marrying of open source blockchain and traditional database capabilities to enable unique enterprise benefits.

At the most recent OOW this month Larry Ellison and Juan Loaiza announced new converged features in Oracle Autonomous Database, including the new Blockchain Table type. Among the many blockchain events at OOW 2019, this one stood out.  Our experience over the last few years working with customers deploying blockchain technology showed that not every project requires full capabilities of blockchain technology and the related complexity of introducing a completely new technology stack into their IT environment.  Some customers want to leverage the tamper-resistance and non-repudiation properties of the blockchain in use cases that do not involve multiple organizations. Blockchain Tables enable customers to use Oracle Database when they need highly tamper-resistant data management but do not require distributing the ledger across multiple organizations or relying on a decentralized trust model. They can also be used to improve data integrity and fraud protections of services provided by central authorities, such as an Escrow company, a SaaS service provider, Trade Exchange, or a Central Bank.

Why is Oracle Database Providing a Blockchain Table?

There are a number of applications where customers would benefit from user fraud protection and administrator fraud protection.  Not only are insider attacks the most difficult to identify, but having your user’s or DBA’s credentials spearfished could open up a lot of critical data to an external hacker. Blockchain tables provide stronger database security by protecting against user fraud where someone rewrites their history, deletes certain data, or encrypts it for ransom. 

It can also provide identity fraud protection – the optional signing of row data with the PKI signatures based on the user’s private key protects against users or admins impersonating a different database user, or database user claiming that someone else was impersonating them.

In addition, it can protect against DBA actions if you enable encryption and use Oracle Database Vault.  And if you are concerned about admins with full root access subverting these levels of added protection, you can implement a “Trust but Verify” model by periodically copying cryptographic hashes and user signatures to external stores.  No matter what happens, even if your database was rolled back to a previous point in time and subsequent inserts replaced with fraudulent entries, you could compare the hashes and PKI signatures against the external audit log to verify data integrity and detect any tampering.

The result is an easy-to-use but highly tamper-resistant centralized data management option that transparently supports existing applications, and enables users and developers to leverage the rich set of Oracle development tools and environments, including SQL, PL/SQL, JDBC, etc.  It also provides very high insert rates compared to a decentralized blockchain because commits do not require consensus.  It’s going to be built into Oracle Database 20c – in the cloud, on-premises, and part of Autonomous Database. And it can be used together with regular tables and many other database features, including the aforementioned Machine Learning capabilities thanks to technology convergence in Oracle Database.

How Do I determine whether to use Blockchain Tables or Blockchain Platform?

Here’s a summary comparison of Database Blockchain Tables and Blockchain Platform:

Common attributes of Blockchain Tables and Blockchain Platform:

  • Append-only data
  • Chaining using cryptographic hashing for tamper-resistance
  • Digitally signed updates (optional in Blockchain Tables, mandatory in Blockchain Platform transactions)

Additional Blockchain Tables Features or Attributes

  • Built-in database backup and archiving, partitioning, access control
  • Higher throughput for insert transactions
  • Programming model using SQL and PL/SQL
  • No new infrastructure required beyond Oracle Database

Common use cases that benefit from Blockchain Tables include maintaining a centralized immutable transaction log/audit trail, storing compliance data (e.g., used in SOX 404-covered financial reporting, SEC compliance reporting, FDA reporting for clinical trials, etc.), using it for financials / accounting ledger/sub-ledger tables, legal hold data, centralized chain of custody or provenance information.

Additional Blockchain Platform Features or Attributes

  • Distributed ledger replicated across organizations
  • Multi-signature, decentralized trust
  • Smart contracts executed across multiple nodes
  • Open-source based and inter-operable with other Hyperledger Fabric blockchain nodes

Common use cases that benefit from Blockchain Platform include decentralized record keeping/audit trail, supply chain provenance & authenticity across a trading community, multi-party exchange transactions – payments, funds-transfer, asset tokenization, marketplaces, etc., digital identity or certifications across multiple issuers, business transactions based on multi-party object/document matching & reconciliation, multi-brand loyalty systems, Know-Your-Customer (KYC) solutions in financial services or Know-Your-Supplier (KYS) solutions in supply chain ecosystems.

For more information about Blockchain Tables, follow this Oracle Blockchain blog, which covers all the news of Oracle Blockchain offerings:

Mark Rakhmilevich

Vice President, Blockchain Product Management

Mark is responsible for Blockchain strategy and products. He focuses on evolving Oracle Blockchain Platform and Oracle Database Blockchain Tables in the cloud and on-premises to meet the needs of customers and partners for scalable, secure, production-ready platform to support blockchain solutions. He helps to guide customers and partners around the world in applying blockchain technology to deliver on key business outcomes – accelerating growth, reducing costs and friction in business ecosystems, reducing risk and fraud, and bringing to market innovative solutions that solve real-world societal challenges. Mark facilitates customers’ journey from rapid experimentation to live production through discovery, sharing industry use cases and best practices, and advising on solution architecture.


Previous Post

Big Week for Blockchain at OpenWorld 2019

Mark Rakhmilevich | 7 min read

Next Post


Welcome to the Future of Finance with Blockchain

Emma Hitzke | 5 min read