Wide Column Store NoSQL Database
Characteristics of NoSQL Databases CAP Theorem – In essence, NoSQL Databases select two of the three CAP theorem principles (consistency, availability, partition tolerance). In order to achieve better availability and partitioning, many NoSQL databases have loosened the demands on consistency. This resulted in BASE systems (basically available,
soft-state, ultimately consistent). This implies that a compromise can be made, for example, either with low performance or offer high accessibility and low consistency with quick performance. Scalable vertically and horizontally – Traditionally, relational databases live on a single server that can be scaled to provide scalability by adding further processors, storing and memory. Replication is generally used to maintain the databases synchronized in relationship databases resident on multiple servers. NoSQL databases can be on a single server, but are designed more often to operate in a cloud of servers. On-Disk Storage — In-Memory Dataset Relational databases live nearly always in a disk drive or storage zone network. As portion of SQL select or saved procedure activities database rows sets are placed in memory. Some NoSQL databases are built to exist in memory for speed and can continue to be stored on disk.
