building a database [Archive]

lamderham

07-28-02, 13:21

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

WingMan

08-20-02, 06:14

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 ...

Roelwe

08-21-02, 09:43

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.

WingMan

08-22-02, 12:48

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
:(

Roelwe

08-23-02, 07:20

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...