W3 Asig Selection Criteria and Data Warehouses Essay

W3 Asig survival of the fittest Criteria and Data W behouses - Essay ExampleWhen there is a need to add, modify, delete or display data, the c all overing 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 asseverates in the United States, the criteria to be use to select the RDBMS for the head organizations data warehouse are as follows load balancing, fit processing options, query governor, query optimizer, query management, load utility, metadata management, scalability, extensibility, portability, Query tool Application Program Interfaces (APIs), and institution (Ponniah, 2010). The tools for the data warehouse are aptly illustrated in the figure belowThese criteria are relevant in terms of ensuring that all pertinent information could be accessible and available to authorized users and stakeholders at effective 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 come 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 waiter 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 i n the most accurate manner. Finally, virtuoso should be able to select