Search results for "Relational"
showing 10 items of 238 documents
CORAL Server and CORAL Server Proxy: Scalable Access to Relational Databases from CORAL Applications
2011
The CORAL software is widely used at CERN for accessing the data stored by the LHC experiments using relational database technologies. CORAL provides a C++ abstraction layer that supports data persistency for several backends and deployment models, including local access to SQLite files, direct client access to Oracle and MySQL servers, and read-only access to Oracle through the FroNTier web server and cache. Two new components have recently been added to CORAL to implement a model involving a middle tier "CORAL server" deployed close to the database and a tree of "CORAL server proxy" instances, with data caching and multiplexing functionalities, deployed close to the client. The new compon…
CORAL and COOL during the LHC long shutdown.
2013
CORAL and COOL are two software packages used by the LHC experiments for managing detector conditions and other types of data using relational database technologies. They have been developed and maintained within the LCG Persistency Framework, a common project of the CERN IT department with ATLAS, CMS and LHCb. This presentation reports on the status of CORAL and COOL at the time of CHEP2013, covering the new features and enhancements in both packages, as well as the changes and improvements in the software process infrastructure. It also reviews the usage of the software in the experiments and the outlook for ongoing and future activities during the LHC long shutdown (LS1) and beyond. CORA…
LCG Persistency Framework (CORAL, COOL, POOL): Status and Outlook
2011
The LCG Persistency Framework consists of three software packages (POOL, CORAL and COOL) that address the data access requirements of the LHC experiments in several different areas. The project is the result of the collaboration between the CERN IT Department and the three experiments (ATLAS, CMS and LHCb) that are using some or all of the Persistency Framework components to access their data. The POOL package is a hybrid technology store for C++ objects, using a mixture of streaming and relational technologies to implement both object persistency and object metadata catalogs and collections. POOL provides generic components that can be used by the experiments to store both their event data…
Food community networks as leverage for social embeddedness
2013
Social embeddedness, defined as the interaction of economic activities and social behavior, is used in this study as a conceptual tool to describe the growing phenomenon of food community networks (FCNs). The aim in this paper was to map the system of relations which the FCNs develop both inside and outside the network and, from the number of relations, it was inferred the influence of each FCN upon the formation of new socially embedded economic realities. A particular form of FCN was taken under consideration: solidarity purchase groups (SPGs). Performed with the aid of social network analysis on a sample of SPGs in Sicily (a region in southern Italy), the study allowed us to identify a r…
Database to Ontology Mapping Patterns in RDB2OWL Lite
2016
We describe the RDB2OWL Lite language for relational database to RDF/OWL mapping specification and discuss the architectural and content specification patterns arising in mapping definition. RDB2OWL Lite is a simplification of original RDB2OWL with aggregation possibilities and order-based filters removed, while providing in-mapping SQL view definition possibilities. The mapping constructs and their usage patterns are illustrated on mapping examples from medical domain: medicine registries and hospital information system. The RDB2OWL Lite mapping implementation is offered both via translation into D2RQ and into standard R2RML mapping notations.
Program for the Prevention of Violence among Teenage Couples in the School Setting
2015
Domestic violence remains one of the major problems in the 21st century entailing severe costs and consequences for the victims. Despite the promulgated laws, this type of violence has increased among adolescents. Although several theories have been put forward to explain the causes of domestic violence, a psychobiological or social-educative explanation that proposes an agreed starting point for understanding and preventing this phenomenon is lacking. Experts in the field agree on the need for programs that focus on this relational problem; however, existing programs for adolescents have a broad spectrum where the prevention of domestic violence is just one more aspect of their objectives.…
Social Influence Maximization in Hypergraphs
2021
This work deals with a generalization of the minimum Target Set Selection (TSS) problem, a key algorithmic question in information diffusion research due to its potential commercial value. Firstly proposed by Kempe et al., the TSS problem is based on a linear threshold diffusion model defined on an input graph with node thresholds, quantifying the hardness to influence each node. The goal is to find the smaller set of items that can influence the whole network according to the diffusion model defined. This study generalizes the TSS problem on networks characterized by many-to-many relationships modeled via hypergraphs. Specifically, we introduce a linear threshold diffusion process on such …
Il Paradigma della Città Fluida
2013
Nella recente crisi globale i poderosi flussi di capitali finanziari, sociali e relazionali che hanno alimentato la riqualificazione urbana nel corso degli ultimi quindici anni non sono più disponibili ad essere intercettati in maniera indiscriminata così come è stato possibile fino a qualche anno fa. Nell'era della crisi strutturale le città più dinamiche non sono più quelle in grado di attrarre progetti urbani iconici ed investitori spinti dal mercato immobiliare o dalla redditività delle attività ricreative, ma quelle città che, a partire dalle loro profonde e diversificate risorse culturali, saranno capaci di attuare una vera e propria “metamorfosi” per usarle come base per la creazione…
An Ehrenfeucht-Fraïssé Approach to Collapse Results for First-Order Queries over Embedded Databases
2001
We present a new proof technique for collapse results for first-order queries on databases which are embedded in N or R>o. Our proofs are by means of an explicitly constructed winning strategy for Duplicator in an Ehrenfeucht-FraissE game, and can deal with certain infinite databases where previous, highly involved methods fail. Our main result is that first-order logic has the natural-generic collapse over {N,≤ ,+} for arbitrary (i.e., possibly infinite) databases. Furthermore, a first application of this result shows the natural-generic collapse of first-order logic over {R>o,≤,+} for a certain kind of databases over R>o which consist of a possibly infinite number of regions.
Publish By Example
2008
We propose an approach for producing database publishing programs by example. The main idea is to interactively build an example document, representative of the program output. The system infers from this document, without ambiguity, the publishing program. The end-user does not need to know a programming language, a query language or the database schema.