NoSQL databases - comet.lehman.cuny.edu

NoSQL databases AN IN TR OD UC TIO N AN D C OM PARIS ON B E T W E E N M ON GOD B AN D M YS QL D O C U M E N T S TO RE A quick introduction to NoSQL databases The term NoSQL was coined by Carlo Strozzi in the year 1998 to a light weight database queried without SQL interface. NoSQL databases represent a collection of types of nonrelational databases that don't require the use of SQL queries like RDBMS. NoSQL systems are also sometimes called Not-Only SQL

to emphasize the fact that they may support SQL-like query languages of relational database systems. Why create NoSQL databases? Big Data : Data generation has increased exponentially. Most RDMS can not keep Up In todays time, data is

becoming easier to access and capture data. Most of all generated data are unstructured data. Why create NoSQL databases? Contd Delivering Hot Data In large applications, the data cache stored in RAM can grow very large and be subjected to thousands or even millions of requests per second. Handling Large Data Volumes

Many relational databases (RDBMS) such as Oracle 12c, MySQL, Postgres or Microsoft SQL Server were designed to run on a single server. As the size of a relational database grows, organizations may run into performance issues with their infrastructure and database technology due to database scalability challenges. Dealing with Highly Volatile Data when thousands of updates per second are applied to a single database row (for example, flash online sales for high-demand concert tickets), it is crucial to maintain exact values at every second. MySQL is designed around full transactional semantics with support for long transactions and works with diskbased log durability.

Properties of NoSQL databases They have higher scalability. They use distributed computing. They are cost effective. They support flexible schema. Theyre able to process both unstructured and semistructured data. There are no complex relationships, such as the ones between tables in an RDBMS. Types of NoSQL databases Key-value stores Every item in the database is stored as an attribute name (or "key")

together with its value ( examples: Riak, Amazon Dynamo) Wide-column stores Store data together as columns instead of rows and are optimized for queries over large datasets. (examples: CouchDB) Document databases Documents can contain many different key-value pairs, or key-array pairs, or even nested documents. (examples: MongoDB, Cassandra) Graph databases A network database that uses edges and nodes to represent and

store data (example: Neo4j) Introduction to Document stores Document store NoSQL database system models are one of the most commonly used NoSQL database solutions, A document-based model builds on a simpler type of NoSQL DBMS called the Key-Value store database model. Document databases are a collection of semi-structured documents stored in formats like JSON that contain nested values associated with a key. Introducing Mongo DB

Mongo DB was started in 2007 as a part of an open source cloud computing stack, with its first standalone release was in 2009. It was developed using C++ a goal of specializing in document store that offered high scalability, flexibility, eventual consistency, and lightning speed operations. utilizes BSON format (Binary JavaScript Object Notation) to store complex data types in its documents. Features of Mongo DB Auto-sharding to scale from single server deployments to lllll lll lllllll lllll-llll llllll lllllllllllll.

Replication of the data with master-slave architecture llllllll llll llllllllllll llll llllllll lllllllllll Leverages native caching and RAM. lllllll llll llllllll llllll, lllllllll lllllll lll lll lllllll lllllllllll lllllllll lll llllllllll ll llll lllllllllll lllllll lll llllllllll. MongoDB can perform map and reduce functions by lllllll lll lllllllll lll lll lllllllll llll llll llllllllll llllllll lll lllllll lllllllll lll llll lll lllllllll. MongoDB can be retrieved through several programming lllllllll llll ll llll, l, l++, llll, l#, lll llllll. Introducing MySQL Document store

Since the introduction of MySQL 5.7 and later, the MySQL platform has included support for a NoSQL document store. It gives developers the ability to integrate both SQL relational tables and schema-less JSON collection into a collective database. X Dev API on top of its existence X protocol which introduces collections as a new schema object and provides full CRUD and SQL operations Key Features of MySQL Document Store InnoDB a storage engine that enables multi-document transaction

