历年真题2018年架构英文题希塞给的参考大答案有问题

Designing the data storage architecture is an important activity in system design. There are two main types of data storage formats: files and databases. Files are electronic of data that have been optimized to perform a particular transaction. There are several types of files that differ in the way they are used to support an application.

（ 71 ） store core information that is important to the business and , more specifically , to the application , such as order information or customer mailing information . （  72） contain static values , such as a list of valid codes or the names of cities . Typically, the list is used for validation. A database is a collection of groupings of information that are related to each other in some way. There are many different types of databases that exist on the market today.

（ 73 ） is given to those databases which are based on older , sometimes outdated technology that is seldom used to develop new applications . （  74） are collections of records that are related to each other through pointers In relational database , （  75） can be used in ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronized.

（71）A． Master files

B. Look-up files

C. Transaction files

D. History files

（72）A． Master files

B. Look-up files

C. Audit files

D. History files

（73）A． Legacy database

B. Backup database

C. Multidimensional database

D. Workgroup database

（74）A． Hierarchical database

B. Workgroup database

C. Linked table database

D. Network database

（75）A． identifying relationships

B. normalization

C. referential integrity

D. store procedure

 

参考答案应该是：

71-A

72-B

73-A

74-D

75-D

软考很多的英文题都是来自英文原著，所以看了历年真题的参考答案解析

发现与希赛的对不上，上网找了。

原文见:http://spots.gru.edu/tschultz/resources/eBooks/WileySysAD/Ch11.pdf

 

P411

Hierarchical databases cannot efficiently represent many-to-many (M:N) rela-
tionships or nonhierarchical associations—a major drawback—so network databases
were developed to address this limitation (and others) of hierarchical technology.
Network databases (e.g., IDMS/R, DBMS 10) are collections of records that are
related to each other through pointers. Basically, a record is a member in one or
more sets, and the pointers link the members in a set together (Figure 11-4).

 

P409

Master files store core information that is important to the business and, more specifically, to the application, such as order information or customer mailing information. They usually are kept for long periods, and new records are appended to the end of the file as new orders or new customers are captured by the system. If changes need to be made to existing records, programs must be written to update the old information.

Look-up files contain static values, such as a list of valid codes or the names of the U.S. states. Typically, the list is used for validation. For example, if a customer’s mailing address is entered into a master file, the state name is validated against a look-up file that contains U.S. states to make sure that the value was entered correctly. A transaction file holds information that can be used to update a master file.

The transaction file can be destroyed after changes are added, or the file may be saved in case the transactions need to be accessed again in the future. Customer address changes, for one, would be stored in a transaction file until a program is run that updates the customer address master file with the new information.

For control purposes, a company might need to store information about how data changes over time. For example, as human resources clerks change employee salaries in a human resources system, the system should record the person who made the changes to the salary amount, the date, and the actual change that was made. An audit file records “before” and “after” images of data as the data are altered, so that an audit can be performed if the integrity of the data is questioned. 

 

另：目前官方没有公布2019年架构设计师的真题，但是对比16-18的真题，发现上午的综合题大概有10+左右的题目跟网络规划设计师是一模一样的，可以考虑做下

2019年网络规划设计师的题目