Java Database Connectivity Research Articles

Abstract PO-052: A multisystem approach doubles the number of patients referred for genetic testing and diagnosed with Lynch syndrome with equally success among ethnic/racial groups

Abstract Background: Lynch syndrome (LS) affects 1/279 individuals and accounts for 3-5% of all colorectal cancers (CRC). LS is due to germline mutations in mismatch repair (MMR) genes MLH1, MSH2, MSH6, or PMS2. Tumors exhibit MMR deficiency, expressed as loss of MMR protein expression on immunohistochemistry (IHC). A subset of sporadic tumors also has MMR deficiency due to inactivation of MLH1 via promoter methylation and about 2/3 have BRAFV600E mutations. Increased surveillance and chemoprevention reduce cancer incidence and mortality in LS. LS is largely underdiagnosed, particularly among minorities. Universal screening of CRC tumors through IHC is recommended in order to help identify patients for LS genetic testing. Nevertheless, even in programs that have implemented this, minority patients with MMR deficient tumors were found to be consistently under-referred mostly due to referral bias. We set up a strategy to increase LS and tackle disparities in cancer genetics (CG). Methods: This study reports on the analysis of universal CRC IHC testing for MMR expression, initially followed by BRAF V600E and later by MLH1 testing for loss of MLH1/PMS2 expression, from implementation (1/1012) until 1/1021. In 6/2015, a system was established where a designated Pathologist reviewed all results and a list of identified candidates for germline LS testing (abnormal MMR expression/wild type BRAF or methylation of MLH1) was sent to the CG program. After a two-week period, if no referral had been placed, a genetic counselor (GC) messaged the provider requesting a referral. The pathology side was fully automated in 9/2018 through the monitoring engine Repetitive Tasks Scheduling Engine (RTSE) that pulls data stored in the underlying relational database-Adaptive Server Enterprise, which is accessible to RTSE via a Java Database Connectivity API. This process automatically generates weekly emails that report all cases with suspicion criteria for LS to CG. Results: Since 1-2012, 1,433 patients with CRC underwent tumor testing and were included in this study: 78.5% non-Hispanic white (NHW); 12.2% African American (AA); 6.77% Hispanic (H). Prior to the interventions 25% of eligible patients were referred to CG and none among AA. Once the interventions were established, appropriate referrals prior to messaging the provider were 39.5% for NHW, 35.7% for AA, and 42.8% for H. As a result of the messages, referral rates increased to 80.5% (p=0.00) in NHW, 85.7% in AA (p=0.05), and 71.5% in H (ns). The total number of patients diagnosed with LS since universal testing started was 19: 2 prior to the interventions (0.8% of all CRC); 17 during the interventions (1.5% of all CRC). Conclusion: A systematic, automated, multi-system approach, that includes a targeted message to providers can double the number of appropriate referrals for genetic testing to rule out Lynch syndrome and resulted in almost twice the percentage of LS diagnosis with equal success among AA, H, and NHW. Citation Format: Vinit Singh, Amanda Ganzak, Peter Gershkovich, Joanna Gibson, Rosa M. Xicola, Xavier Llor. A multisystem approach doubles the number of patients referred for genetic testing and diagnosed with Lynch syndrome with equally success among ethnic/racial groups [abstract]. In: Proceedings of the AACR Virtual Conference: 14th AACR Conference on the Science of Cancer Health Disparities in Racial/Ethnic Minorities and the Medically Underserved; 2021 Oct 6-8. Philadelphia (PA): AACR; Cancer Epidemiol Biomarkers Prev 2022;31(1 Suppl):Abstract nr PO-052.

Chemistry with Java

The Chemistry with java is an application which combines the Organic and the Inorganic world of Chemistry into a single application which can be accessed by users across all changes to promote the learning and the understanding of the subject by introducing visual aid to the subject. The application is developed basically with three levels The User Interface being built using the Swing framework is an API for providing Graphical User Interface across all platforms. The Intermediate level we implement Java Database Connectivity for SQLite3 implying that the underlying base layer we use SQLite3 as the database. For the Organic world of Chemistry we use an API named OPSIN(Open Parser for Systematic IUPAC Nomenclature) which converts the general name of the Organic Compound into the IUPAC name of the same compound along with its standard structure.

Integrated Design of Graduate Education Information System of Universities in Digital Campus Environment

