1 / 10

Efficient Dataset Limiting to Optimize Report Processing Time

Learn how to limit datasets in the cataloging module to enhance system performance and reduce run time for reports. Use the “binoculars” search and ALEPH.OWN field to create smaller, targeted record sets for quicker processing. Follow step-by-step instructions to generate and save limited datasets for streamlined report execution. Make the most of your system resources by utilizing this dataset limiting technique.

jlaine
Download Presentation

Efficient Dataset Limiting to Optimize Report Processing Time

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Limiting datasets • Some reports can take hours and even days to run. The Retrieve Catalog Records (p_ret_01) is one such report. • One way to significantly reduce run time and load on system is to limit the number of records to process. • Once a smaller group of records is identified, it can be used as the “input dataset” to the longer running processes.

  2. To define a smaller dataset within the cataloging module, use “binoculars” search

  3. The drop down menu is defined by pc_tab_sear.eng and is also affected by indexed fields defined in tab00.

  4. One of the most useful fields in a consortia setting with a shared database is the ALEPH OWN field.

  5. Enter the ADM code and hit OK. This will generate a set of records satisfying that criteria. You can be as general or specific as needed.

  6. This is a search for the same OWN field but also limited by FORMAT of SE.

  7. Highlight the set you want to use and then hit SAVE.

  8. You will be prompted for a filename. Keep it short and easy to remember. If you are in a consortia, you will want it to be unique to avoid overwriting or getting overwritten!

  9. The system stores that set in $alephe_scratch. Your limited set of records is ready to be used as input for services such as ret-01. Be sure to check that the service you wish to run looks for the input file in the $alephe_scratch directory. • For example, the HELP documentation for ret-01 states:Input FileEnter the name of an input file only if you want to narrow a previously retrieved group of document numbers. The input file must exist in the $alephe_scratch directory. If no input file is necessary, leave the field blank.

  10. The name of the saved record set is used as the INPUT FILE for ret-01. The service will only process against those records saving much time and system resources.

More Related