real time data warehousing

Sponsored Links

Also known as active data warehousing, real time data warehousing is the process of storing and analyzing data across multiple types of storage systems. Companies tend to use this approach in an ongoing effort to maximize the benefits from various forms of business intelligence, especially in terms of positioning the company for growth through sales. By capturing the information that becomes available and the assimilation of data with historical information, it is possible to predict shifts in customer demand, and develop new marketing strategies that will attract new customers.

Basic process real time data warehousing requires transactional data added to the database, such as placing orders or invoicing system, immediately analyzed, classified, and linked to information that has been shed from the previous transaction. Ideally, the additional information will yield additional information that helps to show the trend in purchases of goods or services offered by the company, the generation of profits or losses.

With assimilation and the rate of transactions and other data occurs, companies can move more quickly to take advantage of the trends that have the potential to recover significant business. Because real-time data warehousing process automatically, no need for anyone to turn this trickle of data from various transactional databases to a central database in real time. So, it is possible to access bank information is updated every time, and using data for planning future projects or actions that will be in accordance with corporate interests.

The process of data mining in real time can also include automatic generation of reports tailored to the needs of end users. Design a data warehouse often allows users to select from a series of pre-programmed report formats, or use a tool built into the software package to create a special report that manage data in many ways. This versatile data warehouse architecture makes it easy for companies of various sizes and related to different areas to use the same basic software, but adjusts the use software in accordance with their respective needs.

Most real-time data warehousing package also allows on-demand report generation and also on the schedule you set. This can be very helpful, as they may submit a request for a sudden moment, and the answer in seconds or minutes. For example, if a sales manager presented with a question about the sales day today is along the lines of a particular product, he can only frame the query, has a software pull-up-to-minute data, and reports that provide information with ease. other conventional methods would require up to half an hour or more to manage what real time warehouses can be set in less than three minutes.

Article Source:
http://www.wisegeek.com/what-is-real-time-data-warehousing.htm