This study takes the digital campus construction planning of the high school as an example and determines the requirements of the postgraduate management information system under the digital campus environment through the analysis of the overall framework and technology of the digital campus. Combining the current situation of computer technology, network technology, and the actual situation of our university, the current mainstream B/S three‐layer architecture is adopted, the web adopts the current popular Java Server Pages technology, and the struts framework connects to the Oracle backend database through the Java Database Connectivity interface to design the browser‐side and server‐side programs. The struts framework connects to the Oracle backend database through the Java Database Connectivity interface to design browser‐side and server‐side programs. The functional model and data flow model of the system were established through a detailed and effective analysis of the entire workflow of postgraduate students’ training management during their school years. Then, the system analysis, design, and drawing of the swim lane diagram and data business flow diagram were carried out. The system was designed in detail in terms of system architecture, development tools, functional modules, and database design, and the core module of training program making in postgraduate training management was highlighted as an example to discuss the principles and methods in the construction of departmental business systems and informatization under the digital campus environment, and a flexible and efficient postgraduate management information system was realized. It standardizes the construction of data standardization in universities; does a good job of standardizing and normalizing information; improves the accuracy, validity, and real‐time production of data collection and the real and safe unified management of historical data; and provides scientific and reasonable data support for the leadership to make relevant decisions.

Optimizing N-Tier Application Scalability in the Cloud

An effective cloud computing environment requires both good performance and high efficiency of computing resources. Through extensive experiments using a representative n-tier benchmark application (Rice University Bulletin Board System (RUBBoS)), we show that the soft resource allocation (e.g., thread pool size and database connection pool size) in component servers has a significant impact on the overall system performance, especially at high system utilization scenarios. Concretely, the same software resource allocation can be a good setting in one hardware configuration and then becomes an either under- or over-allocation in a slightly different hardware configuration, causing a significant performance drop. We have also observed some interesting phenomena that were caused by the non-trivial dependencies between the soft resources of servers in different tiers. For instance, the thread pool size in an Apache web server can limit the total number of concurrent requests to the downstream servers, which surprisingly decreases the Central Processing Unit (CPU) utilization of the Clustered Java Database Connectivity (C-JDBC) clustering middleware as the workload increases. To provide a globally optimal (or near-optimal) soft resource allocation of each tier in the system, we propose a practical iterative solution approach by combining a soft resource aware queuing network model and the fine-grained measurement data of every component server. Our results show that to truly scale complex distributed systems such as n-tier web applications with expected performance in the cloud, we need to carefully manage soft resource allocation in the system.

An Intelligent Data Service Framework for Heterogeneous Data Sources

Heterogeneous data on distributed computing sources are growing day by day. To manage the data from the distributed sources into a distinct type of application like mobile, cloud, desktop, web etc. is a challenging issue in the global information systems, particularly for cooperation and interoperability. This paper proposes a Data Service Framework, which integrates the data from distributed sources such as databases, Simple Object Access Protocol (SOAP) based web services and flat files, and performs create, read, update and delete (CRUD) operations on it through Representational State Transfer (REST) services over the Hyper Text Transfer Protocol (HTTP). The proposed data service framework also supports java database connectivity (JDBC). Detailed description of the proposed framework and experimental results are reported in this paper.

Analysis with performance of computer based scholar management system

Computer based scholar management system is software which is helpful for scholars as well as the school authorities/college. In the current system all the activities are done manually. It is very time consuming and costly. In this paper computer based scholar management system deals with the various activities related to the scholars. In this paper, software can register as a user and user has of two types, scholar and administrator. Administrator has the power to add new user and can edit and delete a user. A scholar can register as user and can add edit and delete his profile. The administrator can add edit and delete marks for the scholar. All the users can see the marks. This paper helps to any school and college to maintain the scholar record. An application that runs stand-alone in adesktop or laptop computer. Contrast with Web-based application, which requires the Web browser to run. The term may be used to contrast desktop applications with mobile applications that run in smartphones and tablets. In this project we can easily update and delete file from our database. This application can run without internet connection. This application use database for store records of student and we can manage easily. This application use AWT and Swing components and database for data. Swing is a set of program component s for Java programmers that provide the ability to create graphical user interface (GUI) components, such as buttons and scrollbar that are independent of the windowing system for specific operating system Swing components are used with the Java Foundation Classes (JFC). Java Database Connectivity (JDBC) is an application programming interface (API) for the programming language Java, which defines how a client may access a database. It is Java based data access technology and used for Java database connectivity. It is part of the Java Standard Edition platform, from Oracle Corporation.

