Uso de visões nas bases de dados relacionais - problemas e benefícios

Abstract

This work aims to study views in relational databases, their applicability, mode of use, operating rules in data manipulation, presentation of their advantages and disadvantages. As being of great importance, there was a need to study and present to the various users of information systems, the advantage that this theme brings with regard to ease of use, privacy and independence in relation to applications. The present text has as content, the study of views in relational databases using SQL. The study is justified by the importance it has in a database management system, and by the need for a better perception of the information existing in the database tables, in order to receive the necessary information from it. This study was carried out at the company Agua de Maputo, more specifically at the Matola pilot agency, located in the city of Matola. Regarding the importance mentioned above of this work, we will present two advantages, one on the part of the consumer and the other that reflects on the company's management: - Water consumer - you can know your customer account at any time to make tmorim, Ana Paulaimely payments of your debts, and if you do not agree, you can consult the values ​​of the readings, the meter number, the address, as you can be mistakenly be debited for consumption by morim, Ana Paulaothers. Part of this information contained in the BD (Database), can be seen in a view. - The company's management - you can find out at any time the invoiced amounts, collection rates, various statistics, addresses of certain consumers, areas with the greatest water needs, etc..., all this to find out if the company is fully satisfied. the needs of your customers and that will help in decision making