create account

Daily techtalk: Is there a future for RDBMS ? by cuttie1979

View this thread on: hive.blogpeakd.comecency.com
· @cuttie1979 ·
$63.94
Daily techtalk: Is there a future for RDBMS ?
In my everyday work, I'm often thinking about this question. I have a theory regarding the current system design which we use in nearly 90% of all of our systems. Most of the codes are now using the Object Oriented programming model. If we utilize an RDBMS, to any kind of system we always construct and flatten objects. My personal opinion is that this kind of activity consumes more than the used computation task.

![DatabaseDesign63230.png](https://steemitimages.com/DQmTnhCvk9FYp5hUTZHyvHuAg5txs1VqV4ffb5mjTCebBDn/DatabaseDesign63230.png)
[*image source](http://www.datasciencesgroupinc.com/assets/DatabaseDesign63230.png)

With the evolution of the Object Based storages, we can store and retrieve the objects with a single call, we don't need to do an unnecessarily needed conversion. I think that for these kind of tasks the CEPH initiative is a good start. With CEPH we can provide the redundancy, and replication at the storage level.

The problematic question is always how we can query the objects itself based on the chosen attributes. For this purpose, we can build in-memory indexes. The in-memory indexes can be maintained based on the code which runs on top of this database.

If we think about the MapD database: [http://www.mapd.com](http://www.mapd.com) it shows that we can utilize the GPU for special tasks. With this effort the index scan rate can be scaled to 3-4 TB/s rates per node, with high grid architecture to hundreds of TBs.

Of course, if we can reduce the layers of the code to the data storage it helps a lot. Depending on the volume size, we can balance latency vs. Throughput. For high throughput I prefer GPU, for low latency I prefer NV-DIMM technology.

With the above considered, is there any future for RDBMS databases, or it is time to move forward to the Object Database Era.

If I need to bet on technology I see much more of a future in Object Storage technology. I know this is a bad news for Software Vendors, but for Innovative Companies a good start to open for the future...

I would be interested if anyone has a good comparison of performance difference on the two technologies.
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
properties (23)
authorcuttie1979
permlinkdaily-techtalk-is-there-a-future-for-rdbms
categorytechnology
json_metadata{"tags":["technology","database","rdbms","future","theory"],"image":["https://steemitimages.com/DQmTnhCvk9FYp5hUTZHyvHuAg5txs1VqV4ffb5mjTCebBDn/DatabaseDesign63230.png"],"links":["http://www.datasciencesgroupinc.com/assets/DatabaseDesign63230.png","http://www.mapd.com"],"app":"steemit/0.1","format":"markdown"}
created2018-01-13 20:47:51
last_update2018-01-13 20:47:51
depth0
children2
last_payout2018-01-20 20:47:51
cashout_time1969-12-31 23:59:59
total_payout_value49.010 HBD
curator_payout_value14.926 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length2,131
author_reputation90,996,652,990,411
root_title"Daily techtalk: Is there a future for RDBMS ?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id29,311,516
net_rshares7,655,849,682,493
author_curate_reward""
vote details (56)
@jcsc ·
I have been using FireBase as to reduce the need for the extra server, but I miss my SQL scripts.
properties (22)
authorjcsc
permlinkre-cuttie1979-daily-techtalk-is-there-a-future-for-rdbms-20180115t022642003z
categorytechnology
json_metadata{"tags":["technology"],"app":"steemit/0.1"}
created2018-01-15 02:26:42
last_update2018-01-15 02:26:42
depth1
children0
last_payout2018-01-22 02:26:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length97
author_reputation48,856,896,290
root_title"Daily techtalk: Is there a future for RDBMS ?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id29,596,692
net_rshares0
@mykill ·
Very nice post. I'm still using RDBMS. I will definitely look into Object Storage technology which is supposed to be faster when it comes to storing data  and retrieval.
properties (22)
authormykill
permlinkre-cuttie1979-daily-techtalk-is-there-a-future-for-rdbms-20180115t100733520z
categorytechnology
json_metadata{"tags":["technology"],"app":"steemit/0.1"}
created2018-01-15 10:08:21
last_update2018-01-15 10:08:21
depth1
children0
last_payout2018-01-22 10:08:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length169
author_reputation15,714,200,615
root_title"Daily techtalk: Is there a future for RDBMS ?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id29,667,473
net_rshares0