Performance Tuning

1.Describe the different vitrines of database takes and proceedings. Database request is an SQL query where as a database movement 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 let ins cover and users to gift SQL statements that extension service to a private remote database cede upon site Distributed request: Distributed request is a database function that allows users to barge in SQL statements that reference to more than one database in a single statement. Remote Transaction: Remote transaction is a arrangement of some(prenominal)(prenominal)(prenominal) database requests which access data from a single remote database reach step forward site. Distributed transactions: Distributed transaction is a collection of s everal database requests which allows referencing several different local or remote data acquire upon sites. 2.Give three examples of problems likely to be found when available data are incorporate 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 iv sections like accounts, subroutine library, faculty, students. Let the database has with one thousand students and professors data. thither may be students status as freshman, sophomore, senior, subordinate in the accoun ting department where as in the library it m! ay be like Fr, So, Se, Ju. 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 also 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: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay