Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
Help Constructing a Database Layout
Date: Sat Mar 12 2005 - 12:29:10 CST
I am considering converting a system from a proprietary implementation of
FoxPro database and the Microsoft Jet access engine to MaxDB.
I was hoping someone could give me some advice on how our current
structure could be ported to MaxDB.
Currently, whenever we add a new client my system creates a new filepath
on the database server and creates all of the appropriate client specific
tables in that directory and then makes an entry in our master client
table indicating the client general information and the filepath to the
client's directory. The client specific directory contains approximately
40 different tables depending on which of our services the client is
What I am having difficulty with is how to map this process to MaxDB. As
best as i can determine I would have to either:
1. Create a different database for each client
2. Create all of the tables for all of the clients in the same master
database and prefix the table name with some client specific code.
3. Have only one of each kind of table and a key field that links each
entry to which group the entry belongs.
1. Seems like it would require a DBA to do some work for each new client.
2. This would currently mean 16,000 tables in one database for my existing
3. I have to wonder what the performance hit would be considering instead
of looking for all of the transactions from 1/1/2004-12/31/2004 for a
certain plan participant from a table of one million records it would be
searching for them in a table of 50 million records.
My main reason for wanting to switch how we currently do it is to allow
for a replication slave in an off site location that would be synchronized
with our current database up to the minute instead of just backups that
are done a couple of times a day.
As for the activity on the tables. We have about 10 people who access the
tables to post received checks and answer questions from clients and
participants. We have another 5 who perform data entry. in addition we
have an IVR system that takes calls on several phone lines that access the
database and we have a web interface that allows participants to examine
account information. Generally at any one time approximately 50-100 people
can be executing some sort of request against the database server.
I do not have a high insert or update volume.
Thanks for any help.
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb