Please enable JavaScript.

Coggle requires JavaScript to display documents.

5E a.s. 2024-2025, DATABASES, ❤️, Andiamo avanti!!!! - Coggle Diagram

- - - - characteristics reflect that
- - - - SQL has been recognized
        as a programming language
    - - SQL still dominant tool
    - - IBM improved SQL language and implemented different dialects
    - - creation of SQL
  - - - Doesn’t manage unstructured data
      - Difficult to scale
    - - Longevity
      - Support transaction
      - doesn't abide to every Codd’s laws
      - Flexibility
  - - - Sets of tuples
        
        Each tuple share aaaaaattributes/columns
      - Creation
        
        Data type
        
        Primary key
        
        Foreign key
- - - - Tuning
      - Security
      - Backups
      - Routine Management Tasks
      - Updates
    - - Self-driving
        
        Automated processes
        
        DBAs different focusses
        
        Infrastructure management
      - Self-securing
      - Self-repairing
        
        Prevent downtime
      - Benefits
        
        Automatic patches and fixes
        
        Manual management task deleted
        
        Reduced cost
      - Algorithms
        
        System upgrades
        
        Systems Always running
        
        Scalability and less resources
        needed
  - - - Lower cost
- - - - Tree-like model (One to many relationship)
    - - Flexible model (multiple relationship)
    - - Relational database
      - 1990s
        
        Object-oriented database
        
        Present
        
        NoSQL database
        
        Enabled to use unstructured data
        
        Cloud database
        
        Innovations (collection, storing, management and utilisation)
        
        Self-driving database
        
        Autonomous database
        
        Machine learning
        
        To automate database tuning
        
        Security
        
        Backups
        
        Updates
        
        Routine management
        
        Why use ADB?
        
        Efficiency
        
        Realiability
        
        Scalability
        
        Security
        
        Availability
        
        Types of data
        
        Unstructured
        
        1 more item...
        
        Structured
        
        1 more item...
        
        Components
        
        Data warehouse
        
        1 more item...
        
        Transaction processing
        
        1 more item...
        
        Why choosing ADB?
        
        Benefits
        
        10 more items...
        
        Future of ADB
        
        They offer advantages to enterprises
        
        1 more item...
- - - - Data
        
        Series of tabels
        
        efficient processing and data querying
      - DBMS
      - Applications
      - SQL
        
        Writing and querying data