The need for an effective information management solution is of top priority in today's changing & competitive business environment...
Read More
Showing posts with label Database Technologies. Show all posts
Developing Project Scope For a Data warehousing Project
A typical project scope for Data warehousing is as below - Title: APPLYING DATA WAREHOUSING The major goal & effort on working ...
Read More
Data warehousing technology
Throughout the history of systems development, the primary emphasis had been given to the operational systems (simple OLTP -Online transac...
Read More
Concept of Data warehousing
In the present day competitive & technology centric information age, business enterprises are realising that the enterprise data is va...
Read More
Datawarehousing and OLTP Systems
We shall compare the ordinary OLTP systems & the Data warehouse systems w.rt the type of data that they handle and shall point out how...
Read More
How Important is Data warehousing in shaping your IT
Data warehousing has a great relevance in IT since it provides an Integrated Information management solution that aids in providing the ri...
Read More
System study & Analysis-Pre-engineering in a Data Warehouse Project Life Cycle
Pre-engineering is the time to define the goals of the application, to make the initial analysis of the system and make other decisions. T...
Read More
Design and implementation-Engineering in a Data Warehouse Project Life Cycle
Once the application is well defined, data warehouse developers are able to begin making technical decisions about building the logical ...
Read More
Ongoing Maintenance and Changing User Requirements in a Data Warehouse Project Life Cycle
Ongoing maintenance is the final phase of creation of a data warehousing system. The ongoing maintenance of data warehouse generally invol...
Read More
Data warehouse Project Management
Characteristics of successful data warehouse projects generally include the following aspects - Clear business justification for the pro...
Read More
Defining Data in Building a Data warehousing
There are two kinds of definitions relevant to data warehouse design - (1) definition of business terms (2) definition of data elements. ...
Read More
DB2 Tuning - Sample DB2 Reorg and Run stats commands
If anyone is looking for a quick cheat sheet for DB2 areorg and subsequent runstat, below is a very useful and concise explanation with exa...
Read More
Sample DB2 Database Configuration
Here is a tuned Database configuration for a heavily loaded workflow application - [db2inst1@intranet db2inst1]$ db2 get db cfg for wf ...
Read More
Sample PL/SQL script for cleaning a detail table referring a mastertable
Have you ever had a need to write a PL/SQL snippet to clean a table. If you are in need, here is one below - Here is a sample PL/SQL code t...
Read More
Newton Raphson Method
Newton Raphson method is the core in computer Numerical analysis software programs to find root of euqations such as e<sup>-x</sup...
Read More
Numerical solution by method of Iteration
Solving x = 1/ (1+x)1/2 using iteratrion method - Iteration is a method of solving algebraic or transcendental equation and is widely us...
Read More
Data Mining of Email Traffic Patterns
E-mail traffic is one of the main target of intelligence surveillance to detect terrorist and other malicious activities. Its rather easy a...
Read More
XML Database Management Systems
Deepesh Joseph April, 2009 Purpose The purpose of this document is to present a management report that analyzes the current usage of XM...
Read More
Subscribe to:
Posts (Atom)