# Patent

## Title
Semantic system for integrating software components

## Abstract

A system and method for integrating databases and/or web services into a searchable ontological structure. The structure allows for free-form searching of the combined system and for the discovery of an execution path through the ontology. The discovered execution path (or paths) provides for the generation of code that integrate databases and services for the purpose of fusing information from disparate databases and Web services.

## Background
This invention was made with government support under Grant Number FA-8721-04-C0001, awarded by The United States Air Force, Electronic Systems Center. The government has certain rights in the invention.


FIELD OF THE INVENTION
The present application relates to a system for integrating software components using a semantic ontology management system.
BACKGROUND OF THE INVENTION
Web service standards are enjoying widespread adoption in corporations across many industries. Corporations are recognizing the value of making it easier for other applications to consume their data by using web standards such as the Hyper Text Transfer Protocol (HTTP), web addressing, and Extensible Markup Language (XML). Using these standards, software clients written in one programming language can access and retrieve information from a server, irrespective of the technology (e.g., hardware, operating system, and programming language) that the server uses.
However, even with the adoption of these web standards, problems remain. For example, although XML is mature as a syntax for web data exchange, current XML technologies do not supply the capabilities provided by more mature technologies like relational database systems. Also, while solutions that aid in web service discovery (e.g., Universal Description, Discovery and Integration (UDDI), as described at uddi.org/specification.html, incorporated by reference herein) and invocation (e.g., Web Services Description Language (WSDL), incorporated by reference herein) are emerging, they are far from mature. Similarly, technologies that reason with web service description files for the purpose of chaining web services are not available. It is left to the programmer to determine, at design time, which web services to invoke, the order in which they need to be invoked, and the formatting of information necessary to complete an operation. As a result, the programmer writes much of the “glue code” necessary for a particular computation. A need still exists for methods and systems that allow automatic generation of such “glue code,” as well as automatic discovery and integration of available web services and data repositories.
SUMMARY OF THE INVENTION
In one aspect, the invention is a method of generating executable code for linking data in a structured data repository to structured inputs and outputs from a source web service. According to the method, a first domain ontology encoding the structured data repository and a second domain ontology encoding the structured inputs and outputs of the source web service (and optionally also access parameters for the web service) are provided, and are linked to form a merged ontology. Data from the structured data repository and the web service are mapped into the merged ontology to create an expanded ontology. One or more desired input(s) and output(s) are specified for a linked web service, and the expanded ontology is searched for an execution path between the desired input(s) and output(s), which may include at least one concept from the first ontology and one concept from the second ontology. Executable code is then generated that executes steps of the execution path in order to produce the desired outputs. The expanded ontology may be created either by mapping data from the structured data repository and structured inputs and outputs from the web service into the merged ontology, or into the first domain ontology and second domain ontology before merging.
In another aspect, the invention is a method of constructing a new web service that provides a selected output type in response to a selected input. The method includes accepting an input item and an output type from a user, and searching an ontology to find one or more input matches for the input item and output matches for the output type. The ontology comprises structured data from one or more structured data repositories and structured input and output information from one or more existing web services. Once match(es) for the input item and output type are found, the ontology is searched to find execution path(s) that link input match(es) and output match(es). (If multiple execution paths are found, a user may be permitted to select a desired path, and if multiple input and/or output matches are found, a user may also be permitted to select among the matches found). The execution path is then used to generate executable code for the new web service, which allows a user to provide input of a type corresponding to the accepted input item, and provides an output of the accepted output type. The execution path may include at least one concept from a structured data repository and at least one concept from structured input and output information from an existing web service.
In yet another aspect, the invention is a method of selecting and accessing one or more web services, wherein each web service has a set of one or more structured input(s) and output(s). The method includes providing a domain ontology that includes mappings to the structured input(s) and output(s) (and optionally access parameters for a web service in the ontology), specifying one or more desired inputs and outputs, and searching the domain ontology to match the one or more desired inputs and outputs. The domain ontology is also searched for an execution path linking the one or more structured inputs to the one or more structured outputs. The web service(s) having mappings on the execution path are then returned to a user. When a plurality of web services is returned, the web services may form a chain in which a structured output of one web service provides a structured input for another web service.
In still another aspect, the invention comprises a method of mapping a web service having a set of one or more structured input(s) and one or more structured output(s) to a domain ontology. Them method includes identifying an input type for each of the structured input(s), searching the ontology for concepts having each input structure type and adding mappings between the structured inputs and the located concepts in the ontology, and searching the ontology for concepts having each output structure type and adding mappings between the structured outputs and the located concepts in the ontology. A concept is then added to the ontology representing the web service and adding mappings between the added concept, the structured inputs, and the structured outputs. In addition, access parameters for the web service may be added. The ontology may also include concepts and relationships derived from one or more structured data repositories.
In a further aspect, the invention is a software tool for accessing a structured data repository and a source web service having structured inputs and outputs. The tool includes a searchable ontology structure, an interface for a user to specify one or more input items and one or more output types, a search module that searches the searchable ontology for an execution path linking the specified input item(s) and output type(s), and a query module that traverses the execution path to provide output of the output type(s) that is linked to the input item(s) in the ontology. The searchable ontology structure includes concepts and relationships from a selected knowledge domain, concepts and relationships of the structured data repository, and concepts and relationships of the structured input(s) and output(s) of the web service. The concepts and relationships of the structured data repository and of the web service are linked to the concepts and relationships from the selected knowledge domain, and the execution path may include concepts from both the structured data repository and the web service. The tool may also include a code generation module that generated executable code that carries out the execution path, and/or a selection module that allows a user to select among a plurality of execution paths.



