Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Cloud DB War: Autonomous Databases

blog.panoply.io

Post reply on HN
Print view View original

31–40 of 51 posts

Re: Cloud DB War: Autonomous Databases

#31

Post by mamcx »

Entangled wrote: post #6

All I want is an ordinary RDBMS with SPAAS (Stored Procedures as a Service) that return a binary blob of tables, nothing else. I don't want noSQL, I don't care about cloud objects, I saw Firebase and didn't like it, I don't want JSON as a result, I don't care if noobs don't know who CODD is, they will learn it the hard way sooner or later. Oracle is the living god of RDBMS and they should take advantage of that yet t…

I almost do this. My main APIs are POST/GET sqlite databases (ie: I build a sqlite db and return it like a file, then in clients and use it. Not using stupid JSON when I need long rows!).

--

I'm dreaming about building a relational language and by the way build a RDBMS on top of maybe sqlite. I think exist a lot of potential for a relational store with more flexibility

Think: with both in-memory and on-disk data storage, fixed schema (as normal) + dynamic (like JSON) + Flexible.

By flexible I mean to use Union Types and return mixed rows:

//A union of several schemas: Table Log = | Customer | Order | OrderLine

SELECT Log =

Customer(1,...). Customer(2,...) Order(1, ...) OrderLine(1, ...)

Also, maybe allow to directly acces indexes (so a index is just a KV store!), to allow logical log manipulation, etc.

In short, what about a relational-redis?

Re: Cloud DB War: Autonomous Databases

#32

Post by jinqueeny »

bmh_ca wrote: post #25
zzzcpan wrote: post #23

Wouldn't a much bigger deal be distributed part of the Oracle database in the cloud, not ML? Because turning a feature rich RDBMS into a decent distributed database is not really possible. You either have to sacrifice consistency, which by the looks of it is what Oracle is thinking to do [1], or you have to sacrifice both performance and availability. And there are already cheap not CAP consistent RDBMSs as services…

Note Google Spanner.

And CockroachDB, TiDB, etc...

Re: Cloud DB War: Autonomous Databases

#33

Post by jinqueeny »

dalacv wrote: post #12

When is someone going to make this: Example 1 --------- Me: "Create a new Customer Record" DB: "Customer Entity doesn't exist, shall I create it?" Me: "Yes" DB: "Customer Entity created. What is the Name of your Record?" Me: "Larry Ellison" DB: "Customer, Larry Ellison created" Example 2 --------- Me: "How many customers are there?" DB: "There are 123 customers" Example 3 --------- Me: "How many customers have accoun…

Sounds interesting! Looks like Siri on a DB.

Re: Cloud DB War: Autonomous Databases

#34

Post by munk-a »

Hackthepack wrote: post #2

How can we even know #18c will do anything? it sounded like a bunch of buzzwords! Oracle is so late to the game its gonna take a miracle for them to make a dent in AWS

Reading about 18c it sounds like the focus will be on applying ML to performance tuning the database, this is actually a pretty solid thing to pursue as performance tuning will usually have dramatic results and it's a knowledge area that is isolated and esoteric.

Re: Cloud DB War: Autonomous Databases

#35

Post by SomeStupidPoint »

tdb7893 wrote: post #18
sna1l wrote: post #9

> Oracle will have a steep climb to pull off their vision. They eventually will... someday. It's not with the fortune 100s that you surpass biological evolution, it's with the hackers, startups, developers, and red-eyed bandits that code at 3:14 AM to solve that one bug that kept them from sleeping for the past 3 days. The Revolution of Evolution in cloud ML and autonomous DB will come from a Panoply, the execution o…

It's amazing how freeing working only from 9 to 5 and not having access to emails away from the office is. I'm surprised anyone would willingly work that crazy

I don't even get why they would. It's not like the time I have to type code is my limiting factor on productivity.

Past a certain point, I'm not solving issues -- I'm creating them. On any horizon over a week, I'm better off sleeping, eating, exercising, etc than trying to smash every hour into working. Keeping my brain on a routine and properly nurtured is more productive than crazy hours, by a wide margin.

