Database and Data Warehousing Design
Data warehousing is basically more than just the database-like method which is usually used within the company for storing information. This then means that although the database merely holds information, a well designed data warehousing will comprise of three segments; staging which entails the storing and manipulation of the raw data by the developer (Corr & Stagnitto, 2012). In this stage, the role of the developer will be gathering of raw data from any broadly separated sources, standardize it as well as organizing it hence making it ready for integration. The next stage is integration which involves the categorization and storage of the raw data logically with respect to the end user’s needs thus allowing easy access. The last stage is accessing which ensures that the data is to be presented to the end user in a rational way which is much easier to understand and use.
In most cases, customers do make use of computer desktop apps in accessing as well as analyzing the data which the warehousing system provides. Although majority of companies are still on board with data warehousing, storage and the daily use of intelligence systems, others do find it hard to grasp it together with the benefits that arises from it (Corr & Stagnitto, 2012). Because of that, here are the pros which justifies the need for having data warehousing solution with the company;
Improved user access _ with data warehousing can be easily read and manipulated through various programs for instance Oracle client or the SQL Query Studio although there still exists a considerable ramp for its end users to be in the position of using them. Therefore, warehousing databases there will be a better consistency of information. Developers will be working with this system once it has been received so as to ensure the standardization of the data contained in it (Malinowski & Zimányi, 2008). Only that information which will be uniform is the one which will efficiently be used for successful comparison. Other solutions which do not have levels of consistency will be eliminated.
Within the company, data warehousing will give it the ability of receiving data from various sources. This then implies that any system which will be within the company will contribute to its data. Although different business organizations do make use of different apps, for my company, the presence of efficient warehousing database solutions can necessitate the acquiring of data from various sources hence making the business to have a better picture view which is required for analyzing the business itself, track any form of competition, and make adequate plans and so on (Malinowski & Zimányi, 2008). Because of this consideration, the table below shows the efficiency of logical design as compared to the physical design
|
Logic design Physical (as tables-paces)
|
|
||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
For the purpose of displaying future evidence, data warehousing solutions usually does to take into consideration the source of its data. This is because it has the ability of working with any raw data as well as massaging data with causes some troubles. By having a wider consideration on this, the warehousing database solution will ultimately outlast any changes in technology. For instance, the company will be able to make changes in the app in currently uses in gathering market statistics, choose whole new CRM solutions, overhaul its accounting system and all of this won’t matter its source (Bellatreche, 2010).
Nonetheless, the need for warehousing database for the company will arise from the desire for the advanced query processing. This is because, in any business organization, even the availability of efficient database systems is largely bound to both a single server and just a handful of servers in a group. Database warehouse is usually perceived as being a warehouse built solution for processing queries more efficiently and relatively much faster. This will result to efficiency as well as increased productivity.
Nevertheless, with the system in place the retention of history of the data will be convenient. Mostly, the end user apps in general do not have the capability of maintaining much transactions history as well as keeping track of the various changes to the information. This then means that the warehousing database solutions will give the company the ability of tracking any changes to the data, provision of reliable history of all the alterations to the data, deletions, and additions (Bellatreche, 2010). Conversely, with the data warehouse in place, data integrity is also ensured or enhanced.
Consequently, a huge majority of the information which will be stored in historical or current data will ultimately be used in creating reports or revealing of trends. This happens so since it gathers information from nay different sources for instance finance, sales or marketing at once hence cutting down the time needed for tracing as well as analyzing important data. Moreover, unlike any other storage solutions which can be used in the businesses, solid data warehousing will be beneficial in that it will make all the operations done by the company to be easier and more efficient.
With respect to the above chart, it should be noted first that the management of the company data is of great importance as much the exchange, storage and retrieval of information is concerned. In connection to that, there also the need of protecting such information against theft or being accessed by unauthorized individuals. Therefore, when it comes to its application in disaster recovery, data warehousing system offers an advanced security to it (Imhoff et al, 2003). This happens so because once information from various desperate systems has been received by the data warehouse, it in return acts as a backup source before it is also backed up. This then comprises of four sites where the data will be stored i.e. original source, the backup site for the original information, the data warehouse, and its successive backup. This then becomes the unparalleled data security.
With respect to the above advantages which will arise from the efficient implementation and use of the system in the company y, it should be noted first that the data which is to be generated and captured by the company is one of the most essential assets which will be made available not only to the company alone but also to the employees to (Imhoff et al, 2003). Unfortunately, as the amount information being generated grows exponentially to the extent of overwhelming many positions, data warehouse will remain to be the only solution. Therefore, its main purpose will entail integrating or bringing together of data from different sources into a single centralized location. Below is the E-R diagram that can be extracted from the above chart and table;
In accordance to that, for the company to be successful and enjoy the economies of scale in the future, its management should make good decisions. In making good decisions will necessitate taking into consideration all the relevant data. In the long-run the relevant source of that information will only be through the use of a well-designed data warehouse.
Reference
Corr, L., & Stagnitto, J. (2012). Agile data warehouse design: Collaborative dimensional modeling, from whiteboard to star schema. Leeds: Decisionone Press.
Malinowski, E., & Zimányi, E. (2008). Advanced data warehouse design: From conventional to spatial and temporal applications. Berlin: Springer.
Bellatreche, L. (2010). Data warehousing design and advanced engineering applications: Methods for complex construction. Hershey, PA: Information Science Reference.
Imhoff, C., Galemmo, N., & Geiger, J. G. (2003). Mastering Data Warehouse Design. New Jersey: John Wiley & Sons.
