Code First
All Articles

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 to a level that is was a complex ordeal some years back. Eventhough a thorough domain/ERD based approach provides some advantages, there are far more overall improvements to development and…

All Articles

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 business person make sense of the data and to understand the meaning of data stored in their operational OLTP system. Business term definitions help the business person manage his business….

All Articles

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 a data warehouse project Efficient project personnel Ensuring data quality & consistency Data warehouses deal with historical data from a variety of sources. So care must taken to ensure data…

All Articles

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 and addressing the changing analysis requirements of end users Now as the end users gains confidence, satisfaction and control over the data warehousing system, they wish to switch over…

All Articles

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 system. They may specify the system integration details, the database/software platforms to be used, baseline system models and architectures to be designed at the beginning of data warehouse…

All Articles

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 of the enterprise such as man, machine, raw materials & money. The great value of data lies in the fact that enterprises could manipulate this data and create valuable information,…

All Articles

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 they process. Little effort was put on building up an integrated information management system that is capable of capturing, storing & handling the distributed operational data (current & historic…

All Articles

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 study and analyse a typical system (eg: automobile servicing stations) for applying Data warehousing, study the scope of Data warehousing in the system and present a proposed system Perform Data warehouse…

All Articles

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, DSS& EIS has been serving this information management need for many years. Data warehousing is an Enhancement of such information management solutions in providing complete, integrated enterprise a information management…

All Articles

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 wf Database configuration release level                    = 0x0900 Database release level                                  = 0x0900 Database territory                                      = US Database code page                                      = 819 Database code set                                       = ISO8859-1 Database country code                                   =…

All Articles

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 their information and communication resources (ICT?s) (hardware, software, networks, databases, service offerings, processes, and portal layers) around a focal strategy.  Grocery Industry Introduction • NAICS 445110: Supermarkets and Other Grocery…

All Articles

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 strategy and by continuously improving business competitiveness and adaptability. The ultimate goal of any IM job is to add up to the combined efforts to meet the required business strategy….

All Articles

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 on the other hand are based on historical information and thus supports complex data mining/analysis and decision making. The core difference lies in the way queries are run to process/analyze…

All Articles

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 is an enterprise’s nation-wide ERP system which comprises of distributed databases, all of which are Oracle. Heterogeneous database systems on the other hand are distributed database systems that consist of…

All Articles

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 into separate entities. In effect, normalization leads to clean database design. Since we do not store redundant data, we save storage space and save resources to maintain (update, delete) redundant…