G
Guest
Here's my situation, which I can't wrap my head around. I have a flat file
of non-normalized data. I want to dump the file into an Access db and run
reports on it but I understand that for performance reasons the data need to
be normalized.
This raises two questions:
1) What is the best way to accomplish the initial normalization?
2) I will be adding to this data from a similar non-normalized flat file
every month. How do I add subsequent month's data to the db, keeping in mind
the issue of normalization?
I realize these are fairly open-ended questions, and I understand the
concepts of data normalization. I'm just not clear on how to get from flat
file to normalized database structure, and maintain this on an ongoing basis.
Thanks for any thoughts,
Dave
of non-normalized data. I want to dump the file into an Access db and run
reports on it but I understand that for performance reasons the data need to
be normalized.
This raises two questions:
1) What is the best way to accomplish the initial normalization?
2) I will be adding to this data from a similar non-normalized flat file
every month. How do I add subsequent month's data to the db, keeping in mind
the issue of normalization?
I realize these are fairly open-ended questions, and I understand the
concepts of data normalization. I'm just not clear on how to get from flat
file to normalized database structure, and maintain this on an ongoing basis.
Thanks for any thoughts,
Dave