JDBC Driver Research Articles

Comparative analysis of connection performance with databases via JDBC interface and ORM programming frameworks

The research subject of this paper was the comparative analysis of efficiency of connections with databases using different communication methods based on Java programming language. The tools investigated included JDBC drivers and Object-relational mapping (ORM) frameworks. A survey based on 8 different criteria was conducted to determine the most effective method and tool for working with relational databases when developing Java applications. The weights of the criteria were determined through a survey of Java programmers and computer science students.

JackHare: a framework for SQL to NoSQL translation using MapReduce

As data exploration has increased rapidly in recent years, the datastore and data processing are getting more and more attention in extracting important information. To find a scalable solution to process the large-scale data is a critical issue in either the relational database system or the emerging NoSQL database. With the inherent scalability and fault tolerance of Hadoop, MapReduce is attractive to process the massive data in parallel. Most of previous researches focus on developing the SQL or SQL-like queries translator with the Hadoop distributed file system. However, it could be difficult to update data frequently in such file system. Therefore, we need a flexible datastore as HBase not only to place the data over a scale-out storage system, but also to manipulate the changeable data in a transparent way. However, the HBase interface is not friendly enough for most users. A GUI composed of SQL client application and database connection to HBase will ease the learning curve. In this paper, we propose the JackHare framework with SQL query compiler, JDBC driver and a systematical method using MapReduce framework for processing the unstructured data in HBase. After importing the JDBC driver to a SQL client GUI, we can exploit the HBase as the underlying datastore to execute the ANSI-SQL queries. Experimental results show that our approaches can perform well with efficiency and scalability.

Prioritized fuzzy logic based information processing in relational databases

Many years of research related to fuzzy logic and fuzzy set theory extensions to relational databases have not lead to stable implementations, standardized languages or fuzzy relational database application development tools and methods. The main goal of this paper is the modelling and the implementation of a set of tools that allow usage of fuzzy logic enriched with priorities in relational database applications. In order to achieve that goal, at first, the relational data model is extended with the elements of fuzzy set theory. After that, a fuzzy extension of the SQL query language, called the PFSQL, is defined. An interpreter for that language is integrated inside an implementation of the fuzzy JDBC driver. An implementation of the CASE tool for modelling of fuzzy relational database schemas rounds up a set of tools for the implementation of Java fuzzy database applications. In this sense, this paper presents a step towards a methodology for the fuzzy relational database application development.

Extending Binary Large Object Support to Open Grid Services Architecture-Data Access and Integration Middleware Client Toolkit

Problem statement: OGSA-DAI middleware allows data resources to be federated and accessed via web services on the web or within grids or clouds. It provides a client API for writing programs that access the exposed databases. Migrating existing applications to the new technology and using a new API to access the data of DBMS with BLOB is difficult and discouraging. A JDBC Driver is a much convenient alternative to existing mechanism and provides an extension to OGSA-DAI middleware and allows applications to use databases exposed in a grid through the OGSA-DAI 3.0. However, the driver does not support Binary Large Objects (BLOB). Approach: The driver is enhanced to support BLOB using the OGSA-DAI Client API. It transforms the JDBC calls into an OGSA-DAI workflow request and sends it to the server using Web Services (WS). The client API of OGSA-DAI uses activities that are connected to form a workflow and executed using a pipeline. This workflow mechanism is embedded into the driver. The WS container dispatches the request to the OGSA-DAI middleware for processing and the result is then transformed back to an instance of ResultSet implementation using the OGSA-DAI Client API, before it is returned to the user. Results: Test on handling of BLOBs (images, flash files and videos) ranging from size 1 KB to size 2 GB were carried out on Oracle, MySQL and PostgreSQL databases using our enhanced JDBC driver and it performed well. Conclusion: The enhanced JDBC driver now can offer users, with no experience in Grid computing specifically on OGSA-DAI, the possibility to give their applications the ability to access databases exposed on the grid with minimal effort.

An efficient annotation and gene-expression derivation tool for Illumina Solexa datasets