support and full ACID database compliance. InnoDB Cluster and Group replication for on-demand application scaling to achieve high availability with master-slave architecture. Document data consistency is maintained to the point in time when the backups are completed. Users can perform Point in Time recovery to recover to a specific transaction using the MySQL binlog. Transparent Data Encryption for auditing, advanced authentication, and firewall help to maximize security. CRUD APIs are supported across multiple popular programming languages like javascript, python and SQL.

Data Integrity Control Concurrency control: measures to prevent multiple clients from modifying the same piece of data simultaneously MongoDBs multi-granularity locking that allows operations to lock at the global, database or collection level. MongoDB lock manager to allows storage engines to manage their own concurrency control. MySQLs InnoDB multi-versioned storage engine keeps information about old versions of changed rows, to support transactional features such as concurrency and rollback. Acid complicity: Although most Nosql try to keep the BASE(Basically Available, Soft state, Eventual consistency) in

compliance with the CAP (Consistency, Availability, Partition tolerance) theorem. Mongo DB version 4.0 supports both single and multi-document ACID transactions Current state and performance evaluation Mongo DB remains the benchmark for NoSQL databases with excellent insert and retrieval speeds. Mongo DB software support community remain far superior to MySQL Documents store due its market maturity. MySQL Document store offer a unique opportunity to

simultaneously host relational tables and document in the same database cluster. Companies utilizing Mongo db include Google, SAP, cisco, intuit, Carfax MySQL Document store remain relatively new with bug fixes, feature improvement. Not production ready.

Recently Viewed Presentations

  • Chapter 2 Motion Along a Straight Line ... - MR. G'S DP PHYSICS

    Chapter 2 Motion Along a Straight Line ... - MR. G'S DP PHYSICS

    • Automobile passive safety standards have been adopted across the globe based on research conducted in many countries . Theory of knowledge: • Do conservation laws restrict or enable further development in physics? Utilization: • Jet engines and rockets •...
  • Ecotourism investment opportunities in ... - Kenya Forest Service

    Ecotourism investment opportunities in ... - Kenya Forest Service

    Ecotourism investment opportunities in Kenyan forests. Philip IreriChief Officer EcotourismKenya Forest ServiceEcotourism Kenya Monthly Talk, 5th July 2012. Layout of the presentation. Background: tourist facilities in Kenyan forests ... Coastal forests & Mangrove areas .
  • Creation/Evolution Graphics

    Creation/Evolution Graphics

    Što je inteligentan dizajn? Dr. Heinz Lycklama [email protected] www.osta.com/messages www.osta.com/croatia-12/WhatIsID.ppt Sve istine prolaze kroz tri stupnja:
  • Lifetime Health - PC\|MAC

    Lifetime Health - PC\|MAC

    Codependency is the condition in which a family member or friend sacrifices his or her own needs to meet the needs of an addict. Fetal alcohol syndrome (FAS) is a set of physical and mental defects that affect a fetus...
  • Beau Daniel Period 1 project Cell Analogy

    Beau Daniel Period 1 project Cell Analogy

    Chromosomes - The Play Book. The Chromosomes are the DNA. The Chromosomes are like the Play Book because it has every play the team will run in it and a blueprint of what everybody's job is. ... Beau Daniel Period...
  • SAINT PAUL CHURCH - Kensington CT OUR CHURCH MINISTRIES ...

    SAINT PAUL CHURCH - Kensington CT OUR CHURCH MINISTRIES ...

    ___Bakers- Prepare requested cookies/bake goods for some upcoming church events (New Initiative) ___Baptismal Robe Makers—Create/sew robes for each person Baptized at our church ___Bereavement Support Group- Assist those in our parish who have suffered the loss of a loved one.
  • Active Learning - Optimus Education

    Active Learning - Optimus Education

    Active learning. Active learning focuses on a range of attitudes and dispositions that help to define a child's motivation.. It includes three key characteristics which demonstrate a child's intrinsic motivation to achieve mastery - to experience competence, understanding, and autonomy.
  • Self-Determination & Student Engagement

    Self-Determination & Student Engagement

    Sometimes people interchange the terms self-determination and self-advocacy,but being a competent self-advocate is part of being self-determined.Another important part of self-determination is the ability to use the supports and resources availableand to be resourceful/creative by identifying other/new supports and resources.A...