#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2015
    Posts
    46
    Rep Power
    3

    Dyamic Database System


    How would I be able to find a database system that allows me to store objects instead of just as columns and rows. I need to change the properties of the objects on the fly from the front end.
  2. #2
  3. Lord of the Dance
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Oct 2003
    Posts
    4,131
    Rep Power
    2011
    Can you be more specific and define what you mean with "object" and "on the fly"?

    Normally, the table is your object where the properties would be the columns and rows.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2015
    Posts
    46
    Rep Power
    3
    Ok, thank you for responding. An object can be anything the user creates on the site: a person, an event, a group, a table.
    And instead of creating database rows and columns beforehand, as you would for a site. I want users to be able to type in the name of the object (class) they're creating and the properties of the object/class, and the "rows and columns" will be created from this information, with properties being the column heads. Unfortunately, I don't know how this will fare with traditional relational databases, and I was looking into other methods of storing information like this, from a website and dynamically.
  6. #4
  7. Lord of the Dance
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Oct 2003
    Posts
    4,131
    Rep Power
    2011
    Isn't that question the same you posted here: Object Creation Program ?
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2015
    Posts
    46
    Rep Power
    3
    Well, basically. But I've realized the problem is the database system most likely, instead of the actual program. Hence, I've posted it here, so this particular part of the idea is resolved.
  10. #6
  11. Lord of the Dance
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Oct 2003
    Posts
    4,131
    Rep Power
    2011
    You could have a table object where all the object names is stored:
    objectid objectname
    1 person
    2 event
    etc.

    A second table objectproperties would then contain the properties for each obect:
    objectid propertyname
    1 first name
    1 last name
    2 event name
    2 event type
    etc.

    This setup will not work?
  12. #7
  13. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    867
    Rep Power
    391

    Cool


    You could look into XML Database(s) and/or implement an Entity–attribute–value model
  14. #8
  15. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2015
    Posts
    46
    Rep Power
    3
    Thank you very much everyone for all the answers. I will look into XML databases, and will try to find a good one...hopefully learn some of the required XML while I try to do this. Also, I will look into entity-attribute-value models, in addition to others. Hopefully I will find good usable examples of each, along with tutorials for someone with intermediate programming experience. Mr Fujin, I will try to use the relational database method you suggested however, without an example, it seems very variable in attempting to implement it. Like how to tell the database in PHP to add a particular items id to the list, without knowing beforehand the object itself, for example. Thank you all, and I look forward to working on this, and perhaps with all of you in the future. Aloha.

IMN logo majestic logo threadwatch logo seochat tools logo