星型架构

多年来，我创建了一个用于测试Informix新版本的中型数据仓库星型架构，并将它用于标准程序测试。

Over the years , I have built up a midsize data warehouse star schema that I use for testing new releases of Informix , and I used it for this benchmark .

本文不会详细介绍星型架构设计。

This document will not go into details of star schema design .

IWA技术以压缩格式将数据仓库星型架构中的记录载入内存，并使用新的列存储技术来组织数据。

IWA technology loads the records from a data warehouse star schema into memory in a compressed format , and organizes the data using new columnar storage technology .

但是，如果时间、费用和资源都不成问题，理想的方法是使用ETL工具构建适用专用数据栈或数据仓库的星型架构设计并尽可能汇总数据。

However , if time , expense , and resources are not a road block , the ideal scenario is to work towards a star schema design for a data mart or warehouse using an ETL tool and aggregate data where possible .

设计数据库时必须将维度模式星型架构与IWA相结合，必须定义表格并将它们载入IWA中，以充分利用IWA的性能。

A database must be designed using a dimensional model star schema to work with IWA , and the tables must be defined and loaded into IWA to take advantage of its performance .

使用星型架构专用数据栈或数据仓库

Use a Star Schema Data Mart or Warehouse

由于企业业务支持系统所涉及的三个维表较简单且不存在数据冗余，所以采用星型架构。

The operation support system involves three simple dimension tables and does not have unnecessary data , so it uses the star schema .

当企业数据根据行业标准星型架构设计进行合并和结构化时，基于数据进行报告更容易实现，性能通常也更好。

When your enterprise data is consolidated and structured according to the industry standard star schema design , reporting on the data is easier to accomplish and performance is usually much better .

本文所做的主要工作有：第一，给出了一个星型无线局域网体系架构，并针对白色家电控制简单的特点，设计了内部局域网络应用层协议。

The major works done in the paper are as follows : firstly , it used Star Wireless LAN architecture and designed a simple internal LAN application layer protocol because of the simple control characteristics of white goods .