Data modeling tools and techniques
Top Stories
-
Feature
26 Jan 2022
NLP and AI boost the automated data warehouse
Businesses are working to automate as many elements of their data warehouses as they can through nascent tools like augmented analytics and natural language processing. Continue Reading
-
Tip
30 Dec 2021
Top 5 elements needed for a successful data warehouse
While conventional data warehouses may struggle to keep up with growing volumes of data, these five elements best give the ability to tap into valuable BI. Continue Reading
-
Feature
06 Feb 2018
Data catalog software takes open data initiative to the streets
Data catalog software from Alation helped San Diego's chief data officer open up the city's data to residents, as well as city planners and other government workers. Continue Reading
-
Opinion
02 Feb 2018
Data managers should study up on GPU deep learning
As GPU deep learning becomes more common, data managers will have to navigate several new layers of complexity in their quest to build or buy suitable data infrastructure. Continue Reading
-
Tip
01 Feb 2018
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
-
Podcast
23 Jan 2018
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
-
News
03 Jan 2018
Apache Hadoop 3.0 goes GA, adds hooks for cloud and GPUs
Is this the post-Hadoop era? Not in the eyes of Hadoop 3.0 backers, who see the latest update to the big data framework succeeding in machine learning applications and cloud systems. Continue Reading
-
Feature
21 Dec 2017
How SQL Server containers in Docker can ease database deployment
Docker containers can make the SQL Server deployment process more efficient and flexible. Here's what they are and how to get started on creating containers for SQL Server databases. Continue Reading
-
Answer
27 Oct 2017
Dimension tables vs. fact tables: What's the difference?
Fact tables and dimension tables are used together in star schemas to support data analytics applications. But they play different roles and hold different types of data. Continue Reading
-
Feature
19 Oct 2017
NewSQL databases rise anew -- MemSQL, Spanner among contenders
The NewSQL database was almost hidden when Hadoop and NoSQL arose. Now, as more big data teams move toward production uses, MemSQL, Cloud Spanner and similar products may get a second look. Continue Reading
-
Feature
26 Sep 2017
Bank sees ETL processes evolve from IT to front-line users
ETL jobs -- once the sole province of IT -- take on a new form as data wrangling and self-service gain greater traction with business users of analytics. Continue Reading
-
Feature
21 Aug 2017
Data management processes take on a new tenor in analyst's view
Changes in data management processes -- including self-service data preparation, data lakes and real-time analytics -- create a new landscape in companies, according to analyst Matt Aslett. Continue Reading
-
News
24 Jul 2017
Chief data officer jobs call for nurturing data ethos in companies
In many organizations, chief data officer jobs centered on defense against risk are giving way to ones emphasizing innovation. To do so, CDOs must nurture a data culture, MIT panelists said. Continue Reading
-
Quiz
11 Jul 2017
Quiz: What's your IQ on data lake implementation and management?
A data lake can provide lots of analytics value to an organization. This quiz can tell you if you know what it takes to deploy and manage one; it also contains info to help boost your knowledge. Continue Reading
-
Answer
17 May 2017
Operational data store vs. data warehouse: How do they differ?
Operational data stores and data warehouses both store operational data, but the similarities between them end there -- and they both have a role to play in analytics architectures. Continue Reading
-
Feature
23 Feb 2017
Many say yes to NoSQL software for easing big data management woes
NoSQL software is seen answering the need for a more flexible database framework to capture, manipulate and analyze massive amounts of unstructured data. Continue Reading
-
Buyer's Guide
13 Feb 2017
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
-
Feature
10 Feb 2017
A look at the leading operational database management systems
The market for operational DBMS products can be confusing, especially with so many choices. But knowing your application requirements can help point you in the right direction. Continue Reading
-
Tip
19 Jan 2017
Options for scaling out SQL Server applications to boost workloads
Scaling out a database to meet the needs of a heavy processing workload can be a challenge. Here are details on the SQL Server scalability methods available to ease the process. 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
05 Dec 2016
Microsoft SQL Server 2016 relational DBMS overview
Microsoft SQL Server 2016 for Windows comes in four editions, with updates that include a new stretch database feature, Polybase, dynamic data masking and more. Continue Reading
-
Feature
24 Oct 2016
Reltio master data management architecture rides graph analytics wave
An onslaught of unstructured data, social and otherwise may change the nature of master data management platforms. Reltio Cloud may stand as an indicator. Continue Reading
-
Buyer's Guide
24 Oct 2016
How to determine which data governance tool best meets your needs
This buyer's guide provides insights to help you determine if your organization could benefit from data governance software and how to navigate the buying process. Continue Reading
-
Feature
28 Sep 2016
Examining the top data governance tools on the market
Expert John Ladley examines the leading data governance software products, comparing and contrasting their features to help you determine which tool will best meet your needs. Continue Reading
-
Feature
19 Sep 2016
Alation Data Catalog helps provide collaborative data governance
Alation Data Catalog provides business analysts and data stewards with search and discovery, governance and collaboration functionality, and automates many data governance tasks. Continue Reading
-
News
15 Sep 2016
HPE sells Vertica analytics, thanks to the growth of open source software
HPE is paring down its software holdings, including analytical database software in the Vertica line and other big data tools. A sale to Micro Focus is due to close next year, leaving users in some limbo for now. Continue Reading
-
Feature
29 Aug 2016
What you should know about Collibra Data Governance Center
Collibra Data Governance Center is a repository- and workflow-oriented data governance platform that also offers features for data management and data stewardship. Continue Reading
-
Feature
25 Aug 2016
How to narrow down your choices for buying a data governance tool
Evaluating and selecting a data governance tool depends on not only features and functionality, but also how you will use the tool to add value to your organization. Continue Reading
-
Feature
08 Jul 2016
Exploring the features of Oracle Enterprise Manager 13c
Cloud Control, a feature of Oracle Enterprise Manager 13c, can be used to monitor and manage databases, middleware, infrastructure and hardware running on-premises or in the cloud. Continue Reading
-
Feature
06 Jul 2016
Inside BMC's database performance tools for DB2 for z/OS
BMC offers several tools to help DBAs manage and prevent critical performance issues in DB2 for z/OS, as well as monitoring options for other vital mainframe subsystems. 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
17 Jun 2016
Examining the functions and features of database performance tools
To help you determine which tools your organization needs, it's important to review the primary features and functionality of the three database performance tools categories. Continue Reading
-
Feature
08 Jun 2016
Three indicators that could signal database performance issues
Database performance monitoring and management tools can be used to mitigate issues and help organizations be more proactive, so they can avoid performance problems and outages. 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
-
Feature
12 May 2016
What you need to know about database performance software
Database performance software identifies bottlenecks and points of contention, monitors workload and throughput, and manages system and DBMS resource usage. Continue Reading
-
Feature
26 Apr 2016
Inside the MapR Hadoop distribution for managing big data
The MapR Hadoop distribution replaces HDFS with its proprietary file system, MapR-FS, which is designed to provide more efficient management of data, reliability and ease of use. Continue Reading
-
Feature
21 Apr 2016
What to know about the IBM Information Governance Catalog
IBM's Information Governance Catalog provides organizations with a workflow-oriented data governance tool for organizing, managing and accessing their data assets. Continue Reading
-
Buyer's Guide
30 Mar 2016
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
-
Blog Post
25 Mar 2016
Unstructured data is a misnomer
Nowadays, the term unstructured data pops up everywhere. It owes its popularity for a large part to the success of big data, to successful technologies such as NoSQL and Hadoop, and to formats such ... Continue Reading
-
Feature
22 Mar 2016
Five factors to help select the right data warehouse product
How big is your company, and what resources does it have? What are your performance needs? Answering these questions and others can help you select the right data warehouse platform. Continue Reading
-
Feature
10 Mar 2016
A look inside the SAP IQ column-oriented database
The SAP IQ column-oriented database is designed for large data warehouses that require high scalability, rapid data loading and optimal query performance. Continue Reading
-
Feature
09 Mar 2016
Examining the Teradata Data Warehouse
With both relational and columnar options, the Teradata Active Enterprise Data Warehouse gives companies an efficient, scalable appliance they can deploy in-house or in the cloud. Continue Reading
-
Feature
24 Feb 2016
Evaluating the key features of data warehouse platforms
Choosing between the different types of data warehouse platforms can be simplified once you know which deployment option best meets your project requirements. Continue Reading
-
Feature
17 Feb 2016
What to expect from Oracle Exadata Database Machine
Oracle Exadata Database Machine combines hardware and software to enable analytics, batch, reporting and other tasks to run simultaneously within and across databases. Continue Reading
-
Feature
15 Feb 2016
Examining the IBM PureData System for Analytics appliance
Powered by Netezza technology, the IBM PureData System for Analytics data warehouse appliance enables users to execute complex queries and get results quickly. Continue Reading
-
News
29 Jan 2016
Data quality metrics a governance must, managers say
Data governance managers who spoke during an online conference said that tracking business-oriented metrics on data quality improvement is a key to success in governance efforts. Continue Reading
-
Feature
16 Nov 2015
The benefits of deploying a data warehouse platform
Big data may be all the rage, but data warehouse platforms are still being utilized by companies of all sizes. Expert Craig S. Mullins takes a look at the technology. Continue Reading
-
Feature
29 Oct 2015
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
-
Blog Post
05 Oct 2015
Big Data Myth 3: Big Data is Too Big for SQL
The third big data myth in this series deals with how big data is defined by some. Some state that big data is data that is too big for a relational database, and with that, they undoubtedly mean a ... Continue Reading
-
Feature
14 Aug 2015
Types of NoSQL databases and key criteria for choosing them
In a book excerpt, consultant Dan Sullivan offers insights into how to select the right type of NoSQL database for the right application in your organization. Continue Reading
-
Feature
13 Aug 2015
How to identify master data in a multi-domain MDM program
In an excerpt from their book on managing multi-domain master data management programs, Mark Allen and Dalton Cervo explain how to identify MDM domains and your master data. Continue Reading
-
Feature
07 Aug 2015
SAP HANA in-memory DBMS overview
SAP HANA is an in-memory DBMS and application platform designed to handle high transaction rates and complex queries using one data copy. Continue Reading
-
Feature
31 Jul 2015
Redis open source DBMS overview
The Redis open source DBMS provides a highly scalable data store that can be shared by multiple processes, applications or servers. Continue Reading
-
Feature
27 Jul 2015
MySQL open source RDBMS overview
Developers, database administrators and DevOps teams use MySQL open source RDBMS to more easily operate next-generation applications in the cloud. Continue Reading
-
Blog Post
02 Jul 2015
Convergence of Data Virtualization Servers and SQL-on-Hadoop Engines?
Hadoop has become a popular and powerful platform for data storage and data processing. Data stored in Hadoop can be used by a wide range of applications and tools and for a wide range of use ... Continue Reading
-
Quiz
11 Jun 2015
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
-
Feature
11 Jun 2015
Which in-memory DBMS best fits your company's needs?
Database expert Craig S. Mullins examines some top in-memory DBMS software offerings to help you determine which is the best fit for your organization. Continue Reading
-
Feature
04 Jun 2015
Oracle Database 12c relational database management system overview
Oracle Database 12c delivers strong performance for mission-critical workloads, with features and functionality for diverse processing needs and requirements. 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
-
E-Zine
07 May 2015
Sort through types of database management systems before you buy
The database management system lies at the center of any organization's business activities. It houses the data that pumps life into operations and analytics applications and ensures that it's managed and manipulated securely. But the types of database management systems, or DBMSes, are numerous -- and organizations starting the evaluation process need to first examine the data they need to process, says data management consultant Craig S. Mullins in this special edition of Business Information. Is it traditional, structured data? Or is it a vast pool full of audio and video streams, social media data and other unstructured information?
First, Mullins surveys the database product landscape, detailing the advantages of the types of database management systems on the market, breaking them into three main categories: relational database management systems, NoSQL databases and in-memory databases. Next Mullins takes a close look at relational systems. Any organization shopping for a database system should begin here, he says, because relational databases are good for a wide range of uses -- traditional data management and analytical applications, batch processing and more. Finally, Mullins explores the relatively new world of NoSQL database systems, known for their able handling of big data. NoSQL has its own types of database management systems, falling into four categories: key-value, document, column and graph. Each is suitable for particular uses, so companies may want to consider mixing and matching, depending on their data needs. Continue Reading -
Opinion
01 May 2015
With database management tools, never settle
They're the heart of it all, pumping data to applications and business processes. But the sheer number of products on the market can boggle any mind. 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
-
01 May 2015
Key criteria for deciding if a relational DBMS meets your IT needs
For many organizations, a relational database management system will get the job done; others need to keep looking to fulfill their needs. Continue Reading
- 01 May 2015
-
Feature
30 Apr 2015
Which relational DBMS is best for your company?
Database expert Craig S. Mullins examines the top relational database management system software to determine which best fits your organization. Continue Reading
-
Feature
17 Apr 2015
How to determine if an in-memory DBMS is right for your company
Database expert Craig S. Mullins examines the pros and cons of the in-memory database management system, and the criteria you should consider during the request-for-proposal and evaluation period. Continue Reading
-
Feature
27 Mar 2015
Key considerations for determining if a NoSQL DBMS meets your IT needs
NoSQL represents the fastest-growing type of DBMS being adopted today. Is it right for you? Continue Reading
-
Feature
24 Feb 2015
Key criteria for deciding if a relational DBMS meets your IT needs
For many organizations, a relational database management system will get the job done; others need to keep looking to fulfill their needs. Continue Reading
-
Answer
19 Feb 2015
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
-
News
04 Jun 2014
Apache Spark goes 1.0, looks to improve on MapReduce performance
The Apache Software Foundation released Version 1.0 of Spark, a processing framework aimed at outpacing MapReduce for machine learning and other uses. Continue Reading
-
Quiz
30 May 2014
Quiz: How do relational databases and NoSQL technologies compare?
Take this quiz to see what you know about the recent developments in the world of RDBMS and NoSQL databases technologies. Continue Reading
-
Feature
30 May 2014
Conversation with Monash: On horses for courses and parallelism
Data industry viewer Curt Monash discusses parallelism and more as new databases gain attention. Part 1 in a series. Continue Reading
-
Answer
29 May 2014
Seven best practices to boost big data governance efforts
Governing big data is much like governing other data, though businesses must adjust governance processes to accommodate larger, more varied data sets. Continue Reading
-
Feature
22 May 2014
Former shadow IT worker helps bring analytics data into the light
Ryan Fenner worked in a shadow IT unit at Union Bank for years. Now he's helping lead an IT effort to better manage BI data created in those shadows. Continue Reading
-
News
20 May 2014
Podcast report covers recent Enterprise Data World event
This week's Talking Data podcast recaps Enterprise Data World and a mother lode of data quality information. Continue Reading
-
News
08 May 2014
Big data charge could turn data management profession on its head
Discussed at DAMA's EDW 2014 were more flexible approaches to the data management profession. That's in response to growing mountains of diverse data. Continue Reading
-
Opinion
28 Apr 2014
Big data cloud is changing familiar database tech tune
New cloud database applications that increasingly fall into the "big-data-intensive" category are shaking up the usual build-or-buy soliloquy. Continue Reading
-
News
22 Apr 2014
Touched by analytics: Scenes from Gartner business intelligence event
In the latest Talking Data podcast, SearchCIO's Nicole Laskowski reports on doings at the recent Gartner business intelligence summit. Continue Reading
-
Feature
14 Apr 2014
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
-
Feature
28 Feb 2014
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
-
Feature
28 Feb 2014
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
-
Tip
16 Jan 2014
Using data profiling techniques -- and estimating the effort required
Data profiling is a key part of data quality efforts. Here's a simple formula for calculating the amount of time needed to profile a data set. Continue Reading
-
Tutorial
23 Dec 2013
Exploring data virtualization tools and technologies
Learn about data virtualization technology in this guide, which includes news and trend stories, case studies, interviews and videos. Continue Reading
-
News
21 Nov 2013
Strata Conference East 2013: Data professionals confront privacy, access issues
In a podcast, SearchDataManagement's Jack Vaughan reports on data issues as discussed at Strata East 2013 in New York, and IBM IOD 2013 in Las Vegas. Continue Reading
-
Guide
30 Oct 2013
Building an effective data governance framework
This essential guide examines data governance and data stewardship from various angles, outlining best practices and answers to common challenges. Continue Reading
-
Quiz
15 Oct 2013
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
-
Feature
27 Sep 2013
Big data, fast: Avoiding Hadoop performance bottlenecks
A variety of performance issues can bog down Hadoop clusters. But there are ways to sidestep the pitfalls and keep your big data environment humming. Continue Reading
-
News
09 Sep 2013
Survey: Execs buying into big data in a big way
TechTarget's Wayne Eckerson discusses survey results showing that two-thirds of respondents expect to spend more than $1 million on big data programs this year. Continue Reading
-
Tip
03 Sep 2013
Data steward role needs some shepherding itself
Consultant David Loshin gives suggestions for building and managing a data stewardship program that can effectively support data governance. Continue Reading
-
Feature
29 Aug 2013
Big data adds new complications for data stewards
In order to accommodate big data and the needs of data scientists, data stewards will need to adjust to a more short-term view of data stewardship. Continue Reading
-
Tip
20 Aug 2013
Data governance tools: Part, but not all, of the governance puzzle
While tools designed for data governance are helpful, organizations must also implement best practices and standard processes to be effective. Continue Reading
-
Feature
15 Aug 2013
Gartner describes the building blocks for a strong MDM program
MDM teams should consider these seven building blocks, outlined by Saul Judah, research director on the information management team at Gartner Inc. Continue Reading
-
Feature
12 Jun 2013
Enterprise data quality efforts in good company with MDM, governance
Combining data quality initiatives with master data management and data governance programs can help ensure that data remains accurate and consistent. Continue Reading
-
News
12 Jun 2013
Enterprise data quality efforts in good company with MDM, governance
Tying data quality initiatives to master data management and data governance programs can help ensure that data remains accurate and consistent. Continue Reading
-
News
14 May 2013
Enterprise Data World reveals keys to a successful career in analytics
SearchDataManagement's Mark Brunelli and Jack Vaughan talk about this year's Enterprise Data World conference, which was held recently in San Diego. Continue Reading
-
Tip
22 Apr 2013
Real-time querying in Hadoop? Not so fast
Hadoop vendors are adding real-time query engines to the open source software. But the jury is out on that effort, writes Wayne Eckerson. Continue Reading
-
News
08 Mar 2013
Informatica looks up, despite down year in 2012
TechTarget's Wayne Eckerson reflects on Informatica after briefings with company execs. His take: It's poised to join the ranks of elite vendors. Continue Reading
-
Feature
31 Oct 2012
Successful data stewardship framework needs solid plan, firm focus
Stewarding data can be a tough nut to crack: lots of effort for a reward that isn't always apparent. To succeed, strong project management is needed. Continue Reading
-
Feature
26 Sep 2012
Data stewardship program: Quality booster, but a hard step for many
While data stewardship can help improve the quality of corporate data, analysts say there's more talk than action when it comes to adopting the concept. Continue Reading
-
Feature
19 Aug 2012
Make communication, purpose priorities in a data governance program
Data governance can be all bureaucracy and no benefit. To avoid that, managing the process effectively is a must, says consultant Danette McGilvray. Continue Reading
-
Feature
08 Aug 2012
Mission impossible? Data governance process takes on 'big data'
Effective governance can help companies get the most out of their "big data" environments. But at this point, there's no formula for how to do that. Continue Reading