scholarly journals In-Depth Analysis of OLAP Query Performance on Heterogeneous Hardware

Author(s):  
David Broneske ◽  
Anna Drewes ◽  
Bala Gurumurthy ◽  
Imad Hajjar ◽  
Thilo Pionteck ◽  
...  

AbstractClassical database systems are now facing the challenge of processing high-volume data feeds at unprecedented rates as efficiently as possible while also minimizing power consumption. Since CPU-only machines hit their limits, co-processors like GPUs and FPGAs are investigated by database system designers for their distinct capabilities. As a result, database systems over heterogeneous processing architectures are on the rise. In order to better understand their potentials and limitations, in-depth performance analyses are vital. This paper provides interesting performance data by benchmarking a portable operator set for column-based systems on CPU, GPU, and FPGA – all available processing devices within the same system. We consider TPC‑H query Q6 and additionally a hash join to profile the execution across the systems. We show that system memory access and/or buffer management remains the main bottleneck for device integration, and that architecture-specific execution engines and operators offer significantly higher performance.

Cancers ◽  
2020 ◽  
Vol 13 (1) ◽  
pp. 86
Author(s):  
Mohit Kumar ◽  
Chellappagounder Thangavel ◽  
Richard C. Becker ◽  
Sakthivel Sadayappan

Immunotherapy is one of the most effective therapeutic options for cancer patients. Five specific classes of immunotherapies, which includes cell-based chimeric antigenic receptor T-cells, checkpoint inhibitors, cancer vaccines, antibody-based targeted therapies, and oncolytic viruses. Immunotherapies can improve survival rates among cancer patients. At the same time, however, they can cause inflammation and promote adverse cardiac immune modulation and cardiac failure among some cancer patients as late as five to ten years following immunotherapy. In this review, we discuss cardiotoxicity associated with immunotherapy. We also propose using human-induced pluripotent stem cell-derived cardiomyocytes/ cardiac-stromal progenitor cells and cardiac organoid cultures as innovative experimental model systems to (1) mimic clinical treatment, resulting in reproducible data, and (2) promote the identification of immunotherapy-induced biomarkers of both early and late cardiotoxicity. Finally, we introduce the integration of omics-derived high-volume data and cardiac biology as a pathway toward the discovery of new and efficient non-toxic immunotherapy.


Author(s):  
N. Narikawa ◽  
T. Sato ◽  
N. Sasaki

Abstract This paper gives an overview of an integrated and intelligent database system for a plant engineering framework. We have integrated existing two-dimensional (2D) CAD systems, a three-dimensional (3D) CAD system, and a relational database system which stores engineering information such as design conditions, maintenance histories, and inherent properties. By integrating these systems, the infrastructure for concurrent engineering has been realized. As for design knowledge, we treat object-oriented programming as a useful knowledge representation method. We analyze the plant structure and functional requirements of the system, and then represented them by using the hierarchical Class structure. Design knowledge accompanies the Class, so we represent it using Method. As a design automation system, we develop an automated design check system. This is implemented by using the Common Lisp Object System. These systems are the main parts of the plant engineering framework, and are utilized in the practical design. We intend to develop a mechanical/electronic design framework using the same approach.


2011 ◽  
pp. 49-80
Author(s):  
Hans-Peter Kriegel ◽  
Martin Pfeifle ◽  
Marco Potke ◽  
Thomas Seidl ◽  
Jost Enderle

In order to generate efficient execution plans for queries comprising spatial data types and predicates, the database system has to be equipped with appropriate index structures, query processing methods and optimization rules. Although available extensible indexing frameworks provide a gateway for seamless integration of spatial access methods into the standard process of query optimization and execution, they do not facilitate the actual implementation of the spatial access method. An internal enhancement of the database kernel is usually not an option for database developers. The embedding of a custom, block-oriented index structure into concurrency control, recovery services and buffer management would cause extensive implementation efforts and maintenance cost, at the risk of weakening the reliability of the entire system. The server stability can be preserved by delegating index operations to an external process, but this approach induces severe performance bottlenecks due to context switches and inter-process communication. Therefore, we present the paradigm of object-relational spatial access methods that perfectly fits to the common relational data model, and is highly compatible with the extensible indexing frameworks of existing object-relational database systems, allowing the user to define application-specific access methods.


