Facebook primarily uses MySQL for structured data storage such as wall posts, user information, timeline etc. This data is replicated between their various data centers. Cassandra is free and open source distributed database management system designed to handle large amounts of data across many commodity servers and providing high availability without single point of failure. It … Continue reading Facebook uses..
MySQL-relational database in general uses the JOIN operation. This allows you to perform queries across multiple tables. MongoDB does not support joins but it does multi-dimensional data types such as arrays and even other documents. Placing one document inside another is referred to as embedding. For example : If you want to create a blog … Continue reading MySQL Vs MongoDB
Non Relational Databases can be classified into four major categories such as Key-values database, column database, document database and graph database. Key-values database: This is the simplest form of NoSQL database where each value is associated with unique key. Example : Redis Column database: This database is capable of storing and processing large amount of … Continue reading Non Relational DB Categories
Non Relational is also known as NoSQL (not always SQL) provides a mechanism for storage and retrieval of data, which is modeled in means other than the tabular relations used in relational databases. It is used to handle rapid growth of unstructured data and scale them out easily. This provides flexible schema so there is no … Continue reading Non Relational Database
It is based on the Relational Model of data. The objects in the relational databases are structured. Data are stored as rows and columns in a table linked to rows in another tables. Most of the tables are related to each other with primary and foreign keys thus providing Referential Integrity among the objects. Examples : Oracle, … Continue reading Relational Database
DB2 is a database product from IBM. It is a Relational Database Management System (RDBMS). DB2 product is extended with the support of Object-Oriented features and non-relational structures like XML. An iSeries computer is geared mainly to serve the demands of DB2. The IBM System i is IBM's previous generation of midrange computer systems for IBM i … Continue reading DB2
A cloud database is a database, that typically runs on a cloud computing platform. Cloud database also referred to as 'Database as a Service' (DBaaS). There are two common deployment models: users can run databases on the cloud independently, using a virtual machine image or they can purchase access to a database service, maintained by a … Continue reading Cloud Database
A database is an organized collection of data. A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data. Well-known DBMSs include MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase and IBM DB2. Oracle Oracle is an object-relational database management system. The purpose of a database is to store and retrieve related information. … Continue reading DBMS