Please enable JavaScript.

Coggle requires JavaScript to display documents.

Databases (Data Analytics (Business Environment (Operational Systems …

- - - - Data Warehousing
        
        Non-volatile :peace_symbol:
        
        Time-variant :clock11:
        
        Subject-Oriented :person_frowning::skin-tone-4:
        
        Integrated :arrow_right: :arrow_left:
      - Data-Mining :pick:
        
        CRISP-DM :apple:
        
        Data Preparation
        
        Data Understanding
        
        Deployment
        
        Evaluation
        
        Modelling :dancer::skin-tone-3:
        
        Predictive
        
        Regression (Numeric)
        
        Classification (Categorical)
        
        Descriptive
        
        Business Understanding
- - - - Querying methods
        
        Query by Example (QBE)
        
        Native Queries
        
        SODA
    - - A permanent, shareable store for serialised objects in one or more programming languages.
    - - Weaknesses of RDBs
        
        Poor representation of real-world entities.
        
        Semantic Overloading
        
        Limited Operations (set theory)
        
        Homogeneous Structure
  - - - triggers
    - - Allows businesses to adopt the object-oriented paradigm progressively, rather than abandoning established systems.
    - - A relational database that supports database features
    - - Introduces concepts such as inheritance, user-defined types, and other new SQL types.
  - - - Neo4J
    - - MongoDB
    - - ACID Principles
        
        Atomicity :atom_symbol:
        
        Consistency
        
        Isolation
        
        Durability :shield:
  - - - XPath
      - XQuery
        
        FLWOR :sunflower:
    - - The value of some attribute
      - Shredded across multiple attributes and relations
      - In a schema-independent format
      - Stored in a parsed (internal) format.