Welcome!

Big Data Journal Authors: Pat Romanski, Elizabeth White, Adrian Bridgwater, Liz McMillan, Kevin Benedict

Related Topics: Big Data Journal, Java, SOA & WOA, .NET, Linux, Web 2.0

Big Data Journal: Article

Best Practices for Integrating Different Big Data Sources

Data organization eliminates potential future problems

Choosing when to adopt a data warehouse largely depends on how easily and effectively your organization can manage multiple data sources. When you do decide to combine all data sources into one central location, the decisions become more uniform. You can, of course, approach the integration of all data sources into a data warehouse in your own way, but if you’re not careful, you could create more problems than you solve.

To extract your data and load it into the new data warehouse, there are some basic must-follow rules that help avoid problems down the road. This process is often abbreviated to ETL, or Extract, Transform, Load. Let’s take a look at the steps and examine the best practices for each.

Extraction
There are quite a few things that could go wrong during the extraction process. This is when you’ll copy all the data from every data source in your company, including proprietary databases, files you’ve uploaded during your several years in business, APIs, and even all of your files within any cloud-based storage services you may use.

This may not sound too hard, but there are a few mistakes many make right from the beginning. The most common is copying all data every time they sync with the data warehouse. Consider the data sources you’ll be integrating into the new data warehouse. Do you really have the time or space to copy and transfer those millions of records every time? The time this takes can be a pain, which causes many companies to start relaxing how often and how much data they sync, without any real plan. You definitely don’t want to get your company into this type of situation.

Transformation
One big step toward ensuring you don’t copy and sync every file every time is to cleanse and optimize your data. During this step, the files will be denormalized and pre-calculated so that analysis is easier. By denormalized and pre-calculated, we mean that any inconsistencies will be discovered and resolved. Links with various tags will be standardized, notes and statuses will be examined and organized, and any methods for accessing data will be streamlined.

With these steps complete, there will be no need to continually copy and transfer the same data over and over. You can simply identify the new data, cleanse and denormalize, and then sync with the data warehouse.

Loading
Loading the data into the new data warehouse might be the easiest step, but you could still make critical errors if you’re not careful. You’ll still be working with several different types of information, and one mistake could corrupt several files at once.

Keep in mind that loading the millions of files your company has can take a lot of time, too. You don’t want to cut corners or walk away while the information is being transferred. To do so could result in the loss of vital information. Of course, you can always access this data again from the original sources, but going through the same process multiple times is a waste of company resources and time.

With all your information in one central place, there will never be the need to access several different data sources. You’ll save time, which saves money. You’ll avoid mistakes, which saves money. And you’ll save on additional equipment, which definitely saves money.

Are you ready to integrate all your data sources into one data warehouse? We’re happy to answer any questions you might have, so leave a comment to start the conversation!

More Stories By Keith Cawley

Keith Cawley is the media relations manager at TechnologyAdvice. a market leader in business technology recommendations. He covers a variety of business technology topics, including gamification, business intelligence, and healthcare IT.

Latest Stories from Big Data Journal
Enthusiasm for the Internet of Things has reached an all-time high. In 2013 alone, venture capitalists spent more than $1 billion dollars investing in the IoT space. With “smart” appliances and devices, IoT covers wearable smart devices, cloud services to hardware companies. Nest, a Google company, detects temperatures inside homes and automatically adjusts it by tracking its user’s habit. These technologies are quickly developing and with it come challenges such as bridging infrastructure gaps,...
Predicted by Gartner to add $1.9 trillion to the global economy by 2020, the Internet of Everything (IoE) is based on the idea that devices, systems and services will connect in simple, transparent ways, enabling seamless interactions among devices across brands and sectors. As this vision unfolds, it is clear that no single company can accomplish the level of interoperability required to support the horizontal aspects of the IoE. The AllSeen Alliance, announced in December 2013, was formed wi...
Goodness there is a lot of talk about cloud computing. This ‘talk and chatter’ is part of the problem, i.e., we look at it, we prod it and we might even test it out – but do we get down to practical implementation, deployment and (if you happen to be a fan of the term) actual cloud ‘rollout’ today? Cloud offers the promise of a new era they say – and a new style of IT at that. But this again is the problem and we know that cloud can only deliver on the promises it makes if it is part of a well...
There’s Big Data, then there’s really Big Data from the Internet of Things. IoT is evolving to include many data possibilities like new types of event, log and network data. The volumes are enormous, generating tens of billions of logs per day, which raise data challenges. Early IoT deployments are relying heavily on both the cloud and managed service providers to navigate these challenges. In her session at 6th Big Data Expo®, Hannah Smalltree, Director at Treasure Data, to discuss how IoT, B...
SYS-CON Events announced today that Connected Data, the creator of Transporter, the world’s first peer-to-peer private cloud storage device, will exhibit at SYS-CON's 15th International Cloud Expo®, which will take place on November 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA. Connected Data is the creator of Transporter, the world’s first peer-to-peer private cloud storage device. Connected Data is focused on providing elegantly designed solutions for consumers, professi...
Cisco on Wedesday announced its intent to acquire privately held Metacloud. Based in Pasadena, Calif., Metacloud deploys and operates private clouds for global organizations with a unique OpenStack-as-a-Service model that delivers and remotely operates production-ready private clouds in a customer's data center. Metacloud's OpenStack-based cloud platform will accelerate Cisco's strategy to build the world's largest global Intercloud, a network of clouds, together with key partners to address cu...
I write and study often on the subject of digital transformation - the digital transformation of industries, markets, products, business models, etc. In brief, digital transformation is about the impact that collected and analyzed data can have when used to enhance business processes and workflows. If Amazon knows your preferences for particular books and films based upon captured data, then they can apply analytics to predict related books and films that you may like. This improves sales. T...
Technology is enabling a new approach to collecting and using data. This approach, commonly referred to as the “Internet of Things” (IoT), enables businesses to use real-time data from all sorts of things including machines, devices and sensors to make better decisions, improve customer service, and lower the risk in the creation of new revenue opportunities. In his session at Internet of @ThingsExpo, Dave Wagstaff, Vice President and Chief Architect at BSQUARE Corporation, will discuss the real...
IoT is still a vague buzzword for many people. In his session at Internet of @ThingsExpo, Mike Kavis, Vice President & Principal Cloud Architect at Cloud Technology Partners, will discuss the business value of IoT that goes far beyond the general public's perception that IoT is all about wearables and home consumer services. The presentation will also discuss how IoT is perceived by investors and how venture capitalist access this space. Other topics to discuss are barriers to success, what is n...
When one expects instantaneous response from video generated on the internet, lots of invisible problems have to be overcome. In his session at 6th Big Data Expo®, Tom Paquin, EVP and Chief Technology Officer at OnLive, to discuss how to overcome these problems. A Silicon Valley veteran, Tom Paquin provides vision, expertise and leadership to the technology research and development effort at OnLive as EVP and Chief Technology Officer. With more than 20 years of management experience at lead...