Presentation

Views:
 
Category: Entertainment
     
 

Presentation Description

No description available.

Comments

 

By: akashbathla (53 month(s) ago)

Hi Muhammad, this presentation is now featured on authorSTREAM. Congratulations and keep up the great work! - Akash, authorSTREAM Team.

Presentation Transcript

PowerPoint Presentation:

In 1970… Relational Databases were introduced.

PowerPoint Presentation:

In 1970… Structured Query Language (SQL) was used to manage queries/requests. Output SELECT … , … FROM … , … WHERE … = …

PowerPoint Presentation:

In 1970… During this time, data storage was expensive, and data schemas were simple. SQL was fast enough. But now…

PowerPoint Presentation:

Present Day Ever since the introduction of the Web, the volume of data has increased. DATA

PowerPoint Presentation:

Data is accessed more frequently, and is processed more intensely. SELECT … , … , … , … , … FROM … , … , … , … , … WHERE … AND … AND … AND … AND … SQL is far too slow. Present Day

PowerPoint Presentation:

The cost of data storage has gone down. Relational Databases were not designed to take advantage of the cheap storage we have today. Present Day

PowerPoint Presentation:

A faster type of database is required.

PowerPoint Presentation:

One that is more compatible with the technology we have today.

PowerPoint Presentation:

This database is known as...

PowerPoint Presentation:

SQL

PowerPoint Presentation:

No sql is not a relational database. Atrribute 1 Attribute 2 … Attribute n Atrribute 1 Attribute 2 … Attribute n Relational Database NO Rather, it is a database that does not adhere to the Relational Database Management System structure.

PowerPoint Presentation:

Since No sql is non-relational, there are multiple ways to implement No sql .

PowerPoint Presentation:

Key-Value Stores The simplest No sql database.

PowerPoint Presentation:

Key-Value Stores Each item in the database is stored as… KEY A Key VALUE together with its Value.

PowerPoint Presentation:

KEY VALUE color yellow ssn 28848492 age 28 start_date 31-03-1999 result false Key-Value Stores The ‘value’ does not have a set data type. There can be multiple types in the ‘value’ column KEY VALUE String   Integer   Integer   Date   Boolean  

PowerPoint Presentation:

KEY VALUE compiler_path C:\Program Files\ MinGW \bin error_msg_2 Stupidity Overflow error_msg_3 Syntax Error error_msg_4 Value does not exist user2443_age 22 user2443_color blue user9944_age 28 user9944_color yellow Key-Value Stores So, every value is stored in one massive table. KEY VALUE

PowerPoint Presentation:

Document Databases KEY DOCUMENT Similar to key-value stores, each key is paired with a document.

PowerPoint Presentation:

DOCUMENT Document Databases Documents are complex data structures. { }

PowerPoint Presentation:

Document Databases They can contain key-value pairs, { } Name: “Student1” , StudentID : “h1399999” , They can contain key-array pairs, Modules:[ “MA1110” , “PC1110” ], PrgReport :[ {Module: “MA1110” , Grade: “A” }, {Module: “PC1110” , Grade: “A+” } ] Or even nested documents.

PowerPoint Presentation:

Wide-Column Stores The common way to store data is to serialize each row of data. Name ID Sex Aaron 1337 M Bob 6969 M Chuck 9001 M 001: “Aaron” , 1337, “M” ; 002: “Bob” , 6969, “M” ; 003: “Chuck” , 9001, “M” ; ROW ORIENTED

PowerPoint Presentation:

Wide-Column Stores Wide-column stores store columns of data together, instead of rows. Name ID Sex Aaron 1337 M Bob 6969 M Chuck 9001 M “Aaron” :001, ”Bob” :002, ”Chuck” :003; 1337:001, 6969:002, 9001:003; “M” :001, “M” :002, “M” :003; COLUMN ORIENTED

PowerPoint Presentation:

Graph Stores Based on Graph Theory, Graph Stores use nodes and edges. ID: 418243 Name: Tim Age: 19 ID: 14535 Type: Board Name: Chess ID: 9184423 Label: is_member Used to store information about networks, such as social connections.

PowerPoint Presentation:

All No sql databases have a few features in common.

PowerPoint Presentation:

Dynamic Schema Before data population, a Relational Schema requires pre-defined schemas. SSN Name ID Sex EMPLOYEE EMPLOYEE

PowerPoint Presentation:

Dynamic Schema This does not complement an agile development approach, SSN Name ID Sex EMPLOYEE EMPLOYEE As whenever new updates are applied, the schema often needs to change. Dept

PowerPoint Presentation:

Dynamic Schema Migration of the previous data to the new schema follows. EMPLOYEE EMPLOYEE’ If the database is large, this will be a very slow process.

PowerPoint Presentation:

KEY VALUE emp2913_dept 9 emp2183_dept 2 emp5223_dept 5 emp2458_dept 4 Dynamic Schema Nosql databases are built to allow data insertion without a pre-defined schema, KEY VALUE emp2913_sex M emp2183_ID s8500224j emp5223_ID s9696969a emp2458_sex F Making it easy to make significant changes in real-time.

PowerPoint Presentation:

Auto- Sharding , Replication and Integrated Caching SERVER Due to the way they are structured, a single server has to host the entire database for a Relational Database. This ensures reliability and continuous availability of data.

PowerPoint Presentation:

Auto- Sharding , Replication and Integrated Caching SERVER This gets expensive quickly and places limits on scale. $

PowerPoint Presentation:

Auto- Sharding , Replication and Integrated Caching No sql solves this by adding more servers instead of concentrating more capacity on a single one. SERVER SERVER SERVER SERVER SERVER The same processing and storage capabilities, for a fraction of the price.

PowerPoint Presentation:

Auto- Sharding , Replication and Integrated Caching No sql databases also support auto- sharding . SERVER SERVER SERVER SERVER SERVER Meaning they automatically spread data across an arbitrary number of servers. DATA DATA DATA DATA DATA

PowerPoint Presentation:

Auto- Sharding , Replication and Integrated Caching No sql databases also support auto-replication. SERVER SERVER SERVER SERVER SERVER DATA DATA DATA DATA DATA Meaning high data availability and better disaster recovery.

PowerPoint Presentation:

Auto- Sharding , Replication and Integrated Caching DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA DATA No sql databases have excellent integrated caching capabilities. They keep frequently-used data in system memory as much as possible.

PowerPoint Presentation:

However, No sql databases do have a few disadvantages. The design goal for the Nosql system is to provide a zero-admin solution.

PowerPoint Presentation:

Maturity While RDBMS systems are stable and richly functional, Most No sql alternatives have many key features yet to be implemented.

PowerPoint Presentation:

Support Most No sql systems are open projects.

PowerPoint Presentation:

Administration Despite the design goal , No sql requires a lot of skill to install and a lot of effort to maintain.

PowerPoint Presentation:

Expertise No sql systems are a new paradigm. All developers are still in learning mode.

PowerPoint Presentation:

Some of the early adopters of the No sql database systems are… FACEBOOK TWITTER

PowerPoint Presentation:

END OF PRESENTATION

authorStream Live Help