Performance Tuning

1.Describe the different vitrines of entropybase necessitates and proceedings. Database request is an SQL query where as a database act is combination of star or more SQL queries which penalize successfully or aborted. In distributed database management system database requests and transactions ar classified into two types. They are remote and distributed away request: contrary request is a database function that awards cover and users to knuckle under SQL statements that extension service to a adept remote database feign upon site Distributed request: Distributed request is a database function that allows users to hand SQL statements that reference to more than one database in a single statement. Remote Transaction: Remote transaction is a arrangement of several(prenominal)(prenominal)(prenominal) database requests which access data from a single remote database preserve site. Distributed transactions: Distributed transaction is a collection of se veral database requests which allows referencing several different local or remote data turn by upon sites. 2.Give three examples of problems likely to be found when available data are compound into the data warehouse.

Database type and coordinate allow for the main problem when operational data are integrated into data warehouse. Let us consider a university database which has tetrad sections like accounts, library, faculty, students. Let the database has with one thousand students and professors data. thither may be students status as freshman, sophomore, senior, junior in the accounting department where as in the library it may be like Fr, So, Se, J! u. The date of enrollment for classes in accounting table will be DD-MM-YYYY dress where as the date of enrollment in the students department will be MM-DD-YYYY, then alike problem arises. There may also be a problem when the data type for the grade point average is declared as float in one department and decimal in other department.If you want to pick out a full essay, order it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper