Q

Dealing with old and infrequently used data

What is the best practice to deal with data that is old and infrequently used?

There is no "best" practice because this is largely determined by your company's policies relating to older data. Can the old data be simply deleted? Must it be archived for a certain number of years? If it is archived, will it be used on a semi-regular basis or almost never? Once you start to answer these questions, you can determine which method is best for you.

To give you an idea of the different methods, we'll go through a few scenarios.

If the data can simply be deleted, the DELETE statements against appropriate tables can help.

If the data needs to be accessed frequently, many people move the old data to an archive table. Then production can access the new data, while keeping the older data in the database. Many people also set up a data warehouse (if that is appropriate) for their older information. Also, many people don't need all of the details of their older data so they aggregate it.

If the data needs to be accessed only in rare circumstances, then it is probably best to keep the data out of the database. Export the data. Unplug a tablespace. Or whatever works to remove the data from the database, but keep it in a format that can easily be added to the database.

For More Information


This was first published in March 2003

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close