BRIEF DESCRIPTION OF THE DRAWING
The invention is described with reference to the several figures of the drawing, in which,
FIG. 1 is a generic “triple” showing the relationship conveyed in graphs shown in this document;
FIG. 2 is a domain ontology for an address domain;
FIG. 3 is a partial ontology for an address database;
FIG. 4 is a generic upper ontology for a web service;
FIG. 5 is a portion of an augmented domain ontology D+;
FIG. 6 is a generic upper ontology for accessing a web service;
FIG. 7 is an instance of the ontology of FIG. 6 for a specific web service;
FIG. 8 is a portion of an augmented domain ontology D++;
FIGS. 9, 10, 11A, and 11B show execution paths within D++; and
FIG. 12 is a flow chart for a standalone web service whose glue code may be generated by the Semantic Viewer.



DETAILED DESCRIPTION OF CERTAIN PREFERRED EMBODIMENTS
Definitions
As used herein, a “web service” is an application program (for example, a program implemented in Java or PHP on the World Wide Web) that accepts defined input(s) and returns defined output(s), and that exposes its interface, for example using Web Services Definition Language (WSDL). Example web services include the map servers found at MapQuestTM and Yahoo! MapsTM, online telephone directories such as Switchboard.comTM, and online weather services such as Weather.comTM and the National Weather Service site. While the web services discussed in the specification are available on the World Wide Web, the term “web service” is also intended to include services accessible only on internal intranets (such as an employee “facebook” or directory) or on standalone computers (such as an XML front end to a database or application program).
As used herein, a “database” or “structured data repository” is a collection of data having a formalism (i.e., structured data). Databases may be organized into “tables” of “records” having “fields” as is conventional in the art (see, e.g., Webster's New World Dictionary of Computer Terms, 4th ed., Prentice Hall, New York, 1992), or may be more loosely structured (e.g., a structured text file or a tagged file format document).
As used herein, a “triple” or “RDF triple” is a statement that conveys information about a resource, and that can be represented as a subject, a predicate, and an object. As depicted herein, a triple is graphically represented as shown in FIG. 1, wherein subject and object nodes are connected by a directional line representing the predicate. An example statement that could be represented as a triple might be “the book Moby Dick (subject) has an author (predicate) whose value is Herman Melville (object).” Subject, predicate, and object can all be identified by uniform resource identifiers (URIs), such as a uniform resource locator (URL). Predicates are generally properties of resources, while subjects and objects may be described as “concepts.”
As used herein, an “ontology graph” or simply a “graph” is a collection of related triples that together convey information about the relationships between the concepts represented by the nodes of the graph (the set of objects and subjects of the statements represented by the triples).
As used herein, an “ontology” or “domain ontology” is a dictionary of terms within a given domain of knowledge, formulated in a known syntax and with commonly accepted definitions, including relationships between the terms (e.g., in the form of triples or an ontology graph).
Semantic Web Technologies
Today, Semantic Web technologies are beginning to emerge with promises of enabling a much faster integration of applications and data (see, e.g., Gruber, “A Translation Approach to Portable Ontologies,” J. Knowledge Acquisition, 5(2):199-200, 1993; Guarino, et al., “Ontologies and Knowledge Bases: Towards a Terminological Clarification,” in Towards Very Large Knowledge Bases: Knowledge Building and Knowledge Sharing, N. Mars, ed., IOS Press, Amsterdam, 1995; Berners-Lee, et al., “The Semantic Web,” Scientific American, May 2001; and Daconta, et al., The Semantic Web: A Guide to the Future of XML, Web Services, and Knowledge Management, Wiley US, July 2003, all of which are incorporated by reference herein). However, for that to happen, Semantic Web technologies must facilitate access to large amounts of data with minimal programmer intervention. Web services must be discovered, chained, and invoked automatically, thus relieving the programmer from having to do these steps. Semantic Web standards provide a rich framework for the precise description of data and applications, thereby enabling greater automation in this end-to-end web service execution process. The World Wide Web Consortium (W3C) proposed recommendation for a standard web ontology language (OWL), (incorporated by reference herein), builds on web technologies including XML's ability to define customized tagging schemes and RDF's flexible approach to representing data.
Convergence between web services and Semantic Web technologies is beginning as illustrated by the OWL-Services (OWL-S) effort which is incorporated herein by reference). OWL-S is an effort to develop a web service ontology that could be used to describe the properties and capabilities of web services in unambiguous, computer-interpretable form.
According to the invention, such Semantic Web technologies can be used to discover execution paths spanning the retrieval of data from structured data repositories and execution of web services, to automate the integration of data repositories and web services, and to automatically generate the “glue code” needed to achieve the integration. The example described below shows how a marriage of web services and Semantic Web technologies can further automate this integration process. OWL-S represents a partial solution that can be used according to the invention to orchestrate web services. The example also illustrates how databases can be mapped into ontologies according to the invention, thus making their data available to web services.
An information system will need the capability to integrate new and existing services, e.g., application programs or web services, and incorporate additional information resources, e.g., relational databases or XML documents. In most cases application programs and web services require access to information contained within a data source. Very often the challenge for IS systems is to integrate existing data sources with application programs or web services. The use of IS ontologies and an ontology management system according to the invention can enable this type of integration by generating the integration code automatically.
The existing OWL-S web service ontology model provides features for invoking and accessing web services. However OWL-S does not address the need for web service integration and interaction with an existing database without first building a web service that abstracts the database. The invention provides a methodology to enable the integration of new web services with existing databases.
By representing databases and web services in ontology space and by linking them to the domain ontology, we can now integrate with existing databases, and other web services, without developing additional code. Using IS ontologies in this way not only results in code being generated, but also eliminates the need for creating a web service ontology with composite processes comprised of control flow constructs as defined in OWL-S.
EXAMPLES
The invention is described below with reference to particular examples such as integrating a database with a web service, and “chaining” multiple web services. However, those of ordinary skill in the art will readily see that the inventive techniques may be used in a variety of ways, including rapidly integrating pluralities of legacy databases and/or web services into new systems without a need for extensive programming, and selecting appropriate web services from within an ontology without a need for user familiarity with the available web services. Further, the invention may be used not only with an “ontology viewer” to process individual user queries, but may also be used to construct custom Information System (IS):web/database services that access underlying databases and web services as needed to process queries.
The following example shows how an address database and a map-finding web service (e.g., the map services available at MapQuestTM and Yahoo!TM) may be integrated according to the invention, by performing the following steps:

    
    
        Provide a domain ontology
        Create and link a database component ontology to the domain ontology
        Create and link a web service component ontology to the domain ontology
        Broker a user request to suggest executable paths
        Manually view the result of implementing one of the executable paths through the augmented ontology or automatically generate a web service to do so
    
    


