Easysoft ODBC-Google-Analytics Driver User's Guide - Glossary

Terms and definitions

Application Programmer Interface (API)

A published set of function calls and constants allowing different programmers to utilize a ready-written library of subroutines.

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.

Column

The vertical component of a database table. A column has a name and a particular data type (for example, character, decimal, or integer).

Commit

To end a unit of work by releasing locks so that the database changes made by that unit of work can be perceived by other processes. This operation makes the data changes permanent.

Cursor

An entity that maps over a result set and establishes a position on a single row within the result set. After the cursor is positioned on a row, operations can be performed on that row, or on a block of rows starting at that position. The most common operation is to fetch (retrieve) the current row or block of rows.

Data Definition Language

The subset of SQL statements that define all attributes and properties of a database and its objects. DDL statements typically start with CREATE, ALTER, or DROP.

Data Manipulation Language

The subset of SQL statements that is used to retrieve and manipulate data. DML statements typically start with SELECT, INSERT, UPDATE, or DELETE.

Data source

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.

Data type

An attribute that specifies what type of information can be stored in a column, parameter, or variable.

DBMS

Database Management System -- software that handles access to a database.

Dimension

Every report in Google Analytics is made up of dimensions and metrics.

Dimensions describe characteristics of your users, their sessions and actions. The dimension City describes a characteristic of sessions and indicates the city, for example, "Paris" or "New York", from which each session originated. The dimension Page describes a characteristic of page view actions and indicates the URL of each page that was viewed.

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 data source name (DSN). The Driver Manager loads the driver specified in the DSN's configuration file. On 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.

DSN-less connection

A type of data connection that is created based on information in a data source name (DSN), but is stored as part of a project or application. DSN-less connections are especially useful for Web applications because they let you move the application from one server to another without re-creating the DSN on the new server.

Host

A computer visible on the network.

Index

A data structure that optimizes queries.

License key

A string that is provided by Easysoft for use in the licensing process.

Metric

Metrics are quantitative measurements. The metric Sessions is the total number of sessions. The metric Pages/Session is the average number of pages viewed per session.

NULL

An entry that has no explicitly assigned value. NULL is not equivalent to zero or blank. A value of NULL is not considered to be greater than, less than, or equivalent to any other value, including another value of NULL.

ODBC

Open Database Connectivity -- a programming interface that enables applications to access data in database management systems that use Structured Query Language (SQL) as a data access standard.

ODBC driver

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

Primary Key

A record's unique immutable identifier. In an RDBMS, the primary key is typically an integer stored in each row's id field.

Record

A group of related fields (columns) of information treated as a unit. A record is more commonly called a row in a relational database.

Result set

A set of row values as returned by, for example, a cursor or procedure.

Row

The horizontal component of a table, consisting of a sequence of values, one for each column of the table.

Segment

A Segment is a subset of your Analytics data. For example, of your entire set of users, one Segment might be users from a particular country or city. Another Segment might be users who purchase a particular line of products or who visit a specific part of your site.

Structured Query Language (SQL)

A standardised language for defining and manipulating data in a relational database.

SQL-92

The version of the SQL standard published in 1992. The international standard is ISO/IEC 9075:1992 Database Language SQL. The American National Standards Institute (ANSI) also published a corresponding standard (Data Language SQL X3.135-1192), so SQL-92 is sometimes referred to as ANSI SQL in the United States.

Table

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

Transaction

An atomic series of SQL statements that make up a logical unit of work. All of the data modifications made during a transaction are either committed together as a unit or rolled back as a unit.