TOC PREV NEXT INDEX



Easysoft JDBC-ODBC Bridge User Guide - Glossary

Terms and definitions

API

    Application Programmer Interface. An API is a published set of function calls and constants allowing different programmers to utilize a ready-written library of subroutines.

Applet

    A Java program that has certain restrictions placed upon it, such as restricted network and filesystem access. Applets are able to run in a web browser.

Application

    By contrast to an Applet, a Java Application has unrestricted network and file access.

Authorization code

You must have an authorization code for the Easysoft product you wish to license in order to obtain a purchased license. When you purchase a product your authorization code is emailed to you. You do not need an authorization code to obtain a trial license.

Bitmask

    A value which, when written out in binary, has a meaning assigned to each digit, which can be 0 or 1. This is a very efficient way of storing a number of flags in a small amount of memory. When viewed in decimal it is a single number resulting from adding up the values of the individual bits, worth 1, 2, 4, 8, 16, 32 and so on.

Client/Server

    The name given to the architecture whereby one process (the server) keeps track of global data, and another (the client) is responsible for formatting and presenting the data. The client requests queries or actions be performed on the data by the server. Often these processes run on different hosts across a local-area network.

Column

    The vertical dimension of a table. Columns are named and have a domain (or type). The term column might refer to only the definition of a column (i.e. its name and type), or to all the data in it.

Connection String

    ODBC driver managers accept a connection string when a client connects. Ideally it contains all necessary attribute values to make the connection to a data source, but provision is made for the driver to negotiate with the application or the user for any missing information.

Data source

    In the context of JDBC or ODBC, a data source is a database or other data repository coupled with an ODBC driver.

DLL

    Dynamic Link Library. Windows' mechanism for shared object code. See also Shared Object.

to Download

    To retrieve data from a remote machine (or "the internet") to your local machine. Mechanisms for achieving this include FTP and the World Wide Web.

Driver

    In the context of JDBC or ODBC, software that accesses a proprietary data source, providing a standardized view of the data to ODBC.

Driver Manager

    Software whose main function is to load drivers. ODBC or JDBC applications request a DSN through the Driver Manager. The Driver Manager loads the driver specified in the DSN's configuration file. In Windows, the ODBC Data Source Administrator is used to set up the Driver Manager.

DSN

    Data Source Name. A name associated with an ODBC data source. Driver Managers, such as unixODBC or the Microsoft Windows Driver Manager, use the Data Source Name to cross-reference configuration information and load the required driver.

Field

    A placeholder for a single datum in a record. For example, you can have a Surname field in a Contact Details record. Called a cell in Microsoft Access.

Flags

    Single-bit values, representing `Yes' or `No'. Also called "True" and "False".

Host

    A computer visible on the network.

HTTP

    HyperText Transfer Protocol. The means of transferring web pages.

HTTPAdmin

    An NT user name, valid on the machine the server is running on. This is the only user allowed to amend settings, or display certain items, through the Web Administrator.

JDBC (Java DataBase Connectivity)

    A Java API for database access based on the ODBCAPI, but includes an object-oriented interface to the underlying data source.

JDK (Java Development Kit)

    A software development environment for writing Java applets and applications.

JRE (Java RunTime Environment)

    A subset of the Java Development Kit (JDK) which supports the execution (but not the development) of Java applications and consists of the Java Virtual Machine (JVM), the core classes, and supporting files.

JVM (Java Virtual Machine)

    Software that interprets and executes the byte codes in Java class files like a microprocessor would execute machine code. There are many virtual machines available from different vendors and for different purposes.

Middleware

    Software that is placed between the client and the server to improve or expand functionality.

ODBC (Open DataBase Connectivity)

    A standard API for connecting application programs to relational database systems through a suitable driver. ODBC is available on a wide number of platforms and the Easysoft JDBC-ODBC Bridge allows the database and the application to reside on different machines across the network.

Operating System

    Academics still haven't agreed on the actual definition of an operating system, but a working definition can be:

    A collection of software programs, APIs and working practices that control and integrate the execution of system functions on behalf of application programs.

Platform

    The term platform normally covers the hardware and operating system as a unit. For example, a PC running Microsoft Windows, a PC running BSD Unix, and a Sun system running Solaris are three different platforms.

Server

    A computer, or host, on the network, designed for power and robustness rather than user-friendliness and convenience. Servers typically run round-the-clock and carry central corporate data.

¯ OR ¯

    A process performing the centralized component of some task, for example extracting information from a corporate database. See also Client/Server.

Shared Object

    A piece of object code (i.e. a program fragment) that can be loaded and executed by other programs.

SQL (Structured Query Language)

    A standard language for interacting with relational database systems, based on Relational Theory.

System data source

    In the context of ODBC under Microsoft Windows, a data source which can be accessed by any user on a given system. See also User data source.

Table

    A data set in a relational database, composed of rows and columns. For example:

software
vendor name
Easysoft Easysoft JDBC-ODBC Bridge
Mysoft My JDBC Application

    This table has two columns; vendor, and name. It has two rows: one corresponding to Easysoft JDBC-ODBC Bridge and the other corresponding to MySoft's Java application. The term table can also apply to just the definition of the table, without its data.

User data source

    An ODBC Data Source with access limited to a specific user on a given system. See also System data source.

Web Administrator

    A web server run by the Easysoft JDBC-ODBC Bridge which can be used to display, amend and configure selected parameters.


Copyright Notice
TOC PREV NEXT INDEX