838 Hits in 3.4 sec

Remote Batch Invocation for SQL Databases

William R. Cook, Ben Wiedermann
2011 International Workshop/Symposium on Database Programming Languages  
In this paper we show how batch services provide a simple and powerful interface to relational databases, with support for arbitrary nested queries and bulk updates.  ...  Batch services are a new approach to distributed computation in which clients send batches of operations for execution on a server and receive hierarchical results sets in response.  ...  Acknowledgments We thank our collaborators, Eli Tilevich and Ali Ibrahim, for their help in making Batch2SQL possible.  ... 
dblp:conf/dbpl/CookW11 fatcat:qt3iajwssjb6xe2z6muj574bby

An Empirical Study of Local Database Usage in Android Applications

Yingjun Lyu, Jiaping Gui, Mian Wan, William G. J. Halfond
2017 2017 IEEE International Conference on Software Maintenance and Evolution (ICSME)  
Local databases have become an important component within mobile applications. Developers use local databases to provide mobile users with a responsive and secure service for data storage and access.  ...  However, using local databases comes with a cost.  ...  For example, both local and remote databases can be attacked using SQL injection (SQLI) attacks, if developers do not follow best practices for validating user input and interacting with the databases  ... 
doi:10.1109/icsme.2017.75 dblp:conf/icsm/LyuGWH17 fatcat:52l2j66phffm7nwqwnadm7wxcq

Integrating databases and workflow systems

Srinath Shankar, Ameet Kini, David J. DeWitt, Jeffrey Naughton
2005 SIGMOD record  
The definition of data products is in relational format, and invocation of programs and querying is done in SQL.  ...  We present a language for modeling workflows that is tightly integrated with SQL. Each scientific program in a workflow is associated with an active table or view.  ...  For example, consider the role of planning in a WFMS. In their analysis of batch workloads across remote compute clusters, Bent et al.  ... 
doi:10.1145/1084805.1084808 fatcat:glg7ykanyzfppiuwlsp23teobu

A framework for scheduling parallel dbms user-defined programs on an attached high-performance computer

Michael A. Kochte, Ramesh Natarajan
2008 Proceedings of the 2008 conference on Computing frontiers - CF '08  
This framework is advantageous for many DBMS workloads in the following two aspects.  ...  Second, the interactive response time of the remaining applications on the database server platform is improved by the off-loading of long-running user-defined programs to the attached HPC platform.  ...  , or for multiple and related query invocations on the same target database table.  ... 
doi:10.1145/1366230.1366245 dblp:conf/cf/KochteN08 fatcat:lgfcjjlybngwfd6jjkgtuh3rsi

Object Caching Design Framework for Improving Data Access Performance in Enterprise Applications

Nilayam KumarKamila, Renu Raghavan, Naveen Chalicheemala
2014 International Journal of Computer Applications  
But it becomes difficult to cache database results (dynamic data) when the database is manipulated by various external applications.  ...  In today's technological world, applications are designed to communicate across different interfaces and databases with high speed mode.  ...  Batch Job CacheLive Communication The batch job would run either on database local system or on the remote system where the application is running.  ... 
doi:10.5120/15415-3957 fatcat:gb6mffbhjbexzghwt65j4qjwj4


K. Venkatesh Emani, Tejas Deshpande, Karthik Ramachandra, S. Sudarshan
2017 Proceedings of the 2017 ACM International Conference on Management of Data - SIGMOD '17  
Application programs that access data located remotely (such as in a database) often perform poorly due to multiple network round trips and transfer of unused data.  ...  These techniques optimize database application programs by identifying relational operations expressed in imperative code, and translating them into SQL.  ...  SIGMOD In this demonstration, we will showcase equivalent SQL translation for database applications written in Java that use JDBC or Hibernate to access the database.  ... 
doi:10.1145/3035918.3058747 dblp:conf/sigmod/EmaniD0017 fatcat:f7ypslahazehhnba2f4pyzng5i

Integration of Oracle and Hadoop: Hybrid Databases Affordable at Scale

L Canali, Z Baranowski, P Kothuri
2017 Journal of Physics, Conference Series  
This work reports on the activities aimed at integrating Oracle and Hadoop technologies for the use cases of CERN database services and in particular on the development of solutions for offloading data  ...  The goal and interest of this investigation is to increase the scalability and optimize the cost/performance footprint for some of our largest Oracle databases.  ...  As previously mentioned, the interface used for running SQL remotely from Oracle makes use of Oracle database links.  ... 
doi:10.1088/1742-6596/898/4/042055 fatcat:llz3fl6nr5favf7ffk6xp26wjy

Real-Time UAV Trash Monitoring System

