OBO-Edit:SQL Database Adapters

From GO Wiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Location

Documentation

/**

* @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