Easysoft ODBC-JDBC Gateway User's 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

    An Application Program ("Application" or "App") is a program that applies the computer to solving some real-world problem. In ODBC terms, it is the program connecting to the data source.

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 task (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 ODBC terms, a data source is a database or other data repository coupled with an ODBC Driver, which has been given a Data Source Name (see DSN) to identify it to the ODBC Driver Manager.

DLL

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

Download

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

Driver

    See ODBC driver.

Driver Manager

    Software whose main function is to load ODBC drivers. ODBC applications connect to the Driver Manager and request a DSN. 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 MS Access.

Flags

    Single-bit values, representing `Yes' or `No'. When more than one flag is present, they are normally stored in a bitmask.

Host

    A computer visible on the network.

HTTP

    HyperText Transfer Protocol. The means of transferring web pages.

JDBC (Java DataBase Connectivity)

    A Java API for database access based on the ODBC API, 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.

ODBC driver

    Software that accesses a proprietary data source, providing a standardized view of the data to ODBC.

Operating System

    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 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 Client/Server.

Shared Object

    A piece of object code (i.e. a program fragment) for loading and executing 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 ODBC-JDBC Gateway
MySoft My ODBC Client Application

    This table has two columns; vendor, and name. It has two rows: one corresponding to the Easysoft ODBC-JDBC Gateway and the other corresponding to MySoft's ODBC client software. 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.