We're Hiring!

Accesing OMERO database using query language

Having a problem deploying OMERO? Please ask new questions at https://forum.image.sc/tags/omero
Please note:
Historical discussions about OMERO. Please look for and ask new questions at https://forum.image.sc/tags/omero

The OMERO.server installation documentation begins here and you can find OMERO.web deployment documentation here.

Accesing OMERO database using query language

Postby shaneklumpp » Mon Aug 22, 2016 4:06 pm

I am exploring how to access data in OMERO directly from the underlying database using a query language (e.g. SQL).

Is there a best practice for this?

Also, is the OMERO database schema documented somewhere, and how could I find this?

Thanks
shaneklumpp
 
Posts: 38
Joined: Tue Aug 16, 2016 10:07 pm

Re: Accesing OMERO database using query language

Postby atarkowska » Mon Aug 22, 2016 6:50 pm

Hi,

OMERO API supports two principle ways of querying OMERO and retrieving the objects. You can write SQL-like queries using the query service (uses “HQL”) or you can use one of the other services that already has suitable queries. Using the query service is very flexible but it requires detailed knowledge of the OMERO model and is susceptible to any change in the model.
For more details please follow the http://www.openmicroscopy.org/site/supp ... arted.html

Depends on your programming language preferences you can find relevant training examples in our github repository https://github.com/openmicroscopy/openm ... s/Training

I hope that will help.

Please do not hesitate to ask more specific questions.

Ola
atarkowska
 
Posts: 327
Joined: Mon May 18, 2009 12:44 pm


Return to Installation and Deployment

Who is online

Users browsing this forum: No registered users and 1 guest