Table 2

Example BioWarehouse operations, implemented as SQL, and as operations in the Java utilities.

Example

SQL

Java


Create a new entry in the Protein table and add a comment for it in the CommentTable.

// Obtain a new WID SELECT WID_sequence.NextVal FROM dual INSERT INTO Protein (WID, Name, AASequence, DataSetWID) VALUES ('5', 'Sample Name', 'XXX', '2');

INSERT INTO CommentTable (OtherWID, Comm) VALUES ('5', 'Tester"s comment');

// A new WID is automatically obtained by the Protein class

Protein protein = new Protein (2); protein. setName("Sample Name"); protein. set AASequence("XXX"); protein. addComment ("Tester's comment"); protein. storeQ;

Retrieve an existing entry in the Protein table and alter some of its data.

SELECT * FROM Protein WHERE WID = '5'; UPDATE Protein SET Name = 'New Name' WHERE WID = '5';

Protein protein = new Protein (2, 5); protein. load(); protein. setName("New Name""); protein. update();

Delete the Protein entry.

DELETE FROM Protein WHERE WID = '5';

Protein protein = new Protein (2, 5); Protein. delete ();


Lee et al. BMC Bioinformatics 2006 7:170   doi:10.1186/1471-2105-7-170

Open Data