2003 ◽  
Vol 47 (2) ◽  
pp. 43-51 ◽  
Author(s):  
M.B. Beck ◽  
Z. Lin

In spite of a long history of automated instruments being deployed in the water industry, only recently has the difficulty of extracting timely insights from high-grade, high-volume data sets become an important problem. Put simply, it is now relatively easy to be “data-rich”, much less easy to become “information-rich". Whether the availability of so many data arises from “technological push” or the “demand pull” of practical problem solving is not the subject of discussion. The paper focuses instead on two issues: first, an outline of a methodological framework, based largely on the algorithms of (on-line) recursive estimation and involving a sequence of transformations to which the data can be subjected; and second, presentation and discussion of the results of applying these transformations in a case study of a biological system of wastewater treatment. The principal conclusion is that the difficulty of transforming data into information may lie not so much in coping with the high sampling intensity enabled by automated monitoring networks, but in coming to terms with the complexity of the higher-order, multi-variable character of the data sets, i.e., in interpreting the interactions among many contemporaneously measured quantities.


Author(s):  
Daniel C McFarlane ◽  
Alexa K Doig ◽  
James A Agutter ◽  
Jonathan L Mercurio ◽  
Ranjeev Mittu ◽  
...  

Modern sensors for health surveillance generate high volumes and rates of data that currently overwhelm operational decision-makers. These data are collected with the intention of enabling front-line clinicians to make effective clinical judgments. Ironically, prior human–systems integration (HSI) studies show that the flood of data degrades rather than aids decision-making performance. Health surveillance operations can focus on aggregate changes to population health or on the status of individual people. In the case of clinical monitoring, medical device alarms currently create an information overload situation for front-line clinical workers, such as hospital nurses. Consequently, alarms are often missed or ignored, and an impending patient adverse event may not be recognized in time to prevent crisis. One innovation used to improve decision making in areas of data-rich environments is the Human Alerting and Interruption Logistics (HAIL) technology, which was originally sponsored by the US Office of Naval Research. HAIL delivers metacognitive HSI services that empower end-users to quickly triage interruptions and dynamically manage their multitasking. HAIL informed our development of an experimental prototype that provides a set of context-enabled alarm notification services (without automated alarm filtering) to support users’ metacognition for information triage. This application is called HAIL Clinical Alarm Triage (HAIL-CAT) and was designed and implemented on a smartwatch to support the mobile multitasking of hospital nurses. An empirical study was conducted in a 20-bed virtual hospital with high-fidelity patient simulators. Four teams of four registered nurses (16 in total) participated in a 180-minute simulated patient care scenario. Each nurse was assigned responsibility to care for five simulated patients and high rates of simulated health surveillance data were available from patient monitors, infusion pumps, and a call light system. Thirty alarms per nurse were generated in each 90-minute segment of the data collection sessions, only three of which were clinically important alarms. The within-subjects experimental design included a treatment condition where the nurses used HAIL-CAT on a smartwatch to triage and manage alarms and a control condition without the smartwatch. The results show that, when using the smartwatch, nurses responded three times faster to clinically important and actionable alarms. An analysis of nurse performance also shows no negative effects on their other duties. Subjective results show favorable opinions about utility, usability, training requirement, and adoptability. These positive findings suggest the potential for the HAIL HSI system to be transferrable to the domain of health surveillance to achieve the currently unrealized potential utility of high-volume data.


2010 ◽  
pp. 81-90
Author(s):  
YASUHIRO KOYAMA ◽  
TETSURO KONDO ◽  
MORITAKA KIMURA ◽  
MASAKI HIRABARU ◽  
HIROSHI TAKEUCHI

Author(s):  
YUN BAI ◽  
YAN ZHANG

In this paper, we propose a formal approach of Artificial Intelligence (AI) in securing object oriented database systems. We combine the specification of object oriented database with security policies and provide its formal syntax and semantics. The properties in the inheritance of authorizations in object oriented database system and reasoning about authorizations on data objects are also investigated in detail.


Sign in / Sign up

Export Citation Format

Share Document