例如,分析应用程序可能需要按产品、地区和日期(三个维)获取一个大型事实表中的销售信息。
For example, an analytical application might require sales information contained in a large fact table to be retrieved by product, by region, and by date (three dimensions).
第一个是Items表,它跟踪有关所销售商品的信息和客户的相关评论。
The first is an Items table that tracks information about items for sale and comments that customers have made about them.
天气预报、损益表和销售趋势属于信息。
Information is a prediction of the weather, a profit-and-loss statement, and a sales trend.
销售信息经常更新到sales表中,但这不是说经理们必须得到最新的信息。
The sales information gets updated constantly in the sales table, but it is not essential that the executives get up-to-the-second information.
例如,假设有两个分别包含产品信息和销售信息的表,您可以使用联接操作来匹配同一销售订单的销售信息和产品。
For example, given two tables that contain product information and sales information, you could use a join operation to match sales information and products for the same sales order.
例如,假设有两个分别包含产品信息和销售信息的表,您可以使用联接操作来匹配同一销售订单的销售信息和产品。
For example, given two tables that contain product information and sales information, you could use a join operation to match sales information and products for the same sales order.
应用推荐