Welcome!

Containers Expo Blog Authors: Pat Romanski, Yeshim Deniz, Elizabeth White, Liz McMillan, Zakia Bouachraoui

Related Topics: Containers Expo Blog, Microservices Expo, @CloudExpo, Cloud Security, @DXWorldExpo, SDN Journal

Containers Expo Blog: Article

What to Do About the Data Silo Challenge

Using Data Abstraction to Bring Agility to BI and Analytics

Organizations today understand that better access to information assets can improve their bottom-line.

But they struggle with the variety of enterprise, cloud and big data sources, and all their associated access mechanisms, syntax, security, etc.  Further, few data sources are structured properly for business user or application consumption, let alone reuse.  And often the data is incomplete or duplicated.

Data Abstraction Addresses These Challenges
Data abstraction overcomes data source to data consumer incompatibility by transforming data from its native structure and syntax into reusable views and data services that are easy for application developers and business analysts to understand and consume.

Data Abstraction Technology Options
Some data abstraction approaches used today work better than others.

For example, some organizations build data abstraction by hand in Java or use business process management (BPM) tools.  Unfortunately, these are often constrained by brittleness and inefficiencies.  Further, such approaches are not effective for large data sets since they lack the robust federation and query optimization functions required to meet data consumers' rigorous performance demands.

Data warehouse schemas can also provide data abstraction.  Data modeling strategies for dimensions, hierarchies, facts and more are well documented.  Also well understood is the high cost and lack of agility in the data warehousing approach.  Further, data warehouse based schemas don't include the so many new classes of data (big data, cloud data, external data services and more) that reside outside the data warehouse.

Data Virtualization Is a Superior Solution for Data Abstraction
Data virtualization
is an optimal way to implement data abstraction at enterprise scale.  From an enterprise architecture point of view, data virtualization provides a semantic abstraction or data services layer supporting multiple consuming applications.  This middle layer of reusable services decouples the underlying source data and consuming solution layers. This provides the flexibility required to deal with each layer in the most effective manner, as well as the agility to work quickly across layers as applications, schemas or underlying data sources change.

Data Abstraction Reference Architecture
The diagram below outlines the layers that form Composite Software's Data Abstraction Reference Architecture.  Architects and analysts can use as a guide when building a data abstraction layer using Composite's data virtualization platform.  This various layers included in this reference architecture are described in Figure 1.

  • Data Consumers - Client applications want to retrieve data in various formats and protocols. They want to receive the data in a way that they understand. Data abstraction allows the consumers to format the data according to their specifications and deliver over various transport protocols including: Web Services, REST, JDBC and Java clients.
  • Application Layer - The "Application Layer" serves to map the Business Layer into the format which each application data consumer wants to see. It might mean formatting into XML for Web services or creating views with different alias names that match the way the consumers are used to seeing their data.
  • Business Layer - The "Business Layer" is predicated on the idea that the business has a standard or canonical way to describing key business entities such as customers and products. In the financial industry, one often accesses information according to financial instruments and issuers amongst many other entities. Typically, a data modeler would work with business experts and data providers to define a set of "logical" or "canonical" views that represent these business entities. These views are reusable components that can and should be used across business lines by multiple consumers.
  • Physical Layer - The "Physical Layer" provides access to underlying data sources and performs a physical to logical mapping.
    • The "Physical Metadata" is essentially imported from the physical data sources and used as way to onboard the metadata required by the data abstraction layer to perform its mapping functions. As an "as-is" layer, entity names and attributes are never changed in this layer.
    • The "Formatting Views" provide a way to map the physical metadata by aliasing the physical names to logical names. Additionally the formatting views can facilitate simple tasks such as value formatting, data type casting, derived columns and light data quality mapping. This layer is derived from the physical sources and performs a one-to-one mapping between the physical source attributes and their corresponding "logical/canonical" attribute name. This layer serves as a buffer between the physical source and the logical business layer views. Naming conventions are very important and introduced in this layer.
  • Data Sources -The data sources are the physical information assets that exist within and without an organization. These assets may be databases, packaged applications such as SAP, Web services, Excel spreadsheets and more.