Yu-Hsien Liao, Jih-Gau Juang
2022 Applied Sciences  
The detection results were sent to a data streaming platform for data processing and analysis. The Kafka message queuing system and the Mongo database were used for data transmission and analysis.  ...  While a UAV is automatically controlled by an onboard computer, it can also be controlled through a remote station.  ...  The addition of a new column for the table in the SQL database is time-consuming. The advantage of SQL is that it is more suitable for complex queries.  ... 
doi:10.3390/app12041838 fatcat:3fog3uqkaffb3a2igodkekmlh4

Development Of Reliable Web-Based Laboratories For Developing Countries

Teyana S. Sapula, Damian D. Haule
2010 Zenodo  
The need for remote laboratories came after experiencing problems imposed by traditional laboratories.  ...  Remote laboratories enable users to get real data from real-time hand-on experiments.  ...  It interacts direct with the SQL database.  ... 
doi:10.5281/zenodo.1082616 fatcat:7whskcpvh5ebjokvj4en3ysumy

Using domain-specific languages for analytic graph databases

Martin Sevenich, Sungpack Hong, Oskar van Rest, Zhe Wu, Jayanta Banerjee, Hassan Chafi
2016 Proceedings of the VLDB Endowment  
Moreover, the DSL-based approach has significant performance benefits as well, (1) by skipping (remote) API invocation overhead and (2) by applying high-level optimization from the compiler.  ...  In this paper, we present a new graph database system that integrates a robust graph storage with an efficient graph analytics engine.  ...  ACKNOWLEDGMENTS We thank Felix Kaser, Jinha Kim, Korbinian Schmid and Alexander Weld (Oracle Labs) for their work and contributions to PGX, the PGQL and Green-Marl language and for reviewing this paper  ... 
doi:10.14778/3007263.3007265 fatcat:xa7yedsjk5aa7o6uzrp5vjkrvi

Towards Programmability of a NUMA-Aware Storage Engine

Dirk Habich, Johannes Schad, Thomas Kissinger, Wolfgang Lehner
2015 Lernen, Wissen, Daten, Analysen  
The SQL database language was originally intended for application programmers.  ...  However, after more than 20 years of language extensions, SQL can only be generated by software components and is no longer suitable for an increasing user base like knowledge workers or data scientists  ...  the storage operation (e.g., a batch of keys for the lookup or filters for a scan), and additional data that is necessary for the query processing.  ... 
dblp:conf/lwa/HabichSKL15 fatcat:5yv7amydinadlmcgmaoazmr3mq

Rethinking the application-database interface

Alvin Cheung
2014 Proceedings of the 1st ACM International Workshop on Programmable file systems - PFSW '14  
Invocation (RMI) interface to the database program for each type of transaction, passing along with it the arguments to each transaction type.  ...  Each host maintains a local heap for fields and arrays placed at that host as well as a remote cache for remote data.  ...  there is work on moving application code to execute in the database as stored procedures to reduce the number of round trips (such as PYXIs), which is similar to our goals.  ... 
doi:10.1145/2603941.2603947 dblp:conf/hpdc/Cheung14 fatcat:ey7zthb6vnhpjp6xtd2e6u25ma

From Web Service Composition to Megaprogramming [chapter]

Cesare Pautasso, Gustavo Alonso
2005 Lecture Notes in Computer Science  
Additionally, the current version of JOpera includes supports for many other kinds of services, modeling a Java remote method invocation (RMI), a job submitted to a batch scheduling system of a cluster  ...  Method (RMI) Method Parameters Exception Database services Database Query (SQL) Parameters XML JDBC Error XML services X-Path Query (XPATH) XML XML X-Path Pro- cessor Error Style Sheet  ... 
doi:10.1007/978-3-540-31811-8_4 fatcat:r6q7yzfnyncf5dv7i72aksyn4i

Efficient Execution of Multi-query Data Analysis Batches Using Compiler Optimization Strategies [chapter]

Henrique Andrade, Suresh Aryangat, Tahsin Kurc, Joel Saltz, Alan Sussman
2004 Lecture Notes in Computer Science  
batch.  ...  The results show our techniques achieve sizable reductions in the amount of computation and I/O necessary for executing query batches and in average execution times for the individual queries in a given  ...  Many projects have worked on database support for scientific datasets [9, 20] .  ... 
doi:10.1007/978-3-540-24644-2_33 fatcat:k4glcqv2knepzlpsuzodm547yq

Efficient Session Type Guided Distributed Interaction [chapter]

K. C. Sivaramakrishnan, Karthik Nagaraj, Lukasz Ziarek, Patrick Eugster
2010 Lecture Notes in Computer Science  
infrastructure illustrates the costs and benefits of our composable enhancement strategies. which describes a simple protocol implemented in Java RMI, to invite co-workers obtained from a social networking database  ...  We observe that explicit control flow information manifested by MPST opens intriguing avenues also for performance enhancements.  ...  Cook for sharing insights and the source code for RBI [12] with us.  ... 
doi:10.1007/978-3-642-13414-2_11 fatcat:eyll4zlpzfcidbd3e4uh77xeq4
« Previous Showing results 1 — 15 out of 838 results