Building the Data Warehouse

Скачать в pdf «Building the Data Warehouse»
Language Interface


The data warehouse must have a rich language specification. The languages used by the programmer and the DSS end user to access data inside the data warehouse should be easy to use and robust. Without a robust language, entering and accessing data in the warehouse become difficult. In addition, the language used to access data needs to operate efficiently.


Typically, the language interface to the data warehouse should do the following: ■■ Be able to access data a set at a time


■    Be able to access data a record at a time


■    Specifically ensure that one or more indexes will be used in the satisfaction of a query


■    Have an SQL interface


■    Be able to insert, delete, or update data


There are, in fact, many different kinds of languages depending on the processing being performed. These include languages for statistical analysis of data, where data mining and exploration are done; languages for the simple access of data; languages that handle prefabricated queries; and languages that optimize on the graphic nature of the interface. Each of these languages has its own strengths and weaknesses.

Efficient Loading of Data


An important technological capability of the data warehouse is to load the data warehouse efficiently, as shown in Figure 5.3. The need for an efficient load is important everywhere, but even more so in a large warehouse.


Ninth technological requirement— to be able to load the warehouse efficiently


Tenth technological requirement— to use indexes efficiently


Eleventh technological requirement— to be able to store data in a

Скачать в pdf «Building the Data Warehouse»