-
Notifications
You must be signed in to change notification settings - Fork 40
Databases
https://en.wikipedia.org/wiki/Database
There are many GCP databases: BigQuery, Bigtable, Cloud SQL, Datastore, Firebase, Firestore, Spanner, and Memorystore.
https://cloud.google.com/products/databases
https://cloud.google.com/blog/products/databases/unifying-expanding-optimizing-databases-next22/
- GCP Database Products
- AWS Database products
- Azure databases
- Oracle databases
- IBM DB2 database
- SAP HANA Cloud
https://www.youtube.com/watch?v=W2Z7fbCLSTw
Structured Query Language (SQL) is the standard language for data manipulation in a DBMS.
A NoSQL (originally referring to "non-SQL" or "non-relational") database provides a mechanism for storage and retrieval of data that is not modeled in relational databases.
NewSQL is a class of relational database management systems that seek to provide the scalability of NoSQL systems for online transaction processing (OLTP) workloads while maintaining the ACID guarantees of a traditional database system.
HTAP is an emerging application architecture merge transaction processing and analytics. It may combine support for both OLTP and OLAP.
A Distributed SQL database is a single relational database which replicates data across multiple servers. Distributed SQL databases are strongly consistent and most support consistency across racks, data centers, and wide area networks including cloud availability zones and cloud geographic zones.
https://medium.com/capital-one-tech/newsql-the-next-evolution-in-databases-19109973ee53
https://www.virtual-dba.com/differences-between-sql-nosql-and-newsql/
https://www.guru99.com/difference-between-file-system-and-dbms.html
https://www.holistics.io/blog/the-rise-and-fall-of-the-olap-cube/
https://www.informatica.com/blogs/etl-vs-elt-whats-the-difference.html
https://aws.amazon.com/big-data/datalakes-and-analytics/what-is-a-data-lake/
A database transaction can be either a single operation or a sequence of operations, but is treated as a single logical operation on the data by the database.
The CAP theorem dictates that the three desirable properties, consistency, availability and partition tolerance cannot be offered simultaneously.
Linearizability (also known as atomic consistency, strong consistency, immediate consistency) describes reads and writes on a single object (stores a single value). Serializability deals with multiple objects.
Multiversion concurrency control (MCC or MVCC), is a concurrency control method commonly used by database management systems to provide concurrent access to the database and in programming languages to implement transactional memory.
Distributed consensus problem requires agreement among a number of processes (or agents) for a single data value.
https://kokizzu.blogspot.com/2021/11/databases-with-automatic-rebalance.html?m=1
https://www.cockroachlabs.com/docs/stable/cockroachdb-in-comparison.html
https://docs.yugabyte.com/latest/comparisons/
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_AuroraOverview.html
https://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html
https://cloud.google.com/blog/products/databases/alloydb-for-postgresql-intelligent-scalable-storage
https://cloud.google.com/blog/products/databases/alloydb-for-postgresql-columnar-engine
https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases
https://medium.com/google-cloud/from-zero-to-hero-with-databricks-on-google-cloud-7cb41b1bfb30
https://cloud.google.com/blog/topics/retail/unlocking-the-power-of-modern-devops
https://www.snowflake.com/technology-partners/google-cloud-platform/
https://www.elastic.co/cloud/elasticsearch-service/signup
https://cloud.google.com/blog/products/api-management/how-to-manage-your-graphql-apis-with-apigee
https://mariadb.com/products/skysql/google-cloud-platform/
https://www.datastax.com/platform/google-cloud-platform
https://docs.datastax.com/en/astra/docs/setting-up-an-astra-database-on-gcp.html