BD ADMINISTRATOR (DBA)
| | must decide what information should be kept in the database, ie, identify entities of interest to the company and the information to be recorded on these entities. This process is called BD logical design. The DBMS will use the version object (compiled) for that scheme to respond to requests for access. Source Version (without compiling) serve as a reference document for users of the system. |
| Define the internal schema | must decide how to represent information stored in the database. This process is called physical design of the database. The DBA uses the internal DDL to create the storage structure definition and the relevant correspondence between the internal and conceptual schemes (in both source and object version). |
| Link with users | The DBA should be responsible for communicating with users, ensuring the availability of data needed and write the required schemes. Consultations on application design, delivery technique, assistance in locating and solving problems, and other similar professional services related to the system. |
| Define security and integrity checks | verifications security and integrity can be considered part of the conceptual schema. |
| Define backup and recovery procedures | When a company decides to use a BD system, it becomes greatly dependent on proper functioning of that system . If you suffer damage any portion of the database is essential to repair the data involved with a minimum of delay and affecting as little as possible to the rest of the system. The DBA must define and implement an appropriate recovery plan that includes, for example, download, or "empty" newspaper of the BD in a backup storage media, and procedures to load the database again from casting more recently when necessary. |
| Monitor performance and respond to changing requirements | DBA is the responsibility of organizing the system so as to obtain better performance for the company and make appropriate adjustments when changing requirements. |
0 comments:
Post a Comment