BackgroundThe data produced by an Illumina flow cell with all eight lanes occupied, produces well over a terabyte worth of images with gigabytes of reads following sequence alignment. The ability to translate such reads into meaningful annotation is therefore of great concern and importance. Very easily, one can get flooded with such a great volume of textual, unannotated data irrespective of read quality or size. CASAVA, a optional analysis tool for Illumina sequencing experiments, enables the ability to understand INDEL detection, SNP information, and allele calling. To not only extract from such analysis, a measure of gene expression in the form of tag-counts, but furthermore to annotate such reads is therefore of significant value.FindingsWe developed TASE (Tag counting and Analysis of Solexa Experiments), a rapid tag-counting and annotation software tool specifically designed for Illumina CASAVA sequencing datasets. Developed in Java and deployed using jTDS JDBC driver and a SQL Server backend, TASE provides an extremely fast means of calculating gene expression through tag-counts while annotating sequenced reads with the gene's presumed function, from any given CASAVA-build. Such a build is generated for both DNA and RNA sequencing. Analysis is broken into two distinct components: DNA sequence or read concatenation, followed by tag-counting and annotation. The end result produces output containing the homology-based functional annotation and respective gene expression measure signifying how many times sequenced reads were found within the genomic ranges of functional annotations.ConclusionsTASE is a powerful tool to facilitate the process of annotating a given Illumina Solexa sequencing dataset. Our results indicate that both homology-based annotation and tag-count analysis are achieved in very efficient times, providing researchers to delve deep in a given CASAVA-build and maximize information extraction from a sequencing dataset. TASE is specially designed to translate sequence data in a CASAVA-build into functional annotations while producing corresponding gene expression measurements. Achieving such analysis is executed in an ultrafast and highly efficient manner, whether the analysis be a single-read or paired-end sequencing experiment. TASE is a user-friendly and freely available application, allowing rapid analysis and annotation of any given Illumina Solexa sequencing dataset with ease.

Research Code Management System Based on J2EE

Web-based Code Management System (WCMS) is an essential tool for realizing information exchange in distant collaborative product design and manufacturing among global-based enterprises. A framework for WCMS is built up on a three-tier client/server system and the WCMS is developed utilizing JAVA and J2EE technologies. The developed WCMS mainly uses servlets and JSP to handle user inputs and manage and retrieve code data from the database through the JDBC driver, with the server components stored on a middleware program called Tomcat. The WCMS developed in this work has been successfully implemented in an enterprise.

A framework for web-based product data management using J2EE

Because eManufacturing is motivated by the emerging need for distant collaborative design required among R&D centres and manufacturers of global-based enterprises, web-based product data management becomes an essential tool for realising the technology. In this paper, the design of a web-basedproductdatamanagement (WPDM) system is presented. The developed WPDM is aimed at achieving the goal of eManufacturing by providing an effective tool for product database management through the Internet utilising JAVA and J2EE technologies. In our scenarios, all the involved engineering and management team members who need WPDM are inherently located dispersedly. The ultimate goal is to optimise product cycle time and upgrade a traditional PDM system to face the challenge of the new era of global business competition. Basically, the proposed WPDM is developed in such a way that it allows designers/users to create, view and manipulate product data through the World Wide Web, while founding the architecture of the web application on a three-tier client/server system. The current WPDM of our design mainly uses servlets and JSP to handle user inputs and manage and retrieve product data from the database through the JDBC driver, with the server components stored on a middleware program called Tomcat. Within this environment, all parties involved in product design and manufacture can access the WPDM log-in page with the given URL after a successful identity authorisation. Consequently, these users can create, search and/or manipulate the desired engineering data through the enabled WPDM. The WPDM developed in this work has been experimentally tested in the lab.

Applications of JAVA programming language to database management

The Java programming language [1,3] from its inception has been publicized as a web programming language. Many programmers have developed simple applications such as games, clocks, news tickers and stock tickers in order to create informative, innovative web sites. However, it is important to note that the Java programming language possesses much more capability. The language components and constructs originally designed to enhance the functionality of Java as a web-based programming language can be utilized in a broader extent. Java provides a developer with the tools allowing for the creation of innovative network, database, and Graphical User Interface (GUI) applications. In fact, Java and its associated technologies such as JDBC API [11,5], JDBC drivers [2,12], threading [10], and AWT provide the programmer with the much-needed assistance for the development of platform-independent database-independent interfaces. Thus, it is possible to build a graphical database interface capable of connecting and querying distributed databases [13,14]. Here are components that are important for building the database interface we have in mind.