Open Database Connectivity Research Articles

Cloud security framework and key management services collectively for implementing DLP and IRM

A free and open-source framework management solution can help organizations as well as end-users. An agentless, completely controlled, centrally administered, and freely distributed source, cloud-based data leak control includes enhanced data loss protection management for both corporations and end-users. An Open-Source Framework in the cloud zone was used to construct the data loss prevention tool. This framework can be released under an Open License or a Free License, making it freely usable by end-users throughout the world. You can run it on any of these platforms: Linux, Windows, or UNIX. It relies on open database connectivity and MSSQL credentials for its database connectivity, although MySQL Server is used for database connectivity. As many as hundreds of individual files or thousands of multiple files can be accessed simultaneously by the Open User Data Loss Management Console, which can identify the case-sensitive information among them.

Production line 3D visualization monitoring system design based on OpenGL

New production line management technologies are required and adopted recently with the development of modern manufacturing industry. In this study, a production line three-dimensional (3D) visualization monitoring system based on OpenGL modeling, open database connectivity (ODBC), and database management technology is established on a VC++6.0 platform to satisfy effective production. A client/server model is adopted in the system, and data on processing information, interactive operation, and failure process are stored in the server side database. A client reads the workpiece process information from the server, and the machining process of every workpiece is visually represented in the form of 3D visualization. Production line 3D visualization provides production capacity simulation to optimize the parameter settings. When compared with the analysis results of production line capacity, the key parameters possess the same optimal values, and this proves the accuracy of production line 3D visualization monitoring system. The system provides effective data support for production line monitoring and management in enterprises.

RETRACTED ARTICLE: Research on intelligent city energy management based on Internet of things

In order to solve the problem of energy management in Intelligent City, the energy management platform of the Internet of things is applied. the method of the energy consumption measurement data access to the energy management platform of the Internet of things is studied. According to the different communication protocols used by the energy management subsystem, the access methods of OPC technology, Web Service and open database connectivity and front-end communication are discussed. The results show that the intelligent city energy management system based on the Internet of things can meet the needs of the “intelligent city” construction. The system integrates the isolated energy information and realizes the energy consumption measurement. It lays the foundation for the diagnosis and energy saving evaluation of urban energy consumption.

International AC: An Education Case on Continuous Monitoring SQL Server Data with ODBC-Linked Tables in Microsoft Access

ABSTRACTThis education case teaches students Continuous Auditing/Continuous Monitoring (CA/CM) using Open Database Connectivity (ODBC) connections from students' Microsoft Access (Access) to tables in Microsoft SQL Server (SQL Server). First, the institution's database administrator (DBA) imports the student tables provided with the Teaching Notes into the institution's SQL Server with read-only access. In Access, students create ODBC connections to the SQL Server student tables. Then, students create Access queries using the ODBC-linked tables to monitor for anomalies. During a scheduled week, the DBA, in coordination with the faculty member, enters anomalies in the SQL Server student tables at random times, and students run their Access queries to identify the anomalies.

Technical Note: Development and performance of a software tool for quality assurance of online replanning with a conventional Linac or MR-Linac.

To develop an integrated quality assurance (QA) software tool for online replanning capable of efficiently and automatically checking radiation treatment (RT) planning parameters and gross plan quality, verifying treatment plan data transfer from treatment planning system (TPS) to record and verify (R&V) system, performing a secondary monitor unit (MU) calculation with or without a presence of a magnetic field from MR-Linac, and validating the delivery record consistency with the plan. The software tool, named ArtQA, was developed to obtain and compare plan and treatment parameters from both the TPS and the R&V system database. The TPS data are accessed via direct file reading and the R&V data are retrieved via open database connectivity and structured query language. Plan quality is evaluated with both the logical consistency of planning parameters and the achieved dose-volume histograms. Beams in between the TPS and R&V system are matched based on geometry configurations. To consider the effect of a 1.5 T transverse magnetic field from MR-Linac in the secondary MU calculation, a method based on modified Clarkson integration algorithm was developed and tested for a series of clinical situations. ArtQA has been used in their clinic and can quickly detect inconsistencies and deviations in the entire RT planning process. With the use of the ArtQA tool, the efficiency for plan check including plan quality, data transfer, and delivery check can be improved by at least 60%. The newly developed independent MU calculation tool for MR-Linac reduces the difference between the plan and calculated MUs by 10%. The software tool ArtQA can be used to perform a comprehensive QA check from planning to delivery with conventional Linac or MR-Linac and is an essential tool for online replanning where the QA check needs to be performed rapidly.