The domain ontology, D, includes the RDF classes Business, Customer, Name, Location, Street, CityOrTown, State, and PostalZIP. D is represented as a uniform structure of triples, {subject, relationship, object}, as shown in Table 1. This ontology may also be represented graphically, as shown in FIG. 2. (Note that the domain ontology may include other classes and relationships; for simplicity, only seven triples from the ontology are shown).









TABLE 1









D::{Business, sellsTo, Customer}



D::{Customer, doesBusinessAs, Name}



D::{Customer, residesAt, Location}



D::{Location, hasA, Street}



D::{Location, hasA, CityOrTown}



D::{Location, hasA, State}



D::{Location, hasA, PostalZIP}










sellsTo, doesBusinessAs, and residesAt are OWL object properties, and hasA is an OWL datatype property with domain rdf:Class and range datatype string. As shown, this domain ontology is manually created, typically by experts in the business domain to which it pertains. It may be possible to automatically create useful domain ontologies using artificial intelligence techniques or other methods; such ontologies may also be used according to the invention.

A database ontology R is then constructed for linking to the domain ontology D to form an augmented ontology D+. R is the conjunction of a database upper ontology RU specifying the structure, algebra, and constraints of the database, and a database lower ontology RL including the data as instances of RU, as follows.
The upper ontology RU specifies the structure, algebra and constraints of any relational databases in RDF/OWL triples. We define the RDF classes Database, Relation, Attribute, PrimaryKey and ForeignKey. A portion of RU is given in Table 2:









