introduction to oracle inter media text l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Introduction to Oracle inter Media-Text PowerPoint Presentation
Download Presentation
Introduction to Oracle inter Media-Text

Loading in 2 Seconds...

play fullscreen
1 / 18

Introduction to Oracle inter Media-Text - PowerPoint PPT Presentation


  • 268 Views
  • Uploaded on

Introduction to Oracle inter Media-Text. By Derek Mathieson (AS-IDS). The Problem. Find X by keyword Y. SELECT cod FROM bud_codes WHERE desc LIKE ‘%EDH%’; SELECT doc_id FROM edh_docs WHERE UPPER(short_desc) LIKE ‘%PRINTER%’;. TOO SLOW!. f1. The Solution. Oracle inter Media-Text.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Introduction to Oracle inter Media-Text' - Anita


Download Now 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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
introduction to oracle inter media text

Introduction to Oracle interMedia-Text

By Derek Mathieson

(AS-IDS)

the problem
The Problem
  • Find X by keyword Y

SELECT cod FROM bud_codes WHERE desc LIKE ‘%EDH%’;

SELECT doc_id FROM edh_docs WHERE UPPER(short_desc) LIKE ‘%PRINTER%’;

TOO SLOW!

f1

the solution
The Solution

Oracle interMedia-Text

searching with inter media text
Searching with interMedia-Text
  • Rewritten query using interMedia-Text.

SELECT doc_id FROM edh_docs WHERE CONTAINS( short_desc, ‘%PRINTER%’, 1) > 0;

d3, d4, d5

query operators
Query Operators
  • Algebraic
  • Dictionary
  • Other
algebraic query operators
Algebraic Query Operators
  • AND, OR, NOT, MINUS

Example:

  • monitor NOT flat
  • AS-IDS OR AS-SAS

d6

dictionary query operators
Dictionary Query Operators
  • ABOUT

ABOUT(subatomic particles)

matches text on the subject of physics

  • Broader, Narrower, Related or Preferred Term

BT(dog)

Matches ‘dog’, ‘mammal, ‘animal’

d7

dictionary query operators8
Dictionary Query Operators
  • Stem

stem(sing)

matches ‘sing’ ‘sung’ or ‘sang’

  • Synonym

SYN(tiger)

matches ‘tiger’ ‘cat’, etc.

  • Translated Term

TR(chien)

matches ‘chien’ or ‘dog’

other query operators
Other Query Operators
  • fuzzy, soundex

?apply

matches ‘apply’ ‘apple’ ‘applied’ ‘April’

  • Wildcards

math%, %day, %th%, _ing

name

other query operators10
Other Query Operators
  • NEAR((word1, word2,...) [, max_span [, order]])

NEAR((monday, tuesday, wednesday), 20, TRUE)

  • WITHIN

workflow WITHIN TITLE

Derek WITHIN AUTHOR WITHIN BOOK

  • <TITLE>Workflow</TITLE>
  • Business process automation…
sorting by relevance
Sorting by Relevance

SELECT doc_id FROM edh_docs WHERE CONTAINS( short_desc, ‘DOG, CAT, MOUSE’, 1) > 0;

sorting by relevance12
Sorting by Relevance

SELECT doc_id FROM edh_docs WHERE CONTAINS( short_desc, ‘DOG, CAT, MOUSE’, 1) > 0 ORDER BY SCORE(1) DESC;

sorting by relevance13
Sorting by Relevance

SELECT /*+ FIRST_ROWS */doc_id FROM edh_docs WHERE CONTAINS( short_desc, ‘DOG, CAT, MOUSE’, 1) > 0 ORDER BY SCORE(1) DESC;

acid

creating indexes
Creating Indexes
  • Now built in to Oracle kernel
  • NOT automatically updated after DML
    • Manually refreshed
    • ctxsrv process

create index edh_docs_idx on edh_docs( short_desc ) indextype is ctxsys.context

data sources
Data Sources
  • Column data (VARCHAR, CLOB, etc.)
  • Detail Table
  • External File
  • URL
data types
Data Types
  • Text
    • ASCII, HTML, XML, …
  • Microsoft
    • RTF, Word, Works, PowerPoint, Excel, Access, …
  • Other
    • PDF, WordPerfect, Lotus 1-2-3, MacWrite, QuattroPro, dBASE, …
  • Over 160 different File Formats!
applications
Applications
  • EDH Search Screens
    • Supplier by keyword, or partial address
    • Budget Code by description
    • Document by short description
    • Document by full text?

What about YOUR application?

thank you
Thank You

For More Information

Browse to:http://technet.oracle.com /training/products/intermedia/listing.htm