MONDRIAN: Annotating and Querying Databases through Colors and Blocks

Geerts, Floris; Kementsietsidis, Anastasios; Milano, Diego

doi:10.1109/icde.2006.102

Cited by 82 publications

(89 citation statements)

References 16 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…The expressiveness of our algebra goes well beyond the query capabilities of similar systems like, for example, DBNotes [5]. The algebra is simple and intuitive and is able to express all the queries mentioned earlier, and many more (see [1] for the full syntax and examples). For example, query q 1 below retrieves all the tuples that are annotated by either John or Mary, while query q 2 only retrieves tuples that have a gene-protein sequence (gid, sid) annotated pair.…”

Section: Introductionmentioning

confidence: 96%

“…A visually expressed query is translated to a query written in the MONDRIAN query algebra and this is subsequently translated to SQL and is executed over the underlying RDBMS. One advantage of MONDRIAN queries is that they are storage-model independent [1]. That is, MONDRIAN queries are at a level of abstraction that is independent of the chosen representation of annotations.…”

Section: System Architecturementioning

confidence: 99%

“…The demo also illustrates how MONDRIAN supports alternative annotation semantics [1]. For example, we discuss annotation (non-)inheritance a property that, given an annotation over a set of values, it determines whether, or not, any subset of these values also inherits the annotation.…”

Section: Demonstrated Functionalitymentioning

confidence: 99%

“…Another distinguishing feature of MONDRIAN is the ability to query annotations and values alike. MONDRIAN offers an annotation-aware query algebra which we have shown to be both complete (it can express all possible queries over the class of annotated databases) and minimal (all the algebra operators are primitive) [1]. The expressiveness of our algebra goes well beyond the query capabilities of similar systems like, for example, DBNotes [5].…”

Section: Introductionmentioning

confidence: 99%

“…Our work in the MONDRIAN 4 annotation management system [1] is motivated by the pressing needs of biologists, some of which are highlighted by the following example. Consider the relation in Figure 1 which lists triples of identifiers belonging to three distinct biological databases.…”

Section: Introductionmentioning

confidence: 99%

See 4 more Smart Citations

iMONDRIAN: A Visual Tool to Annotate and Query Scientific Databases

Geerts

Kementsietsidis

Milano

2006

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Abstract. We demonstrate iMONDRIAN, a component of the MONDRIAN annotation management system. Distinguishing features of MONDRIAN are (i) the ability to annotate sets of values (ii) the annotation-aware query algebra. On top of that, iMONDRIAN offers an intuitive visual interface to annotate and query scientific databases. In this demonstration, we consider Gene Ontology (GO), a publicly available biological database. Using this database we show (i) the creation of annotations through the visual interface (ii) the ability to visually build complex, annotationaware, queries (iii) the basic functionality for tracking annotation provenance. Our demonstration also provides a cheat window which shows the system internals and how visual queries are translated to annotation-aware algebra queries.

show abstract

Section: Introductionmentioning

confidence: 96%

Section: System Architecturementioning

confidence: 99%

Section: Demonstrated Functionalitymentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

See 3 more Smart Citations

iMONDRIAN: A Visual Tool to Annotate and Query Scientific Databases

Geerts

Kementsietsidis

Milano

2006

Lecture Notes in Computer Science

View full text Add to dashboard Cite

show abstract

Design and Development of a Model for Generating and Exploiting Annotation in the Context of Economic Intelligence

Okunoye¹,

Uwadia²

2013

Competitive Intelligence and Decision Problems

View full text Add to dashboard Cite

AstroDAS: Sharing Assertions Across Astronomy Catalogues Through Distributed Annotation

Bose

Mann

Prina-Ricotti

2006

Provenance and Annotation of Data

View full text Add to dashboard Cite

Abstract. As diverse scientific data collections migrate online, researchers want the ability to share their assertions regarding the entities that span these disparate databases. We focus on a case study provided by the astronomical community's Virtual Observatory effort to investigate the use of annotation to record and share the celestial object mappings asserted by different research groups. The prototype for our Astronomy Distributed Annotation System (AstroDAS) complements the existing OpenSkyQuery tools for federated database queries, and provides web service methods to allow clients to create and store mapping annotations as relational database tuples on annotation servers. We expect the mechanisms for creating and querying annotations in AstroDAS can be extended to assist with tasks other than entity mapping, in other domains with relational data sources.

show abstract

MONDRIAN: Annotating and Querying Databases through Colors and Blocks

Abstract: Abstract

Cited by 82 publications

References 16 publications

iMONDRIAN: A Visual Tool to Annotate and Query Scientific Databases

iMONDRIAN: A Visual Tool to Annotate and Query Scientific Databases

Design and Development of a Model for Generating and Exploiting Annotation in the Context of Economic Intelligence

AstroDAS: Sharing Assertions Across Astronomy Catalogues Through Distributed Annotation

Contact Info

Product

Resources

About