TABLE 2









RU::{Database, hasRelation, Relation}



RU::{Relation, hasAttribute, Attribute}



RU::{PrimaryKey, subClassOf, Attribute}



RU::{ForeignKey, subClassOf, Attribute}










where hasRelation and hasAttribute are OWL object properties, and subClassOf is defined in the RDF schema.

Consider a database having a table ADDRESS as depicted in Table 3. (For brevity, only two of the data records are shown). The relation ADDRESS has Address_ID as the primary key, and Name, Street, City, State, and Zip as attributes. The portion of RL corresponding to this table may then be constructed (in part) as shown in Table 4.












TABLE 3





Address_ID
Name
Street
City
State
Zip







.
.
.
.
.
.


.
.
.
.
.
.


.
.
.
.
.
.


001
The MITRE
202 Burlington
Bedford
MA
01730



Corporation
Road


002
XYZ, Inc.
255 North Road
Chelms-
MA
01824





ford


.
.
.
.
.
.


.
.
.
.
.
.


.
.
.
.
.
.


















TABLE 4









RL::{Address, isInstanceOf, Relation}



RL::{Address, hasAttribute, AddressI_D}



RL::{Address, hasAttribute, Street}



RL::{Address, hasAttribute, Name}



RL::{Address, hasAttribute, Zip}



RL::{Name, isInstanceOf, Attribute}



RL::{Street, isInstanceOf, Attribute}



RL::{Zip, isInstanceOf, Attribute}



RL::{Address_ID, isInstanceOf, PrimaryKey}










