Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2002
    Posts
    6

    building a database

    Hi, i would want to build a database to login calls for problem and resolution.
    anybody has a working model on this?
    thanks

  2. #2
    Join Date
    Aug 2002
    Location
    UK
    Posts
    87
    It might help people if you specified what sort of system you require?

    i.e. Single/Multiple user access, 1, 2, or 3 tier system, Unix or M$, small DB (upto a few 1000 rows), hugh DB (1 million rows) etc ...

  3. #3
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    I didn't know that was important while building a database schema?
    We are talking about a relational database design, right?
    Sizing usually comes afterwards.
    Anyway: There are some default models available.
    I 've seen one on the RDD course of Informix Software.
    rws

  4. #4
    Join Date
    Aug 2002
    Location
    UK
    Posts
    87
    Oh right i see what you mean.

    I was thinking of which technologies first although the way you might want to use the database and the amount of data might effect how you design the structure. (i.e. you could contain multiple sets of 'lookup' data into one table, or have one table for each set of 'lookup' data')
    or you might want to use partitioned tables (oracle data warehousing)
    etc ....


    I've not worked on call centre systems - sorry for not being much help

  5. #5
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Hey WingMan,
    I was not trying to offend you.
    This just looked like a very simple database design.

    Table patritioning is a good thing, once the database is growing. I assume almost every database vendor has this feature...
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •