Converting Unigene datasource to a relational format, enalbe to be loaded/ and accessed from a federated database system.
Original Publication Date: 2002-Oct-17
Included in the Prior Art Database: 2003-Jun-21
At present Unigene datasource is not accesseble by any relational database engine. By converting the datasource in to a relational model, and creating a relational schema for the Unigene data, now it can be quiried using standard SQL interfaces. Providing a SQL interface capability to this datasource opens up this source to many relational search engines. Also it enables the users to do more complex queries on the Unigene datasource. Implemented as a prototype for IBM Discovery_Link/DB2 product on 05-15-2002. The Schema developed for this relation model is given here. There are thirteen organisms covered so far in Unigene database. The schema differs between the species in some tables. Wherever the differences are they were identified in the parantheses. Unigene Animals: 1. Anopheles gambiae (Aga)