Enterprise Data Warehousing (EDW) has been an important technology for many years. The basis of the need for data storage and management shows little sign of slowing based on several recent articles that we have seen pop up in The Trend Point over the past week.
One article discusses how Hadoop will impact EDW technologies. “The Future of EDW’s with Hadoop on the Horizon” shares the following:
HBase/Hive are all still very IT focused. They need people with lot of expertise in writing MapReduce programs in Java, Pig, and other specialized languages. Business users who actually need the data are not in a position to run ad-hoc queries and analytics easily without involving IT…Most EDW come with pre-built adaptors for various ERP systems and databases. Companies have built complex ETL functions, data marts, analytics and reports on top of these warehouses. It will be extremely expensive, time-consuming and risky to recode that into a new Hadoop environment…
Another article we saw points to this major emphasis on an efficient and intuitive user experience for professionals in any given organization that are not data experts. “Kerns Interview Shines Light on Future of EDW” sources information found on IBM Big Data Hub:
…what should be happening more, is a trend around users, especially the people who don’t know much about data and don’t exactly need to know much about the data but need answers…Any user who doesn’t know anything about the data side should be able to go into their enterprise interface and type ‘regional sales’ and then have a chart pull up. We should not have to ask people to construct queries for everything.
During the Enterprise Data World event that happened about a month ago, Unified Information Access was a topic that Cambridge Semantics presented on. In “Making Sense of Unstructured Data” we saw the following summary:
Cambridge Semantics will present the case for Unified Information Access at this year’s Enterprise Data World event. Addressing hot topics such as data integration, the challenges of effective MDM and SOA, and enterprise information management, Cambridge Semantics founding team members will highlight how Unified Information Access, powered by semantics, can serve as a critical differentiator for enterprise data management initiatives.
What we are seeing is a push for next generation EDW solutions – or rather the next generation of solutions encompassing EDW,Search and semantic tehcnologies. Many companies are interested in a solution that works out-of-the-box and is not IT-dependent, but that still offers plenty of data accessibility and search capabilities. Unified Information Access (UIA) is leading the way in this sector. With the functionality of both traditional EDW mixed with the ability to perform semantic analysis and extraction on unstructured data, this type of technology goes above and beyond traditional enterprise search and data warehousing.
Search and semantic technologies can contribute in two different ways (amongst others): Augment (meta) data that can then be treated by traditional DW analystics. Extend analysis to unstructured data, for example from public information Websites, in order to deliver the reasons behind changes in figures and performance indicators in BI dashboards.
Visualization and analytics become just a short step for analysts to take when they access data through a UIA platform.
Jane Smith, May 22, 2012