R is then the conjunction of RU and RL as partially shown in FIG. 3 (Note that the fields “City” and “State” have not been shown in R for the sake of brevity, but are linked to the concepts “CityOrTown” and “State” in D in a manner analogous to that shown for “Street” and “Zip” below). If there are entity relationships not captured in the R, these may be inserted manually at this stage.
The concepts in database ontology R are then mapped to the concepts in the domain ontology D to create an augmented domain ontology D+. In this example, this is done using the relationship hasSource, as shown in Table 5. (Note that the linked concepts need not have identical names, as in the mapping between D::PostalZIP and R::Zip).









TABLE 5









D+::{D::Name, hasSource, R::Name}



D+::{D::Street, hasSource, R::Street}



D+::{D::PostalZIP, hasSource, R::Zip}










The map-finding web service is then mapped to an upper ontology WU that models web services as concepts of Inputs (in Parameters), Output, Classification Conditions, and Effects, as shown in FIG. 4. An instance of this ontology, WI, is created for the map-generation web service of the example. This ontology is then mapped to D+ to form augmented ontology D++, for example using the relationship isInputTo, e.g. D++:: {D+::Location, is InputTo, WI::MapQuest}. A portion of D++, showing a link between WI and D+, is shown in FIG. 5.
For automatic code generation, in addition to the ontological representation of the inputs and outputs of the web service, access parameters for the web service may be needed. A generic upper ontology, VU, that models how to access and invoke a web service is shown in FIG. 6. VU also preserves the structure of any document consumed or produced by the web service. An instance of this ontology, WM, is created to describe the parameters for invoking the web service. As shown in FIG. 7, WM shows parameters for invoking MapQuestTM. (For clarity in the drawing, the URL for MapQuestTM, is represented as [URL Val]). WM is then mapped into D++, for example using the relationships isValueOf, isServedAt, and hasResult. The isValueOf links the range or object value of the hasLabel relationship in the ontology WM to concepts in the augmented domain ontology D++. The isServedAt relationship links the subject or domain of the hasOutput relationships in the D++ ontology to the object of the hasUrl relationship in the WM. The hasResult relationship links the range of hasLabel relationship in the WM to the range of hasOutput relationship in the ontology D++. This relationship is useful when the output of the web service contains the inputs of another, as further discussed below. A portion of D++ including WM and WI is shown in FIG. 8, illustrating the links between the web service ontologies and the domain ontology.
Once the ontology D++ has been created, a single application (hereinafter, the “Semantic Viewer”) can broker a variety of user requests to return data outputs and/or executable glue code. As implemented in this example, the Semantic Viewer is a web-enabled application. When a user enters any input data, it is linked to concepts in the augmented domain ontology using the userInput, userOutput, and userCriteria relationships. The userOutput links a goal the user is interested in a concept in the augmented domain ontology. The userInput links the user's input to the object value of the in Parameter relationship that are not input to web services in the augmented domain ontology. The userCriteria is used to link user's input to concepts in the augmented domain ontology.
For example, suppose a user provides “255 North Road” and “01824” as inputs, and “map” as a requested output. The Semantic Viewer searches D++ for matches to the input values, and locates them in RL as a Street and a Zipcode, respectively. In addition, it searches for “map” and locates it as a concept in WI. It then locates a path through the ontology graph linking the inputs with the output, as shown in FIG. 9. Finally, it generates executable glue code to actually invoke the web service discovered (in this case, MapQuestTM) and return a map of the requested address.
The above example user inputs are the same as what would be required if the user were simply to visit MapQuestTM and request the map directly, although the user does not have to know how to access MapQuestTM in order to use the Semantic Viewer as described in this example. If multiple map services were available, the Semantic Viewer would present the user with multiple execution paths, allowing access to whichever map service was desired, again without requiring the user to know the URL or data formatting requirements of each service.
The additional power of the Semantic Viewer can be seen if the user instead enters “MITRE” as an input, and “map” as a requested output. No available web service in D++ takes a corporate name and returns a map. However, the Semantic Viewer still locates “MITRE” in the database as an instance of Business_Name, and discovers a path through the ontology graph linking it to the Map output of MapQuestTM, as shown in FIG. 10. Thus, the execution path returned now includes a database query to discover the street address of the MITRE Corporation, formats that data for the MapQuestTM map service, and returns a map of the company location.
In practice, the Semantic Viewer may find multiple execution paths for a single query. In this case, the user may be presented with the multiple execution paths and allowed to select the desired path. For example, in the case where a user enters a single input of “01730” and a desired output of “map,” there are two possible connecting paths through the D++ described above. According to one path, illustrated in FIG. 11a, the Semantic Viewer recognizes “01730” as a zip code, and passes it to MapQuestTM without a street address, resulting in a map of the general area around that zip code (the recognition of “01730” as a zip code according to this path may be through its existence in the database, but it is also within the scope of the invention to manually indicate that 01730 is a zip code in order for the Semantic Viewer to discover an execution path). However, there also exists a path, illustrated in FIG. 11b, in which the Semantic Viewer finds each instance of “01730” in the database, and passes each Street Address/Zipcode combination (for each listed business having that zip code) to MapQuestTM, obtaining maps for every business in the selected zip code area.
In the above examples, a single output of a single web service has been the desired output. However, multiple outputs may also be requested, and these outputs may not all be derived from the same web service. For example, suppose a user enters a single input of “01730” and desired outputs of “map” and “business name.” In this case, an execution path similar to the second path described in the previous paragraph exists. The Semantic Viewer recognizes 01730 as a zip code, and queries the database to find all of the businesses in that zip code, requesting both the business name and the street address. The street addresses and the selected zip code are passed to MapQuestTM, and the resulting maps are returned along with the business names, for each business in the database that matches the criteria.
The Semantic Viewer may also “chain” web services as necessary to obtain a desired result. For example, suppose the domain ontology also contains the relationships hasVoiceNumber and hasFaxNumber, and has been further augmented to include a reverse lookup telephone service (such as that found at SwitchboardTM), which accepts an input “telephone number” and provides a listing name and address. In this case, when a user enters “781-271-2000” as input and “map” as output, one of the returned execution paths will include taking the telephone number from the database listing, passing it to the reverse lookup service to obtain a street address, and passing the street address to MapQuestTM to obtain the requested map.
Similarly, web services may operate in parallel on the same or related inputs to provide multiple outputs. For example, web services that provide maps (as discussed above) and aerial photos (such as that found at TerraServer-USA) may both be called with the same address information, if an address is input and both “map” and “photo” are selected as outputs.
For each of the above-described examples, the Semantic Viewer has located an execution path, and then performed the necessary steps to answer a user query. However, the execution path may also be used to generate glue code necessary to create a new service of the type requested. For example, in the case described above in which a user provided the input “MITRE” and the output “map,” in addition to simply providing a map of the MITRE location, the Semantic Viewer can also return executable “glue code” for a service that accepts a company name, looks it up in the database to find a street address, passes the street address to MapQuestTM, and returns the requested map. This static code can then be directly used to create a new standalone web service which is independent of the Semantic Viewer. A flow chart of the resulting web service, including exemplary pseudocode describing the construction of a SQL database query and a web service URL, is shown in FIG. 12. Of course, the code generated will depend on the specific requirements of the database and web service. Further the database type and query syntax may be represented in ontological form and linked to the R in an analogous way to the construction of WM for accessing the web service, as discussed above.
Other embodiments of the invention will be apparent to those skilled in the art from a consideration of the specification or practice of the invention disclosed herein. It is intended that the specification and examples be considered as exemplary only, with the true scope and spirit of the invention being indicated by the following claims.

