Database Web Applications - Glossary
A web application is an application that is accessed over a network such as the Internet or an intranet. The term may also mean a computer software application that is hosted in a browser-controlled environment (e.g. a Java applet)[citation needed] or coded in a browser-supported language (such as JavaScript, combined with a browser-rendered markup language like HTML) and reliant on a common web browser to render the application executable.
Web applications are popular due to the ubiquity of web browsers, and the convenience of using a web browser as a client, sometimes called a thin client.
The ability to update and maintain web applications without distributing and installing software on potentially thousands of client computers is a
key reason for their popularity, as is the inherent support for cross-platform compatibility. Common web applications include webmail, online retail
sales, online auctions, wikis and many other functions.
- ActiveX Data Objects
- A set of Component Object Model (COM) objects that provides an easy-to-use, scriptable interface to data sources
- Auto and Immediate windows
- The Autos window displays the values of variables that are within the scope of currently executing procedures. The Immediate window shows the results of debug statements running in the code, or that you type in directly.
- client/server
- Need a definition
- Clustered Computer
- High-volume servers often operate in clusters. This way, more than one computer can handle many users. From the user's point of view, the cluster appears to be a single fast computer.
- command object
- An object used to execute queries.
- comparison and logical operators
- Characters used to form expressions. Comparison operators compare two values or expressions. Logical operators, sometimes called Boolean operators, produce a logical TRUE/FALSE result.
- connection object
- An Active Data Object that is used to establish and maintain connections to data sources.
- data consumer
- Uses data. ADO and VBScript are data consumers.
- data provider
- Contains and exposes data to data consumers, such as a database, spreadsheet, etc.
- data remoting
- This refers to storing data on a remote server. The data is accessed across a network. The remote data server could be in the same room or building as the client or even in a different country.
- Data Source Name (DSN)
- A term for the information used to connect an application to an ODBC database.
- data type
- A variable or field attribute that specifies the kind of data it can hold.
- data-bound DTC
- A data-bound DTC is associated with a specific data item. DTCs aren't data-bound until this is done. For example, you can drag a DTC onto a page, but it isn't bound to anything until it's properties are set
- data-centric solution
- An application that primarily involves database access.
- design time
- The mode of operation when the application is being written.
- direct connection string
- A string that selects a database by file name instead of using an ordinary DSN.
- Distributed Component Object Model
- An extension of the Component Object Model that allows communication between objects on different computers.
- field
- A location in a database record where a data element is stored, also called a column.
- floating point data type
- A single precision number containing a sign bit and a 23-bit mantissa.
- HTML controls
- Used in Web pages to display information, also referred to as HTML elements.
- HTTP request
- A function provided by the Hypertext Transfer Protocol to request an action of the Web server.
-
initialization script
-
Commonly used to set initial values of variables, properties, and so on. Initialization code can be executed as soon as the Web
page is loaded to make global settings, or in a function or procedure to make local settings.
-
interface
-
Provides access to an application, objects, hardware, etc.
-
iterate
-
To execute program statements zero or more times in a loop structure.
-
join
-
The process of generating a result set by matching rows from two or more database tables.
-
logical connection
-
In the context of this course, refers to the association between the application and the datasource.
-
middleware
-
Software layer that enables communication between the application and the database.
-
offline volume
-
Storage that is not directly accessible. For example, optical juke boxes and tape drives are examples of offline volumes.
-
OLE Automation Client
-
An application that accesses objects exposed by another application.
-
operate redundantly
-
When a system operates redundantly, two or more computers perform the same function. This way, if a failure occurs, the
surviving system can continue operation unimpeded.
-
outer join
-
Similar to a join, except that all rows from one table will appear in the result set, even if there are no corresponding rows
in other tables.
-
PageObject
-
A script object that lets you treat active server pages as an object.
-
production database
-
A database in use in the production environment
-
programmatically retrieve
-
This means to use a programming logic and code to get data from a data source.
-
qualified fields
-
When a field name is ambiguous, that is it appears in more than one table, you must qualify which field you want to use by
prefixing the appropriate table name and a period before the field name.
-
querystring
-
This is a VBScript variable that is used to hold SQL statements.
-
recordset object
-
An Active Data Object that it used to retrieve, modify, display, and navigate recordsets.
-
relational database
-
A database that is organized and accessed based on relationships between tables, rows, and columns.
-
remote debugging
-
Debugging processes or scripts that are executed on a remote computer.
-
runtime
-
The mode of operation when the application is running.
-
script language engine
-
A software component that interprets a scripting language.
-
service
-
Is a special type of application that can be automatically started when the machine is booted, or can be started manually by
the user
-
SQL
-
Consists of statements that allow you to query databases from your applications.
-
SQL clause
-
Used to provide more specific instructions in a statement.
-
stored procedure
-
A database object, such as a query that can be executed.
-
stored procedures
-
Stored procedures are like little programs stored in the database and executed on command.
- subtype
- The different data types represented by the variant type.
- swap space or swap file
- Disk space used by the operating system to temporarily remove information from main memory.
- syntax
- The rules used to form a statement.
-
trigger
-
A stored procedure that is automatically executed when SQL modification statement occurs, such as insert, delete, and
modify.
-
unique key
-
A column value that is unique to each row.
-
variant
-
The data type for all variables that aren't explicitly declared as a specific type.
-
view
- A database object that appears to be a table, but is really the result of a predefined query.
- Web application
- A collection of pages that comprise a Web site.