Get started

Get started

Bring yourself up to speed with our introductory content.

• What's the difference between DDL and DML?

  What's the difference between DDL and DML? Get the answer and see examples of data manipulation language and data definition language commands for SQL databases. Continue Reading

• 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

• Google Cloud data lake fuels cloud payment processing flow

  To create a cloud payment processing system, Global Payments first had to deploy a data lake in the Google Cloud. Getting quick user feedback was another early step. Continue Reading

• Develop smart AI in CRM strategies to win and keep customers

  Of the three words that comprise customer relationship management, one word binds the other two. As necessity and competition dictate that CRM upgrade itself with artificial intelligence and flights to the cloud, what counts most in ... Continue Reading

• GDPR compliance requirements drive new winds of data privacy

  Hello, GDPR. May 25 is the witching hour for enforcement of the EU's much-discussed GDPR compliance requirements -- and it's a harbinger of more changes to come. Continue Reading

• Definitions to Get Started

  • What is data egress? How it works and how to manage costs
  • What is data?
  • What is Microsoft Visual FoxPro (VFP)?
  • What is corporate performance management (CPM)?

  • What is NoSQL (Not Only SQL database)?
  • What is a data fabric?
  • What is Structured Query Language (SQL)?
  • What is data validation?

  View All Definitions

• Why running SQL Server on Docker is no longer frowned upon

  Microsoft now lets SQL Server databases run in Docker containers, a capability that depends on using volumes to store data in a persistent way outside the containers.Continue Reading

• What does the GDPR definition of personal data include?

  The definition of personal data in the EU's GDPR data protection rules is broad enough to include any type of data that can be used to directly or indirectly identify a person.Continue Reading

• U-SQL

  U-SQL is a Microsoft query language that combines a declarative SQL-like syntax with C# programming, enabling it to be used to process both structured and unstructured data in big data environments.Continue Reading

• Data expert: GDPR deadline is an opportunity, not a burden

  There is stress as the EU's General Data Protection Regulation compliance deadline nears, but the GDPR privacy movement is a good thing for data policies, advises consultant Daragh O Brien.Continue Reading

• TensorFlow

  TensorFlow is an open source framework developed by Google researchers to run machine learning, deep learning and other statistical and predictive analytics workloads.Continue Reading

• Hyperledger Fabric offers path to enterprise blockchain future

  Blockchain arose from bitcoin, but it's looking to find a place in the enterprise. Frameworks like Hyperledger Fabric could smooth out the technology's rough side for business uses.Continue Reading

• Data lake concept needs firm hand to pay big data dividends

  Data lakes pose technology deployment and data management challenges that can leave analytics users high and dry if the implementation process isn't handled properly.Continue Reading

• Slow to gain traction, AI apps on the verge of explosion

  From chatbots ("Can I help you?") to killer bots ("I'll be back."), artificial intelligence runs the gamut of applications and emotions like no other technology. It's been nearly 70 years since AI first came into consciousness with humankind, yet ...Continue Reading

• Three ways to turn old files into Hadoop data sets in a data lake

  Hadoop data lakes offer a new home for legacy data that still has analytical value. But there are different ways to convert the data for use in Hadoop depending on your analytics needs.Continue Reading

• Hadoop data lake

  A Hadoop data lake is a data management platform comprising one or more Hadoop clusters.Continue Reading

• How AI and IoT will influence data management in 2018

  AI and IoT will alter the data management landscape in 2018, according to analyst James Kobielus. AI will need regular updates, and DevOps will become more prevalent as a result.Continue Reading

• MariaDB

  MariaDB is an open source relational database management system (DBMS) that is a compatible drop-in replacement for the widely used MySQL database technology.Continue Reading

• Microsoft SSIS (SQL Server Integration Services)

  Microsoft SSIS (SQL Server Integration Services) is an enterprise data integration, data transformation and data migration tool built into Microsoft's SQL Server database.Continue Reading

• Microsoft SQL Server Management Studio (SSMS)

  Microsoft SQL Server Management Studio (SSMS) is an integrated environment to manage a SQL Server infrastructure.Continue Reading

• How to select the best DBMS software: A buyer's guide

  Learn how to evaluate and buy the best DBMS software for your organization.Continue Reading

• 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

• A buyer's guide to selecting the best data warehouse product

  With several deployment options and product choices, it's difficult to know where to start. This buyer's guide helps you choose the right data warehouse product for your company.Continue Reading

• Three ways to build a big data system

  In a book excerpt, author Dale Neef outlines and compares different approaches organizations can take when trying to bring a big data system into their IT environments.Continue Reading

• Apache Spark architecture quiz: Do you know Spark?

  Apache Spark is an open source processing engine designed for use in big data applications. Take this quiz to see if you're up to speed on Spark's history and features.Continue Reading

• Five steps to implementing an MDM program

  Instituting a master data management program involves discovery, analysis, construction, implementation and sustainment processes, according to MDM expert Anne Marie Smith.Continue Reading

• Supermarket co-op stocks up on big data platform to help spur sales

  Co-operative Allegiance Retail Services is deploying a cloud-based big data stack to replace a homegrown system that fell short on analytics power.Continue Reading

• Identifying data quality issues via data profiling, reasonability

  In a book excerpt, author Laura Sebastian-Coleman explores data profiling, data issue management and using reasonability checks in assessing quality.Continue Reading

• Dissecting data measurement: Key metrics for assessing data quality

  In a book excerpt, data quality architect Laura Sebastian-Coleman explains data assessment terminology and details a framework for measuring quality.Continue Reading

• Quiz: Improving your data governance and data stewardship program

  Do you know what it takes for an effective data governance structure to take root in an organization? Take this quiz and find out.Continue Reading

• master data

  Master data is the core data that is essential to operations in a specific business or business unit.Continue Reading

• 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

• 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

• The evolution of MDM architecture

  Find out how MDM architecture has changed over the years and gain insight on architectural considerations to take into account when planning an MDM program and system.Continue Reading

• MDM and SOA: An introduction to SOA and the benefits of SOA

  Learn about MDM and SOA and how they relate. Read an introduction to SOA and learn about the benefits of SOA in this master data management and data governance book excerpt.Continue Reading

• An introduction to enterprise architecture framework and MDM patterns

  Get an introduction to enterprise architecture framework and MDM enterprise architecture patterns. Learn about MDM framework concepts and a definition of SOA.Continue Reading

• 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

• CRUD cycle (Create, Read, Update and Delete Cycle)

  The CRUD cycle describes the elemental functions of a persistent database in a computer.Continue Reading

• Sarbanes-Oxley compliance quiz: Are you SOX savvy?

  Test your knowledge of Sarbanes-Oxley compliance concepts and software by taking a SOX quiz.Continue Reading

• Enterprise data integration quiz

  Take this enterprise data integration quiz to test your knowledge of data integration terms, trends and technologies.Continue Reading

• Data quality and governance management quiz

  Test your knowledge of data quality and data governance management concepts, trends and vendor news in this short quiz. When you are done, check your answers and read detailed explanations for each response.Continue Reading