Oracle ConText Option Application Developer's Guide, Rel. 2.3 Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence Go to next file in sequence

SQL*Plus Sample Code


This appendix describes the sample SQL*Plus scripts provided by ConText. The scripts illustrate how to use SQL*Plus to build simple queries and generate linguistic output using ConText linguistics.

The scripts are divided into two functional areas: CTXPLUS (performing ad-hoc queries) and CTXLING (generating linguistic output).

The following topics are covered in this chapter:

Setting Up the ConText Sample Applications

Before you can use either the CTXPLUS, CTXLING or CTX QUERY sample applications, you must create the required demonstration objects by preforming the following setup tasks:


Note:

The files required for performing the setup tasks are located in the demo directory for ConText. For example, in a UNIX environment, the files are named demo.dmp and demo_setup.sql and are located in $ORACLE_HOME/ctx/demo/install.

For the exact location and name of the setup files, see the Oracle7 installation documentation specific to your operating system.

 

  1. Import the export file into the predefined ConText user CTXDEMO's schema. For example:
    IMP ctxdemo/ctxdemo FILE=demo.dmp TABLES=articles
    

    Importing the export file creates an ARTICLES table for CTXDEMO and populates ARTICLES.TEXT with the text of the articles used in the samples.

  2. Start one or more ConText Server with the DDL (D) personality.
  3. Log in to SQL*Plus as the demo user and run the setup script. For example:
    @demo_setup
    
    

    The script creates the policies, preferences, views, and results tables used by the samples and creates a text index for the ARTICLES table.

    This script illustrates the tasks you must perform to set up your tables for processing queries using ConText.

Overview of CTXPLUS

The CTXPLUS sample code consists of the following SQL scripts:

Script   Description  

query1.sql

 

Performs a one-step query using the input query expression and returns a hitlist, sorted by score, to the standard output.

 

query2.sql

 

Performs a two-step query using the input query expression and returns a hitlist, sorted by score, to the standard output.

 

queryc.sql

 

Performs an in-memory query using the input query expression and returns an unsorted hitlist to standard output

 

querys.sql

 

Performs an in-memory query using the input query expression and returns a hitlist, sorted by score, to the standard output.

 

storeqry.sql

 

Performs a query and stores the results as a system SQE. The results of the SQE can then be used in a query (one-step, two-step, or in-memory).

 

showsqe.sql

 

Returns a list of all the system SQEs that have been stored for a policy. Note that this script is not currently implemented.

 

view.sql

 

Selects a document based on the input textkey and returns the text of the document to the standard output.

 

See Also:

For more information about the location of the scripts, see the Oracle7 Server installation documentation specific to you operating system.

 

Concepts

The ConText concepts illustrated in this sample code are:

Using CTXPLUS

To use the CTXPLUS sample SQL scripts:

  1. Ensure that one or more ConText servers are running with the Query (Q) personality.
  2. Log in to SQL*Plus as the owner of the demonstration objects (usually CTXDEMO).
  3. To initiate a query, run one of the query scripts (query1, query2, queryc, or querys). The scripts prompt you to enter a query expression.

    For example:

    @query1
    Enter value for query_terms: coffee|tea
    



