I have a requirement and I am not sure if I should use Analysis services or Reporting services or some other technique.
我有一个需求，我不确定是否应该使用分析服务或报告服务或其他技术。
My client wants to show special deals from a database on their online website. They want to target users, i.e. if user is from UK; show deals for UK and in Pound. if user is from Canada; show deals for Canada and in canadian dollar etc.
我的客户想从他们的在线网站上的数据库中显示特殊的交易。他们想要目标用户，即如果用户来自英国;展示英国和英镑的交易。如果用户来自加拿大;展示加拿大和加拿大元等的交易。
Their database has multiple tables loaded with 1 to 2 million records in each table. Each table is for a different category of products and has a currency and a Country column to filter. I cannot restructure their schema as they have huge amount of development done to integrate with various buisness applications.
他们的数据库有多个表，每个表中有1到200万条记录。每个表用于不同类别的产品，并有一个货币和一个国家列供筛选。我无法重构它们的模式，因为它们已经完成了大量的开发，以集成各种buisness应用程序。
I need a solution which involves datawarehouse, can fetch data quickly and cache it for next 12 or 24 hours (Do not want to cache on web server). I do not have much experience in Analysis and Reporting services so I need your solution/suggestion and anything you can share from your good or bad experiences.
我需要一个包含datawarehouse的解决方案，它可以快速获取数据，并将其缓存12或24小时(不希望在web服务器上缓存)。我在分析和报告服务方面没有太多的经验，所以我需要你的解决方案/建议和任何你可以分享的好或坏的经验。
1 个解决方案
#1
5
Analysis services is not what you want here: you do not need cubes that summerize info. Nor is reporting services: you will want to display your data in plain HTML.
分析服务不是您想要的:您不需要聚合信息的多维数据集。报告服务也不是:您将希望以普通的HTML显示数据。
I would just query the existing data and display that data. If performance becomes an issue you could run an SSIS job every 12 hours to extract data to a specific database you created for this application. But consider tweaking your indexes first.
我只需查询现有数据并显示该数据。如果性能成为问题，您可以每12小时运行一次SSIS作业，将数据提取到为该应用程序创建的特定数据库中。但是首先考虑调整索引。
#1
5
Analysis services is not what you want here: you do not need cubes that summerize info. Nor is reporting services: you will want to display your data in plain HTML.
分析服务不是您想要的:您不需要聚合信息的多维数据集。报告服务也不是:您将希望以普通的HTML显示数据。
I would just query the existing data and display that data. If performance becomes an issue you could run an SSIS job every 12 hours to extract data to a specific database you created for this application. But consider tweaking your indexes first.
我只需查询现有数据并显示该数据。如果性能成为问题，您可以每12小时运行一次SSIS作业，将数据提取到为该应用程序创建的特定数据库中。但是首先考虑调整索引。