Enhancing Call-Level Interfaces with Thread-Safe Local Memory Structures

Database applications are being increasingly under pressure to respond effectively to ever more demanding performance requirements. Software architects can resort to several well-known architectural tactics to minimize the possibility of coming across with any performance bottleneck. The usage of call-level interfaces (CLIs) is a strategy aimed at reducing the overhead of business components. CLIs are low-level APIs that provide a high-performance environment to execute standard SQL statements on relational and also on some NoSQL database (DB) servers. In spite of these valuable features, CLIs are not thread-safe when distinct threads need to share datasets retrieved through Select statements from databases. Thus, even in situations where two or more threads could share a dataset, there is no other possibility than providing each thread with its own dataset, this way leading to an increased need of computational resources. To overcome this drawback, in this paper we propose a new natively thread-safe architecture. The implementation herein presented is based on a thread-safe updatable local memory structure (LMS) where the data retrieved from databases is kept. A proof of concept based on Java Database Connectivity type 4 (JDBC) for SQL Server 2008 is presented and also a performance assessment.

Virtual credit card processing system

The Institute of Technology Blanchardstown decided in 1999 to teach Java to our computing students from 1st year. Java is now being used to support the practical component of all our subjects. This paper presents a project implemented by two of our third year students as a case study of what students can achieve after 3 years of Java programming. The virtual credit card processing system is an e-business system which provides a secure and universal mechanism for making purchases over the Internet. The system uses Remote Method Invocation(RMI), Java Server Pages(JSP), Java Servlets and Java Database Connectivity(JDBC).

Development of a SNOMED-CT Mapping Framework for the Interoperability of Biobank Resources in Korea

The existing Systematized Nomenclature of Medicine - Clinical Terms (SNOMED-CT) toolkit includes only a clinical term search, and its output functions are not linked to a particular database, making it difficult for users to map biological data, and the use of biobanks requires much time and effort. This study developed a SNOMED-CT toolkit using an optimized search, allowing users to map clinical items for efficient utilization and standardization of biobank resources. The toolkit was developed using the Java programming language and Java Database Connectivity to connect to a previously developed research database. The user interface was implemented using Swing. The functions and interfaces of the toolkit were developed after a requirement analysis by SNOMED-CT experts. Using the toolkit, the user can search SNOMED-CT concepts. Using pre-and post-coordinated mapping of clinical items with the toolkit, it is possible to maximize the semantic interoperability of the previously developed database.

Design and Development of a Platform forProcessing Bio-Images and Signals UsingAgent Oriented Programming

Agent can be defined as a component that, given a goal could act in the place of a user within its domain knowledge. Agents are also called intelligent agents, as intelligence is a key component of agency. Agent oriented approach can be viewed as next step of Object Oriented approach. The project work attempts to demonstrate the concept of developing Multi-Agent platform for processing of Bio-Images and signals. It also demonstrates the concept of developing and deploying agents using JADE – Java Agent DEvelopment framework. The technical goal of this work is to develop a multi agent platform for processing of bio-images and signals aiming at assisting medical practitioners in developing standard examination procedures. If a medical practitioner wants to have an expert opinion about mammogram images and EEG / ECG / EMG of his patient, Generic Agent can be invoked to which he has to specify the SSN (Social Security Number) of the patient, the type of the image and signal and the corresponding data file. The Generic Agent in turn will search for the Specific Agent – Breast image Agent , EEG Agent, ECG Agent, EMG Agent based on the image and signal type on the network and if found, the corresponding information will be passed to the specific agent by the Generic Agent. The result is being sent to the Generic Agent and it stores / updates the result in the Database using the Java Data Base Connectivity. As the agents on the JADE environment run on Threads, the response time is very less which helps the medical practitioner to make a quick diagnosis of mammogram images and signals

Integrated Usage of Heterogeneous Databases for Novice Users

