HP Structured Records Management Solution Tutorial, August 2011

HP Structured Records Management Solution Tutorial 49
Searching the extract in HP TRIM
HP TRIM also allows you to search the structured records. As with any other
record in HP TRIM, you may need to query it for business reasons, a Freedom of
Information request or an e-discovery exercise for litigation. All of the HP TRIM
search methods are available, in the same way that they would be for other types
of records.
For example, you might search by Date Created.
TIP While searching in HP TRIM is useful, you may find that what you really
need is to query the archive data in much the same way that you do when the data
was stored in a database. HP Database Archiving provides a Record Query Server,
which enables you to execute SQL queries against your archived data files. Refer
to Querying archived data (page 49).
For more information about searching records within HP TRIM, refer to your HP
TRIM documentation.
Querying archived data
While the search facilities within HP TRIM are quite powerful, the data stored in
the XML files from HP Database Archiving is relational. As such, you may, at
times, want to query the data as you did when it was stored in a database but
without incurring the overhead of reloading it into your production database. The