Data integration
Most organizations draw data from multiple sources, including external ones. Data integration combines this data to create unified sets of information for tracking business performance and managing operations. Learn about data integration strategies to ensure information from multiple sources is consistent to meet users' data analysis needs across the organization.
Top Stories
-
Tip
12 Jul 2024
7 data modeling techniques and concepts for business
Three types of data models and various data modeling techniques are available to data management teams to help convert data into valuable business information. Continue Reading
-
News
10 Jul 2024
Graph technology helps battle election misinformation
Backed by a grant from Neo4j, including free use of its platform, Syracuse University is exposing coordinated networks that spread election misinformation on social media. Continue Reading
-
News
21 Mar 2019
Machine learning approaches gain critical mass for data pros
Machine learning will bring change to analytics and data management, said data luminary Michael Stonebraker. Others agree managing such change will take special effort. Continue Reading
-
Feature
06 Mar 2019
Augmented data management draws more enterprise interest
With AI and machine learning, organizations are starting to augment their data management. This is changing the way enterprise users capture, govern and integrate data. Continue Reading
-
Feature
27 Feb 2019
How to navigate the challenges of the data modeling process
Data modeling and curation can help businesses more efficiently use data they've collected. There are challenges, however -- beginning with ensuring data quality. Continue Reading
-
Feature
13 Feb 2019
5 best practices for managing real-time data integration
Real-time data integration isn't like traditional data integration -- "it's moving, it's dirty and it's temporal," cautions one data pro. Experts offer up some best practices. Continue Reading
-
News
11 Feb 2019
Web integration platform eases way to machine learning models
StoryFit data scientists employ machine learning algorithms to gauge film script scenarios' prospects. They use Import.io tools to make data preparation easier. Continue Reading
-
Feature
29 Jan 2019
5 data management infrastructure technologies to evaluate
It's the start of a new year -- is your organization ready to face the data management challenges ahead? Here are five technologies to consider adopting. Continue Reading
-
News
21 Jan 2019
Data.gov shutdown shows limits of open data
The Data.gov shutdown shows that, as open data can be turned off, data professionals may need to consider alternative sources for the kinds of data the government offers. Continue Reading
-
News
28 Dec 2018
Data management trends for 2019: Governance, DataOps, cloud
Better data governance, increased cloud use and wider DataOps adoption head the list of trends for data management teams to plan for in 2019, IT analysts say. Continue Reading
-
Feature
30 Nov 2018
Don't let blockchain complexity bog down business applications
Enterprise blockchain applications that run in a controlled environment don't require some of the components of cryptocurrency networks, explains expert David Teich. Continue Reading
-
News
06 Nov 2018
IBM-Red Hat deal highlights changes due in data processing
The IBM acquisition of Red Hat marks a watershed in computer architecture. The duo says it can rebuild data applications in new ways. This news analysis explores what's coming. Continue Reading
-
Podcast
27 Sep 2018
Big data platform broadens place in analytics architecture
Big data platforms stumbled a bit getting out of the prototyping stage. But a view from the Strata Data Conference in New York sees broader use in the offing. Continue Reading
-
Feature
26 Sep 2018
Mining equipment maker uses BI on Hadoop to dig for data
BI on Hadoop is still new, but moving BI to data is trending. A data scientist working with IoT data at Komatsu sees the importance of getting big data to the right people. Continue Reading
-
News
16 Aug 2018
Chief data officer skills tested by AI tech blitz
A reporter's notebook from a recent MIT symposium provides insights on chief data officer needs, as the AI wave starts to hit CDOs and affects them more than most other tech trends. Continue Reading
-
Tip
13 Jul 2018
How graph data modeling can help evaluate database tools
Mapping data to a graph model can be challenging, but these steps can help you create prototype applications -- which then can aid in evaluating graph databases. Continue Reading
-
Tip
27 Jun 2018
Three factors for protecting sensitive data in the GDPR era
Data privacy is a hot topic nowadays thanks to GDPR and the Facebook data scandal. But how do data security, access control and data protection differ? Continue Reading
-
Tip
18 Jun 2018
What goes into a customer analytics data integration framework
Customer data integration is a minefield for IT teams to navigate. But incorporating a set of core technical functions into an integration architecture can ease the process. Continue Reading
-
Tip
18 Jun 2018
Data integration techniques to help keep BI data consistent
Data integration processes that aren't managed properly can create inconsistent data in BI and analytics applications. Here are some steps to avoid that problem. Continue Reading
-
Feature
09 Apr 2018
Information architecture applied to big data streaming, AI
New technologies challenge data professionals, but taking a step back helps with hurdles. In this interview, consultant William McKnight takes a measured look at data streaming, GDPR and AI. Continue Reading
-
Feature
06 Apr 2018
Cloud workloads, data lakes challenge information architecture
Data management options are expanding; cloud workloads are an example. That means changing your approach to information architecture, says data management expert William McKnight. Continue Reading
-
Podcast
22 Feb 2018
Google TPUs open up on cloud; LinkedIn intros Hadoop Dynamometer
In big data news, we find Google TPUs, or Tensor Processing Units, offered as a cloud service, while LinkedIn is open sourcing a Hadoop test simulator called Dynamometer. Continue Reading
-
Tip
13 Feb 2018
Data analytics architecture must break down higher ed silos
Siloed data isn't only a problem for businesses. It's also a big issue for many large universities -- one that their data infrastructures need to resolve for effective analytics. Continue Reading
-
Answer
21 Dec 2016
What are key features for choosing the best ETL tools for your needs?
Choosing the right ETL tool for your data integration requirements can be a challenge. Here's a rundown on what to look for in ETL software and potential vendors to consider. Continue Reading
-
Feature
29 Jun 2016
Inside the SAP Data Services data integration tool
SAP Data Services can be used alone or with other SAP products to provide data integration, transformation, data quality, data profiling and text data processing. Continue Reading
-
Feature
29 Jun 2016
An overview of the Pentaho Data Integration platform
The Pentaho Data Integration platform enables organizations to integrate, blend, convert and transform data from any data source across their entire enterprise. Continue Reading
-
Feature
03 Jun 2016
What you need to know about Oracle Data Integrator 12c
Oracle Data Integrator 12c works with several other Oracle products to leverage the capabilities of RDBMSs for processing and transforming data. Continue Reading
-
Tip
18 May 2015
Relational database design tips to boost performance
As relational database management systems handle more and more data, a strategic approach to data modeling has become vital. Continue Reading
-
01 May 2015
Key considerations for determining if a NoSQL DBMS meets your IT needs
A broad range of nouveau database systems can be helpful for organizations that need to crunch large volumes of unstructured, fast-moving data -- but there’s a lot to look out for. Continue Reading
-
News
21 Apr 2011
Disney discovers a whole new world of data warehouse best practices
The director of data warehousing and analytics at Walt Disney Parks and Resorts shares some important BI and data warehouse best practices. Continue Reading
-
Tutorial
06 Apr 2011
Structuring data integration models and data integration architecture
Get tips on structuring data integration models and data integration architecture. Learn how to build a business case for data integration modeling and leverage process modeling. Continue Reading
-
Tutorial
06 Apr 2011
Using logical data models for data integration modeling
Learn about using logical data models for data integration modeling. Get an overview of using a target-based data integration design technique. Continue Reading
-
News
23 Mar 2011
Capacity planning for the data warehouse environment
Capacity planning is essential for all data warehouse environments. Data warehouses grow at high rates and must be managed to keep budgets under control. Continue Reading
-
Tutorial
16 Sep 2010
Data integration maturity levels and the future of data integration
Read about current data integration maturity levels, data integration trends, how data integration technologies have evolved and the future of the data integration market. Continue Reading
-
Answer
02 Aug 2010
What is the difference between data definition language (DDL) and SQL?
Learn the difference between a data definition language (DDL), also known as data descriptive language, and the Structured Query Language (SQL). Find examples of both DDL and SQL. Continue Reading
-
Answer
01 Jun 2010
Steps for converting a logical data model into a physical data model
Learn how to convert a logical data model into a physical data model via data modeling best practices. Find out how DDL and your data modeling practices play a role in conversions. Continue Reading
-
Answer
01 Jun 2010
Data modeling tools: Best practices for selection and evaluation
Get best-practices advice and tips for choosing and evaluating data modeling tools. Also, learn how to define data modeling requirements and use your data governance council. Continue Reading
-
Feature
26 Oct 2009
Advantages and disadvantages of XML shredding
Learn about the advantages and disadvantages of XML shredding and different shredding methods, plus find out when shredding is and isn't a good option for your company. Continue Reading
-
Feature
27 Jul 2009
An introduction to database transaction management
Find out the performance advantages of using one connection for multiple statements in this database tutorial. Get a definition of local vs. distributed transactions and learn how to manage database transactions. Continue Reading
-
Feature
11 Jun 2009
Similarities and differences between ROLAP, MOLAP and HOLAP
Find out the differences between ROLP, MOLAP and HOLAP and their advantages and disadvantages. Learn about data quality and the evolution of data warehouse applications. Continue Reading
-
Feature
20 May 2009
Data modeling for the business: What is a data model?
Learn about high-level data modeling, what a data model is and how business and IT can use logical data modeling to plan a data design with these best practices from a data modeling handbook and guide. Continue Reading
-
Answer
14 Oct 2008
What are the components of service-oriented architecture (SOA)?
What are the components that make up service-oriented SOA? Find out in this expert response. Continue Reading
-
Answer
21 May 2008
Enterprise versus project level conceptual data modeling
Learn the differences between enterprise level and project level conceptual data modeling, and find out how both approaches are compatible. Continue Reading
-
News
08 May 2008
A brief history of ETL
"Do you remember the spread of data warehousing through the public and then private sectors? The IPO of Prism Solutions? This article takes a look at the history of ETL and provides a glimpse into ETL's future." Continue Reading
-
Answer
22 Apr 2008
Data model conversion: Conceptual design to logical design using an ER model
Learn two common approaches to converting a data model from a conceptual design to a logical design. Continue Reading
-
Answer
28 Nov 2007
The ETL process and MySQL
Get advice on the ETL process and ETL tools for transforming raw data in MySQL. Continue Reading
-
Answer
23 Oct 2007
What are the benefits of a conceptual data model?
Learn the functions and potential benefits of a conceptual data model, from data modeling expert Pete Stiglich. Continue Reading
-
Feature
21 Jun 2007
Continuous integration: The value of CI
Learn about the value of continuous integration and get reasons why continuous integration can benefit the enterprise in this free sample chapter download. Continue Reading