OBO-Edit:SQL Database Adapters

From GO Wiki
Jump to: navigation, search




* @author cjm
* Relational Database Adapter for any Schema that implements the OBD SQL API
* Status of OBD API, per schema
*   OBD: partially implemented
*   Chado: No
*   GODB: No
*   BioSQL: No
* The OBD SQL API consists of a schema-neutral
*  (a) a view layer; and
*  (b) SQL functions, such as store_node(...)
* This API can be implemented on a per schema / DBMS vendor basis
* The SQL API route was the most economical for us to implement, and
* it has many benefits. Those with a pathological aversion to DBMS logic
* can override methods in this adapter and implement the update logic in java
* (this may also turn out to be more efficient)
* See the obo-database svn repository on obo.sourceforge.net for the OBD API
* 		obo-database/sql/api/obd-mutable-api
* Note that this adapter is for both ontologies and annotations;
* Schema implementations may choose to implement store_annotation()
* in any way they choose
* Currently this adapter is incomplete
*   Reads: No
*   Writes: Partial
*   Filters on read: unimplemented
*   Filters on write: unimplemented
*   Lazy read: unimplemented
* At some point in the future there will be a LinkDatabase implementation;
* this will bring various advantages:
*  - using a RDBMS as a reasoner
*  - using MergedLinkDatabase to wrap multiple sources

See also