But I guess looking busy can be as important as results.

Re: Cloud DB War: Autonomous Databases

#36

Post by SomeStupidPoint »

tyingq wrote: post #22
mayank wrote: post #15

Earlier quoted context omitted.

Oracle is also building their own public cloud: https://cloud.oracle.com

Sure, but their non database features probably aren't in the same league as the top 3.

They actually have some features that aren't available in other clouds (well, AWS/GCP/AZ) -- if we weren't so locked into AWS, we might've tried them for that reason. We wanted to know if we could run our own hypervisor in their cloud and access VT-x instructions. (And there were other companies at their talk that were definitely hitting up sales for trials; the "baremetal" aspect intrigued a lot of people with compliance reqs or complex cloud appliances. Dedicated bandwidth was another.)

I think later clouds have advantages and not just missing/worse features -- they got to design their architecture after seeing others try, and definitely learned some lessons.

Re: Cloud DB War: Autonomous Databases

#37

Post by dfox »

mamcx wrote: post #31
Entangled wrote: post #6

All I want is an ordinary RDBMS with SPAAS (Stored Procedures as a Service) that return a binary blob of tables, nothing else. I don't want noSQL, I don't care about cloud objects, I saw Firebase and didn't like it, I don't want JSON as a result, I don't care if noobs don't know who CODD is, they will learn it the hard way sooner or later. Oracle is the living god of RDBMS and they should take advantage of that yet t…

I almost do this. My main APIs are POST/GET sqlite databases (ie: I build a sqlite db and return it like a file, then in clients and use it. Not using stupid JSON when I need long rows!). -- I'm dreaming about building a relational language and by the way build a RDBMS on top of maybe sqlite. I think exist a lot of potential for a relational store with more flexibility Think: with both in-memory and on-disk data stor…

Transferring whole sqlite databases makes sense when one side (usually the client) really uses the file as semi-persistent database for some non-trivial timespan (we actually do that for most of our mobile applications, usually for long-lived read only reference data, but one of our applications actually POSTs modified sqlite files back to server as part of normal operation, which is in fact mainly a hackish way to overcome memory limitations of the hardware involved). Using it only as data format for the transfer is hugely inefficient in terms of both time and bandwidth.

Re: Cloud DB War: Autonomous Databases

#38

Post by arejaytee »

dalacv wrote: post #12

When is someone going to make this: Example 1 --------- Me: "Create a new Customer Record" DB: "Customer Entity doesn't exist, shall I create it?" Me: "Yes" DB: "Customer Entity created. What is the Name of your Record?" Me: "Larry Ellison" DB: "Customer, Larry Ellison created" Example 2 --------- Me: "How many customers are there?" DB: "There are 123 customers" Example 3 --------- Me: "How many customers have accoun…

Check out http://kueri.me/ it wont do everything in your examples

Re: Cloud DB War: Autonomous Databases

#39

Post by aaron695 »

dalacv wrote: post #12

When is someone going to make this: Example 1 --------- Me: "Create a new Customer Record" DB: "Customer Entity doesn't exist, shall I create it?" Me: "Yes" DB: "Customer Entity created. What is the Name of your Record?" Me: "Larry Ellison" DB: "Customer, Larry Ellison created" Example 2 --------- Me: "How many customers are there?" DB: "There are 123 customers" Example 3 --------- Me: "How many customers have accoun…

It's made. It's called a person with a 3 year college degree.

One day AI will be smarter than a college degree, but it's a while off.

If you want a simple subset there's heaps of CRMs.

Re: Cloud DB War: Autonomous Databases

#40

Post by micrum »

dalacv wrote: post #12

When is someone going to make this: Example 1 --------- Me: "Create a new Customer Record" DB: "Customer Entity doesn't exist, shall I create it?" Me: "Yes" DB: "Customer Entity created. What is the Name of your Record?" Me: "Larry Ellison" DB: "Customer, Larry Ellison created" Example 2 --------- Me: "How many customers are there?" DB: "There are 123 customers" Example 3 --------- Me: "How many customers have accoun…

FriendlyData already made this: https://friendlydata.io/
Post reply on HN