Databases
 |
In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and analyze the data. The DBMS additionally encompasses the core facilities provided to administer the database. The sum total of the database, the DBMS and the associated applications can be referred to as a database system. Often the term "database" is also used loosely to refer to any of the DBMS, the database system or an application associated with the database. |
|---|---|
| wikipedia:: Database |
Platforms
- In-memory DB and Cache
- Difference between in-memory DB and in-memory cache
- https://stackoverflow.com/questions/37015827/difference-between-in-memory-cache-and-in-memory-database
- In-memory Cache
- Cache - By definition means it is stored in memory. Any data stored in memory (RAM) for faster access is called cache. Examples: Ehcache, Memcache Typically you put an object in cache with String as Key and access the cache using the Key. It is very straight forward. It depends on the application when to access the cahce vs database and no complex processing happens in the Cache. If the cache spans multiple machines, then it is called distributed cache.
- In-memory Database
- It has all the features of a Cache plus come processing/querying capabilities. Redis falls under this category. Redis supports multiple data structures and you can query the data in the Redis ( examples like get last 10 accessed items, get the most used item etc). It can span multiple machine and is usually very high performant and also support persistence to disk if needed. For example, Twitter uses Redis database to store the timeline information.
- In-memory Database
- https://en.wikipedia.org/wiki/In-memory\_database
- An in-memory database (IMDB, also main memory database system or MMDB or memory resident database) is a database management system that primarily relies on main memory for computer data storage.
- contrasted with database management systems that employ a disk storage mechanism.
- Redis v
- Apache Ignite
- H2
- In-memory Cache
- Cache
- AWS Elasticache v
- Memcached
- Difference between in-memory DB and in-memory cache
Entity
- Basically, the main focus of a given table. Akin to an object in programming. E.g., in a person table, with first name, last name, and phone number columns, the entity is simply the person, as an object, and the columns are the attributes of that entity.
- Entity-Relationship Model omnioutliner:///open?row=meYuM7aQBOM
Repository
- A database repository is a logical, but also sometimes physical grouping of data from related but separate databases. This is usually done when there is a 'higher purpose' for the data, but the data items needed to do this reside on different databases. In these cases a repository is necessary to bring together the discrete data items and operate on them as one.
Triggers
Sample Databases
Database Administration
Sources
Inbox
- Data Layer
Databases
Interactive graph
On this page
Databases
Platforms
SQL
DBMS
Database model
Data model
Relational model
Object model
Document-oriented database
Graph database
Flat-file database
NoSQL
Spatial database
Time series database
Database Tools
Database Engine
Object Relational mapping
ODBC
Database Design & Best Practices
Database Transactions
Entity
Repository
Database schema
Distributed Data Store
DAO
DTO
Triggers
Sample Databases
Database Administration
Sources
Inbox