外文翻译 - 构建基于 Web 的分析系统.docVIP

外文原文1 Building a Web-Based Analysis System Part 1 A real-world look at using the Analysis Services Thin Web Client Browser Mark Scott, John Lynn Using OWC to Deploy Office on the Web When working with analytical databases, analysts organize data into common groups and try to determine what would happen if things were different. For example, would increasing a products price—which would increase profit per unit but probably reduce number of units sold—yield a higher or lower overall profit? Or how would a drop in the federal discount rate affect the yield of real estate loans? To help analysts make educated projections based on historical trends, Microsoft provides Analysis Services in SQL Server 2000 and OLAP Services in SQL Server 7.0. These services provide OLAP capability and can process data stored in SQL Server (or any other OLE DB—compatible data source) into multidimensional data structures called cubes. Data cubes simplify the process of analyzing trends and correlating the way entities interact with one another. For example, real estate investors use cash-flow modeling to isolate a group of loans that have common characteristics (e.g., types of properties, geographic area, range of interest rates) and project the effects of different kinds of events. What will happen if loans mature more rapidly than expected or if the borrowers default? And how might such unpredictable events affect the yield of bonds that the loans secure? Selecting from lists that can include hundreds of loans and isolating the loans that have the characteristic that youre analyzing can be tricky. Analysis Services and OLAP Services can help correlate these groups of loans so that analysts can model loan assumptions. To help a clients real estate analysts project the performance of commercial mortgage-backed securities, our development team needed to devise a system that simplified the grouping of loans in different ways—such as by their interest rate, term to maturity, or property locat