8 ms·
>> Just to be clear, standard SQL databases are not great for large-scale analytics. What do you mean by "standard" SQL? Were you using an OLTP or OLAP db when
by TuringNYC 2y ago
>> Just to be clear, standard SQL databases are not great for large-scale analytics.
What do you mean by "standard" SQL? Were you using an OLTP or OLAP db when you faced these difficulties? Also, what makes BigQuery not a "standard SQL database" -- they use GoogleSQL, true, but many DBs have slight SQL variants.
- braiamp 2y agoAccording to their other comment standard means what it comes in the box by default.
- bhouston 2y ago> What do you mean by "standard" SQL? No extensions, just the default Postgres Cloud SQL offering from Google Cloud. > Also, what makes BigQuery not a "standard SQL database" -- they use GoogleSQL, true, but many DBs have slight SQL variants. I view BigQuery as not a standard DB because it really doesn't do transactions, rollbacks, foreign key constraints, indices, stored procedures, etc. I view it as a non-SQL database pretending to be SQL for query convenience.
- gbin 2y agoI think you mean a relational database.
- layer8 2y agoAll the features mentioned are part of SQL.
- nom 2y agoSQL is a language to interact with a relational database. It is not about the language.
- jandrewrogers 2y agoSQL (the DML) is just a query language. It could be implemented on anything. Parts of SQL DDL is implementation specific. The SQL standard hardcodes the assumption of (by modern standards) a small-scale system and therefore will deviate significantly on large-scale systems. There is no practical way to make this "standard", you have to understand the implementation it reflects.