Identifying Application Performance Requirements › Determining the Database Entry Point and Access Key for Each Transaction

Determining the Database Entry Point and Access Key for Each Transaction

You need to determine the first entity that each transaction accesses in the database. Identifying entry points can point out the need for additional indexes, or, as will be seen in Determining How an Entity Should Be Stored, the need for an entity to be stored with a location mode of CALC.

You can determine the database entry point and the data element used as an access key for a transaction by reviewing the access path diagram that you developed for the transaction during the logical design process. Specify the name of the entity and the data element used to access the entity.

Sample transactions

The following table shows the database entry points and access keys for three typical transactions.