NoSQL databases - comet.lehman.cuny.edu

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

  • "I Couldn't Control Myself"" Murder in Post WWI Berlin

    "I Couldn't Control Myself"" Murder in Post WWI Berlin

    "I Couldn't Control Myself"" Murder in Post WWI Berlin "The better you know this huge city of stone, the more you think it's an insane asylum. In the east live the criminals; in the center, the swindlers. In the north...
  • Routine to Research : R2R

    Routine to Research : R2R

    Include the level of care e.g. primary, secondary; number of participating centres. Be general rather than give the name of the specific centre, but give the geographical location if this is important. Include the dates of the study period. Patients,...
  • MAE 5310: COMBUSTION FUNDAMENTALS Mass Diffusion and Droplet

    MAE 5310: COMBUSTION FUNDAMENTALS Mass Diffusion and Droplet

    1-D STEFAN PROBLEM To see effects of concentrations at interface and at top of tube, let mass fraction of A in freestream be zero, while arbitrarily varying YA,i, interface mass fraction, from zero to unity In terms of an experiment,...
  • Process Writing - Mrs. Golden's Classes

    Process Writing - Mrs. Golden's Classes

    B. In the first paragraph of the body of the paper (the second paragraph of the paper, the one following the introduction), specify the materials your readers will need so that they can have them ready before beginning the process....
  • Top Tips: Preparing the Brief to Counsel

    Top Tips: Preparing the Brief to Counsel

    On the case law, HHJ Matthews found . the fact that a litigant had been acting in person was not of itself a reason to dis-apply procedural rules, orders or directions, or excuse non-compliance with them. The exception was that...
  • CMT 2360-Building Codes and Inspections

    CMT 2360-Building Codes and Inspections

    CMT 2360-Building Codes and Inspections Author: Steve Peterson Last modified by: Nancy Kesterson ... and Receipts Cash Provided by Contractor Cash Provided by Contractor Determining a Project's Cash Flow Determining a Project's Cash Flow Maximum Cash Required Cash Invested on...
  • Fundamental Principles of American Democracy

    Fundamental Principles of American Democracy

    The young United States was large and represented people of different cultural backgrounds, economic conditions, and religious beliefs. The classical republican idea of civic virtue conflicted with the Founders' belief in natural rights and with their understanding of human nature...
  • Future global drought conditions in terms of the

    Future global drought conditions in terms of the

    Most significant increase of the drought risk (great decrease of rPDSI together with low inter-model uncertainty) is projected for central USA, central-south Canada, Mexico, most of Brazil, south and equatorial (west of 30E) Africa, south Australia, Mediterranean + Middle East,...