Loading [MathJax]/jax/output/HTML-CSS/fonts/TeX/fontdata.js
Copy and Edit

Object-relational database

Description

All of the above was reproduced courtesy of Mohsan Ali.
adamelvin786
Mind Map by adamelvin786, updated more than 1 year ago
adamelvin786
Created by adamelvin786 about 11 years ago
20
0
0
1 2 3 4 5 (0)

Resource summary

Object-relational database
  1. Features
    1. Advantages
      1. Ease of use
        1. Flexibility
          1. Precision
            1. Security
              1. Data Independence
                1. Data Manipulation Language
                2. Disadvantages
                  1. machine performance
                    1. Schema Changes
                      1. Language Dependence
                        1. Lack of Ad-Hoc Queries
                      2. object types
                        1. model real-world entities
                          1. Object Columns
                            1. An object column is a column in a table that is defined using an object type.
                            2. Object Tables
                              1. object table is a table in which each row contains one object of a given object type.
                            3. NULL
                              1. atomic NULL
                                1. object can be atomically NULL
                                  1. cannot be updated
                                2. NULL attributes
                                  1. object can have attributes that are NULL
                                    1. Updates on its individual attributes
                                      1. Must use cascade clause
                                3. collection types
                                  1. VARRAY
                                    1. variable sized array which has ordered set of data elements of the same type.
                                    2. Nested tables
                                      1. Tables are ordered set of elements of the same data type
                                    Show full summary Hide full summary

                                    0 comments

                                    There are no comments, be the first and leave one below:

                                    Want to create your own Mind Maps for free with GoConqr? Learn more.

                                    Similar

                                    A2 Organic Chemistry - Reactions
                                    yannycollins
                                    Main People in Medicine Through Time
                                    Holly Bamford
                                    English Basic Grammar
                                    tvazacconcia
                                    Topic 1 Quiz - Elements & The Periodic Table
                                    Musicdudejoe
                                    3.1 Keywords - Marketing
                                    Mr_Lambert_Hungerhil
                                    Meteorologia I
                                    Adriana Forero
                                    4. The Skeletal System - bones of the skull
                                    t.whittingham
                                    Repaso Revalida PR 2016
                                    Rodrigo Lopez
                                    Core 1.5 Mechanisms
                                    T Andrews
                                    Mapa Mental para Resumir y Conectar Ideas
                                    Ricardo Padilla Alcantara
                                    Browse Library