This paper proposes the system enabling users to use heterogeneous databases in an integrated manner without any conversion and servers. In order to treat a variety of sources in a unified manner, this system is realized by using Java Database Connectivity (JDBC) in accessing databases on the user’s computer. It also joins and/or projects them as required. The syntax identifying a kind of database or file is introduced. The system maintains data by using ArrayLists in Java. It is experimentally shown that there is no practical problem in the equijoin of three tables having 100,000 rows in heterogeneous databases.

Bugs Pattern Detection Application in JDBC using Static Analysis Non-Linear Method

In this paper, it will be explained about an application which able to analyze the quality of java program code in implementing Java Database Connectivity (JDBC). The analysis will be based on existing best practice in implement JDBC. To analyze JDBC, bugs patterns are needed to be compared with existing best practice. Various methods are available to be used in constructing this kind of application, but in this paper, static analysis non-linear method is used in designing this application. Static analysis means the java program code will be read and analyzed without executing. Non-linear means the java program code will not read sequentially, but it will follow the flow of the program code itself. And this application will be called Bedhigasan, which able to detect bugs pattern in implementing JDBC and it will report those bugs to the web page including with location of the bugs.

Research on Web Server Based on Red5, Tomcat and Apache

This paper aims to set up the Web Server which can handle Flash streaming client, static HTTP requests, dynamic JSP requests and interact with the Database Server. The streaming media Server Red5 responses RTMP requests, Application Server Tomcat responses dynamic JSP requests, Web Server Apache responses static HTTP requests, Framework Spring achieves the dynamic equipment of each service object. The Object-Relational Mapping model Hibernate and the Java Database Connectivity JDBC do the persistence operation and realize data persistence layer. The Web Server can realize the Web Server of Web Video Conference based on B/W/D architecture.

SU‐GG‐T‐533: Remote PC Application Access to a Stereotactic Treatment Planning System SQL Database

Purpose: To implement remote access using Matlab to a PostgreSQL database, which supports the Leksell GammaPlan (LGP) version 8.1 treatment planning system. Method and Materials: A postgreSQL Java Database Connectivity (JDBC) driver was downloaded from the official website of postgreSQL. The class path that specifies a series of files and directories, pointing to classes accessible to Matlab, must be edited to include the database driver. Table patients maintains information on patients. Table examinations maintains information on each examination. Table skulls maintains information on skull coordinates. Table plans minal information on each target . Table targets maintains information on each target. Table shots maintains information on each shot. lann examinations is related to table patients through examination ID. Table skulls is related to table examinations through examination ID. Table plans is also related to table examinations through examination ID. Table targets is related to table plans through plan ID. Table shots is related to table targets through target ID. Results: An application was implemented in Matlab. By entering the patient ID, any information about any treatment performed on any specific patient, from patient's name and birthday to the shot time of each shot, could be retrieved remotely on a PC from the database in a well‐maintained data structure. The retrieved data were further used to verify LGP treatment plans through independent dose calculation and display. Conclusion: A remote access to PostgreSQL database behind LGP is feasible in Matlab. Similar application could also be implemented in other environments like Visual C#. It is of great convenience for users who desire to develop their own applications that use information found in the LGP SQL database.

Internet-Based Teaching and Experiment System for Control Engineering Course

e-Learning engineering courses with online experiments are attracting a great deal of attention because of the flexibility they provide in both teaching and learning. This paper has described an Internet-based teaching and experiment system for control engineering (ITESCE) that provides students with online course material, a simulator, an online control experiment using an arm robot, and the ability to store and search simulation and experimental results. To implement the functions required by the course and to facilitate connection to the Internet, the ITESCE is based on a standard browser/server architecture with three layers and employs multithreading, Java applets, and Java database connectivity. Background control subsystems handle the real-time control of experiments, and a network server handles communication with clients and with background control subsystems. A database stores simulation and experimental results. The course covers a variety of control methods, and students can try them out through online simulations and experiments. To enhance realism, a Web camera takes a video of an experiment and streams it to a student's PC in real time.

An Introduction to Network Programming the Python Way

