Chapter

Introducing JDBC

January 2015

DOI:10.1007/978-1-4842-0641-6_12

In book: Pro Java 8 Programming (pp.479-528)

Authors:

When your application creates or uses large amounts of data, it’s usually necessary for that information to be stored in a database. Although there has been significant growth in the use of NoSQL databases in recent years, the most widely used type of database is still a relational database, and some examples of relational database products are Oracle, DB2, Sybase, MySQL, and Microsoft SQL Server. A relational database product is sometimes referred to as a relational database management system (RDBMS, or simply DBMS), while a database usually refers to a collection of data managed by a DBMS.

ResearchGate has not been able to resolve any citations for this publication.

ResearchGate has not been able to resolve any references for this publication.

Article

Integration of Native Functions in an Open Source Database Management Environment: A Study

Databases and Database Management Systems (DBMS) have become essential components of everyday life in modern society. There are many RDBMS like Oracle, MySQL,PostgreSQL, Ingres and DB2, which provide different capabilities and features to the users. Being an open source database management system, MySQL permits the users to use, change, and improve and to redistribute it in modified or unmodified ... [Show full abstract] forms with proper licenses from the developers. Comparing with other database management system like Oracle, MySQL lacks some basic native functions such as SINH (), COSH (), TANH (), INITCAP (), ASINH (), ACOSH (), ATANH ().Our work aims to overcome such shortcomings by integrating some of these functions into MySQL's code directory. An attempt has been made to include functions such as SINH (), COSH () and TANH() in MySQL.

Article

Selection of Database Management System with Fuzzy-AHP for Electronic Medical Record

September 2015 · International Journal of Information Engineering and Electronic Business

Database selection is one of the main problems in designing electronic medical record (EMR) Software, since there are many different data with different types and formats in it. This work provides an approach for selecting suitable database management system (DBMS) with fuzzy analytical hierarchical process that gives capabilities of requirements to electronic medical record software. Criteria ... [Show full abstract] are choose based upon capabilities of requirements including supporting from type of operating system and programming language, maximum of table size, indexing, replication and access control. In addition, alternatives are PostgreSQL, MySQL, Oracle, DB2 and Microsoft SQL Server. According to the application of fuzzy analytical hierarchical process a ranking is obtained to decision making the best database management system for electronic medical record software.

Chapter

SQL Databases

January 2012

Adam Aspin

An awful lot of the data that you will be called upon to load into SQL Server is probably already stored in a relational database. While you can certainly export from most of the currently available commercial SQL-based databases into a text or XML file, and from there into SQL Server, there are also standard ways of connecting directly to most RDBMSs (relational database management systems) and ... [Show full abstract] then extracting data from them into the Microsoft RDBMS. In this chapter, therefore, we will be looking at some of the available ways of ingesting and linking to data from the following: Oracle DB2 MySQL Sybase Teradata PostgreSQL

Article

Design methodology for a bioinformatic application: the case of aMAZE

July 2003

Introduction The aMAZE system is a workbench for the management, the annotation and the analysis of information on networks of biochemical pathways and cellular processes. This workbench is composed of a database, for the storage of the data, and an application, for the data management, the annotation and the analysis. In this poster we describe the methodology we adopted for the design of the ... [Show full abstract] data model used for the aMAZE database and application. Some Details 1. The dilemma For the development of a workbench with the above mentioned goals, a choice of paradigm for data modeling and data storage. With regards to persistent data storage, the relational model seems to be the best choice, both for robustness and efficiency. The relational model has been implemented in many DataBase Management Systems (DBMS), as commercial or open source packages (e.g. Oracle, Sybase, PostgreSQL, or even MySQL). RDBMS are the most widely used in many different areas for very huge and mission critica

Article

Dynamic data migration for distributed databases across the network

January 2013

This paper presents the idea of automation of transfer of data design as well as data sets from one Data Base Management System (DBMS) to other across the network. At the source side, the user selects a given RDBMS like Oracle, MS SQL server, DB2, Sybase etc. and interrogates to get a list of tables present in the system. The user has to choose a table, select the columns of the table to migrate ... [Show full abstract] and sets up a filter condition for the records to pick. The user also specifies the destination RDBMS system that need not be the same type as the source.The definition of the table selected and its records are read by the application, converted into socket object and transmitted to the destination side application (server) using the network. The destination side application receives the Object, parses them and creates the required tables and records in the destination RDBMS. This proposed data migration model will be useful for an administrator to switch from one DBMS system to another as well to enable efficient dynamic data migration with minimal overload; hence the entire data conversion becomes reliable, fast and efficient.

Article

Full-text available

CONSTRAINT BASIS DATA SEBAGAI FONDASI YANG KUAT DALAM PENGEMBANGAN SISTEM INFORMASI

January 2012

Suwanto Raharjo

Database is play important roles in computer based information system. Almost computer based information system will used database to store the data and information. Relational database management system (RDBMS) is one of database management system widely used in information system to storing data. RDMS such as Oracle, MS SQL Server, PostgreSQL, DB2 and MySQL are well known database management ... [Show full abstract] system use in information system. Information system will collects, process and stores data from organizationtextquoterights resources for many purposes that supports the management functions of organization. The strored data must be good, clean, correct and valid data, free from garbage to support the functional of information system, data validation is a choice that can be done. Data validation can be done into two approaches application software code or database constraints. Many information system will using application software code to validate the data, application software usually developed using PHP, Delphi, VB or others. Only fewer information system application use database constraints to validate data, the study will show benefit of using database constraints to protect un-correct data enter into a system