Data Warehousing

TDWI’s Business Intelligence Maturity Model TDWI’s Business Intelligence Maturity Model was designed in the year 2004 by Wayne Eckerson. The technical aspects of the maturity model were the main focus of this model. The key areas of this model are: ·         Scope ·         Sponsorship ·         Funding ·         Value ·         Architecture ·         Data ·         Development and ·         Delivery. These aspects are graded by the following: ·         Infant ·         Child ·         Teenager ·         Adult ·    ...

This blog discusses in brief about the various types of data centers that exists around the world. The types are described as per the operating facilities offered by the data centers. Colocation Centers: (Colos) Data centers that are available for rental to customers with amenities such as space, equipment, power, cooling, physical security, servers, storage and network equipment are known as colocation data centers. Colocation centers range from 50,000 to 100,000 square feet in size generally. Although small size companies to fortune 500 companies use colos, they are popular with midsize IT companies. The colo providers undertake the maintenance of facility and internal systems and customers maintain control over the hardware. Century Link, Equinix and Hurricane Electric are few of the major colocation data center providers. In-house Data Centers Many large scale industries design, build, manage their own data centers. In-house data centers are those that are built and ...

Constructing a Data Center A fully operational data center should comprise of aspects such as  Availability ( Up-time ), Reliability, Safe & Secure, Eliminate Single point of failure (SPOF), Power, Cooling, 24x7 operations and maintainability . Proper planning and design is required to construct a facility that will be secure, defendable and cost effective. This embraces several key principles in the  site location, building selection, floor layout, electrical system design, mechanical design,  and the concept of  modularity  that enables the data center facility to change and adapt as needed, with minimum renovation and change to basic building systems. A few of the vital requirements for a data center are as follows. Site Location The site should be in a safe area that is not subject to any natural environmental dangers such as flood planes or an area subject to landslides. If the building is subject to a sustained period of heavy rain or loca...

Online transaction Processing (OLTP) Online Transaction Processing, or OLTP, is a class of data frameworks that encourage and oversee transaction-oriented applications, ordinarily for information passage and recovery transaction handling. Instant client response and high individual transaction volume are the key features of OLTP. It is largely used in businesses such as bank and online shopping websites that rely mainly on effective processing of huge client transactions. Atomicity should be provided by the OLTP systems that help in processing or removing an order entirely. Use of OLTP has wide range such as financial transactions, customer services, online shopping, customer relationship management (CRM). Online transaction processing system progressively requires bolster for transactions that traverse a system and may incorporate more than one organization. Therefore, current online transaction processing programming use customer or server handling and expediting programm...