Can anybody give me an example of any dbms that spans the OLTP/OLAP gap properly _on the same data_?
Potentially added constraints:
-ACID for OLTP
-## TB+
-30-way analytical joins on complex criteria and multiple data sets with billions of entries
-fast iterations on data prep for analytics, so analysts can make, find and correct errors
-proper workload management (almost no "stupidly designed" queries)
-HA
-HPC
I'm asking because I can't see this without hw and sw being integrated to allow for it (appliance). Are there any cloud offerings that live up to this?
Potentially added constraints: -ACID for OLTP
-## TB+
-30-way analytical joins on complex criteria and multiple data sets with billions of entries
-fast iterations on data prep for analytics, so analysts can make, find and correct errors
-proper workload management (almost no "stupidly designed" queries)
-HA
-HPC
I'm asking because I can't see this without hw and sw being integrated to allow for it (appliance). Are there any cloud offerings that live up to this?
EDIT: Formatting got mangled on submit.