W3 Asig Selection Criteria and Data Warehouses - Essay Example

Selection Criteria and Data Warehouses al Affiliation Selection Criteria and Data Warehouses You are the administrator of adata warehouse for a hotel chain with leading presence in 10 western states in the United States. Write a proposal describing the criteria you will use to select the RDBMS for your data ware house. Make your assumptions clear. A relational database management system (RDBMS) was defined as a “special system software that is used to manage the organization, storage, access, security and integrity of data.

This specialized software allows application systems to focus on the user interface, data validation and screen navigation. 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:Source: Ponniah, 2010, p. 185 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 an appropriate RDBMS vendor that could tailor the system according to the organization’s needs and demands (RDBMS Vendors, n.d.).ReferencesRDBMS Functionality. (n.d.). Retrieved November 5, 2014, from rdbms.ca: http://rdbms.

ca/database/functionality.htmlRDBMS Vendors. (n.d.). Retrieved November 5, 2014, from rdbms.ca: http://rdbms.ca/database/vendors.htmlPonniah, P. (2010). Data Warehousing Fundamentals for it Professionals. John Wiley & Sons, Inc.