did someone use a object database?

Discussion in 'Chit Chat' started by MarkusR, Feb 5, 2019.

  1. Diceman

    Diceman Member Licensed User

    Is there a way I can unsee that photo? :eek:
     
    jimmyF likes this.
  2. udg

    udg Expert Licensed User

    I wonder how the bathroom furniture can possibly fit his size..eheh
     
  3. LucaMs

    LucaMs Expert Licensed User

    Oh, va bene, ho capito che conoscete la lingua tedesca, ma questo a noi interessa poco; anzi, niente :p

    The "stupid tables" have to main purposes:

    1) represent an "object"
    2) allow you to perform searches, filtering and associations/relations (via non-stupid queries).

    Saving a complex object, in binary format or xml/json text does not have the same usefulness.
     
    Last edited: Feb 9, 2019
  4. MarkusR

    MarkusR Well-Known Member Licensed User

    see
    https://en.wikipedia.org/wiki/Database_normalization
    a table represent some data of a "object" and split everything in tables with links between is terrible and then if you need all for a report u need long querys.

    object databases can also have indexing and a search.
    sql querys are text, uncheckable and raise run time erros. means if u rename a field in db, if u wrote names wrong in sql etc.

    if u can save a whole class/object with all sub objects it have much usefulness. u not need a db table/field mapping. u not have a db struct.
     
  5. LucaMs

    LucaMs Expert Licensed User

    So, if you had an object that represents a customer's purchase order for a product, you save this complete object, rather than having several tables (Customer, Order, Item,...).
    By saving the whole object, you will have precisely what the normalization avoids: redundancy.
     
  6. MarkusR

    MarkusR Well-Known Member Licensed User

    i never saw a object database, i guess it save each object separately and each object have also an primary key.

    -----------------------
    https://en.wikipedia.org/wiki/Object_database
    https://en.wikipedia.org/wiki/Comparison_of_object_database_management_systems
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice