{"id":179,"date":"2022-05-10T12:11:56","date_gmt":"2022-05-10T12:11:56","guid":{"rendered":"https:\/\/blockchain1o1.com\/blog\/?p=179"},"modified":"2022-05-10T14:41:58","modified_gmt":"2022-05-10T14:41:58","slug":"mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1","status":"publish","type":"post","link":"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/","title":{"rendered":"Mapping Blockchain with Database: Design and Implementation of Blockchain Relational Database"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Every time we said that applications of blockchain technology are not restricted to its use in cryptocurrency, we have on furthered the discussion on how else we might use it. We have, occasionally, spoken of business areas that might be disrupted by the technology, but we have not bothered to study the concept in their components. We have not shown in parts how the building blocks of a legacy system may be replaced by blockchain technology.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">However, here is an instance of an effort made to construct a blockchain database. In what the researchers have proposed we find a \u201cdecentralized replicated relational database with blockchain properties\u201d that they have called a blockchain relational database.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In the paper, the researchers have thrown light on a long list of similarities between features of blockchain platforms and a replicated relational database. And this, despite each being conceptually dissimilar &#8211; primarily in their trust model.\u00a0<\/span><\/p>\n<h2><b>Considerations<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">For this model, the researchers have considered a permissioned blockchain model of cognizant yet mutually distrustful organizations. Each organization works on its own database instance which are replicas of one another. The replicated databases execute transactions independently and are governed by decentralized consensus to determine the commit order for transactions.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Here the researchers have come up with two approaches to handle the tasks: in the first, the commit order for the transactions is agreed upon before their executions. In the second approach, the transactions are executed without prior signaling of the commit order with the ordering processes in parallel.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Researchers have leveraged serializable snapshot isolation (SSI) to ensure consistency among the replicas across nodes and also conform to the ordering determined by consensus. They have also devised a new variant of SSI based on block height for the latter approach. Next, they implemented the system on PostgreSQL and presented detailed performance experiments analyzing both approaches.\u00a0\u00a0<\/span><\/p>\n<p><strong>Also Read:<\/strong> <a href=\"https:\/\/blockchain1o1.com\/blog\/blockchain-the-technology-the-applications-and-the-possibilities\/\">Blockchain: The Technology, The Applications, and The Possibilities<\/a><\/p>\n<h2><b>The Objective<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">In this paper, the researchers have addressed this key challenge of ensuring that all the untrusted database nodes must execute transactions independently and commit them in the same serializable order asynchronously. To achieving this, two key design choices were made.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">First, they modified the database to separate the concerns of concurrent transaction execution and decentralized ordering of blocks of transactions. They leveraged ordering through consensus only to order blocks of transactions, and not for the serializable ordering of transactions within a single block. Second, independently at each node, the researchers leveraged serializable snapshot isolation (SSI) to execute transactions concurrently and then serially validate and commit each transaction in a block. This is done to obtain a serializable order that will be the identical across all untrusted nodes and will respect the ordering of blocks obtained from consensus. Applying these ideas, the researchers have come up with two novel approaches, the first is the scenario where block ordering is performed before transaction execution. The second scenario arises where transaction execution occurs parallelly without prior knowledge of block ordering, and discuss their trade-offs. We leverage and modify serializable snapshot isolation to create a novel variant which promises the same serializable ordering across all nodes. They implement their ideas on PostgreSQL going over the subtle challenges they had to overcome.\u00a0 \u00a0<\/span><\/p>\n<p><strong>Also Read:<\/strong> <a href=\"https:\/\/media.hashcashconsultants.com\/blockchain-shootout-unlearn-these-5-common-myths-on-blockchain-technology\/\">Blockchain Shootout: Unlearn These 5 Common Myths on Blockchain Technology<\/a><\/p>\n<h2><b>Key Components of a Blockchain Database Design<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">A permissioned network of organizations aware of each other\u2019s existence but mutually distrustful is the ground we focus on. The network is typically private to the participating organizations. A new organization has to be permissioned to become apart of\u00a0 the<\/span><\/p>\n<p><span style=\"font-weight: 400;\">network. Each participating organization includes clients, database peer nodes and ordering service nodes. This structure is described below, that as a cluster form the decentralized network.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Client: Each organization has a designated administrator charged with onboarding client users onto the network. This administrator and each client possess a digital certificate registered with all the database peers in the system. They use these certificates to digitally sign and submit transactions on the network. This helps bolster authenticity, non-repudiability and access control properties. Clients also come with the ability to listen on a notification channel to receive transaction status.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Database Peer Node: An organization may operate one or more database nodes in the network. All communication to send and receive transactions and blocks happens via a secure communication protocol such as TLS. Each node has a cryptographic identity (i.e., public key) assigned. This enables all communications to be signed and authenticated cryptographically. Each database node is responsible for maintaining its own replica of the ledger as database files. It is able to independently execute smart contracts as stored procedures, and validates and commits blocks of transactions formed by the ordering service.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ordering Service: Consensus is needed to guarantee that the untrusted database nodes agree on an ordering of blocks of transactions. The ordering service comprises of consensus or orderer nodes, each owned by a distinct organization. Every orderer node, similar to database nodes, have their own digital certificate or identity. The consensus results in a block of transactions, which is then atomically broadcast to all the database nodes. A block consists of (a) a sequence number, (b) a set of transactions, (c) metadata associated with the consensus protocol, (d) hash of the previous block, (e) hash of the current block, i.e., hash (a, b, c, d); and (f) digital signature on the hash of the current block by the orderer node.<\/span><\/p>\n<h2><b>Approach 1: Order then Execute\u00a0\u00a0\u00a0<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">A transaction made by a client in the order-then-execute approach comprises of\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">(a) a unique identifier,\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">(b) the username of the client,\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">(c) the PL\/SQL procedure execution command with the name of the procedure and arguments, and\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">(d) a digital signature on the hash(a, b, c)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">using the client\u2019s private key. Four pipelined phases comprise the transaction flow: ordering, execution, committing, and checkpointing. Here a submitted transaction needs <\/span><span style=\"font-weight: 400;\">to first be ordered, next executed, and finally committed before being written on a checkpoint.<\/span><\/p>\n<h3><b>Ordering Phase:<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">When a Client submits transactions directly to any one of the ordering service nodes, a periodic timeout (say every 1 second) is started. The ordering service nodes initiate a consensus protocol among themselves to construct a block of transactions. After constructing a block, the ordering service delivers it to all nodes in the network via atomic broadcast.<\/span><\/p>\n<h3><b>Execution Phase:<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">The Database nodes receive a block of transactions. Each database node verifies whether the received block is in sequence and forwarded by the ordering service. Upon successful verification, the node appends the block to a block store which is maintained in the local file system. Parallely, the node retrieves unprocessed blocks one at a time, in the order of their block sequence number, from the block store and processes them four sequential steps.<\/span><\/p>\n<h3><b>Committing Phase:<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Ensuring that the commit order is the same on all nodes, the order in which the transactions get committed is exactly how the transactions appear in the block. Once all valid transactions are executed and are ready to be either committed or aborted, the node serially notifies one thread at a time to proceed further. Each transaction applies the abort during commit approach to determine whether to commit. Accomplishing this does the next transaction enter the commit stage.\u00a0<\/span><\/p>\n<h3><b>Checkpointing Phase:<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">When all transactions in a block are executed, each node computes the hash of the write set. The is the result of the union of all changes made to the database by the block. Thereafter, the node submits it to the ordering service as a proof of execution and commit. When a node receives the subsequent blocks, it also would receive the hash of write set computed by other nodes. The hash computed by all non-faulty nodes would result in the exact same value and the node then proceeds to record a checkpoint. It is,however, not necessary to record a checkpoint corresponding to every block. Rather, the hash of write sets can be computed for a preconfigured number of blocks and then forwarded to the ordering service.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-180 size-large\" src=\"https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain-with-database-1024x683.png\" alt=\"Mapping Blockchain with Database\" width=\"580\" height=\"387\" srcset=\"https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain-with-database-1024x683.png 1024w, https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain-with-database-300x200.png 300w, https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain-with-database-768x512.png 768w, https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain-with-database-350x233.png 350w, https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain-with-database-270x180.png 270w, https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain-with-database.png 1200w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/p>\n<h2><b>Approach 2: Execute and Order in Parallel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">A transaction submitted by a client in the execute-orderin-parallel approach comprises of\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">(a) the username of the client,\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">(b) the PL\/SQL procedure execution command with the name of the procedure and arguments,\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">(c) a block number,\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">(d) a unique identifier which is computed as hash(a, b, c), and\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">(e) a digital signature on the hash(a, b, c, d)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">using the client\u2019s private key. The transaction flow is comprised of four phases: execution, ordering, committing, and checkpointing phase. A submitted transaction is processed by the<\/span><\/p>\n<p><span style=\"font-weight: 400;\">database nodes and in parallel according to the ordering nodes and is written on a block. This is followed by the commit and checkpoint phases. We describe each phase in detail below:<\/span><\/p>\n<h3><b>Execution Phase:\u00a0<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Clients submit transactions directly to one of the database nodes. Upon receiving a transaction, a node assigns a thread to authenticate, forward and execute the transaction.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">On successful authentication (same as in the order-thenexecute approach), the transaction is forwarded to other database nodes and the ordering service in the background.<\/span><\/p>\n<h3><b>Ordering Phase:<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Here database nodes submit transactions to the ordering service unlike the order-then-execute approach. It must be noted that the transactions are being executed in the database nodes while they are being ordered by the ordering service, concurrently.<\/span><\/p>\n<h3><b>Committing Phase:<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">As in the case of order-then-execute approach, an important pre-condition for transactions entering commit phase is that all transactions in a block must have accomplished its execution and are waiting to proceed with commit\/abort. However, they are different from the former approach in some ways.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">First, after receiving a block, if all transactions are not running, the committer begins executing all the missing transactions and waits for their completion. The comitter then proceeds to the committing phase. Second, unlike the former approach, it is possible for concurrent transactions to be executed at different snapshot heights (as specified by the respective clients). Finally, transactions, concurrent on one node, may not be concurrent on another. However, the set of transaction is needed, that is decidedly to be committed, to be identical on all nodes. As a result, the system doesn\u2019t support blind updates such as UPDATE table SET column = value; which might result in a lock for ww-dependency only on a subset of nodes.<\/span><\/p>\n<h3><b>Checkpointing Phase:<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Checkpointing Phase is the same as in the former approach.\u00a0\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-186 size-large\" src=\"https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/blockchain-mapping-process-1024x683.png\" alt=\"Blockchain mapping process\" width=\"580\" height=\"387\" srcset=\"https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/blockchain-mapping-process-1024x683.png 1024w, https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/blockchain-mapping-process-300x200.png 300w, https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/blockchain-mapping-process-768x512.png 768w, https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/blockchain-mapping-process-350x233.png 350w, https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/blockchain-mapping-process-270x180.png 270w, https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/blockchain-mapping-process.png 1200w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/p>\n<h2><b>In conclusion<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">In this paper, researchers have presented the design of a blockchain relational database, which is a decentralized database with replicas managed by different organizations that do not trust one another. The key challenge addressed here is in ensuring that all untrusted replicas commit transactions in the same serializable order that respects the block ordering determined by consensus.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Every time we said that applications of blockchain technology are not restricted to its use in cryptocurrency, we have on furthered the discussion on how else we might use it. We have, occasionally, spoken of business areas that might be disrupted by the technology, but we have not bothered to study the concept in their [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":183,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,2],"tags":[8,56,55],"class_list":["post-179","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blockchain","category-featured","tag-blockchain","tag-blockchain-database","tag-blockchain-implementation"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Mapping Blockchain with Database: Design and Implementation of Blockchain Relational Database - Blockchain 101<\/title>\n<meta name=\"description\" content=\"A study of the design and implementation of decentralized blockchain relational database view of its usage in enterprise applications.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mapping Blockchain with Database: Design and Implementation of Blockchain Relational Database - Blockchain 101\" \/>\n<meta property=\"og:description\" content=\"A study of the design and implementation of decentralized blockchain relational database view of its usage in enterprise applications.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Blockchain 101\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-10T12:11:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-10T14:41:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Admin_Blockchain\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Admin_Blockchain\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/\",\"url\":\"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/\",\"name\":\"Mapping Blockchain with Database: Design and Implementation of Blockchain Relational Database - Blockchain 101\",\"isPartOf\":{\"@id\":\"https:\/\/blockchain1o1.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain.jpg\",\"datePublished\":\"2022-05-10T12:11:56+00:00\",\"dateModified\":\"2022-05-10T14:41:58+00:00\",\"author\":{\"@id\":\"https:\/\/blockchain1o1.com\/blog\/#\/schema\/person\/6c04b2c17321ad56bd01a476f6b73f01\"},\"description\":\"A study of the design and implementation of decentralized blockchain relational database view of its usage in enterprise applications.\",\"breadcrumb\":{\"@id\":\"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/#primaryimage\",\"url\":\"https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain.jpg\",\"contentUrl\":\"https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain.jpg\",\"width\":1200,\"height\":800,\"caption\":\"Mapping Blockchain\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blockchain1o1.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mapping Blockchain with Database: Design and Implementation of Blockchain Relational Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blockchain1o1.com\/blog\/#website\",\"url\":\"https:\/\/blockchain1o1.com\/blog\/\",\"name\":\"Blockchain 101\",\"description\":\"Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blockchain1o1.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/blockchain1o1.com\/blog\/#\/schema\/person\/6c04b2c17321ad56bd01a476f6b73f01\",\"name\":\"Admin_Blockchain\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blockchain1o1.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0dc77fc16142af54e72d2d7a2c80f7f82564d74e74a7719c09936cbbbc885efc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0dc77fc16142af54e72d2d7a2c80f7f82564d74e74a7719c09936cbbbc885efc?s=96&d=mm&r=g\",\"caption\":\"Admin_Blockchain\"},\"sameAs\":[\"https:\/\/blockchain1o1.com\/blog\"],\"url\":\"https:\/\/blockchain1o1.com\/blog\/author\/admin_blockchain\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mapping Blockchain with Database: Design and Implementation of Blockchain Relational Database - Blockchain 101","description":"A study of the design and implementation of decentralized blockchain relational database view of its usage in enterprise applications.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/","og_locale":"en_US","og_type":"article","og_title":"Mapping Blockchain with Database: Design and Implementation of Blockchain Relational Database - Blockchain 101","og_description":"A study of the design and implementation of decentralized blockchain relational database view of its usage in enterprise applications.","og_url":"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/","og_site_name":"Blockchain 101","article_published_time":"2022-05-10T12:11:56+00:00","article_modified_time":"2022-05-10T14:41:58+00:00","og_image":[{"width":1200,"height":800,"url":"https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain.jpg","type":"image\/jpeg"}],"author":"Admin_Blockchain","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Admin_Blockchain","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/","url":"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/","name":"Mapping Blockchain with Database: Design and Implementation of Blockchain Relational Database - Blockchain 101","isPartOf":{"@id":"https:\/\/blockchain1o1.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/#primaryimage"},"image":{"@id":"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/#primaryimage"},"thumbnailUrl":"https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain.jpg","datePublished":"2022-05-10T12:11:56+00:00","dateModified":"2022-05-10T14:41:58+00:00","author":{"@id":"https:\/\/blockchain1o1.com\/blog\/#\/schema\/person\/6c04b2c17321ad56bd01a476f6b73f01"},"description":"A study of the design and implementation of decentralized blockchain relational database view of its usage in enterprise applications.","breadcrumb":{"@id":"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/#primaryimage","url":"https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain.jpg","contentUrl":"https:\/\/blockchain1o1.com\/blog\/wp-content\/uploads\/2022\/05\/mapping-blockchain.jpg","width":1200,"height":800,"caption":"Mapping Blockchain"},{"@type":"BreadcrumbList","@id":"https:\/\/blockchain1o1.com\/blog\/mapping-blockchain-with-database-design-and-implementation-of-blockchain-relational-database-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blockchain1o1.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Mapping Blockchain with Database: Design and Implementation of Blockchain Relational Database"}]},{"@type":"WebSite","@id":"https:\/\/blockchain1o1.com\/blog\/#website","url":"https:\/\/blockchain1o1.com\/blog\/","name":"Blockchain 101","description":"Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blockchain1o1.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blockchain1o1.com\/blog\/#\/schema\/person\/6c04b2c17321ad56bd01a476f6b73f01","name":"Admin_Blockchain","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blockchain1o1.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0dc77fc16142af54e72d2d7a2c80f7f82564d74e74a7719c09936cbbbc885efc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0dc77fc16142af54e72d2d7a2c80f7f82564d74e74a7719c09936cbbbc885efc?s=96&d=mm&r=g","caption":"Admin_Blockchain"},"sameAs":["https:\/\/blockchain1o1.com\/blog"],"url":"https:\/\/blockchain1o1.com\/blog\/author\/admin_blockchain\/"}]}},"_links":{"self":[{"href":"https:\/\/blockchain1o1.com\/blog\/wp-json\/wp\/v2\/posts\/179","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blockchain1o1.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blockchain1o1.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blockchain1o1.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blockchain1o1.com\/blog\/wp-json\/wp\/v2\/comments?post=179"}],"version-history":[{"count":5,"href":"https:\/\/blockchain1o1.com\/blog\/wp-json\/wp\/v2\/posts\/179\/revisions"}],"predecessor-version":[{"id":187,"href":"https:\/\/blockchain1o1.com\/blog\/wp-json\/wp\/v2\/posts\/179\/revisions\/187"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blockchain1o1.com\/blog\/wp-json\/wp\/v2\/media\/183"}],"wp:attachment":[{"href":"https:\/\/blockchain1o1.com\/blog\/wp-json\/wp\/v2\/media?parent=179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blockchain1o1.com\/blog\/wp-json\/wp\/v2\/categories?post=179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blockchain1o1.com\/blog\/wp-json\/wp\/v2\/tags?post=179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}