Archival of Table from ODS

harish841913 · Post by **harish841913** » Tue Jun 07, 2011 11:48 pm

HI i want to archive the data from ods for 2 years how can i achive this purpose?

chulett · Post by **chulett** » Wed Jun 08, 2011 6:22 am

I'm curious... how many times are you going to post this rather nebulous "business requirement"?

ray.wurlod · Post by **ray.wurlod** » Wed Jun 08, 2011 4:34 pm

Use Optim.

harish841913 · Post by **harish841913** » Wed Jun 08, 2011 11:02 pm

ray.wurlod wrote:Use Optim. ...

But here i have to use unix script it seems and how this process is like i have to extract data from extract feeds and load it into ODS and than i have to create archive database of those repositories in ODS using archival script

Is this approach right

vmcburney · Post by **vmcburney** » Wed Jun 08, 2011 11:41 pm

You are unqualified to fulfill this requirement and you should pass it on to someone who is. The fact that you cannot describe what you are trying to do is ringing alarm bells. I don't know if you are archiving two years of data, or archiving data for the next two years, or archiving data that is more than two years old.

Describing archiving as running a "script" is another alarm bell. That is woefully inadequate for a data archiving solution. Archiving requires all the normal phases of information development - requirements, analysis, design, build and test. Have a look at how the MIKE2.0 methodology describes this process: http://mike2.openmethodology.org/wiki/I ... n_Offering.

If you are indeed removing data from an Operational Data Store you need a functional requirements document - what data needs to be archived? Does archived data needs to be available in lower tier storage? Is there anything currently using that data? How to you maintain the referential integrity of the database? How do you remove the data and then delete it? How do you automate the process so it can be repeated at regular intervals? How do you perform system integration testing to ensure you haven't broken anything once the archive is executed? etc.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 09, 2011 5:12 am

Who said you have to use UNIX script? That information was not part of your original question!