scroll to top
Stuck on your essay?
Get ideas from this essay and see how your work stacks up
Word Count: 1,145
The basic reasons organizations implement data warehouses are To perform serverdisk bound tasks associated with querying and reporting on serversdisks not used by transaction processing systems most firms want to set up transaction processing systems so there is a high probability that transactions will be completed in what is judged to be an acceptable amount of time Reports and queries which can require a much greater range of limited serverdisk resources than transaction processing run on the serversdisks used by transaction processing systems can lower the probability that transactions complete in an acceptable amount of time Or running queries and reports with their variable resource requirements on the serversdisks used by transaction processing systems can make it quite complex to manage serversdisks so there is a high enough probability that acceptable response time can be achieved Firms therefore may find that the least expensive andor most organizationally expeditious way to obtain high probability of acceptable transaction processing response time is to implement a data warehousing architecture that uses separate serversdisks for some querying and reporting To use data models andor server technologies that speed up querying and reporting and that are not appropriate for transaction processing There are ways of modeling data that usually speed up querying and reporting eg a star schema and may not be appropriate for transaction processing because the modeling technique will slow down and complicate transaction processing Also there are server technologies that that may speed up query and reporting processing but may slow down transaction processing eg bit-mapped indexing and server technologies that may speed up transaction processing but slow down query and report processing eg technology for transaction recovery - Do note that whether and by how much a modeling technique or server technology is a help or hindrance to queryingreporting and transaction processing varies across vendors products and according to the situation in which the technique or technology is used To provide an environment
@Kibin is a lifesaver for my essay right now!!
- Sandra Slivka, student @ UC Berkeley
Wow, this is the best essay help I've ever received!
- Camvu Pham, student @ U of M
If I'd known about @Kibin in college, I would have gotten much more sleep
- Jen Soust, alumni @ UCLA