1,492
13
Essay, 2 pages (500 words)

Data ware house technology

Data is the raw materials of any information system. With the revolution of Information Technology we are Improving our decision making process more quick and smart. Data warehouse technology Is the process of collection, sorting, structural formation, analysis, storing and presentation of data. So we say that data warehouse is the technology is overall data management system in the organization. In today’s business world we are facing huge competition. To secure enough profit we have no other way but to make most accurate decision quickly.

We take decision on the basis of information WE HAVE. So to take accurate decision accurately it is a pre requisite to have a smart system which can – * collect sufficient relevant Information * store and deliver data quickly analysis : present data accurately To solve the business need of those data management requirements a technology evolve which is known as data warehousing. How does It works? Data ware house technology has a system of extract data from operational system, these data then stored on historical snapshot basis.

Scalability: how my vendors deals with the data? Will it performed against required performance? Can the infrastructure handle the needs for different user even if they are working concurrently on this system? Agility: How do my vendors deals with the changing needs with mixed loads that include loading data while querying and returning right answer. Enterprise readiness: Are service of my vendors function always to keep my business running( even if in 24*7) . Is it deliver the security I need.

How the vendors re protecting disaster and fraudulent manipulation. There are some other things also we can consider : * Ease of Deployment * Cost of Up gradation Source : HTTPS://blobs. Oracle. Com/transgressing/entry/ data_warehouse_vendor_comparison_l data_warehouse_vendor_comparison_l Flexibility of the company How it take decision : When we think of take decision by using data ware house, we usually go through four main function of data ware house. They are: * Storing the data * Data extraction ; filtering * Quarry tools ; presentation tools.

Data store: The data store is repository where the data are kept to describe the characteristics of the data in data base. It is also linked with the transactional database if any modification of the transactional data will be updated as well. Data Extraction ; Filtering The data warehouse contains two main types of data: data extracted from the production database and data from external sources. The data extraction ; filtering tools are used to extract and validate the data taken from the transactional database and external data sources.

The warehoused data are not the duplicate of he working data. They are summarized and organized for analysis and query speed. Query Tool The data warehouse contains very vast data. However, the manager of any organization may only need definite portion of those facts. As a result, the query tools are used in the ADS database in order to retrieve the suitable and significant. The query tools deliver some queries and reports. To use the query tools, the manager has to know the facts of the query tools such as SQL (Structured Query Language), EJB (Query By Example) and many others.

Thank's for Your Vote!
Data ware house technology. Page 1
Data ware house technology. Page 2
Data ware house technology. Page 3

This work, titled "Data ware house technology" was written and willingly shared by a fellow student. This sample can be utilized as a research and reference resource to aid in the writing of your own work. Any use of the work that does not include an appropriate citation is banned.

If you are the owner of this work and don’t want it to be published on AssignBuster, request its removal.

Request Removal
Cite this Essay

References

AssignBuster. (2022) 'Data ware house technology'. 5 January.

Reference

AssignBuster. (2022, January 5). Data ware house technology. Retrieved from https://assignbuster.com/data-ware-house-technology/

References

AssignBuster. 2022. "Data ware house technology." January 5, 2022. https://assignbuster.com/data-ware-house-technology/.

1. AssignBuster. "Data ware house technology." January 5, 2022. https://assignbuster.com/data-ware-house-technology/.


Bibliography


AssignBuster. "Data ware house technology." January 5, 2022. https://assignbuster.com/data-ware-house-technology/.

Work Cited

"Data ware house technology." AssignBuster, 5 Jan. 2022, assignbuster.com/data-ware-house-technology/.

Get in Touch

Please, let us know if you have any ideas on improving Data ware house technology, or our service. We will be happy to hear what you think: [email protected]