## Claims

1. A method of generating executable code for linking data in a relational database to structured inputs and outputs of a source web service, comprising:
providing a first ontology describing concepts and relationships of the data in the database and organized according to the structure of the database;
linking the first ontology to a second ontology that describes concepts and relationships of the structured inputs and outputs of the source web service to provide a merged ontology, the merged ontology including both the concepts and relationships of the database and the concepts and relationships of the source web service;
mapping the data in the database and the structured inputs and outputs of the source web service to the merged ontology to create an expanded ontology;
searching the expanded ontology for an execution path between one or more desired inputs and one or more corresponding desired outputs through concepts of the expanded ontology originating in the first ontology and the second ontology;
generating executable code that accepts the one or more desired inputs, obtains a set of data from the database corresponding to the one or more desired inputs and responsive to the structured inputs of the source web service, and executes steps of the execution path of the expanded ontology to invoke the source web service using the set of data from the database to produce the corresponding desired outputs; and
using the generated executable code to create a new web service that accepts the one or more desired inputs and that produces the desired outputs.

2. The method of claim 1, wherein said mapping step comprises:
mapping the data in the database to the first ontology to create a first set of mappings;
mapping the structured inputs and outputs of the source web service to the second ontology to create a second set of mappings; and
transferring the first set of mappings and the second set of mappings to the merged ontology.

