Microsoft Corporation, the world's largest software development company, has annual revenues exceeding U.S.$34 billion and operations in 89 countries. As with other global companies, Microsoft has lots of taxes to track and pay - on the local, regional, national, and international levels. The Microsoft IT Tax and Audit Product Group created a 1.8 terabyte Tax Data Warehouse to keep track of financial information. To enhance performance, the company upgraded its Tax Data Warehouse to Microsoft SQL Server 2005 from SQL Server 2000. Since the upgrade, the company has seen a 75 percent reduction in the time required to process OnLine Analytical Processing (OLAP) cubes; 50 percent faster Extract, Transform, and Load (ETL) data processing time; and enhanced developer productivity.
Did you find this white paper useful?
32 out of 50 users found this white paper useful
Related white papers
SGER: Computer-Assisted Interpretation of Citizen Input in Rebuilding Lower Manhattan
Computer-mediated communication, specifically facilitated by the Internet, offers new channels for citizens to express their views to elected officials, government agencies, and civic associations. Individuals have embraced email, mailing lists,...
Streamlining Accident Data Acquisition, Communication, and Analysis for Chinese Highways
This paper proposes and tests a streamlined accident data acquisition, communication and analysis system to improve Chinese highway safety program. A GPS/GIS based data logger is designed to identify the...
Infrastructure Management Technology Audit: IBM Tivoli - Tivoli Intelligent Orchestrator and Tivoli Provisioning Manager (Version 2.1)
Tivoli Intelligent Orchestrator (TIO) and Tivoli Provisioning Manager (TPM) implement automated policy-based management of data centre resources, allowing customer adoption of IBM's on demand strategy within the data centre. Infrastructure...
Reference Data Management Now!
This webcast helps one learn about the best practices for the full cycle of reference data management - from data acquisition through "golden source" data distribution. The webcast helps one...
The Future of Mobile Survey Data Collection in Natural Resource Surveys
This paper presents 3 scenarios that present the full range of our interdisciplinary Digital Government research program. The first scenario describes a conceptual framework for accessing, using and collecting geospatial...
Extracting Meaningful Entities From Police Narrative Reports
Valuable criminal-justice data in free texts such as police narrative reports are currently difficult to be accessed and used by intelligence investigators in crime analyses. It would be desirable to...
Homeland Security: A Cyveillance White Paper
Cyveillance understands that the Government does not have the time or resources to sift through billions of documents on the Internet trying to identify hidden risks, unforeseen threats or fraudulent...
