7.0
Table Of Contents
- Copyright Information
- Table of Content
- Overview
- Understanding PlanetPress Search
- The PlanetPress Search Program
- Search Profiles And Databases
- Searching in PlanetPress Search
- Search
- Search Result
- Detailed Directions
- Perform a Search Using a Basic Query
- Perform a Search Using an SQL Query
- Change the View on Search Results
- Select Search Results
- View the PDF Associated with a Search Result
- Create a PDF of Search Result Pages
- Print PDF Pages Referenced by Search Results
- Print a Summary of the Search Results List
- Copy Information from the Results List
- Advanced Concepts
- Index
PlanetPress Search database structure.
Tables Values and Relationships
Table_
Doc_#
PlanetPress Search index values (INDEX_#) are associated with the page number (Page_Number) in the PDF
(PDF_ID) they appear in. Each of the PlanetPress documents that generate a PDF which PlanetPress Search can
query has a unique Table_Doc_# table.
Table_
Document
PlanetPress documents are associated to a unique Doc_ID integer. The integer is then included in the Table_Doc_#
table naming convention generated for the document.
Table_
Index
Index_Id integers are associated to their labels (Index_Name) as defined in the PlanetPress documents. The integer
is then included in the INDEX_# field naming convention generated for the Table_Doc_# table.
Table_
PDF
PDF_ID integers are associated to a Doc_ID integer provided by the Table_Document table, and a Path_ID
integer in the Table_Path table.
Table_
Path
Path_ID integers are associated to the Path of each of the PDFs that are included in the database.
Database Considerations in a Network Installation
In a standalone installation, PlanetPress Search exists on the local machine and the individual user creates the search profiles
they require. A standalone configuration is common when a single user performs searches. In most circumstances a stand-
alone configuration offers better performance than a network installation. For optimal performance in a standalone con-
figuration, Access databases are recommended.
In a network installation, PlanetPress Search exists on a network and is accessible to the users on that network. A network
installation is common when many users perform searches. SQL Server databases offer the best performance in network
installations.
Database Integrity in a Network Installation
In a network installation, it is common to want to restrict permission to refresh and rebuild a search database to the database
administrator. For example, if any user can refresh or rebuild a database, and one user launches a search just after another
user initiates a rebuild of the database, the first user may unwittingly obtain inaccurate search results.
There are three things an administrator must control to restrict access to the databases PlanetPress Search creates.
Advanced Concepts
©2010 Objectif Lune Inc - 41 -