Oracle8iIntermediaTextppt.pptVIP

Benchmarking Oracle 8i Intermedia Text Benchmarking Oracle 8i Intermedia Text Features in Intermedia Text To be investigated: The text indexing technique The new query operators How to use this in the EDMS Search Engine OIMT Textindexes An OIMT textindex can be created on: varchar2 columns Large object (LOB) columns B-file columns, indexing entire files Allowing queries like: Select id from table where contains(column,’Atlas’)0; 1 One of the detectors in the LHC ring is ATLAS 2 The Atlasmountains are situated in the north of Africa - 1 … contains(column,’Atlas inner detector’)0; 1 The problems with the ATLAS inner detector... 2 The inner detector of ATLAS... - 1 Query optimization Selects the best executing plan based on analyze table…compute statistics; * Background for this benchmark Interesting new features in OIMT Benchmarking, methodology and problems Results Conclusions ODF 000419 Benchmarking Oracle8i Intermedia Text Background for this benchmark The task of the thesis project The EDMS Search Engine CERN’s EDMS CADIM/EDB, managing product data documents MP5, managing physical components Oracle 7, database platform Implement Oracle8i in the future? ODF 000419 Benchmarking Oracle8i Intermedia Text Oracle 8i Intermedia A product embedded in Oracle8i Intermedia allows a unified technique for accessing various types of data such as: Text Documents Images Audio Video ODF 000419 Benchmarking Oracle8i Intermedia Text Features in Intermedia Text ODF 000419 Benchmarking Oracle8i Intermedia Text Database integration Mixed queries against multiple text columns Single SQL API Indexes on most database columns All index data in the database Automatic triggers on textcolumns to detect changes Full text search Exact Word and phrase search, operators, removing stopwords XML and HTML document section searching Features in Intermedia Text ODF 000419 Benchmarking Oracle8i Intermedia Text About Search (All languages) Parses an