Neoview Database Administrator's Guide (R2.5)

Glossary
business
intelligence (BI)
A type of enterprise decision-support system (DSS).
data source The data a user wants to access and the associated operating system, database management
system (DBMS), and network platform used to access the DBMS. To manage ODBC client access
to data in a database appliance, you can add, configure, and delete ODBC data sources on the
client workstation.
data warehouse A large database that stores all data for a company in a structured way.
database
administrator
(DBA)
The person who defines or manages a database or controls access to a database.
driver A software program that implements a connection to a particular database management system,
such as the HP Neoview platform.
extent A file attribute that sets the size of the extents (units of contiguous disk space) that are allocated
for a table, index, or a partition of a table or index.
GUI Graphical user interface.
index An index provides an alternate access path (alternate key) to a table that differs from the primary
access path (clustering key) defined for the table at creation time. An index, stored in a
key-sequenced file, includes columns for the clustering key and the alternate key.
Open Database
Connectivity
(ODBC)
An interface specification for an application programming interface (API) that defines a standard
set of routines that an ODBC application can use to access data in a data source.
schema A named collection of database objects (for example, tables, views, and indexes). Each database
object is described in only one schema, although an object can refer to objects described in other
schemas. A schema cannot contain other schemas. Each schema is described in a catalog. The
schema is the unit of ownership; all database objects in a schema are owned by the schema
owner.
table A logical representation of data in a database in which a set of records is represented as a
sequence of rows, and the set of fields common to all the records is represented as a series of
columns. The intersection of a row and column represents the data value of a particular field
in a particular record. As a database object, a table defines data in columns and defines the
physical characteristics of the table.
view A logical table that contains no data. A view is derived by projecting a subset of the columns,
restricting a subset of the rows, or both, from one or more base tables or other views.
33