Exam 13: Application Architecture and Modeling

A server in the file server model must be more powerful and capable than a server in the client/server model.

A(n) ______________________________ system is a solution in which: (1) the data and data manipulation layers are place on their own server(s); (2) the application logic is placed on its own server; and (3) only the presentation logic and presentation layers are placed on the clients. This is called three-tiered or n-tiered computing.

A distributed relational database distributes or duplicates its database file servers across a number of transaction servers.

___________________________________ partitioning is when different rows in a database are assigned to different database servers.

A software development environment (SDE) is a language and tool kit for constructing information system applications.

A(n) _______________________ server hosts application logic and services for an information system. It must communicate on the front end with the clients (for presentation) and on the back end with database servers for data access and update.

Clean layering requires that the presentation, application, and data layers of an application be physically separated.

A physical data store represents any of the following: (1) the planned implementation of an input to or output from a physical process; (2) a database command or actions such as create, read, update, or delete; (3) the import of data from or the export of data to another information system across a network; or (4) the flow of data between two modules or subroutines within the same program.

A server in the _______________ model must be more powerful and capable than a server in the file server model.

Object database connectivity (ODBC) automatically translates SQL commands for one database server for use on a different database server.

A reason that a logical process might be split into multiple physical processes is because part of the process is performed by people, and part is to be performed by the computer.

A server that hosts services that ultimately ensure that all database updates for a single business transaction succeed or fail as a whole is known as:

When data in a relational database is partitioned across specific database servers, how can it be partitioned?

The ___________ / ______________ boundary distinguishes manual from computerized processes.

A physical data flow represents any of the following (name two) ____________________.

In _______________________________, a central, multi-user computer hosts all the data, process and interface components of an information system. The users interact with this host computer via terminals (or PCs emulating terminals), but virtually all of the actual processing and work is done on the host computer.

A(n) ____________________ is a language and tool kit for constructing information system applications.

A(n) ______________________ server hosts Internet or intranet web sites. It communicates with fat and thin clients by returning documents and data to them.

A file server hosts one or more shared databases (like a database server) but also executes all database commands and services from files for information servers (unlike a database server).

A solution in which the presentation and presentation logic layers are shifted from the server of a legacy system to reside in the client is known as: