A
ActiveX Data Object (ADO)
Microsoft library for accessing data sources through OLE DB. Typically it is used to query or modify data stored in a relational database.
American National Standards Institute (ANSI)
The private, non-profit organization responsible for approving United States standards in many areas, including computers and communications.
B
binary large object (BLOB)
A large database object that can be anything that doesn’t require character set conversion. This includes MIDI, MP3, PDF, graphics and much more. BLOBS can be up to 2 GB in size.
C
Client Cursor Engine (CCE)
When the consumer specifies a client-side cursor, ADO uses the Client Cursor Engine that is part of Microsoft Data Access Components (MDAC). The CCE is an OLE DB rowset implementation.
character large object (CLOB)
A pure character-based large object in a database. It can be a large text file. HTML, RTF or other character-based file. CLOBs can be up 2 GB in size. Also see BLOB.
Component Object Model (COM)
The Microsoft OLE object-oriented programing model that defines a standard mechanism in Windows environments for creating program components and for clients and components to interact. In COM, clients access a component through a pointer to an interface on the component. Every COM component supports the interface.
D
database administrator (DBA)
A person responsible for the design and management of one or more databases and for the evaluation, selection and implementation of database management systems.
DBC
Acronym for Database Computer.
Database Manipulation Language (DML)
In Teradata SQL, the statements and facilities that manipulate or change the information content of the database. These statements include INSERT, UPDATE, and DELETE.
F
foreign key (FK)
One or more table attributes that can uniquely identify a record in another table. A foreign key is the primary key of another table.
I
Internet Protocol version 4 (IPv4)
The dominant Internet layer protocol at the time of this publication. IPv4 uses 32-bit addresses often represented in a textual format similar to “153.65.20.48”.
Internet Protocol version 6 (IPv6)
The designated successor to IPv4. IPv6 uses 128-bit addresses, for example: 2001:db8:85a3::8a2e:370:7334.
L
large object (LOB)
A database object that is large in size. LOBs can be up to 2 gigabytes. There are two types of LOBs: CLOBs and BLOBs. CLOBs are character-based objects, BLOBs are binary-based objects.
M
Massively Parallel Processing (MPP)
A Massively Parallel Processing (MPP) implementation of Teradata consists of multiple SMP nodes that work together. The nodes are connected through the BYNET, a combination of hardware and software that allows the vprocs (PEs and AMPs) to communicate with each other. Teradata is a linearly expandable database system because as additional nodes and vprocs are added, the system capacity scales in a linear fashion.
Microsoft Data Access Components (MDAC)
Microsoft's umbrella term for their ActiveX Data Objects (ADO), OLE DB, and Open Database Connectivity (ODBC) libraries. Together, these provide access to a variety of data sources, both relational (SQL) and nonrelational. MDAC is the technology that supports Universal Data Access, Microsoft's strategy for providing access to information across the enterprise.
MSDN
Microsoft Developer’s Network.
O
OLE DB
A set of component object model (COM) interfaces that provide applications with uniform access to data stored in diverse information sources and that also provide the ability to implement additional database services.
P
primary key (PK)
A column in a table whose value uniquely identifies its row in the table. It cannot be a NULL value.
S
Single Sign On (SSO)
An authentication option that allows Teradata Database users to access Teradata Database based on authorized network usernames and passwords. This feature simplifies the procedure requiring users to enter an additional username and password when logging on to Teradata Database using client applications.
Stored Procedure Language (SPL)
Teradata provides SPL to create stored procedures. A stored procedure contains SQL to access data from within Teradata and SPL to control the execution of the SQL.
Structured Query Language (SQL)
An industry-standard language for creating, updating, and querying RDBMSs. IBM developed SQL in the 1970s for use in System R. It is the default standard as well as being an ISO and an ANSI standard. It is often embedded in general-purpose programming languages. A programming language used to communicate with Teradata Database.
Symmetric Multi Processing (SMP)
An SMP platform consists of a single Teradata node. An SMP system has multiple CPUs that work together. All applications run under a single operating system on the node. The AMPs and PEs on an SMP system communicate through the BYNET software that handles the message queuing and flow control.
U
UDL
Universal Data Link.