ADO Glossary
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
A
absolute URL
ActiveX control
ADISAPI
Advanced Data Internet Server Application Programming Interface
aggregate function
alias
apartment threading
asynchronous operation
B
binding entry
bitmask
bookmark
business object
business rule
C
calculated expression
chapter
chapter-alias
character set
child
child-alias
class identifier
CLSID
client tier
COM
COM component
comparison operator
component
Component Object Model
compound file
constant
cursor
D
data binding
data definition language
data manipulation language
data provider
data shaping
data source name
data source tier
DCOM
DDL
default stream
disconnected recordset
distributed application
Distributed Component Object Model
DLL
DML
document source provider
DSN
dynamic-link library
dynamic property
E
enumeration
event
event handler
F
G
H
handler
hierarchical recordset
hierarchy
I
Internet Server Application Programming Interface
ISAPI
J
K
key
L
M
marshaling
middle tier
MIME
Multi-purpose Internet Mail Extension
N
node
O
object variable
ODBC
OLE DB
Open Database Connectivity
optimistic locking
ordinal value
P
parameterized command
parent
parent-alias
parent-child relationship
persist
pessimistic locking
pooling
ProgID
programmatic identifier
proxy
Q
R
relative URL
remote data source
resource record
root
rowset
S
schema
scope
service provider
shaped Recordset
sibling
stored procedure
stub
sub-node
synchronous operation
T
tree
U
Uniform Resource Locator
URL
V
W
Web server
X
Y
Z
Terms and Definitions
absolute URL
A fully qualified URL that specifies the location of a resource that resides on the Internet or an intranet. See also URL and relative URL.
Return to top
ActiveX control
Self-registering, in-process COM component that often has a visual element either at design time or run time. ActiveX controls also have the ability to communicate with an Active Document container, such as Microsoft Internet Explorer.
Return to top
ADISAPI (Advanced Data Internet Server Application Programming Interface)
An ISAPI DLL that provides parsing, Automation control, Recordset marshaling, and MIME packaging. The ADISAPI component works through the API provided by Internet Information Services (IIS). See also ISAPI.
Return to top
aggregate function
In a query, a function such as COUNT, AVG, or STDEV that calculates a value using all the rows in a column of a table. In writing expressions and in programming, you can use SQL aggregate functions (including the three listed above) and domain aggregate functions to determine various statistics.
Return to top
alias
An alternate name you give to a column or expression in an SQL SELECT statement, often shorter or more meaningful. For example, BobSales is the alias in the following SELECT statement: "Select wr-Sales as BobSales from SalesDB". An alias can be used to dynamically assign columns to control bindings on the DataControl object.
Return to top
apartment threading
A COM threading model where all calls to an object occur on one thread. In apartment threading, COM synchronizes and marshals calls. See also COM.
Return to top
asynchronous operation
An operation that returns control to the calling program without waiting for the operation to complete. Before the operation is complete, code execution continues. See also synchronous operation.
Return to top
binding entry
A mapping between a field in a table and a variable. In the ADO Visual C++ extensions, Recordset fields are mapped to C/C++ variables.
Return to top
bitmask
A numeric value intended for a bit-by-bit value comparison with other numeric values, typically to flag options in parameter or return values. Usually this comparison is done with bitwise logical operators, such as And and Or in Visual Basic, & and | in C++.
For example, the ADO FieldAttributeEnum values can be used as bitmasks to determine the attributes of a field. Suppose you wanted to determine if a field was updateable. You could test for this with the following expression in Visual Basic:
Field.Attributes AND adFldUpdatable
If the result is TRUE, then the field is updateable.
Return to top
bookmark
A marker that uniquely identifies a row within a set of rows so that a user can quickly navigate to it.
Return to top
business object
An object that performs a defined set of operations, such as data validation or business rule logic. Business objects usually reside on the middle tier.
Return to top
business rule
The combination of validation edits, logon verifications, database lookups, policies, and algorithmic transformations that constitute an enterprise's way of doing business. Also known as business logic.
Return to top
calculated expression
An expression that is not constant, but whose value depends upon other values. To be evaluated, a calculated expression must obtain and compute values from other sources, typically in other fields or rows.
Return to top
chapter
A reference to a range of rows from a data source. In ADO, a chapter is typically a reference to another Recordset.
Chapter columns make it possible to define a parent-child relationship where the parent is the Recordset containing the chapter column and the child is the Recordset represented by the chapter.
Return to top
chapter-alias
An alias that refers to the column appended to the parent.
Return to top
character set
A mapping of a set of characters to their numeric values. For example, Unicode is a 16-bit character set capable of encoding all known characters and used as a worldwide character-encoding standard.
Return to top
child
The dependant side of a hierarchical relationship. A child is a node in a hierarchical structure that has another node above it (closer to the root). See also child-alias, parent-child relationship, parent.
Return to top
child-alias
An alias that refers to the child. See also alias, child.
Return to top
CLSID (class identifier)
A universally unique identifier (UUID) that identifies a COM component. Each COM component has its CLSID in the Windows Registry so that it can be loaded by other applications. See also ProgID, COM.
Return to top
client tier
A logical layer of a distributed system that typically presents data to and processes input from the user, sometimes referred to as the front end. Usually, the client tier requests data from a server based on input, and then formats and displays the result. See also middle tier, data source tier, distributed application.
Return to top
COM (Component Object Model)
A binary standard that enables objects to interoperate in a networked environment regardless of the language in which they were developed or on which computers they reside. COM-based technologies include ActiveX Controls, Automation, and object linking and embedding (OLE). COM allows an object to expose its functionality to other components and to host applications. It defines both how the object exposes itself and how this exposure works across processes and across networks. COM also defines the object's life cycle.
Return to top
COM component
Binary file — such as .dll, .ocx, and some .exe files — that supports the COM standard for providing objects. Such a file contains code for one or more class factories, COM classes, registry-entry mechanisms, loading code, and so on.
Return to top
comparison operator
An operator that compares two expressions and returns a Boolean value.
A criteria parameter that may be expressed as ">" (greater than), "<" (less than), "=" (equal), ">=" (greater than or equal), "<=" (less than or equal), "<>" (not equal), or "like" (pattern matching).
Return to top
component
An object that encapsulates both data and code, and provides a well-specified set of publicly available services.
Return to top
compound file
An implementation of COM structured storage for files. A compound file stores separate objects in a single, structured file consisting of two main elements: storage objects and stream objects. Together, they function like a file system within a file. For more information, see Compound Files in the Microsoft® Platform SDK.
A number of individual files bound together in one physical file. Each individual file in a compound file can be accessed as if it were a single physical file.
Return to top
constant
A numeric or string value that does not change. Named ADO enumerations (enumerated constants) can be used in your code instead of actual values, for example, adUseClient is a constant whose value is 3. (Const adUseClient = 3). See also enumeration.
Return to top
cursor
A database element that controls record navigation, updateability of data, and the visibility of changes made to the database by other users. Originally
Return to top
data binding
The process of associating the objects or controls of an application to a data source. A control associated with a data source is called a data-bound control.
The contents of a data-bound control are associated with values from a database. For example, a grid control that is bound to a Recordset object can be updated when the rows in the Recordset are updated. When new values are retrieved by the Recordset, new values are displayed in the grid.
Return to top
data provider
Software that exposes data to an ADO application either directly or via a service provider. See also service provider.
Return to top
data shaping
A technique which makes use of a formalized syntax (called Shape language) to define a specialized Recordset object (called a shaped Recordset) that contains not just data, but also references to other Recordset objects and/or computed values based on those other Recordset objects.
Return to top
data source tier
A logical layer of a distributed system that represents a computer running a DBMS, such as an SQL Server database. See also client tier, middle tier, distributed application.
Return to top
DCOM
A wire protocol that enables COM components to communicate directly with each other across a network. See also COM, component.
Return to top
DDL (Data Definition Language)
Those statements in SQL that define, as opposed to manipulate, data. The schema of a database is created or modified with DDL. For example, CREATE TABLE, CREATE INDEX, GRANT, and REVOKE are SQL DDL statements.
Return to top
default stream
A text or binary stream (represented by a Stream object) that is associated with Record or Recordset objects when using certain OLE DB providers, such as the Microsoft OLE DB Provider for Internet Publishing. The default stream typically contains the contents of a file such as the HTML code for the root of a Web site.
Return to top
distributed application
A program written so that the processing can be divided across multiple computers over a network. Typically, a distributed application is divided into presentation, business logic, and data store layers, or tiers. See also client tier, middle tier, data source tier.
Return to top
disconnected Recordset
A Recordset object in a client cache that no longer has a live connection to the server. If the original data source needs to be accessed again for some reason, such as updating data, the connection must be re-established. However, the collections, properties, and methods of a disconnected Recordset can still be accessed.
Return to top
DLL (dynamic-link library)
A file that contains one or more functions that are compiled, linked, and stored separately from the processes that use them. The operating system maps the DLLs into the address space of the calling process when the process is starting, or while it is running.
Return to top
DML (Data Manipulation Language)
Those statements in SQL that manipulate, as opposed to define, data. The values in a database are selected and modified with DML. For example, INSERT, UPDATE, DELETE, and SELECT are SQL DML statements.
Return to top
document source provider
A special class of providers that manage folders and documents. When a document is represented by a Record object, or a folder of documents is represented by a Recordset object, the document source provider populates those objects with a unique set of fields that describe characteristics of the document, instead of the actual document itself. See also resource record.
Return to top
DSN (data source name)
The collection of information used to connect your application to a particular ODBC database. The ODBC Driver Manager uses this information to create a connection to the database. A DSN can be stored in a file (a file DSN) or in the Windows Registry (a machine DSN).
Return to top
dynamic property
A property specific to a data provider or the cursor service. The Properties collection of an object is populated with these automatically ("dynamically"). An object has no dynamic properties until it is connected to a data source through a particular data provider. See also data provider, cursor.
Return to top
enumeration
A list of named constants. Enumerated values need not be unique. However the name of each value must be unique within the scope where the enumeration is defined. In ADO, enumerations are used for numeric parameter and return values, to add meaning to ADO code and to shield the developer from the numeric values (which may change from version to version). For example, to open a static Recordset, use the adOpenStatic enumerated value:
Recordset.Open ,,adOpenStatic
Also referred to as enumerated constant. See also constant.
Return to top
event
An action recognized by an object, for which you can write code to respond. Events can be generated by command execution, transaction completion, recordset navigation, and data updates, among other actions. See also event handler.
Return to top
event handler
An event handler is the code that is executed when an event occurs. See also event.
Return to top
handler
A routine that manages a common and relatively simple condition or operation, such as error recovery or data management.
Return to top
hierarchical Recordset
A Recordset that contains another Recordset. See also data shaping, chapter.
For more information, see Accessing Rows in a Hierarchical Recordset
Return to top
hierarchy
In general, a hierarchy is a ranked structure with a top level and subordinate levels. In ADO, hierarchical Recordsets are used to represent the parent-child relationship between a record and a chapter. Also in ADO, Record and Stream objects can be used to access hierarchical tree structures such as a folder and documents. ADO MD also includes Hierarchy objects to represent a relationship between the levels of a dimension in an OLAP cube. See also hierarchical Recordsets, parent-child relationship, chapter, tree.
Return to top
ISAPI (Internet Server Application Programming Interface)
A set of functions for Internet servers, such as a Windows NT® Server/Windows 2000 Server running Microsoft® Internet Information Services (IIS).
Return to top
key
A column or columns in a table that uniquely identify a row; often used to index a table.
Return to top
marshaling
The process of packaging, sending, and unpackaging interface method parameters across thread or process boundaries.
Return to top
middle tier
The logical layer in a distributed system between a user interface or Web client and the database. This is typically where business objects are instantiated. The middle tier is a collection of business rules and functions that generate and operate upon receiving information. They accomplish this through business rules, which can change frequently, and are thus encapsulated into components that are physically separate from the application logic itself. Also known as application server tier. See also distributed application, client tier, data source tier.
Return to top
MIME (Multi-purpose Internet Mail Extension)
An Internet protocol originally developed to allow exchange of electronic mail messages with rich content across heterogeneous network, machine, and e-mail environments. In practice, MIME has also been adopted and extended by non-mail applications.
MIME is a standard that allows binary data to be published and read on the Internet. The header of a file with binary data contains the MIME type of the data; this informs client programs (Web browsers and mail packages, for instance) that they will need to handle the data in a different way than they handle straight text. For example, the header of a Web document containing a JPEG graphic contains the MIME type specific to the JPEG file format. This allows a browser to display the file with its JPEG viewer, if one is present.
Return to top
node
An element in a hierarchical tree structure. A node may be the root, or the child of another node. A node can also be the parent of multiple children. See also hierarchy, tree, root, child, parent.
Return to top
object variable
A variable that contains a reference to an object. For example,
objCustomObjectis a variable that points to an object of type CustomObject:
Set objCustomObject = CreateObject(adodb.Recordset)
Return to top
ODBC (Open Database Connectivity)
A standard programming language interface used to connect to a variety of data sources. This is usually accessed through Control Panel, where data source names (DSNs) can be assigned to use specific ODBC drivers.
Return to top
OLE DB
A set of interfaces that expose data from a variety of sources using COM. OLE DB interfaces provide applications with uniform access to data stored in diverse information sources. These interfaces support the amount of DBMS functionality appropriate to the data source, enabling it to share its data. See also COM.
Return to top
optimistic locking
A type of locking in which the data page containing one or more records, including the record being edited, is unavailable to other users only while the record is being updated by the Update method, but is available before and after the call to Update.
Optimistic locking is used when the Recordset object is opened with the LockType parameter or property set to adLockOptimistic or adLockBatchOptimistic. See also pessimistic locking.
Return to top
ordinal value
The numeric location of an item within an order. In an ADO collection, the ordinal value of the first item is zero (0). The next item is one (1), and so on.
Return to top
parameterized command
A query or command that allows you to set parameter values before the command is executed. For example, a SQL string can be parameterized by embedding parameter markers in the SQL string (designated by the '?' character). The application then specifies values for each parameter and executes the command.
Return to top
parent
The controlling side of a hierarchical relationship. In a hierarchical structure, a parent has one or more child nodes directly beneath it in the hierarchy. See also parent-alias, parent-child relationship, child.
Return to top
parent-alias
An alias that refers to the parent. See also alias, parent.
Return to top
parent-child relationship
A relationship in a hierarchical structure in which the parent is one level higher and directly associated with one or more children. A child is one level lower and must have one parent. See also parent, child.
Return to top
persist
To save data in a permanent state, such as saving a Recordset to a file.
Return to top
pessimistic locking
A type of locking in which the page containing one or more records, including the record being edited, is unavailable to other users to ensure that an update will be made. Pessimistic locking behavior is defined by the OLE DB provider. Typically, records are locked upon editing and remain unavailable until the Update method has completed.
Pessimistic locking is enabled when the Recordset object is opened with the LockType parameter or property set to adLockPessimistic. See also optimistic locking.
Return to top
pooling
A performance optimization based on using collections of pre-allocated resources, such as objects or database connections. It is more efficient to draw an existing resource from the pool than to create a new resource.
Return to top
ProgID (programmatic identifier)
A unique name mapped to the Windows registry by a COM application. The ProgID for an ADO Connection is "ADODB.Connection". See also CLSID, COM.
Return to top
proxy
An interface-specific object that provides the parameter marshaling and communication required for a client to call an application object that is running in a different execution environment, such as on a different thread or in another process. The proxy is located with the client and communicates with a corresponding stub that is located with the application object that is being called. See also stub.
Return to top
relative URL
A partially qualified URL that specifies a resource on the Internet or an intranet whose location is relative to a starting point specified by an absolute URL or equivalent ADO Connection object. In effect, the concatenated absolute and relative URLs consitute a complete URL. See also URL and absolute URL.
Return to top
remote data source
A data source that exists on a another computer, rather than on the local system (where the client application runs).
Return to top
resource record
A record from a document source provider that contains fields for the definition and description of a folder or document. The document itself is not contained in the resource record but typically can be accessed by the default stream or a field in the resource record containing a URL. See also document source provider, default stream, URL.
Return to top
root
The top level in a hierarchical tree structure. The root node has no parents, but may have children. See also hierarchy, tree, parent, child.
Return to top
rowset
A set of rows from a data source, all having the same field schema. A rowset can represent all or some fields from a table. A rowset can also represent a virtual table, created by a query or a join of two or more tables. In ADO, rowsets are represented by Recordset objects.
Return to top
schema
A description of a database to the database management system (DBMS), typically generated using the data definition language provided by the DBMS. A schema defines attributes of the database, such as tables, columns, and properties.
Return to top
scope
The range of reference for an object or variable or a range of records in a view or table. For example, local variables can be referenced only within the procedure in which they were defined. Public variables are accessible from anywhere in the application. Objects, such as the current database, are in scope if they are in the defined search path. Record ranges can be specified with a Scope clause in many commands.
Return to top
service provider
Software that encapsulates a service by producing and consuming data, augmenting features in your ADO applications. It is a provider that does not directly expose data, rather it provides a service, such as query processing. The service provider may process data provided by a data provider. See also data provider.
Return to top
shaped Recordset
A Recordset whose columns have been specifically defined to contain not just data, but also references (called chapters) to other Recordset objects and/or computed values based on other Recordset objects.
Return to top
sibling
Any two or more nodes in a hierarchical structure that are on the same level in the hierarchy. The root node in a hierarchy has no siblings.
Return to top
stored procedure
A precompiled collection of code such as SQL statements and optional control-of-flow statements stored under a name and processed as a unit. Stored procedures are stored within a database; they can be executed with one call from an application and allow user-declared variables, conditional execution, and other powerful programming features.
Return to top
stub
An interface-specific object that provides the parameter marshaling and communication required for an application object to receive calls from a client that is running in a different execution environment, such as on a different thread or in another process. The stub is located with the application object and communicates with a corresponding proxy that is located with the client that calls it. See also proxy.
Return to top
sub-node
See child.
Return to top
synchronous operation
An operation initiated by code that completes before the next operation may start. See also asynchronous operation.
Return to top
tree
A structure representing a hierarchical relationship between elements (nodes). There is one node at the top level of a tree (the root). Underneath the root, there can be multiple children. Each child may in turn be the parent of other children, thus branching like a tree. A folder containing documents and other folders is a typical example of a tree structure. See also hierarchy, node, root, child, parent.
Return to top
URL (Uniform Resource Locator)
Specifies the location of a resource residing on the Internet or an intranet. A complete URL consists of a scheme ** (such as FTP, HTTP, mailto, file, and so on), followed by a colon, a server name, and the full path of a resource (such as a document, graphic, or other file). Some examples of URLs are:
https://www.example.com/default.html
ftp://ftp.example.com/file.ext
file://MyServer/MyShare/file.ext
See also absolute URL and relative URL.
Return to top
Web server
A computer that provides Web services and pages to intranet and Internet users.
Return to top