Using Code First first
Traditional ways of software development focus on DB-first implementation methodology. But we are in the realm of latest developments and ORM models has taken us...
Data warehousing – Defining data
Two kinds of definitions relevant to data warehouse design are the definition of business terms and definition of data elements. Data element definitions help the...
Data warehousing – Data warehouse Project Management
Characteristics of successful data warehouse projects generally include the following aspects – Clear business justification for the project ie. measurable benefits must be defined for...
DATA WAREHOUSE PROJECT LIFE CYCLE – Ongoing maintenance and changing user requirements
Ongoing maintenance is the final phase of creation of a data warehousing system. The ongoing maintenance of data warehouse generally involves constant loading of new...
DATA WAREHOUSE PROJECT LIFE CYCLE – Design and implementation-Engineering
Once the application is well defined, data warehouse developers are able to begin making technical decisions about building the logical & physical design of the...
DATA WAREHOUSE PROJECT LIFE CYCLE – System study & Analysis-Pre-engineering
Pre-engineering is the time to define the goals of the application, to make the initial analysis of the system and make other decisions. This includes...
Data warehousing – IMPORTANCE OF DATA WAREHOUSING IN IT
Data warehousing has a great relevance in IT since it provides an Integrated Information management solution that aids in providing the right information, in the...
Data warehousing – OLTP systems and Datawarehousing
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...
Data warehousing – Concept
In the present day competitive & technology centric information age, business enterprises are realising that the enterprise data is valuable resource just like other resources...
Data warehousing – Data warehousing technology
Throughout the history of systems development, the primary emphasis had been given to the operational systems (simple OLTP -Online transact ion processing systems) and the...
Data warehousing – Project Scope
A typical project scope for Data warehousing is as below – Title: APPLYING DATA WAREHOUSING The major goal & effort on working on the project is to...
Data warehousing – Need for Data warehousing
The need for an effective information management solution is of top priority in today’s changing & competitive business environment. Various Information systems like OLTP systems,...
DB2 Reorg and Run stats commands – life saver
Below are some life saver commands for DB2 admin for reorg and subsequent runstat – Reorganising tables:: This process helps in bringing together of widely...
A typical DB2 DB config
Below is a tuned DB config for a heavily loaded workflow application – [db2inst1@intranet db2inst1]$ db2 get db cfg for wf Database Configuration for Database...
Sample PL/SQL script for cleaning a detail table referring a master table
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 –...
Strategic alignment of IT resources – A case study in Grocery industry (Part 2)
Strategic alignment of IT resources – A case study in Grocery industry (Part 2) Japan UK Spain US Effect of economic situation The...
Strategic alignment of IT resources – A case study in Grocery industry (Part 1)
Strategic Alignment of IT Resources Grocery Industry Kathleen Chan, Deepesh Joseph, Raymond Jones, Paul Walleck Introduction To investigate how and why grocery companies are aligning...
What limitations should be imposed on datamining 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 and result oriented when...
Current usage and future of 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 XML based Database...
Information Management and career levels
Deepesh JosephAugust 2006 Information Management (IM) refers to any activity that leads to effective collection, storage, retrieval and analysis of information by focusing on business...
Compare and contrast data warehouse principles
Operational Vs Informational system : Operational Systems are those which are based on current data and thus supports current/day-to-day functioning of a business. Informational Systems...
Various kinds of Database Systems
a. Homogeneous vs. heterogeneous distributed database system Homogeneous database systems involve similar databases distributed over the network (on separate machines). Example of homogeneous database system...
Pros and Cons of normalizing data into 3NF form
Deepesh Joseph February 2009 The main purpose of normalization is to reduce data redundancy and avoid inconsistent data. Normalization leads to separation of unrelated entities...