Reduced Ongoing Management and Maintenance
3. Reduced ongoing management and maintenance
Because traditional data warehousing solutions are generally built to handle specific types of queries, they are not particularly well-suited for environments where data management needs are constantly changing and real-time analysis is critical. (And the reality is that real-time, dynamic requirements are pretty much the norm in a Web-dominated world.) Retrofitting these solutions to handle ad hoc queries requires an enormous amount of manual fine-tuning and results in a huge drain on IT resources.
For instance, trying to run a set of complex analytic queries alongside constantly changing schemas on a warehouse designed to store a deep amount of IT-oriented log data is like trying to use a dictionary to find driving directions. It involves a complete reconfiguration of the underlying data structures, requiring database designers to create indexes and data partitions. Indexing and partitioning also increase data size, in some cases by a factor of two or more.
In contrast, some of the new analytic database products eliminate these manual and ongoing efforts to provide a more "Google-like" experience, so that users can easily leverage the software to answer many types of questions. This level of flexibility presents the potential to reduce ongoing maintenance and operational support by as much as 90 percent. A business that only needs to build one solution that can be used by many optimizes staff usage, as well as time and financial investments. In addition, greater data analysis productivity means less hardware can be used without sacrificing performance.
Some companies are even moving to outsourced operations management, further reducing the number of resources required on-site. Simple to use and maintain, analytic, integration and intelligence solutions lend themselves well to this kind of arrangement as they can be easily administered by outsourced vendors.
Rick Abbott is President of 360DegreeView, LLC. Rick has over 19 years of information management and technology experience, including private and public sector work. On the commercial side, Rick has significant experience in both the telecommunications and financial services industries. Rick has over eight years of "Big 5" experience, including an associate partnership position with Deloitte Consulting. Rick's primary focus over the past 13 years has been on large-scale business intelligence initiatives. He has direct experience in all aspects of business intelligence and data warehouse projects including business case development, strategic planning and business alignment, business requirements, and technical architecture and design. He possesses over 10 years of large, IT-related project management experience. Rick also has significant experience in assisting clients in negotiating large technology product, service, and outsourcing contracts. Read Rick's blog here. He can also be reached at email@example.com.
Bob Zurek is Chief Technology Officer and Vice President of Product Management at Infobright. Bob is also responsible for client services including sales engineering and implementation services. Bob has over 25 years of proven success in software development, technology research, and product management. He also possesses deep expertise in database management systems, business intelligence, and open-source technologies. Prior to joining Infobright, Bob was vice president of products and CTO at EnterpriseDB. While at EnterpriseDB, Bob led the company's technology and product management operations for their open-source product line. Prior to EnterpriseDB, Bob held management positions at IBM, Ascential Software and other technology companies where he consistently demonstrated the ability to define and deliver market-leading products with strong competitive differentiation. Read Bob's blog here. He can also be reached at firstname.lastname@example.org.