System and Method for Semantic Search in an Enterprise Application

a semantic search and enterprise application technology, applied in the field of enterprise systems, can solve the problems of not being able to easily find text, not being able to present to end users, not being able to find text, etc., and unable to achieve semantic relationships within data,

Active Publication Date: 2010-03-18
ORACLE INT CORP
View PDF48 Cites 154 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

These enterprise applications are often quite complex, relying on numerous database tables to store and manage data for virtually every aspect of an organization's business.
However, data stored in relational databases typically may not be stored or directly accessible in a format conducive to text searching, presentation to end users, or other context-related manipulation.
Further, merely converting the stored data into a format that is more conducive to searching may ignore or lose information describing semantic relationships within the data.
For example, a data source that matches all of the search terms may be considered a good match and provided as a search result, while a data source that matches few or no terms may be considered a poor match and provided as a poor search result, or not provided as a matching result at all.
Although additional logic may be employed to match search terms, these searches are unable to identify or make use of semantic relationships that may be present among the indexed data.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • System and Method for Semantic Search in an Enterprise Application
  • System and Method for Semantic Search in an Enterprise Application
  • System and Method for Semantic Search in an Enterprise Application

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0064]

User Query:STANDARD purchase ordersTagged Output:STANDARD / JJ purchase / NN orders / NNSTokens Found:STANDARD, purchase, ordersVocabulary Tokens:purchase, ordersInstances Found:STANDARDSPARQL Query:PREFIX ref: SELECT *{?x rdf:PO_HEADER_ID ?purchase. ?x?prop6 ‘STANDARD’. }

In Example 1, the query requests all purchase orders of type “STANDARD.” The example shows how the entered query is analyzed for ontology entities and translated to a corresponding semantic search.

[0065]As previously described, a search query may be tagged to identify terms or types of terms in the query. A search system according to an embodiment of the invention may receive natural language or other text queries. A query may be processed by a part-of-speech tagger to produce the tagged output described in the examples. A specific example of a tagger suitable for use with embodiments of the invention is the Natural Language Parts of Speech Tagger from Stanford University, available at http: / / nlp.stanford.edu / softw...

example 2

[0068]

User Query:purchase orders vendor type lookup codeinternal currency code EURTagged Output:purchase / NN orders / NNS vendor / NNtype / NN lookup / NN code / NN Internal / NNPcurrency / NN code / NN EUR / NNPTokens Found:purchase, orders, vendor, type,lookup, code, Internal, currency, code, EURVocabulary Tokens:purchase, orders, vendor, type, lookup,code, currency, codeInstances Found:Internal, EURSPARQL Query:PREFIX ref: SELECT *{?x rdf:PO_HEADER_ID ?purchase. ?x?prop59 ‘Internal’. ?x ?prop60‘EUR’. ?x rdf:VENDOR_ID ?vendor.}

The query in Example 2 requests all purchase orders having a vendor type of “INTERNAL” and issued in Euros (EUR). As illustrated by Example 2, a semantic query may include elements of plain language queries, such as “currency code EUR,” as well as query structures specific to the application or the enterprise system, such as “lookup code internal.” Other query structures may be included. As previously described, the query may be analyzed to isolate terms suitable for a semanti...

example 3

[0069]

User Query:vendor having invoice currency code EURTagged Output:vendor / NN having / VBG / invoice / JJ currency / NN code / NN EUR / NNPTokens Found:vendor, invoice, currency, code, EURVocabulary Tokens:vendor, invoice, currency, codeInstances Found:EURSPARQL Query:PREFIX ref: SELECT *{?x rdf:INVOICE_NUM ?invoice. ?x?prop12 ‘EUR’. ?x rdf:VENDOR_ID ?vendor.}

This example shows a query for separate entities that have a semantic relationship, specifically, a query requesting vendors for whom there is at least one invoice in Euros. The “vendor” and “payable invoices” logical entities are involved in processing the query, but the association of a vendor with a payable invoice is through the associated purchase order, which is not present in the query. In the example system according to an embodiment of the invention, the semantic search system is “aware” of the intermediate implicit entries since they are described by an ontology associated with the application.

[0070]As previously described, t...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

Embodiments of the present invention provide techniques for searching enterprise data using semantic information associated with enterprise applications. One or more searchable data definitions that describe searchable data associated with one or more enterprise applications may identify semantic relationships among searchable data in the application. An ontology for the application that describes semantic relationships among data associated with the application may be generated from the searchable data definitions. The ontology may be used to execute search queries and provide search results that include or result from semantic relationships among the searched data.

Description

CROSS-REFERENCES TO RELATED APPLICATIONS[0001]This application is related to co-pending applications entitled “System and Method for Searching Enterprise Application Data,” Attorney Docket No. 021756-053700, filed ______ and “Searchable Object Network,” Attorney Docket No. 021756-053800, filed ______, the disclosure of each of which is incorporated by reference in its entirety for all purposes.BACKGROUND OF THE INVENTION[0002]The present invention relates to enterprise systems, and more particularly to techniques for manipulating searchable data and semantic information associated with applications in an enterprise system.[0003]Many businesses and other organizations use software applications and / or suites of such applications to organize their business affairs, track business performance, manage employee data and perform similar functions. These enterprise applications are often quite complex, relying on numerous database tables to store and manage data for virtually every aspect o...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(United States)
IPC IPC(8): G06F17/30
CPCG06F17/30734G06F16/367
Inventor GHOSH, RAJESHMADDALI, PHANI KISHORERANGARAJAN, KESHAVA
Owner ORACLE INT CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap