Original 150 Pokemon List

Building an auditing system with "triggers" data independence

This article details the use of SQL Server 2000 diparadores in management information systems audits. Explain the two ways to perform the audit by the applications and on the boards of the database.

Party Invitation Wording Pay Own

Web Data Administrator

Current applications often depend on the data. In other words, the requirements of the application in question determine how to organize data in secondary storage and technology to access them. is said that an application is dependent on the data it is impossible to alter the storage structure (the physical organization of data) or access technique without affecting the application.

In a DB system is not advisable to have data-dependent applications, at least 2 reasons:

1. Each application requires a different view of the same data (eg, 2 files that work with a balance in decimal and the other in binary, the DBMS must be prepared and able to perform the conversions). Are the differences that may exist between the way you view the data for a given application and how they are physically stored.

2. The DBA should be free to modify the structure of technical storage or access (or 2 things) to adapt to changing requirements without having to modify existing applications. If your applications depend on data, such changes will certainly require corresponding changes in the programs, which would take a while for the developers could devote to creating new applications.

This independence can be defined as immunity to applications changes in the storage structure and access technique.
define 3 terms:

· A stored field is the smallest unit of stored information that is given a name. The database will include, in most cases, many occurrences (or cases) of each of the various types of stored field.

· A record stored is a set of interrelated stored fields, which has its own name. Once again the distinction between "type" and "occurrence." An occurrence of a record stored is formed by a group of occurrences of fields stored with each other (one occurrence for each different type of part).

· A file stored is the set (named) of all occurrences of a record type stored.

In systems without BD cadi always logical record of an application is identical to a corresponding stored record. This need not be so in a BD system, since the DBA may require the ability to modify the storage structure without changing the corresponding logical structures.

How Does Excersie Affect Herpes Breakout