3. The method of claim 1, wherein the second ontology further comprises access parameters for the source web service.

4. The method of claim 1, wherein the execution path includes at least one concept from the first ontology and at least one concept from the second ontology.

5. The method of claim 1, further comprising providing the second ontology.

6. The method of claim 1, further comprising generating the second ontology.

7. The method of claim 1, wherein the providing step comprises:
constructing a database ontology that describes one or more of (i) a structure of the database, (ii) an algebra of the database, (iii) constraints of the database, and (iv) schema and instances of data within the database; and
linking the database ontology and a third ontology that includes concepts and relationships relevant to the data within the database to form the first ontology.

8. The method of claim 1, wherein providing the first ontology describing concepts and relationships of the data in the database comprises:
providing an upper ontology specifying the structure, algebra, and constraints of the database; and
providing a lower ontology including the data in the database as instances of the upper ontology.

9. A method for constructing a web service that provides a selected output type in response to a selected input, comprising:
accepting an input item from a user;
accepting an output type from the user;
searching an ontology to find one or more input matches for the input item, the ontology comprising data from a database organized according to the structure of the database, and structured input and output information from a web service;
searching the ontology to find one or more output matches for the output type;
searching the ontology to identify an execution path between at least one of the one or more input matches and at least one of the one or more output matches through concepts of the ontology originating in the database and the web service;
generating executable code for a new web service that allows a user to provide an input of a type corresponding to the accepted input item, obtains a set of data from the database corresponding to the one or more desired inputs and responsive to the structured input information from the web service, and that provides an output of the accepted output type by executing steps of the execution path of the ontology comprising data from the database and structured input and output information from the web service to invoke the web service using the set of data from the database to produce the output of the accepted output type; and
creating the new web service using the executable code.

10. The method of claim 9, wherein searching the ontology to find an execution path comprises finding a plurality of execution paths.

11. The method of claim 10, further comprising allowing the user to select an execution path from the plurality of execution paths.

12. The method of claim 9, wherein searching the ontology to find one or more input matches comprises allowing the user to select from a plurality of input matches within the ontology.

13. The method of claim 9, wherein searching the ontology to find one or more output matches comprises allowing the user to select from a plurality of output matches within the ontology.

14. The method of claim 9, wherein the execution path includes at least one concept from the database and at least one concept from the structured input and output information from the web service.