Summary of Key Benefits
Data abstraction bridges the gap between business needs and source data's original form. This best practice implementation of data virtualization provides the following benefits:

  • Simplify information access - Bridge business and IT terminology and technology so both can succeed.
  • Common business view of the data - Gain agility, efficiency and reuse across applications via an enterprise information model or "Canonical" model.
  • More accurate data - Consistently apply data quality and validation rules across all data sources.
  • More secure data - Consistently apply data security rules across all data sources and consumers via a unified security framework.
  • End-to-end control - Use a data virtualization platform to consistently manage data access and delivery across multiple sources and consumers.
  • Business and IT change insulation - Insulate consuming applications and users from changes in the source and vice versa. Business users and pplications developers work with a more stable view of the data. IT can make ongoing changes and relocation of physical data sources without impacting information users.

More Stories By Robert Eve

Robert Eve is the EVP of Marketing at Composite Software, the data virtualization gold standard and co-author of Data Virtualization: Going Beyond Traditional Data Integration to Achieve Business Agility. Bob's experience includes executive level roles at leading enterprise software companies such as Mercury Interactive, PeopleSoft, and Oracle. Bob holds a Masters of Science from the Massachusetts Institute of Technology and a Bachelor of Science from the University of California at Berkeley.

IoT & Smart Cities Stories
Poor data quality and analytics drive down business value. In fact, Gartner estimated that the average financial impact of poor data quality on organizations is $9.7 million per year. But bad data is much more than a cost center. By eroding trust in information, analytics and the business decisions based on these, it is a serious impediment to digital transformation.
SYS-CON Events announced today that Silicon India has been named “Media Sponsor” of SYS-CON's 21st International Cloud Expo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Published in Silicon Valley, Silicon India magazine is the premiere platform for CIOs to discuss their innovative enterprise solutions and allows IT vendors to learn about new solutions that can help grow their business.
We are seeing a major migration of enterprises applications to the cloud. As cloud and business use of real time applications accelerate, legacy networks are no longer able to architecturally support cloud adoption and deliver the performance and security required by highly distributed enterprises. These outdated solutions have become more costly and complicated to implement, install, manage, and maintain.SD-WAN offers unlimited capabilities for accessing the benefits of the cloud and Internet. ...
Founded in 2000, Chetu Inc. is a global provider of customized software development solutions and IT staff augmentation services for software technology providers. By providing clients with unparalleled niche technology expertise and industry experience, Chetu has become the premiere long-term, back-end software development partner for start-ups, SMBs, and Fortune 500 companies. Chetu is headquartered in Plantation, Florida, with thirteen offices throughout the U.S. and abroad.
SYS-CON Events announced today that CrowdReviews.com has been named “Media Sponsor” of SYS-CON's 22nd International Cloud Expo, which will take place on June 5–7, 2018, at the Javits Center in New York City, NY. CrowdReviews.com is a transparent online platform for determining which products and services are the best based on the opinion of the crowd. The crowd consists of Internet users that have experienced products and services first-hand and have an interest in letting other potential buye...
Business professionals no longer wonder if they'll migrate to the cloud; it's now a matter of when. The cloud environment has proved to be a major force in transitioning to an agile business model that enables quick decisions and fast implementation that solidify customer relationships. And when the cloud is combined with the power of cognitive computing, it drives innovation and transformation that achieves astounding competitive advantage.
DXWorldEXPO LLC announced today that "IoT Now" was named media sponsor of CloudEXPO | DXWorldEXPO 2018 New York, which will take place on November 11-13, 2018 in New York City, NY. IoT Now explores the evolving opportunities and challenges facing CSPs, and it passes on some lessons learned from those who have taken the first steps in next-gen IoT services.
Cloud-enabled transformation has evolved from cost saving measure to business innovation strategy -- one that combines the cloud with cognitive capabilities to drive market disruption. Learn how you can achieve the insight and agility you need to gain a competitive advantage. Industry-acclaimed CTO and cloud expert, Shankar Kalyana presents. Only the most exceptional IBMers are appointed with the rare distinction of IBM Fellow, the highest technical honor in the company. Shankar has also receive...
DXWorldEXPO LLC announced today that ICOHOLDER named "Media Sponsor" of Miami Blockchain Event by FinTechEXPO. ICOHOLDER gives detailed information and help the community to invest in the trusty projects. Miami Blockchain Event by FinTechEXPO has opened its Call for Papers. The two-day event will present 20 top Blockchain experts. All speaking inquiries which covers the following information can be submitted by email to [email protected] Miami Blockchain Event by FinTechEXPOalso offers sp...
DXWordEXPO New York 2018, colocated with CloudEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.