Browse Archived Data

Using the Browse Utility, you can quickly and easily review data stored in an Archive File.

For example, you can browse an Archive File to:

When searching archived data, you can begin with data in any archived table and join to related data in other archived tables. For example, even though orders-related information was archived on the basis of a date in the ORDERS table, you can look for archived information pertaining to a specific item by browsing archived rows from the ITEMS table and joining to related rows in other tables.

This section demonstrates how to use the Browse Utility.

Scenario Overview

In the Archive Process, you copied selected data to an Archive File and deleted archived rows from the ORDERS and DETAILS tables.

Archive Directory Maintenance allows you to search for data in Archive Files. When combined with the Browse Utility, this search capacity provides a powerful way to resolve a problem or answer a customer inquiry, without restoring archived data. For this scenario, you will browse archived data from the CUSTOMERS table, joining to related rows in the ORDERS table and the DETAILS table to confirm that a specific item was ordered and shipped more than two years ago.

To browse the data, you will: