The Infona portal uses cookies, i.e. strings of text saved by a browser on the user's device. The portal can access those files and use them to remember the user's data, such as their chosen settings (screen view, interface language, etc.), or their login data. By using the Infona portal the user accepts automatic saving and using this information for portal operation purposes. More information on the subject can be found in the Privacy Policy and Terms of Service. By closing this window the user confirms that they have read the information on cookie usage, and they accept the privacy policy and the way cookies are used by the portal. You can change the cookie settings in your browser.
This article presents key features of a Web-based data warehouse application designed and developed for data entry, data management as well as reporting purposes. The application was build using Oracle application express (OAE) technology which is one of the most innovative tools running on Oracle databases today.
Real time data warehouses open brand new possibilities to enterprises but also maintaining a competitive advantage in today's marketplace. However the design of such systems requires new considerations and modeling approaches.
In this article, methods of communication between a database and operating system was described with emphasis on data changes signaling. Information of data changes is important for warehouse systems to perform online business analysis. As a database, Oracle was chosen running on Linux based operating system.
Modern Data Warehouses based on the OLAP model often require performing periodical analyses of data gathered in fact tables. In order to avoid recalculating the results every time new data arrives there is a need to create an organized results repository to store calculated values of every analysis.
Set the date range to filter the displayed results. You can set a starting date, ending date or both. You can enter the dates manually or choose them from the calendar.