The script then returns a hitlist of the documents in the ARTICLES table that satisfy the query expression you enter. The hitlist consists of a score, ID, author, and title.

  • To view an article, run the view.sql script and give it an article ID. The article ID is the value displayed in the ID column in the hitlist generated by the query scripts.

    For example:

    @view 14
    

    The script then returns the text for the document with the article ID you specified.

  • To create a stored query expression (SQE), run the storeqry.sql script. The scripts prompt you to enter a name for the SQE and a query expression.

    For example:

    @storeqry
    Enter query name: test_sqe
    Enter value for query_terms: coffee|tea

  • Note:

    The script does not return the results of the query to the standard output.

     

    To view the SQEs for the demonstration user, use the CTX_USER_SQES view.

    For example:

    select pol_name, query_name, query_name
    
    
    from ctx_user_sqes;
    

    CTXPLUS Examples

    The following examples execute the query1.sql, query2.sql, and querys.sql scripts using the query terms California and politics and various logical operators (OR, ACCUMULATE, and AND).

    These examples illustrate how one-step, two-step, and (sorted) in-memory queries produce the same results and how the operators in a query expression affect the rows and scores returned by a query:

    Single Term Queries

    @query2
    Enter value for query_terms: California
    
    SCR  ID AUTHOR          TITLE
    ---- -- --------------- ----------------------------
    100  17 Nolo Richards   REVIEW & OUTLOOK (Editorial):
                            California Smashup
    50   18 Nolo Richards   State Farm and California
    30   25 David Shribman  In the Wilderness: Democrats'
                            Troubles In Winning
    20   49 Nolo Richards   California High Court Is
                            Asked to Lift Block Of In
    10   16 Heidi Waleson   LEISURE & ARTS: Cynthia
                            Phelps: Violist in Vogue 
    @query1
    Enter value for query_terms: politics
    
    SCR  ID AUTHOR          TITLE
    ---- -- --------------- ----------------------------
    20   25 David Shribman  In the Wilderness: Democrats'
                            Troubles In Winning
    10   13 Frederick C. Kl LEISURE & ARTS -- Sports:
                            Mediocrity's the Word Ar
    

    Multiple Term Query Using OR

    @querys
    Enter value for query_terms: politics|California SCR ID AUTHOR TITLE ---- -- --------------- ---------------------------- 100 17 Nolo Richards REVIEW & OUTLOOK (Editorial): California Smashup 50 18 Nolo Richards State Farm and California 30 25 David Shribman In the Wilderness: Democrats' Troubles In Winning 20 49 Nolo Richards California High Court Is Asked to Lift Block Of In 10 13 Frederick C. Kl LEISURE & ARTS -- Sports: Mediocrity's the Word Ar 10 16 Heidi Waleson LEISURE & ARTS: Cynthia Phelps: Violist in Vogue

    Multiple Term Query Using ACCUMULATE

    @query1
    Enter value for query_terms: politics,California SCR ID AUTHOR TITLE ---- -- --------------- ---------------------------- 100 17 Nolo Richards REVIEW & OUTLOOK (Editorial): California Smashup 50 18 Nolo Richards State Farm and California 50 25 David Shribman In the Wilderness: Democrats' Troubles In Winning 20 49 Nolo Richards California High Court Is Asked to Lift Block Of In 10 13 Frederick C. Kl LEISURE & ARTS -- Sports: Mediocrity's the Word Ar 10 16 Heidi Waleson LEISURE & ARTS: Cynthia Phelps: Violist in Vogue

    Multiple Term Queries Using AND

    @query2
    Enter value for query_terms: politics&California
    SCR  ID AUTHOR          TITLE
    ---- -- --------------- ----------------------------
    20   25 David Shribman  In the Wilderness: Democrats'
                            Troubles In Winning
    

    Overview of CTXLING

    The CTXLING demo is a set of simple, related SQL*Plus scripts. Two of the scripts automate and track linguistic extraction on the demonstration documents. The remaining scripts can be used to query this linguistic output.

    The CTXLING sample code consists of the following SQL scripts:

    Script   Description  

    genling.sql

     

    Requests theme and Gist generation for each of the documents in the ARTICLES table.

     

    status.sql

     

    Shows the status of the theme and Gist generation initiated by genling.sql.

     

    gist.sql

     

    Displays the Gists for a document.

     

    themes.sql

     

    Displays the themes for a document.

     

    similar.sql

     

    Displays documents with similar themes for the input document

     

    See Also:

    For more information about the location of the scripts, see the Oracle7 Server installation documentation specifc to your operating system.

     

    Concepts

    The ConText concepts illustrated in this sample code are:

    Using CTXLING

    To use the CTXLING sample SQL scripts:

    1. Ensure that one or more ConText servers with the Linguistic (L) personality are running.
    2. Log in to SQL*Plus as the owner of the demonstration objects (usually CTXDEMO).
    3. To generate linguistic output, run genling.sql:
      @genling
      Clearing theme table...
      
      
      Clearing article table...
      Initializing ling_tracking table
      Creating ling. callback function LING_COMP_CALLBACK...
      Submitting all articles for linguistic extraction...
      
      All articles submitted.
    
    
    
  • The linguistic generation runs in the background. While this is happening, you can use status.sql to check on the progress:

    For example:

    @status
    Linguistic Requests left: 36 
    Request Errors....

    The extraction is complete when there are 0 Linguistic Requests left.

  • To view the themes or Gists of an article, run the appropriate script and give it an article ID.

    For example:

    @gist 40
    Points of View
    01 GENERIC ..
    15 production
    16 purchases
    which point of view gist to print: 15
    

    The script then returns the themes or Gists for the document with the article ID you specified.

  • To select articles with the same themes as an article, run the similar.sql script and give it an article ID.

    For example:

    @similar 14
    

    The script then returns a list of the articles with the same themes as the article ID you specified.

  • CTXLING Examples

    The following examples illustrate using themes.sql, gist.sql, and similar.sql to view the linguistic output generated by genling.sql.

    Theme Viewing

    @themes 40 
    Commodities: Coffee Futures Prices Decline on News That
    U.S. Might Not Participate in New International Pact
    by John Valentine 
    
    T#  THEME                                   WEIGHT
    --- --------------------------------------- ------
    01  United States                           11
    02  commerce and trade                      10
    03  coffee                                  10 
    ...
    

    Gist Viewing

    @gist 40
    
    Points of View 
    
    01 GENERIC ...
    15 production
    16 purchases
    
    Which point of view gist to print: 15
    
    Commodities: Coffee Futures Prices Decline on News That
    U.S. Might Not Participate in New International Pact
    by John Valentine 
    
    Consuming and producing nations appear to be poles apart
    in their positions. Producing countries proposed a quota
    that would incorporate the sales of
    ...
    
    

    Theme Comparison Viewing

    @similar 40
    
    Commodities: Coffee Futures Prices Decline on News That
    U.S. Might Not Participate in New International Pact
    by John Valentine
    Article Themes 01 United States 02 commerce and trade 03 coffee .. 14 production 15 purchases Which theme to query: 15 Other articles with this theme ID WT AUTHOR TITLE
    --- --- --------------- -------------------------------- 1 8 William Power OTC Focus: Composite Index Falls 33 7 Alex Kaufmann Your Money Matters: How to Take 5 7 George Anders Shades of U.S. Steel: J.P. 30 6 Michael Siconol Mutual Funds: ...And Find Out if 47 6 Nolo Richards Ponce Federal Bank Is in Talks 45 5 Nolo Richards Farley Wins Round In His Bid to 35 2 Alix M. Freedma Supermarkets Push Private-Label



    Go to previous file in sequence Go to next file in sequence
    Prev Next
    Oracle
    Copyright © 1997 Oracle Corporation.
    All Rights Reserved.
    Go to Product Documentation Library
    Library
    Go to books for this product
    Product
    Go to Contents for this book
    Contents
    Go to Index
    Index