This article is a review of the book, 'Foundations of Python Network Programming' by John Goerzen, published by Apress, 2004. The book covers the standard Python distribution's client protocol implementations-such as HTTP, DNS (Domain Name System), SMTP (Simple Mail-Transfer Protocol), FTP, POP (Post Office Protocol), IMAP (Internet Message Access Protocol), and XML-RPQ and server frameworks (for out of the box HTTP and XML-RPC servers). The Database Clients chapter admirably introduces DB-API 2.0, the Python equivalent of Java database connectivity or open database connectivity. Other chapters explain Python interfaces to the Secure Sockets Layer, HTML/XML parsing, and the mod/spl I.bar/python Apache module, as well as more advanced network programming topics such as IPv6 support, multithreaded servers, and nonblocking 1/0. The book also incorporates third-party networking libraries such as Twisted and PyDNS. Each chapter's text thoroughly explains the code samples, which are far more comprehensive than in the standard documentation. The reviewer feels that the book complements other introductory texts.

CCMS: A geographically distributed concurrent change and configuration management system

In recent years, large-scale software development has involved collaboration among teams of people whose members are dispersed around the globe. Software change and configuration management (SCCM) is an essential discipline that affects all steps of the software development process, from the definition of requirements and prototyping to the final packaging and delivery of a product to a customer. Particularly in a geographically distributed environment, a good SCCM process makes it possible to produce higher-quality software and to reduce time-to-market. The concurrent change management system (CCMS) provides an out-of-the-box, customizable SCCM process framework that allows teams of project managers, architects, developers, testers, and integrators to manage product defects that have been reported, features and enhancements that have been requested, and versions of product artifacts and third-party components that provide solutions for such defects and features over multiple releases in a geographically distributed environment. The CCMS, which uses Java <sup xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink">∗</sup> /Java Database Connectivity (JDBC <sup xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink">∗</sup> ) and the database replication technologies of Oracle and Rational's ClearCase <sup xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink">∗</sup> /MultiSite, <sup xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink">∗</sup> was developed by Lucent Technologies over the past 7 years. In this paper we describe the high-level architecture and the process framework of the CCMS. The process framework will also be described with examples of the use of CCMS. © 2003 Lucent Technologies Inc.

A distributed, heterogeneous computing environment for multidisciplinary design and analysis of aerospace vehicles

A framework for rapid applications development is described that implements an object-oriented computational environment in which the Common Object Request Broker Architecture and the Java programming language are used to encapsulate discipline codes as reusable “objects”. The environment exploits the parallelisms inherent in the application and distributes the disciplines on machines most appropriate to their needs, while insulating the developer and the user from the complexity of the underlying communications constructs. Data and file management are accomplished using Java's database connectivity to access a commercial relational database management system. Java's Beans Development Kit (BDK) is used to implement the disciplines and sub-tasks as reusable components and to provide a graphical interface for user input as well as to facilitate interactive and visual object connectivity and monitor problem execution progress. The advantages of this approach have been demonstrated through the implementation of a standalone aerodynamic optimizer and the analysis of a large-scale high speed civil transport design optimization problem in this framework.

WEB INFORMATION MANAGEMENT AND ITS APPLICATION TO ELECTRONIC COMMERCE

This paper describes various aspects of web information management with particular emphasis on its application to electronic commerce. We first provide a brief overview of the web. Then we discuss concepts for web database management, as database management is a key part of information management. These include data models and architectures, query processing, transaction management, metadata management, storage issues, and integrity and security. Then we discuss various web information management technologies such as multimedia, visualization, data mining and warehousing, and knowledge management. Then we discuss emerging standards such as Java Database Connectivity, Extended Markup Language (XML), and middleware standards such as Object Request Brokers (ORB) and Remote Method Invocation (RMI). Finally we discuss how web data management technologies can be applied to the important area of electronic commerce.

A Distributed Framework for Parallel Data Mining Using HPJava

Java has become a language of choice for applications executing in heterogeneous environments utilising distributed objects and multithreading. To handle large data sets, scalable and efficient implementations of data mining approaches are required, generally employing computationally intensive algorithms. Conventional Java implementations do not directly provide support for the data structures often encountered in such algorithms, and they also lack repeatability in numerical precision across platforms. This paper describes a distributed framework employing task and data parallelism, and implemented in high performance Java (HPJava). Issues of interest for data mining algorithms are identified, and possible solutions discussed for overcoming limitations in the Java Virtual Machine. The framework supports parallelism across workstation clusters, using the message-passing interface as middleware, and can support different analysis algorithms, wrapped as Java objects, and linked to various databases using the Java database connectivity interface. Guidelines are provided for implementing parallel and distributed data mining on large data sets, and a proof-of-concept data mining application is analysed using a neural network.