![\"\"](\"https:\/\/blog.nubisoft.pl\/wp-content\/uploads\/2019\/11\/bc-QLDB-invitation-1024x661.png\")
<\/figure>\n\n\n\nBut before we start with some practice, first let’s talk a bit about theory. Blockchain is a concept of implementation of nonrepudiation by means of chaining blocks of transactions. Each block contains data describing issued transactions and some additional data derived from the previous block (most often being the product of hash function). When the current block is completed, its stamp (hash value) is put to the next one. This way blocks form the consistent chain (being distributed transactions ledger) and this consistency could be easily verified by everyone using the previously mentioned function.<\/p>\n\n\n\n
All the above is of course only the generic concept. As they say – the devil is in the details. And the details here are among others issues on:<\/p>\n\n\n\n
- who calculates stamp of blocks,<\/li>
- who confirms the correctness of the above calculations (how the consensus is achieved),<\/li>
- how the stamps are calculated,<\/li>
- how the whole ledger is distributed so everyone might check its consistency,<\/li>
- who may join the ledger,<\/li>
- how he is authenticated or authorized,<\/li>
- is he authorized to see all transactions or only ones that concern him?<\/li><\/ul>\n\n\n\n
Start digging on the above topics leads us to the concepts of proof-of-work, proof-of-state, Byzantine Generals Problem, etc. It will turn out that the way of implementing all these concepts causes a number of problems on various levels:<\/p>\n\n\n\n
- efficiency,<\/li>
- scalability,<\/li>
- security,<\/li>
- privacy,<\/li>
- legal regulations (e.g. GDPR).<\/li><\/ul>\n\n\n\n
All this means that the practical application of these technologies is often disputable and except for the cryptocurrency area, these technologies have not yet found a widespread and obvious application. But it is worth noting that separation of the concepts of block chaining (BC) and distributing ledger (DLT) is very much possible. Leaving the last one, things become simpler, but at the expense of the need to trust the central \/ trusted entity again.<\/p>\n\n\n\n
This observation has led to the creation of such platforms as Corda, BigchainDB, and eventually Amazon Quantum Ledger Database from the AWS, which was first announced at AWS re:Invent<\/a> 2018 and today available in production form in five AWS regions.<\/p>\n\n\n\n
The concept of QLDB is based on chaining database log. QLDB maintains the so-called “current state” of data but also provides access to all the “historical states”, so it is possible to track all past data changes. It is not a typical SQL database but rather a document-oriented one (ION <\/a>format), however, thanks to implementing PartiQL<\/a> query language (since 10 September 2019), data can be queried, managed, and updated with SQL operators. It also provides an API that allows you to cryptographically verify that the history is accurate and legitimate. The QLDB is serverless what means it offered as a service and one needs not to worry about provisioning capacity or configuring read and write limits.<\/p>\n\n\n\n
So, let’s start with a simple interactive example. First, we create a ledger.<\/p>\n\n\n\n
![\"\"](\"https:\/\/blog.nubisoft.pl\/wp-content\/uploads\/2019\/11\/bc-QLDB_1_create-1024x738.png\")
<\/figure>\n\n\n\nThe system is preparing the environment and in a few minutes (which turn out to be seconds) the ledger gets created.<\/p>\n\n\n\n
![\"\"](\"https:\/\/blog.nubisoft.pl\/wp-content\/uploads\/2019\/11\/bc-QLDB_2_create-1024x412.png\")
<\/figure>\n\n\n\nNext, using the query editor we can create and populate simple database schema.<\/p>\n\n\n\n
CREATE TABLE Book\n\nCREATE INDEX ON Book (ISBN)\n\nINSERT INTO Book\n<< {\n 'ISBN' : '978-0547928227',\n 'Title' : 'The Hobbit',\n 'Year' : '2012'\n},\n{\n 'ISBN' : '978-0395489321',\n 'Title' : 'The Lord of the Rings',\n 'Year' : '1988'\n},\n{\n 'ISBN' : '978-1328613042',\n 'Title' : 'The Fall of Gondolin',\n 'Year' : '2019'\n} >><\/code><\/pre>\n\n\n\n![\"\"](\"https:\/\/blog.nubisoft.pl\/wp-content\/uploads\/2019\/11\/bc-QLDB_3_create-1024x995.png\")
<\/figure>\n\n\n\nNow, we can query our database.<\/p>\n\n\n\n
![\"\"](\"https:\/\/blog.nubisoft.pl\/wp-content\/uploads\/2019\/11\/bc-QLDB_4_create-850x1024.png\")
<\/figure>\n\n\n\nWe can also update some data.<\/p>\n\n\n\n
update Book as b\nset b.Title = 'The Fall of Gondolin!'\nwhere b.ISBN = '978-1328613042'<\/code><\/pre>\n\n\n\n![\"\"](\"https:\/\/blog.nubisoft.pl\/wp-content\/uploads\/2019\/11\/bc-QLDB_5_update-664x1024.png\")
<\/figure>\n\n\n\nAnd now we can query the modification history of a table or a specific document in a table, with the possibility to find modifications within a certain range and on a particular document. In our example, we ask for all records from the beginning of 2019 to now (as we don’t specify the second datetime).<\/p>\n\n\n\n
select * from history(Book, `2019T`)<\/code><\/pre>\n\n\n\nAnd we see that each transaction is tagged with a hash value that is a crucial part of the chainblock, and we can see all versions of a given document.<\/p>\n\n\n\n
![\"\"](\"https:\/\/blog.nubisoft.pl\/wp-content\/uploads\/2019\/11\/bc-QLDB_7_history-1024x494.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/blog.nubisoft.pl\/wp-content\/uploads\/2019\/11\/bc-QLDB_8_history.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/blog.nubisoft.pl\/wp-content\/uploads\/2019\/11\/bc-QLDB_9_history.png\")
<\/figure>\n\n\n\nWe can also verify the integrity of documents that are stored within out ledger\u2019s journal, what has described in Verify a Document in a Ledger<\/a>, and is a great example of the power (and value) of cryptographic verification. At any time we can get the digest of the transaction.<\/p>\n\n\n\n
![\"\"](\"https:\/\/blog.nubisoft.pl\/wp-content\/uploads\/2019\/11\/bc-QLDB_10_digest-1024x441.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/blog.nubisoft.pl\/wp-content\/uploads\/2019\/11\/bc-QLDB_11_digest-1024x253.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/blog.nubisoft.pl\/wp-content\/uploads\/2019\/11\/bc-QLDB_12_digest.png\")
<\/figure>\n\n\n\nAnd at any time we can verify the ledger against the formerly downloaded digest.<\/p>\n\n\n\n
![\"\"](\"https:\/\/blog.nubisoft.pl\/wp-content\/uploads\/2019\/11\/bc-QLDB_13_digest-1024x578.png\")
<\/figure>\n\n\n\nWorth mentions that all the above-described operations can be performed using not only AWS Management Console but also AWS Command Line Interface (CLI)<\/a>, a CloudFormation template, or by making calls to the QLDB API. <\/p>\n\n\n\n
As we see, the threshold to enter the world of blockchain is fairy-tale simple, isn’t it?<\/strong><\/p>\n\n\n\n
Another view angles <\/h2>\n\n\n\n
- We have to pay attention that despite involving a subset of blockchain technologies the QLDB still implements nonrepudiation by means of trust in the central institution (in this case AWS corp).<\/li>
- Although QLDB is only available as a service, there are similar solutions that can be implemented as on-premises. In a case of such deployment scenarios, we must trust in entities who operate them.<\/li>
- Sometimes in case of institutional parties, it is only needed to build trust between parties (this is often scenario in banking) that are involved in a given transaction. Then Corda <\/a>platform seems to be an ideal solution.<\/li><\/ol>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Nowadays, everybody talks about blockchain technologies but not many understand all the concepts behind it. Even less have any practical experience with these issues. Therefore here, we will try to put some light on it. When in June our request for preview access to the QLDB service was approved, we all rubbed our hands together […]<\/p>\n","protected":false},"author":2,"featured_media":91,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_case_study_excerpt":"","footnotes":""},"categories":[5,3],"tags":[32,31,34,35,33],"class_list":["post-90","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-infrastructure","category-software-development","tag-aws","tag-blockchain","tag-database","tag-preview","tag-qldb"],"_links":{"self":[{"href":"https:\/\/nubisoft.io\/blog\/wp-json\/wp\/v2\/posts\/90","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nubisoft.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nubisoft.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nubisoft.io\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nubisoft.io\/blog\/wp-json\/wp\/v2\/comments?post=90"}],"version-history":[{"count":12,"href":"https:\/\/nubisoft.io\/blog\/wp-json\/wp\/v2\/posts\/90\/revisions"}],"predecessor-version":[{"id":191,"href":"https:\/\/nubisoft.io\/blog\/wp-json\/wp\/v2\/posts\/90\/revisions\/191"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nubisoft.io\/blog\/wp-json\/wp\/v2\/media\/91"}],"wp:attachment":[{"href":"https:\/\/nubisoft.io\/blog\/wp-json\/wp\/v2\/media?parent=90"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nubisoft.io\/blog\/wp-json\/wp\/v2\/categories?post=90"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nubisoft.io\/blog\/wp-json\/wp\/v2\/tags?post=90"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}