Difference between revisions of "Databases"
Jump to navigation
Jump to search
Tags: Mobile web edit, Mobile edit |
|||
| (2 intermediate revisions by one other user not shown) | |||
| Line 11: | Line 11: | ||
[[2015]] | [[2015]] | ||
* [[ScyllaDB]] | * [[ScyllaDB]] | ||
| + | * [[CockroachDB]] | ||
[[2005]] | [[2005]] | ||
| Line 33: | Line 34: | ||
== Related terms == | == Related terms == | ||
* [[ClickHouse]] | * [[ClickHouse]] | ||
| − | * [[OLTP]] | + | * [[Views]] |
| + | * [[OLTP]], [[OLAP]] | ||
* [[ACID]]: [[WAL]] | * [[ACID]]: [[WAL]] | ||
* [[SQL]]: [[EXPLAIN]] | * [[SQL]]: [[EXPLAIN]] | ||
Latest revision as of 12:00, 19 February 2023
This article is a Draft. Help us to complete it.
Relational (SQL):
- MariaDB (2009) C, C++
- Microsoft SQL Server (1989)
- MySQL (1995) C, C++
- Oracle Database (1979)
- PostgreSQL (1996) C
- RocksDB (library) (2012) C++
- SingleStore (2013)
- Amazon Aurora (2014)
- Apache Cassandra (2008)
Other databases: Derby DB, Memcached, ClickHouse (2016)
Timeline[edit]
Related terms[edit]
- ClickHouse
- Views
- OLTP, OLAP
- ACID: WAL
- SQL: EXPLAIN
- MemSQL
- Google trends: https://trends.google.com/trends/explore?date=today%205-y&q=PostgreSQL,MySQL,MariaDB
- Connect to a database
- Show databases
- Create database
- Delete database
- Create user
- List users
- List databases
- List tables:
show tables - GRANT
See also[edit]
- NoSQL: Graph database, document-oriented database, Couchbase, Amazon DynamoDB, Amazon DocumentDB, MongoDB, FoundationDB
- Key-value databases: Berkeley DB, Redis, etcd, leveldb, RocksDB (MyRocks), Infinispan, Amazon DynamoDB, Apache Zookeeper, LevelDB
- Databases: Database management, SQL, NoSQL, Wide column, PostgreSQL, MariaDB, MySQL, Derby DB, MongoDB, Cassandra, SQLite, HSQL2, H2, RocksDB, Microsoft SQL Server, DB2, Oracle Database, Memcached, Berkeley DB, Collation, SingleStore, Amazon Aurora, Graph database, Amazon DynamoDB, PrestoDB, Cache hit ratio, ACID, WAL, ARIES, DBMS, OLTP, OLAP, Database Schema, CockroachDB, Tables, Views, Apache Druid
- SQL, NewSQL: GraphQL (2015), SQLite,
select, insert,select count, Distributed SQL, TablePlus, Cache hit ratio,pg_stat_user_tables,EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy,CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint
Advertising:
