BI City

Most Popular

How to Create a Flexible Data Warehouse

By SiliconIndia   |   Thursday, 28 June 2012, 10:27 Hrs
Print Email


Bangalore: A Data warehouse structure depicts how the components that make up the Database will work together apart from showing the growing pattern of the database over a period of time. Though, they have a structure, however only a handful of them are well organized.



An unorganized data warehouse structure would not be flexible and eventually leads to difficulty in maintaining the database. Thus giving an opportunity for a well organized data warehouse to succeed. A company that aims to be successful needs to have a “blue print” of the structure to ensure that the data warehouse is designed appropriately. Good infrastructure architecture will ensure flexibility, size and scalability.



Direct Connection with Your Business
There should be a direct connection between the data warehouse and the business to ensure flexibility. A data warehouse which needs to be updated hourly or at the end of the day should be designed that it meets the update requirements.  A clear technical knowledge of the system is a must to ensure a well designed system. Components that make up a good structure are available globally.



Components of Data Warehouse
Technical and Data elements are the vital components of data warehouse. While building it, the hardware network, operating systems used and meeting the business standards are to be addressed accordingly apart from ensuring that the data that is in the data warehouse should have the same structure.



To ensure a smooth transfer of information, there should be a considerable amount of network bandwidth apart from ensuring that the computer is powerful to run the required software. 



Technically, the warehouse should be able to obtain data from various sources and either encrypts or compressed it. It should also ensure that the data is clean and has been transformed accurately.
 


Experts on BI
Sanjeev Kumar Sharma
Managing Director
augur
Harish   Pandey
BD Manager
INFOLOGY SYSTEM
Niranjan  Rout
Head
Tata BlueScope
Rohan Anil Bhatt
Business Consultant
SQuare
Dinesh Kumar Mehta
V P Operations
Roop Polymers
Gaurav  Mittal
Solution Architect
YASH Technologies
Jayant R Joshi
Delivery Manager
Tech Mahindra
Pramod Kumar Sharma
Project Manager
Suntec Web
Write your comment now
 
Whitepapers
Small and medium-sized businesses stand to benefit from business in...
Data warehouse appliances that bundle analytic databases with serve...