Fig 5 - uploaded by Ahmet Soylu
Content may be subject to copyright.
Source publication
Data access in an enterprise setting is a determining factor for value creation processes, such as sense-making, decision-making, and intelligence analysis. Particularly, in an enterprise setting, intuitive data access tools that directly engage domain experts with data could substantially increase competitiveness and profitability. In this respect...
Contexts in source publication
Context 1
... query generated by OptiqueVQS has a graph pattern represented by a set of triple patterns, where each triple pattern is a tuple t ∈ V ar ×U ×(U ∪V ar ∪L) and V ar is an infinite set of variables. An example SPARQL graph pattern is depicted in Figure 5 for the query example presented in Figure 3 and Figure 4. The state of an edited query is composed of a partial graph pattern and a cursor position (cf. ...
Context 2
... the SPARQL graph pattern given in Figure 5 to the visual representation given in Figure 3, it can be seen that the concept-nodes, variable-nodes referring to literals, and literal-nodes are omitted along with the edges connecting them; and variable-nodes only represent individuals. The type information, output form, and constraints on attributes are embedded into each corresponding variable-node. ...
Citations
... We postulate that one of the tables in a primal join is crucial with respect to the query, as it identifies the semantic entity or (principal) concept (Soylu et al., 2016) in which the user is interested. This principal concept is similar to what Benzi et al. (1996) refer to as a viewpoint, to which we will return shortly. ...
... The expressive power of a VQS is intentionally less expressive than a formal language (Soylu et al., 2016) and may be considered adequate when it meets the needs of its users. Select-project-join queries, which possess the same expressive power as conjunctive queries (Schweikardt et al., 2010), play an important role in most queries. ...
The aim of this work was to develop a technique to speed up complex joins in an incremental visual query system. When designing a visual, highly interactive interface for ad-hoc (read-only) queries, fast response times are of paramount importance. While a column-oriented DBMS reduces the inherent latency found in relational DBMS, there is still the question of how to index the data, especially so as to support complex joins. Equi-joins that involve a many-to-many relationship are an example of complex joins that arise frequently and whose efficient processing is essential for fast query processing. We present OVI-3, a NoSQL visual query system based on incremental querying that uses a simple directory-based indexing scheme for faster processing of such complex joins. The system has been piloted using real data from a student database at Aalto University. The results demonstrated that for certain complex joins the presented indexing scheme outperforms SQL queries from a data server, especially for queries involving anti-joins (negation), where OVI-3 provided an orders of magnitude speed improvement.
... One of the tables in the just mentioned primal join is crucial with respect to the query, as it identifies the semantic entity or (principal) concept (Soylu et al, 2016) that the user is after. This principal concept is similar to what Benzi et al (1996) refer to as a viewpoint, to which we will return shortly. ...
... The expressive power of a VQS is intentionally less expressive than a formal language (Soylu et al, 2016) and may be considered adequate when it meets the needs of its users. Select-project-join queries, which possess the same expressive power as conjunctive queries (Schweikardt et al, 2010), play an important role in most queries. ...
The aim of this work was to develop a technique to speed up complexjoins in an incrementally based visual query system or VQS.When designing a visual, highly interactive interface for ad-hoc (readonly)queries, fast response times are of paramount importance. Whilea column-oriented DBMS reduces the inherent latency found in relationalDBMS, there is still the question as how to index the data,especially with regard to complex joins. Equi-joins that involve amany-to-many (M:N) relationship are an example of complex joinsthat arise often and their efficient processing is essential for fastquery processing. For brevity, we refer to such joins as M:N joins.We present OVI-3, a NoSQL visual query system (VQS) basedon incremental querying that uses a simple directory-based indexingscheme for fast M:N joins. OVI-3 acted as a testbed using realdata from the student database at Aalto University. The resultsshowed that the presented indexing scheme for M:N joins can outperformSQL queries from a data server, especially for queries involvinganti-joins (negation), where OVI-3 was orders of magnitude faster.
... Optique VQS Source : Tiré de Optique VQS, même s'il ne ressemble visuellement pas au CRV-HQ, lui est très similaire dans son principe de fonctionnement. Il permet l'exploration des données par leur schéma, ce qui permet, selon eux, à l'utilisateur de mieux comprendre les connaissances du domaine que par une exploration à partir des individus(Soylu, Giese, Jimenez-Ruiz, Vega-Gorgojo, & Horrocks, 2016). Une première fenêtre présente un graphe des classes à l'utilisateur qui peut incrémentalement ajouter d'autres classes grâce aux relations d'association qui sont présentées dans une deuxième fenêtre. ...
This thesis presents three applications that have been designed, developed and deployed in real
use cases for Hydro-Quebec, the Quebec provincial producer, carrier and supplier of
electricity. These applications were created in such a way as to exhibit properties of selfadaptability to the evolution of knowledge of the company. The objective of this applied
research was to assess the feasibility of using semantic web technologies to create such web
applications that are usable by novice users.
The development of these three applications resulted in contributions specific to each of them.
The first application is a textual semantic browser and it has demonstrated that it is possible to
achieve conceptual independence thanks to semantic web technologies. The second application
is a SPARQL visual query builder. Its development has mainly enabled the exploration of the
transposition of functionalities associated with the construction of SQL queries to the SPARQL
language. The third application is a view builder taking advantage of the lessons learned during
the realization of the two previous applications. The contributions associated with this
application include: 1. A unique software component for ontological exploration; 2. A list of
ontological modeling recommendations allowing models to be used by applications applying
this methodology; 3. A visualization ontology which is a first attempt towards the creation of
a standard in order to guide and personalize user interfaces by annotations made within domain
ontologies; 4. A set of pre-inferences allowing reconciliation of the concept of inheritance in
object-oriented paradigms with the concept of classification of the paradigm of first-order
logic; and 5. An approach for crossing data from OWL ontologies in an ad hoc manner.
The experiments presented in this thesis made it possible to develop a methodology to generate
self-adaptive applications maneuverable by neophytes, thus filling a gap in the literature. The
feasibility of such an approach has been proven by the release of the third application,
generated using this methodology, into the company's systems. This research suggests that
such applications could lead to reduced software development and maintenance costs. In
addition, the genericity and self-adaptability of the tools developed make this approach a prime
candidate for the development of Industry 4.0 applications.
... Visual query composition paradigm (cf. [1], [2], [3], [4], [5]) along with facet-based ( [6], [7]) and controlled natural language based ( [8]) approaches is a promising venue enabling end-user involvement in query composition over SPARQL endpoints (cf. [1]). ...
... [1], [2], [3], [4], [5]) along with facet-based ( [6], [7]) and controlled natural language based ( [8]) approaches is a promising venue enabling end-user involvement in query composition over SPARQL endpoints (cf. [1]). Since the visual query composition is based on creating query patterns from the data classes and their connecting properties, the a priori knowledge of the schema of the data to be queried is helpful to support the query construction. ...
We present the option to use the schema-based visual query tool ViziQuer over realistic Linked Data endpoints. We describe the tool meta-schema structure and the means for the endpoint schema retrieval both from an OWL ontology and from a SPARQL endpoint. We report on a store of the endpoint-specific schemas and the options to support the schema presentation to the end-user both as a class tree within the environment and as external visual diagram.
... Furthermore, many of these tools offer limited support for exploration tasks; this is the case of Linked Data browsers such as LodView 1 that present the results of dereferencing URIs in a tabular form and allow link traversal, but do not provide any overview of the dataset nor class navigation. Another important category of visual approaches over RDF data include visual query tools such as PepeSearch [11], Op-tiqueVQS [12], and SemFacet [13]; they are specifically purposed for data querying, but all these tools require a non-trivial installation/deployment and are not able to cope with large datasets containing tens of millions of triples or even more. ...
... The majority of visual query editors are graphbased, exploiting the fact that RDF data can be represented as a graph. The SPARQL syntax is quite apparent in graph-based editors like iSPARQL 3 or LuposDate [17], while approaches like NITELIGHT [18], OptiqueVQS [12], or QueryVOWL [19] do a better job hiding the intricacies of SPARQL. However, [10] criticizes the use of graphbased interfaces as the default representation for RDF data -the authors denote "the pathetic fallacy of RDF" to assert that because the data model is a graph, the data should therefore be displayed as a graph. ...
Linked Data exploration is an essential task in the process of understanding, assessing, and using datasets made available in the Resource Description Framework (RDF) format. Current solutions for exploration of RDF data are mainly targeted at Semantic Web experts, require non-trivial deployments, and do not scale to the increasing amounts of data published in RDF. The lack of simple, intuitive, and efficient solutions for exploring RDF data, especially for lay users, is the main motivation behind the work presented in this paper. We propose RDF Surveyor, an easy-to-use and lightweight tool for exploring RDF datasets. Its visual interface hides the intricacies of SemanticWeb technologies from the user, while providing intuitive overviews of datasets, class navigation, and visualization of class instances. Furthermore, RDF Surveyor does not require any installation and can handle large datasets such as DBpedia. We provide a detailed overview of RDF Surveyor and illustrate its capabilities in two different scenarios. We also analyze the uptake, performance and usability of RDF Surveyor, showing its suitability for exploring Linked Data at scale.
... black shoes from a small company based in a democratic country). Examples of VQSs designed for RDF data are Rhizomer [3], SemFacet [1], and OptiqueVQS [24]. ...
... It allows users to navigate the conceptual space and each traversal from a class to another adds a typed variable-node and object property connecting it to the query graph. OptiqueVQS was deployed and evaluated in different use cases, including Siemens' case for sensor data [25,10], Statoil's case for oil and gas [27,9], and on generic datasets [24]. In Figure 5, there is an example query asking for all trains with a turbine named "Bearing Assembly" and their journal bearing temperature readings in the associated generator. ...
Ontology-based visual query formulation is a viable alternative to tex-tual query editors in the Semantic Web domain for extracting data from structured data sources in terms of the skills and knowledge required. A visual query system is at any moment responsible for providing the user with query extension suggestions ; however, suggestions leading to empty results are often not useful. To this end, in this article, we first present an approach for projecting OWL 2 ontologies into navigation graphs to be used for query formulation and then a solution where an efficient finite index is used to calculate non-ranked approximated extension suggestions for ontology-based visual query systems using navigation graphs. The results of our experiments suggest that one can efficiently project an ontology into a navigation graph, query it for running an interactive user interface, and suggest query extensions that do not lead to dead-ends.
... The XML schema is a language schema that W3C developed using the XML syntax, and it describes the structure and format of all documents written in XML (Robson & Boray, 2015;Soylu, Giese, Jimenez-ruiz, Vega-gorgojo, & Horrocks, 2016). From a technical perspective, the XML syntax has rich capabilities that render one of the commonly used formats for web data. ...
... Instead, the platform manages the ontology and mappings, giving the illusion of a virtual integrated semantic store. In this way, a query formulation component such as OptiqueVQS [6] or PepeSearch [7] can directly plug in, enabling end users to pose ad hoc queries without requiring specialized IT skills. ...
... For this reason, we developed a form-based GUI to easily interact with the system instead of providing users with a query editor. While this GUI was purposely designed to support the functionalities of the Ahus case, a generic visual query editor like OptiqueVQS [6] or PepeSearch [7] can also be employed to formulate ad hoc queries by the medical staff, e.g. to find the set of patients with a particular disease. ...
Background
Information technology has transformed the way healthcare is conducted. There is a deluge of patient data dispersed in different systems that are commonly not interoperable. As a result, access to patient data has become a major bottleneck for healthcare professionals that struggle to find the relevant information in a timely way and without missing critical clinical information.
Results
We implemented PreOptique, a novel hybrid semantic and text-based system that was commissioned by a large hospital in Norway for providing integrated access to patient health records scattered over several databases and document repositories.
We use ontology-based data access (OBDA) for the seamless integration of the structured databases at the hospital through the Optique platform. We employ text analysis techniques to extract vital sign measures and clinical findings from patient documents.
PreOptique was developed and deployed at the hospital. This solution demonstrates how OBDA technology can provide integrated data access to disparate structured sources in healthcare, without requiring the replacement of existing databases. Unstructured clinical texts are also mined to extract patient findings, while the graphical user interface (GUI) provides a single access point that hides the underlying complexity of the system. We ran a usability study with 5 target users, obtaining a system usability score (SUS) of 86.0. Further, participants in the study stressed the simplicity of the GUI and the integration of data sources enabled by the system.
Conclusions
This pilot study showcases the use of OBDA technology and text analysis to enable the integration of patient data for supporting clinical surgery operations. PreOptique is usable and can be easily employed by medical personnel to find patient data in a timely way.
... According to [15] the designing and modeling roles in agent-based systems to facilitate positive interactivity may provide better understandability to the knowledge workers, designer, and development staff. Semantically enriched ontologies are used as a naturally interactive mode among computing devices and active users are shown to be accurate choices [16]. An interoperability refers to the ability to analyze roles in common and to develop schemas in the deployment perspective realizing different methods and tactics. ...
... Das EU-finanzierte Projekt Optique baut darauf auf und entwickelt eine Plattform, die den Datenzugriff vereinfacht und es Endbenutzern in Unternehmen ermöglichen soll, ohne Fachwissen Informationen aus verschiedenen Systemen abzufragen [6,10]. Dazu wurde eine Benutzeroberfläche namens OptiqueVQS entwickelt, die den Endbenutzer dabei unterstützt, Abfragen mithilfe eines visuellen Abfragesystems (VQS) zu erstellen [11]. Neben OptiqueVQS gibt es zahlreiche weitere Projekte, die verschiedene Bedienkonzepte verfolgen, um die Suche und Navigation in großen Datenmengen für den Endbenutzer zu erleichtern und zu verbessern [12,13]. ...
Trotz des Angebots an großen zusammenhängenden Softwarepaketen für das Informationsmanagement in Unternehmen und vielfältiger Möglichkeiten für deren Integration, wird der Zugriff auf Informationen für einen Mitarbeiter zunehmend schwieriger. Dies liegt an der Anzahl und Komplexität der verschiedenen Benutzeroberflächen und Softwaresystemen, mit denen täglich interagiert werden muss. Die Betrachtung der Unternehmensdaten als Social Network of Business Objects (SoNBO) ist ein Konzept, um ein integriertes und plattformunabhängiges System für den digitalen Arbeitsplatz zu schaffen. In dieser Arbeit wird dafür eine technologische Umsetzung als Prototyp entwickelt, die exemplarisch zeigt, wie Unternehmensdaten aus mehreren Anwendungen eines Customer Relationship Management (CRM) Systems per Konfiguration zu einem Netzwerk aus digitalen Business Objects zusammengefasst werden können, um die Daten auf diese Weise für den Mitarbeiter nutzbar und somit wertvoll zu machen. Für eine intuitive Erkundung dieses Netzwerks wird eine webbasierte Oberfläche zur Graph-basierten Navigation bereitgestellt. Das dahinterliegende Konzept basiert auf der erfolgreich eingeführten Eigenentwicklung eines Unternehmens.
