W3 Asig Selection Criteria and Data Warehouses Essay

W3 Asig Selection Criteria and Data Warehouses - Essay Example When there is a need to add, modify, delete or display data, the application system simply makes a "call" to the RDBMS† (RDBMS Functionality, n.d., p. 1). As the administrator of a data warehouse for a hotel chain with leading presence in 10 western states in the United States, the criteria to be used to select the RDBMS for the head organization’s data warehouse are as follows: load balancing, parallel processing options, query governor, query optimizer, query management, load utility, metadata management, scalability, extensibility, portability, Query tool Application Program Interfaces (APIs), and administration (Ponniah, 2010). The tools for the data warehouse are aptly illustrated in the figure below: These criteria are relevant in terms of ensuring that all pertinent information could be accessible and available to authorized users and stakeholders at actual time frames. For instance, higher management would require pertinent data particular to the actual number of customers of the hotel over the 10 different states as of a particular date, then, the RDBMS would enable integration of inputs from local sites to be generated as a comprehensive data at the head office. Another example would be determining the total number of hotel rooms that could accommodate a corporate outing or seminar at an identified state and date. As such, the RDBMS could locate which among the 10 hotels could provide the needs of the clientele, as requested. Likewise, Ponniah (2010) also revealed that it is relevant to select the server hardware. In addition, the paralleling options were emphasized to be designed according to the need to perform interquery and intraquery parallelization (Ponniah, 2010). In addition, software tools that are to be installed in the data warehouse must be compatible and consistent among the hotels within the 10 states to enable decision makers to view and use needed information in the most accurate manner. Finally, one should be able to select