Transcription of SQL vs NOSQL Discussion - Unime
{{id}} {{{paragraph}}}
Example: confidence
SQL vs NOSQL Discussion - Unime
SQL vs NOSQL DiscussionSQL vs NOSQLOUTLINE What is NOSQL ? How does NOSQL compare to SQL? Data structures and performance considerations Why should OSEHRA care about SQL vs NOSQL ?SQL CharacteristicsData stored in columns and tablesRelationships represented by dataData Manipulation LanguageData Definition Language TransactionsAbstraction from physical layerSQL Physical Layer AbstractionApplications specify what, not howQuery optimization enginePhysical layer can change without modifying applicationsCreate indexes to support queriesIn Memory databasesData Manipulation Language (DML)Data manipulated with Select, Insert, Update, & Delete statementsSelect , ..From Table1, Table2 ..Where = ..Data AggregationCompound statementsFunctions and ProceduresExplicit transaction control05/03/165 Data Definition LanguageSchema defined at the startCreate Table (Column1 Datatype1, Column2 Datatype 2.)
(like MongoDB, Cassandra, Couchbase, Hadoop, etc.) to older Hierarchical systems that had many similar characteristics (like Cache and GT.M) • The NOSQL concept tree illustrates the variety of concepts related to NOSQL. NOSQL Concept Tree ... SQL vs NOSQL Discussion Author:
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: