Please enable JavaScript.

Coggle requires JavaScript to display documents.

NoSQL & MongoDB (Request Data (Filter (Simple (PF.find( { "…

- - - - db.restaurants
    - - JSON Document
        
        With Key/Value
  - - - PF.findOne()
    - - PF.distinct("borough")
        
        All possible values
  - - - PF.find( { "borough" : "Brooklyn" } )
        
        PF.find( { "borough" : "Brooklyn" } ).count()
    - - PF.find( { "borough" : "Brooklyn" , "cuisine" : "Italian" } )
    - - PF.find( {"address.street" : "5 Avenue" } )
    - - PF.find( {"name" : /pizza/i } )
  - - - With 1 on the key
        
        PF.find( { "borough" : "Brooklyn" } {"name":1} )
  - - - "grades.score" : {"$lt" : 10}
    - - $gt / $gte
        
        Greater
        
        At least 1 in the imbrication
      - $lt / $lte
        
        Less
        
        At least 1 in the imbrication
      - $ne
        
        Different
      - $in / $nin
        
        In / Not in
      - $or / $and
        
        $exists
      - $not
        
        On all elements
    - - $elemMatch : {}
    - - grades.0.grade":"C"
  - - - {$match : {} }
        
        Filter
        
        Find
      - {$project : {} }
        
        Projection
        
        Find
      - {$sort : {} }
        
        Key selected
        
        varSort = { $sort : {"name":-1} }
      - {$group : {} }
        
        Document grouping
        
        Aggregation Function
        
        Simple
        
        varGroup = { $group : {"_id" : null, "total" : {$sum : 1} } }
        
        Value
        
        varGroup3 = { $group : {"_id" : "$borough", "total" : {$sum : 1} } }
        
        $borough
        
        Clarify the key
      - {$unwind : {} }
        
        List explosion
        
        varUnwind = {$unwind : "$grades"}
    - - Operator Chain
  - - - PF.update(...{$set : {"comment" : "My new comment"})
    - - PF.update(...{$unset : {"comment" : 1})
    - - {"multi" : true}
    - - PF.remove()
- - - - Multiple servers
        
        Not fault tolerant
  - - - Elasticity
        
        Fault Tolerant
      - Type
        
        HDFS
        
        64Mo Shunk
        
        Replicated
        
        3 servers
        
        Central Server
        
        Namenode
        
        Primary
        
        Secondary
        
        Rack-Aware
        
        Server
        
        Datanode
        
        Map/Reduce
        
        Advantages
        
        Fault-Tolerant
        
        Computing Power
        
        Hbase
        
        PigLatin
        
        Spark
        
        BTree
        
        Central Server
        
        Arborescence
        
        Replicated
        
        Nodes
        
        Data
        
        Map/Reduce
        
        Replication
        
        Advantages
        
        Data similar
        
        On a Node
        
        Replication
        
        At node level
        
        DHT
        
        Distributed Hash Table
        
        Ring Storage
        
        Advantages
        
        Self Management
        
        Elasticity
        
        Not Fault Tolerant
        
        Logical principle only
- - - - All Read/Write
    - - Replication
    - - Network status :check:
      - Vote
        
        Primary
    - - 1 Primary
      - 2 Secondary
  - - - Server Port = 27018
        
        Folder = /data/R0S1
        
        In $MONGO/bin console
        
        mongod --replSet rs0 --port 27018 --dbpath /data/R0S1
        
        For each server
    - - rs.conf()
    - - rs.add("local:27020")
    - - Folder = /data/arb
        
        mongod --port 30000 --dbpath /data/arb --replSet rs0
        
        rs.addArb("local:30000")
  - - - mongod --config mongod.conf
  - - - Update Operations
        
        Journalization
      - Capped
        
        5% of free space
        
        5Go Max by default
  - - - PrimaryPreferred
        
        Secondary
        
        Nearest
- - - - Efficient
    - - Memcached
        
        Cosmos DB
        
        SImpleDB
    - - CRUD Only
      - No Language
        
        Not structured
      - Key Search
        
        Direct use of Value
    - - IoT
        
        Fast Transactions
        
        Log Files
        
        Chat
  - - - Key-Value
        
        Document structure :recycle:
    - - Distributed
        
        Request Language
    - - DynamoDB
        
        Cassandra
        
        CouchBase
    - - Complex Event Collection
        
        Social Network
  - - - Aggregations
        
        Less for Read of 1 Value
    - - HBase
        
        SparkSQL
        
        ElasticSearch
    - - Large Reportings
  - - - Aggregations
        
        Recommendations
    - - OrientDB
        
        FlockDB
    - - Including links
- - - - Data Sorting
  - - - Request router
      - Tree
    - - Organized
        
        ReplicaSet
      - Network knowledge
    - - Data storage
    - - 2 Mongos
      - 2 Shards
      - 3 Config Servers
  - - - In ReplicaSet
    - - In ReplicaSet
    - - Connect
        
        Config Server
        
        Shard
      - Launch
        
        Sharding
        
        Collection
  - - - All in one Shard
      - Overload :warning:
- - - - Consistency
        
        Before/After
        
        Transaction
      - Isolation
        
        Change
        
        Visible
        
        After Validation
      - Durability
        
        Permanent State
        
        After Change
      - Atomicity
        
        Transaction
        
        Yes / No
    - - Complex Request
        
        Integrity
  - - - Data Availability
    - - No consistency at all time
    - - Consistent at the end
  - - - Availability
        
        Partition Tolerant
    - - CA = RDS
        
        CP = MongoDB
        
        AP = Cassandra
- - - - Weight
        
        Frequency
        
        In the document
        
        In all documents
        
        Text Size
      - Score
        
        Vector
        
        Cosinus
  - - - ./bin/elasticsearch.bat
    - - 9200
        
        Interrogation
      - 9300
        
        Listen
    - - http://localhost:9200
        
        For import
      - curl -XPUT -H "Content-Type: application/json" localhost:9200/_bulk --data-binary movies_elastic.json
    - - Key Word
      - Raw
      - curl -XPUT -H "Content-Type: application/json" localhost:9200/movies2 -d mapping_movies/mapping.json
      - curl -XPUT -H "Content-Type: application/json" localhost:9200/_bulk --data-binary mapping_movies/movies_elastic2.json
- - - - $MONGO/bin
        
        mongod.exe
    - - Robo3T
        
        Connexion
        
        localhost
        
        27017
  - - - No fix structure
      - JSON
        
        Document = {}
      - Difficult jointure
        
        2 Tables merge
        
        Denormalization
        
        Imbrication
        
        Requested Together
        
        Frequently
        
        Independant
        
        From other entries
        
        1-n relations
        
        Jointure
        
        Ref
    - - Database
        
        Then Collection
    - - ETL (Extract-Transform-Load)
      - OpenRefine
      - File import
        
        $lookup
        
        $redact
        
        mongoimport --db --collection --file