Object-relational database

Beschreibung

All of the above was reproduced courtesy of Mohsan Ali.
adamelvin786
Mindmap von adamelvin786, aktualisiert more than 1 year ago
adamelvin786
Erstellt von adamelvin786 vor etwa 10 Jahre
19
0

Zusammenfassung der Ressource

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
                                    Zusammenfassung anzeigen Zusammenfassung ausblenden

                                    ähnlicher Inhalt

                                    DNA - Struktur
                                    Lisa10a
                                    Der menschliche Körper
                                    anna.grillborzer0656
                                    2C Entwicklungspsychologie
                                    petra.drewitz
                                    Zellorganellen
                                    Sarah K.
                                    GPSY SOPS
                                    Simon Wirsching
                                    Tierhaltung & Tierhygiene 1
                                    Anne Käfer
                                    Vetie Pharma Datum unbekannt Karteikarten
                                    Alina Stumpf
                                    Vetie- Innere 2017
                                    Ju Pi
                                    Vetie Para Morphologie Entomologie
                                    Kristin E