15. A method of mapping a web service having a set of one or more structured inputs and a set of one or more structured outputs to an ontology, the method comprising:
searching the ontology to locate concepts within the ontology having an output type corresponding to a structured input of the web service, the ontology comprising concepts and relationships of data from a database organized according to the structure of the database;
adding mappings between the structured inputs and the located concepts having the output type corresponding to the structured input of the web service to the ontology;
searching the ontology to locate concepts within the ontology having an input type corresponding to a structured output of the web service;
adding mappings between the structured outputs and the located concepts having the input type corresponding to the structured output of the web service to the ontology; and
adding a concept to the ontology representing the web service with mappings between the added concept, the structured inputs, and the structured outputs in order to create an augmented ontology comprising at least one path through a concept of the ontology, the concept of the ontology corresponding to a set of data from the database selected based on a desired input and responsive to the structured input of the web service, and the concept representing the web service invoked using the set of data from the database to produce a desired output.

16. The method of claim 15, further comprising adding a concept to the ontology representing a method of accessing the web service.

17. A method of linking a collection of structured data in a relational database to a source web service, comprising:
generating a first ontology describing concepts and relationships of the data in the database and organized according to the structure of the database;
providing a second ontology describing concepts and relationships in structured inputs and outputs of the source web service;
linking the first and second ontologies to provide a merged ontology including both the concepts and relationships of the database and the concepts and relationships of the source web service, the merged ontology comprising at least one path through the first ontology and the second ontology originating from a concept of the first ontology corresponding to a set of data from the database derived from a desired input, and invoking the source web service using the set of data from the data base to produce a desired output; and
mapping (i) the data in the collection to the merged ontology and (ii) the structured inputs and outputs from the source web service to the merged ontology to create an expanded ontology.

18. The method of claim 17, wherein the generating step comprises:
constructing an intermediate ontology that describes one or more of (i) a structure of the collection of structured data, (ii) an algebra of the collection of structured data, (iii) constraints of the collection of structured data, and (iv) schema and instances of data within the collection of structured data; and
linking the intermediate ontology and a third ontology that includes concepts and relationships relevant to the data within the collection of structured data to form the first ontology.

19. The method of claim 17, further comprising
searching the expanded ontology for an execution path between an input to the web service and an output;
generating executable code that accepts the one or more specified inputs and executes steps of the execution path to produce the specified outputs; and
using the generated executable code to create a new web service that accepts the one or more specified inputs and that produces the specified outputs.

20. A system for linking a collection of structured data in a relational database to a source web service, comprising:
a memory storing:
a generating module to generate a first ontology describing concepts and relationships of the data in the database and organized according to the structure of the database;
a providing module to provide a second ontology describing concepts and relationships in structured inputs and outputs of the source web service;
a linking module to link the first and second ontologies to provide a merged ontology including both the concepts and relationships of the database and the concepts and relationships of the source web service, the merged ontology comprising at least one path through the first ontology and the second ontology originating from a concept of the first ontology corresponding to a set of data from the database derived from a desired input and invoking the source web service using the set of data from the database to produce a desired output; and
a mapping module to map (i) the data in the collection to the merged ontology and (ii) the structured inputs and outputs from the source web service to the merged ontology to create an expanded ontology; and

one or more processors configured to process the modules.

21. A computer-readable storage medium having computer program code recorded thereon that, when executed by a processor, causes the processor to perform a method for linking a collection of structured data in a relational database to a source web service, the method comprising:
generating a first ontology describing concepts and relationships of the data in the database and organized according to the structure of the database;
providing a second ontology describing concepts and relationships in structured inputs and outputs of the source web service;
linking the first and second ontologies to provide a merged ontology including both the concepts and relationships of the database and the concepts and relationships of the source web service, the merged ontology comprising at least one path through the first ontology and the second ontology originating from a concept of the first ontology corresponding to a set of data from the database derived from a desired input, and invoking the source web service using the set of data from the database to produce a desired output; and
mapping (i) the data in the collection to the merged ontology and (ii) the structured inputs and outputs from the source web service to the merged ontology to create an expanded ontology.