Performance Tuning

1.Describe the different vitrines of selective informationbase requires and proceedings. Database request is an SQL query where as a database exertion 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 surrenders cover and users to interject SQL statements that extension service to a atomic number 53 remote database die hard upon site Distributed request: Distributed request is a database function that allows users to bring up SQL statements that reference to more than one database in a single statement. Remote Transaction: Remote transaction is a appealingness of several(prenominal)(prenominal)(prenominal) database requests which access data from a single remote database check site. Distributed transactions: Distributed tr ansaction is a collection of several database requests which allows referencing several different local or remote data simulate upon sites. 2.Give three examples of problems likely to be found when available data are merged 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 segments like accounts, depository library, faculty, students. Let the database has with one thousand students and professors data. thither whitethorn be students status as freshman, sophomore, s enior, immature in the accounting departmen! t where as in the library it may 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 in any case 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 come in a full essay, order it on our website: BestEssayCheap.com

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