SU-D-BRD-06: Creating a Safety Net for a Fully Automated, Script Driven Electronic Medical Record

Purpose: Demonstrate the effectiveness of in-house software in ensuring EMR workflow efficiency and safety. Methods: A web-based dashboard system (WBDS) was developed to monitor clinical workflow in real time using web technology (WAMP) through ODBC (Open Database Connectivity). Within Mosaiq (Elekta Inc), operational workflow is driven and indicated by Quality Check Lists (QCLs), which is triggered by automation software IQ Scripts (Elekta Inc); QCLs rely on user completion to propagate. The WBDS retrieves data directly from the Mosaig SQL database and tracks clinical events in real time. For example, the necessity of a physics initial chart check can be determined by screening all patients on treatment who have received their first fraction and who have not yet had their first chart check. Monitoring similar “real” events with our in-house software creates a safety net as its propagation does not rely on individual users input. Results: The WBDS monitors the following: patient care workflow (initial consult to end of treatment), daily treatment consistency (scheduling, technique, charges), physics chart checks (initial, EOT, weekly), new starts, missing treatments (>3 warning/>5 fractions, action required), and machine overrides. The WBDS can be launched from any web browser which allows the end user complete transparency and timely information. Since the creation of the dashboards, workflow interruptions due to accidental deletion or completion of QCLs were eliminated. Additionally, all physics chart checks were completed timely. Prompt notifications of treatment record inconsistency and machine overrides have decreased the amount of time between occurrence and execution of corrective action. Conclusion: Our clinical workflow relies primarily on QCLs and IQ Scripts; however, this functionality is not the panacea of safety and efficiency. The WBDS creates a more thorough system of checks to provide a safer and near error-less working environment.

SU‐E‐J‐199: A Software Tool for Quality Assurance of Online Replanning with MR‐Linac

Purpose:To develop a quality assurance software tool, ArtQA, capable of automatically checking radiation treatment plan parameters, verifying plan data transfer from treatment planning system (TPS) to record and verify (R&V) system, performing a secondary MU calculation considering the effect of magnetic field from MR‐Linac, and verifying the delivery and plan consistency, for online replanning.Methods:ArtQA was developed by creating interfaces to TPS (e.g., Monaco, Elekta), R&V system (Mosaiq, Elekta), and secondary MU calculation system. The tool obtains plan parameters from the TPS via direct file reading, and retrieves plan data both transferred from TPS and recorded during the actual delivery in the R&V system database via open database connectivity and structured query language. By comparing beam/plan datasets in different systems, ArtQA detects and outputs discrepancies between TPS, R&V system and secondary MU calculation system, and delivery. To consider the effect of 1.5T transverse magnetic field from MR‐Linac in the secondary MU calculation, a method based on modified Clarkson integration algorithm was developed and tested for a series of clinical situations.Results:ArtQA is capable of automatically checking plan integrity and logic consistency, detecting plan data transfer errors, performing secondary MU calculations with or without a transverse magnetic field, and verifying treatment delivery. The tool is efficient and effective for pre‐ and post‐treatment QA checks of all available treatment parameters that may be impractical with the commonly‐used visual inspection.Conclusion:The software tool ArtQA can be used for quick and automatic pre‐ and post‐treatment QA check, eliminating human error associated with visual inspection. While this tool is developed for online replanning to be used on MR‐Linac, where the QA needs to be performed rapidly as the patient is lying on the table waiting for the treatment, ArtQA can be used as a general QA tool in radiation oncology practice.This work is partially supported by Elekta Inc.

Application and Integration of Control Network and Information Network

Enterprise integrated automation is the general trend of industrial control development. The combination of control network and information network provides comprehensive information services for enterprise as production information, production control, planning decisions and sales management as well. The industrial control network and information network integration can realize the information and resources sharing among the enterprises networks and further improve the enterprises informationization and integrated automation level so as to achieve the situation that the enterprise production and management is more efficient and more flexible. The study introduces the information integration of the fieldbus control network and the information network and analyze the information integration technologies such as internetworking, dynamic data exchange (DDE), Open Database Connectivity (ODBC), OLE for Process Control (OPC), control network and information network with unified protocol standards. the integration application of bus system is illustrated with the example of Controller Area Network (CAN) bus.

A simple versatile solution for collecting multidimensional clinical data based on the CakePHP web application framework

Clinical trials aiming for regulatory approval of a therapeutic agent must be conducted according to Good Clinical Practice (GCP). Clinical Data Management Systems (CDMS) are specialized software solutions geared toward GCP-trials. They are however less suited for data management in small non-GCP research projects. For use in researcher-initiated non-GCP studies, we developed a client–server database application based on the public domain CakePHP framework.The underlying MySQL database uses a simple data model based on only five data tables. The graphical user interface can be run in any web browser inside the hospital network. Data are validated upon entry. Data contained in external database systems can be imported interactively. Data are automatically anonymized on import, and the key lists identifying the subjects being logged to a restricted part of the database. Data analysis is performed by separate statistics and analysis software connecting to the database via a generic Open Database Connectivity (ODBC) interface. Since its first pilot implementation in 2011, the solution has been applied to seven different clinical research projects covering different clinical problems in different organ systems such as cancer of the thyroid and the prostate glands.This paper shows how the adoption of a generic web application framework is a feasible, flexible, low-cost, and user-friendly way of managing multidimensional research data in researcher-initiated non-GCP clinical projects.

Developing a Coal Quality Detection Management System for Power Plants

A Coal Quality Detection Management System is developed in Visual C++ based on Client/Server mode, and the system combines several techniques, such as the open database connectivity, serial communication, and Excel object linking and embedding. The system is composed of three modules: a receipt/allocation module, a data acquisition module, and a detection data management module, and the modular structure endows the system with a series of functions, such as real-time data collection, query results, data processing, data auditing, data storage, and report printing. Recently, the system was applied in two coal-fired power plants for managing coal quality detection, which greatly improves the detection efficiencies and reduces the manual works.

The myImageAnalysis Project: A Web-Based Application for High-Content Screening

A major challenge faced by screening centers developing image-based assays is the wide range of assays needed compared to the limited resources that are available to effectively analyze and manage them. To overcome this limitation, we have developed the web-based myImageAnalysis (mIA) application, integrated with an open database connectivity compliant database and powered by Pipeline Pilot (PLP) that incorporates dataset tracking, scheduling and archiving, image analysis, and data reporting. For system administrators, mIA provides automated methods for managing and archiving data. For the biologist, this application allows those without any programming or image analysis experience to quickly develop, validate, and share results of complex image-based assays. Further, the structure of the application within PLP allows those with experience in PLP programming to easily add additional analysis tools as required. The tools within mIA allow users to assess basic (cell count, protein per cell, protein subcellular localization) and more advanced (engineered cell lines analysis, cell toxicity) biological image-based assays that employ advanced statistics and provides key assay performance metrics.

GRP-181 The Clinical Impact of Calcium-Ceftriaxone Interaction in Patients on Total Parenteral Nutrition

BackgroundA safety alert about the possibility of a potentially fatal interaction in patients, especially neonates, has been issued by the FDA. Patients treated with ceftriaxone and concomitant total parenteral nutrition...

ARTEFACT MOBILE DATA MODEL TO SUPPORT CULTURAL HERITAGE DATA COLLECTION AND INTERPRETATION

Abstract. This paper discusses the limitation of existing data structures in mobile mapping applications to support archaeologists to manage the artefact (any object made or modified by a human culture, and later recovered by an archaeological endeavor) details excavated at a cultural heritage site. Current limitations of data structure in the mobile mapping application allow archeologist to record only one artefact per test pit location. In reality, more than one artefact can be excavated from the same test pit location. A spatial data model called Artefact Mobile Data Model (AMDM) was developed applying existing Relational Data Base Management System (RDBMS) technique to overcome the limitation. The data model was implemented in a mobile database environment called SprintDB Pro which was in turn connected to ArcPad 7.1 mobile mapping application through Open Data Base Connectivity (ODBC). In addition, the design of a user friendly application built on top of AMDM to interpret and record the technology associated with each artefact excavated in the field is also discussed in the paper. In summary, the paper discusses the design and implementation of a data model to facilitate the collection of artefacts in the field using integrated mobile mapping and database approach.

SU-E-T-203: Development of a QA Software Tool for Automatic Verification of Plan Data Transfer and Delivery.

Consistency verification between the data from treatment planning system (TPS), record and verification system (R&V), and delivered recorder with visual inspection is time consuming and subject to human error. The purpose of this work is to develop a software tool to automatically perform such verifications. Using Microsoft visual C++, a quality assurance (QA) tool was developed to (1) read plan data including gantry/collimator/couch parameters, multi-leaf-collimator leaf positions, and monitor unit (MU) numbers from a TPS (Xio, CMS/Elekta, or RealART, Prowess) via RTP link or DICOM transfer, (2) retrieve imported (prior to delivery) and recorded (after delivery) data from a R&V system (Mosaiq, Elekta) with open database connectivity, calculate MU independently based on the DICOM plan data using a modified Clarkson integration algorithm, and (4) compare all the extracted data to identify possible discrepancy between TPS and R&V, and R&V and delivery. The tool was tested for 20 patients with 3DCRT and IMRT plans from regular and the online adaptive radiotherapy treatments. It was capable of automatically detecting any inconsistency between the beam data from the TPS and the data stored in the R&V system with an independent MU check and any significant treatment delivery deviation from the plan within a few seconds. With this tool being used prior to and after the delivery as an essential QA step, our clinical online adaptive re-planning process can be speeded up to save a few minutes by eliminating the tedious visual inspection. A QA software tool has been developed to automatically verify the treatment data consistency from delivery back to plan and to identify discrepancy in MU calculations between the TPS and the secondary MU check. This tool speeds up clinical QA process and eliminating human errors from visual inspection, thus improves safety.

Informatics Infrastructure for Syndrome Surveillance, Decision Support, Reporting, and Modeling of Critical Illness

To develop and validate an informatics infrastructure for syndrome surveillance, decision support, reporting, and modeling of critical illness. Using open-schema data feeds imported from electronic medical records (EMRs), we developed a near-real-time relational database (Multidisciplinary Epidemiology and Translational Research in Intensive Care Data Mart). Imported data domains included physiologic monitoring, medication orders, laboratory and radiologic investigations, and physician and nursing notes. Open database connectivity supported the use of Boolean combinations of data that allowed authorized users to develop syndrome surveillance, decision support, and reporting (data "sniffers") routines. Random samples of database entries in each category were validated against corresponding independent manual reviews. The Multidisciplinary Epidemiology and Translational Research in Intensive Care Data Mart accommodates, on average, 15,000 admissions to the intensive care unit (ICU) per year and 200,000 vital records per day. Agreement between database entries and manual EMR audits was high for sex, mortality, and use of mechanical ventilation (kappa, 1.0 for all) and for age and laboratory and monitored data (Bland-Altman mean difference +/- SD, 1(0) for all). Agreement was lower for interpreted or calculated variables, such as specific syndrome diagnoses (kappa, 0.5 for acute lung injury), duration of ICU stay (mean difference +/- SD, 0.43+/-0.2), or duration of mechanical ventilation (mean difference +/- SD, 0.2+/-0.9). Extraction of essential ICU data from a hospital EMR into an open, integrative database facilitates process control, reporting, syndrome surveillance, decision support, and outcome research in the ICU.

Modelling climate change in a Dutch polder system using the FutureViewR modelling suite

This paper describes the development of a hydrological modelling suite, FutureViewR, which enables spatial quantification of the complex interaction between climate change, land use and soil in the Quarles van Ufford (QvU) polder entangled in and under influence of the Dutch river delta. The soil–water–atmosphere–plant (SWAP) model is used in a grid-based mode. A river module was developed to take into account seepage and percolation in the polder as an effect of the interaction with the main rivers. A simple surface water model was linked to the grid-based SWAP models. The model suite is managed from a Visual Basic (VB) interface which links the different modules. The interface uses a mainstream database management system (MS SQLServer), structured query language (SQL) and open database connectivity (ODBC) to store, transfer, manipulate and analyse model inputs and outputs. The functionality of the FutureViewR modeling suite is demonstrated by modeling a climate change scenario for 2050. The preliminary analysis showed that it is likely that the dryer summers in combination with low water levels in the Rhine and Meuse will yield a decrease in agricultural production. The wetter winters do not necessarily result in an increase in discharge, since the initial soil moisture storage at the winter onset is lower due to the dryer summers. It is concluded that the effects of climate change on polder hydrology is more intense caused by the dependence on local climate conditions and water levels on the Rhine and Meuse rivers, which are mutually reinforcing.

Building a data warehouse for infection control

Recently, the convergence of several themes in health care has stimulated interest in exploiting data collected during clinical encounters to monitor and improve the quality of health care. Infection control departments can be supported by assembling previously collected electronic data into a data warehouse to monitor infections, report communicable diseases, and detect clusters of organisms. I present the rationale for constructing a data warehouse and describe the steps and challenges of developing a data warehouse to support infection control activities.

WebCN: A web-based computation tool for in situ-produced cosmogenic nuclides

Cosmogenic nuclide techniques are increasingly being utilized in geoscience research. For this it is critical to establish an effective, easily accessible and well defined tool for cosmogenic nuclide computations. We have been developing a web-based tool (WebCN) to calculate surface exposure ages and erosion rates based on the nuclide concentrations measured by the accelerator mass spectrometry. WebCN for 10Be and 26Al has been finished and published at http://www.physics.purdue.edu/primelab/for_users/rockage.html. WebCN for 36Cl is under construction. WebCN is designed as a three-tier client/server model and uses the open source PostgreSQL for the database management and PHP for the interface design and calculations. On the client side, an internet browser and Microsoft Access are used as application interfaces to access the system. Open Database Connectivity is used to link PostgreSQL and Microsoft Access. WebCN accounts for both spatial and temporal distributions of the cosmic ray flux to calculate the production rates of in situ-produced cosmogenic nuclides at the Earth’s surface.

Prolog Query Interface: A Set-Of-Mappings Approach With Optional Segmentation

A Prolog-based query interface with optional data segmentation via modules is presented in this paper. The motivation of this work is to provide an implementation of a useful, but simple interface that relieves the Prolog programmer from having to recall the component order within a tuple and the complete definitions of a set of underlying facts when forming declarative queries. The implementation includes a schema level representation and accompanying query predicates, such that the order and number of columns within a Prolog query becomes unimportant, resulting in increased data independence. The interface supports three architectures: 1) the traditional Prolog environment, 2) an environment in which Prolog ground clauses have been extracted from heterogeneous data sources, and 3) as an abstraction layer in a loosely coupled architecture with interfaces to Open Database Connectivity (ODBC) compliant sources in which data is accessed as though it existed as ground clauses within the Prolog environment. As compared to traditional approaches to forming a Prolog query, the current implementation of the interface introduced an additional 17.6 microseconds to retrieve a tuple using a 2.0 GHz Intel Xeon processor with 1GB of RAM.

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.