Product and service reviews are conducted independently by our editorial team, but we sometimes make money when you click on links. Learn more.

Data Warehouses Built for Optimal Performances

By - Source: Toms IT Pro

Tom's IT ProTom's IT Pro

Today on Tom's IT Pro: Data Warehousing: “Conceptual Architecture”, Congrats to Winners of Microsoft IT Exam Voucher Contest,Dell Shifts Focus from Consumer to Enterprise Business, and OCZ Partners to Accelerate Enterprise Storage.

Hardware configuration, logical and physical data models, and workload management are a few important areas to address when putting together an optimally-designed data warehouse. IT pros should also be sure to tailor the conceptual design of the data warehousing implementation so each business unit within the organization has its own unique reporting and analytical requirements met.

Tom’s IT Pro Been There, Done That columnist Laura Paoletti provides a detailed example of how the conceptual architecture of a data warehouse should be built in her latest article for the site: Data Warehousing: Conceptual Architecture.  She depicts the design for the Application Tier, Presentation Tier, and Data Tier of a data warehousing implementation, and describes how the solution architecture outlines the integration of data sources into the Data Warehouse for the purpose of generating reports using the Business Intelligence reporting tool.

Also today, Ed Tittel reveals the nine finalists (selected from pool of over 70 applicants) who’ve won Tom IT Pro’s Microsoft IT exam certification contest.  Each of the winners receives a voucher (valued at $150 a piece) to take a Microsoft Certified Professional (or MCP ) exam at any Prometric testing center worldwide.

Meanwhile, Dell, after spending years focusing primarily on consumers, is changing its market outlook to focus mainly on the enterprise IT sector. Dell now earns more money via the former than the latter.        

OCZ Technology and SANRAD have teamed up to provide Z-Drive R4 drives with its OCZ-SANRAD VXL Enterprise Storage Accelerator. The solution is to be used as an accelerator for traditional iSCSI and FC storage. See here to learn more.

James Alan Milleris Managing Editor of Tom's IT Pro. He is a veteran technology journalist with over seventeen years of experience creating and developing magazine and online content. Founding editor of numerous business and enterprise computing sites at the network, James headed up the After Hours section at PC Magazine, as well as hardware and software sections of various Windows publications.