Exam 13: Application Architecture and Modeling

When using replication technology the RDBMS must propagate updates from one database server to any other database server where the data is duplicated.

_____________________________ is the standardized electronic flow of business transactions or data between businesses. Typically, many businesses must commit to a data format to make it feasible.

Vertical partitioning is when different columns in a database are assigned to different database servers.

A file server system is a LAN-based solution in which a server computer hosts only the data layer. All other layers of the information system applications are implemented on the client PC.

A network computing system is a multi-tiered solution in which the presentation and presentation logic layers are implemented in the client side web browsers using content downloaded from a web server.

A(n) _________________________ client is a personal computer, notebook computer or workstation that is typically more powerful (and expensive in terms of processor speed, memory, and storage capacity. Almost all PCs are considered this type of clients.

The information system application layer that includes all the commands and logic required to store and retrieve data to and from the database is known as:

A distributed system is one in which the components of an information system are distributed across multiple locations and computer networks.

A(n) __________________________ server hosts services that ultimately ensure that all database updates for a single business transaction succeed or fail as a whole.

In file server architectures, if the application wants to examine only one record in the database, the entire file or table of records must be first downloaded to the client PC where the data manipulation logic will be executed to read the desired record.

A(n) ______________________ distributes or duplicates tables to multiple database servers located in geographically important locations.

In online processing, a group of transactions are placed in a line for periodic updates to the database at a later point in time.

Data partitioning distributes rows and columns to specific database servers with little or no duplication between servers.

A distributed relational database distributes or duplicates tables to multiple database servers located in geographically important locations.

Batch input technologies are obsolete.

A distributed data client/server system is a solution in which the data and data manipulation layers are placed on the server(s), and the application logic, presentation logic, and presentation layers are placed on the clients.

The physical processes must meet all the logical process requirements.

______________________________________ is similar to EDI except that the actual images of forms and data are transmitted and received.

It is important to understand the difference between file server systems and distributed data client/server systems. Both store their actual databases on a server. But only client/server systems execute all data manipulation commands to create, read, update and delete records on a server.

Typically, many businesses must commit to a data format to make EDI feasible.