Alexzander Nepomnjashiy

Data Warehouse is not a software product but is instead the architecture used for enterprise-level business intelligence information systems organization. Data Warehouse storage (database) is a central part of such systems; however, a full-function Data Warehouse solution consists of complementary products and technologies. The minimal typical components of a decision support system are: Storage database. […]

Welcome to the follow-up of the first part in Data Warehousing Technology Review. Let’s jump right in. So, the main idea underlying Data Warehousing is that carrying out the analysis directly on OLTP-systems is ineffective and undesirable. Instead, the idea is to extract the necessary data from several OLTP-systems, convert it, and then place it […]

Welcome to the latest article in my OLAP and Data Warehousing (The Problem and Solution) series, a series dedicated to the discussion of OLAP and Data Warehousing technologies. Let’s return once again in more detail to reasons of crisis involving the operating analysis. Below we present only the primary ones: Highly detailed data in OLTP […]

Please find below the follow-up to the first part in my OLAP and Data Warehousing (The Problem and Solution) series, a series dedicated to the discussion of OLAP and Data Warehousing technologies. A lack of world economic stabilization over the last few years has resulted in a growth of competitiveness and a rise in importance […]

The Problem All over the world organizations store or have already accumulated during their activity large volumes of data in corporate databases. These data “sets” store major potential possibilities for extracting new, analytical information to help build the business tactics to reveal market evolution tendencies and to find new solutions stipulating successful development in conditions […]

Included in the wide range of responsibilities for database server administrators, (besides installations, set-up and configuration, troubleshooting and user support), are tasks such as support and control of the database server performance. Correctly planned controls reveal problems at the stage of their origin and allow the administrator to take measures toward their resolution. It’s common […]