Business intelligence technology platform
Top Stories
-
News
28 Sep 2021
HPE intros GreenLake data lakehouse fabric for analytics
HPE taps multiple open source technologies, including Kubernetes, Apache Spark and Delta Lake, for developing new data fabric services on its GreenLake cloud platform. Continue Reading
-
News
22 Jul 2021
Observable expands enterprise data visualization platform
Observable expanded its platform for larger organizations to collaborate on data projects that make information more intuitive to understand and use. Continue Reading
-
News
13 Jun 2012
QlikTech buys into data integration for BI
QlikTech's acquisition of data integration vendor Expressor Software is a big step in its effort to get into the enterprise business intelligence game, says TechTarget's Wayne Eckerson. Continue Reading
-
Tip
25 May 2012
Don't run from 'big data' tools, but approach with caution
There's nothing magic about "big data" technologies such as Hadoop and NoSQL databases, says BeyeNetwork expert Barry Devlin, who poses a series of questions to ask before deploying them. Continue Reading
-
News
28 Mar 2012
IBM users reveal five data governance best practices to remember
IBM customers Nationwide Insurance and Cardinal Health reveal five rules of thumb they learned while implementing highly ambitious data governance programs. Continue Reading
-
News
26 Mar 2012
'Big data' breathes new life into CEP software
Complex event processing (CEP) technology is poised to move from the backwaters of data management to center stage, says TechTarget's Wayne Eckerson. The primary driver? "Big data." Continue Reading
-
News
08 Mar 2012
Data governance programs expose hills to climb on path to success
IT professionals from Sallie Mae and Fannie Mae offered insight on data governance challenges and tips on how to overcome them in separate sessions at two recent conferences. Continue Reading
-
News
06 Mar 2012
'Big data' hype and reality on full display at Strata
The Strata Conference was a showcase for Hadoop and NoSQL, which are gaining bigger footholds in corporate IT. But they're no panacea for managing data, says TechTarget's Wayne Eckerson. Continue Reading
-
News
27 Feb 2012
Categorizing 'big data' processing systems
In the past, analytics applications typically were powered by relational databases. Now the options are more varied and less straightforward, says TechTarget's Wayne Eckerson. Continue Reading
-
Photo Story
16 Feb 2012
Top six data management software stories of 2011
From the rise of "big data" to office politics hampering MDM projects to Hewlett-Packard giving Neoview the ax, and more, there were plenty of notable data management stories in 2011. Continue Reading
-
News
08 Feb 2012
Trends in entity resolution research and applications
In this excerpt from the book "Entity Resolution and Information Quality," readers will learn about emerging entity resolution trends and applications. Continue Reading
-
News
27 Jan 2012
'Big data' liberation theology -- and reality
Data warehouses can do just about anything that "big data" technologies can do, says TechTarget's Wayne Eckerson. The big data movement's real weapon, he contends, is open source software. Continue Reading
-
News
13 Dec 2011
Developing high-quality data models
In this excerpt from "Developing High Quality Data Models" by Matthew West, readers will find tips on data modeling and observations on today's data models. Continue Reading
-
Answer
11 Oct 2011
Key issues to consider when building a data warehouse
There are numerous issues, both technical and cultural, that organizations need to consider before building a data warehouse. Learn what they are from our data warehousing expert. Continue Reading
-
Feature
03 Aug 2011
A must to avoid: Worst practices in enterprise data governance
Consultant Rick Sherman details 10 common data governance mistakes that can send governance initiatives down the wrong path – the one to failure. Continue Reading
-
News
29 Jul 2011
Sallie Mae exec: Meetings, metrics spur data governance best practices
In an interview, Michele Koch discusses the data governance program she leads at Sallie Mae and provides insight on key governance best practices. Continue Reading
-
Answer
18 May 2011
Six tips for improving data warehouse performance
Get six expert tips for improving data warehouse performance. Learn how database engines, SSDs and MOLAP cubes can affect your data warehouse performance. 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
-
News
13 Apr 2011
From the Editors: Database consolidation and standardization 101
If you’re thinking about embarking on a database consolidation or standardization project, make sure you know the technical, cultural and skill-set issues that can arise. 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
-
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
-
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
-
News
23 Mar 2011
Gartner Magic Quadrant ranks data warehouse appliance vendors
EMC-Greenplum is a new "leader" in the latest Gartner Magic Quadrant report on data warehouse software and appliance vendors. Find out who else tops Gartner's rankings. Continue Reading
-
News
17 Mar 2011
From the Editors: Analytical MDM sets up enterprise MDM, but plan well
An analytical master data management project can be a great way to start an enterprise MDM program, but with certain conditions. Get tips for starting an analytical MDM project at your company. Continue Reading
-
Tutorial
14 Feb 2011
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
-
Tutorial
14 Feb 2011
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
-
Tutorial
14 Feb 2011
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
-
Answer
09 Feb 2011
How to get senior execs to buy into a data governance plan
Learn how to get senior management to buy into data governance. Get tips on selling data governance policies and processes to executives who can approve data governance programs. Continue Reading
-
News
30 Dec 2010
Top seven data management stories of 2010
The top data management stories of 2010 include SaaS-based data integration, data warehouse appliances, the SAP-Sybase acquisition and more. Continue Reading
-
News
26 Nov 2010
Creating a database strategy that can adapt to changing business needs
Crafting a successful database strategy requires technology flexibility, the right skill sets and a strong focus on application requirements, according to IT pros and analysts. Continue Reading
-
Answer
11 Nov 2010
What’s the best way to conduct an MDM implementation?
Is it better for companies to go with an enterprise-wide master data management (MDM) implementation or deploy MDM departmentally? Find out which approach our MDM expert prefers. Continue Reading
-
News
10 Nov 2010
Emerging database technologies hit DBMS mainstream, add to choices
Emerging database technologies such as column-based database software, NoSQL databases and Database as a Service (DaaS) platforms are starting to make a splash in the IT market. Continue Reading
-
News
05 Nov 2010
Data governance roles and responsibilities call for diverse skill sets
Learn about data governance roles and responsibilities, and get advice on the management and technical skills that a successful data governance strategy and program requires. 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
-
News
27 Aug 2010
Increase the success of data governance programs from the bottom up
Data governance programs are often overlooked, pushed aside and just plain ignored through a lack of executive interest and funding. But some technology professionals are making the most of the situation. 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
-
Tutorial
06 Jul 2010
Buyer’s Guide: Choosing and understanding MDM software
Read up on master data and master data management, plus get expert advice on choosing MDM software and tools and what to look for in an MDM product or service. 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
-
Answer
24 Mar 2010
What are aggregate tables and aggregate fact tables?
Here you'll see examples and read definitions of aggregate tables and aggregate fact tables. You'll also learn how to use aggregate tables in data warehouses and databases. Continue Reading
-
Answer
24 Mar 2010
Data warehouse concepts: Data flow and sending data to source systems
Learn about a data warehouse concept: data flow. And find out if it's a good idea to flow data from your data warehouse or data marts back to source systems. Continue Reading
-
Feature
04 Feb 2010
Making business transaction processing and applications work
Learn about making business transaction processing work in your company, find tips on transaction processing applications and get transaction processing definitions. Continue Reading
-
Feature
04 Feb 2010
Key benchmarks for measuring transaction processing performance
Find key benchmarks for measuring transaction processing performance at your company, and learn about XA two-phase commit and types of transaction processing. Continue Reading
-
Podcast
14 Dec 2009
Tips for a master data management (MDM) requirements gathering process
Embarking on a master data management (MDM) project? Get an expert's tips for the MDM requirements gathering process and ensure MDM implementation success. 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
-
Answer
07 Oct 2009
What is the difference between a logical and physical warehouse design?
What's the difference between logical design and physical design? Get an expert's take, plus learn about three data warehouse models -- the user model, physical model and logical model -- and how they differ. Continue Reading
-
Answer
15 Sep 2009
Six criteria for master data management (MDM) tool evaluation
Starting to evaluate MDM tools and software? Know what six areas you should look at to make sure you choose the best vendor and tool for your business needs. Continue Reading
-
Answer
15 Sep 2009
Is it better to have a centralized or decentralized master data structure?
Should your master data be centralized or decentralized? Get an expert's take, plus find out how different MDM architecture styles affect your master data and MDM hub. Continue Reading
-
Feature
27 Jul 2009
Executing SQL statements using prepared statements and statement pooling
In this database tutorial, find out about executing SQL statements using prepared statements and statement pooling. Learn what a statement pool is and how to retrieve long data types efficiently. 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
27 Jul 2009
Static SQL vs. dynamic SQL for database application performance
Learn the difference between static SQL vs. dynamic SQL and the benefits and drawbacks of each for database application performance. Get a definition of stored procedure, find out about database drivers and wire protocol database drivers and how the network affects database performance. Continue Reading
-
Feature
02 Jul 2009
Top 13 master data management (MDM) buzzwords and definitions
Get the top master data management (MDM) terms, definitions and concepts and learn how MDM can improve your enterprise data. Also get links to useful MDM tutorials, training, video, podcasts and articles. Continue Reading
-
Answer
24 Jun 2009
How to select an MPP database: DB2 vs. Teradata
Should you run a massively parallel processing (MPP) database with DB2 or Teradata? Find out how to compare DB2 vs. Teradata and how to choose a database system and with advice from a data warehouse expert. 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
10 Jun 2009
Data warehouse architectures, concepts and phases: What you need to know
This tutorial explains the different types of data warehouse architecture including bus, federated and hub-and-spoke. Learn about ETL processes and data staging and data warehouse phases. Continue Reading
-
Feature
10 Jun 2009
Advantages of the multidimensional database model and cube modeling
Discover the advantages of the multidimensional database model and find out how data warehouse cube modeling, data restricting and data slicing work. Learn the role meta-data plays and get a definition of functional dependency. Continue Reading
-
Answer
28 May 2009
Four must-have master data management project skills
There are four important master data management project skills needed for MDM projects and development efforts. Discover what they are and learn about MDM job roles and responsibilities in this tip. Continue Reading
-
Feature
21 May 2009
The importance of managing data assets
Get an overview of data management and data lifecycle, learn how important managing data and data assets is and learn how to control data in this information management tutorial. 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 Apr 2009
Defining dimensional vs. normalized database design, dimension vs. fact tables
Find out if your existing database is in dimensional style or normalized database design style, learn the benefits and drawbacks of fact-dimension and normalized database schemas and read a comparison of dimension tables vs. fact tables. Continue Reading
-
Answer
10 Apr 2009
What are the most common system implementation mistakes?
Learn about some of the biggest mistakes in system implementation and why successful implementations are few and far between. Find out how to avoid these pitfalls with careful planning and more tips from our project management expert. Continue Reading
-
Answer
31 Mar 2009
What are the advantages/disadvantages of database abstraction layers?
Discover the advantages and disadvantages of using database abstraction layers, as opposed to database-specific coding, and learn why abstraction layers offer maximum flexibility. Continue Reading
-
Feature
26 Jan 2009
Designing an MDM project plan
Master data management (MDM) projects require enterprise buy-in and participation in order to be successful. In this chapter, learn how to identify the people in the organization that can benefit from MDM and how to assemble an MDM project team. Discover how to establish and communicate the MDM business case, learn tips for collecting and prioritizing data requirements, developing a plan for enterprise data integration and designing a migration plan for the participating applications. Learn how to tackle these key steps and how to develop a successful MDM project plan in this chapter. Setting the stage for assembling the right team for an MDM program involves determining the best opportunities to socialize the internal value across the enterprise landscape. As this chapter has shown, this socialization is performed along a number of avenues: Communicating the value of presenting a centralized master data asset to the business clients, application owners, and operations staff Identifying the key stakeholders that will participate in the MDM program Carefully articulating within a project charter what will be achieved by the MDM program and how the corresponding milestones will be reached Providing a means for coordinating the participants to reduce conflict and encourage consensus Carefully detailing roles and responsibilities Analyzing the data requirements to establish MDM feasibility ■ ■ ■ ■ ■ ■ 2.7 Summary 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
14 Oct 2008
What's the difference between SOA and Web services?
How are Web services and service oriented architecture (SOA) different? Find out in this expert response. Continue Reading
-
Answer
23 Sep 2008
Definition of data abstraction and data abstraction layers
Data abstraction simplifies database design. Learn the definition of data abstraction and find out the three formal kinds of abstraction layers, from a database expert. Continue Reading
-
Quiz
23 Jul 2008
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
-
Podcast
21 Jul 2008
Creating successful data stewardship programs, with Jill Dyché
Learn how data stewardship fits into data governance and data quality management programs, from Jill Dyché. Continue Reading
-
News
10 Jul 2008
How much historical data is enough?
There are many factors that impact the amount of historical data a corporation requires. Continue Reading
-
Answer
26 Jun 2008
How to evaluate data warehouse software in five steps
Get five steps to evaluating data warehouse software from a data warehouse expert. 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
17 Apr 2008
Can a dimension table be a fact table for another data mart?
Find out if a dimension table can be a fact table for another data mart -- and get an explanation of the answer. Continue Reading
-
News
10 Apr 2008
Why Are Data Warehouses Growing So Fast?
Richard Winter provides observations on the causes and effects of the explosion of digital information. Continue Reading
-
Feature
13 Mar 2008
IT project management: The cost estimating process
Learn about the cost estimating process in IT project management by reading examples and definitions of cost estimation terms, in this free chapter download. Continue Reading
-
Feature
28 Jan 2008
Personal information management: History and details
Learn about personal information management and why managing personal information is especially important in today's data inundated world. Continue Reading
-
News
22 Jan 2008
Active data warehousing explained and examined
Active data warehousing brings business intelligence to more operational decision-making processes. Find out how, and why, active data warehouses enable competitive advantages. Continue Reading
-
Quiz
18 Dec 2007
Enterprise data integration quiz
Take this enterprise data integration quiz to test your knowledge of data integration terms, trends and technologies. 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
-
Quiz
12 Oct 2007
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
-
Feature
06 Sep 2007
Introduction to network analysis, architecture and design
Learn tha basics of network analysis, architecture and design, as well as various ways to characterize a network. 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
-
Feature
01 May 2007
MDM-CDI project implementation guidelines
This chapter excerpt deals with the practical aspects of implementing MDM-CDI solutions as complex, multidisciplinary, enterprise-wide projects or programs. Implementing MDM-CDI solutions requires an approach that may be even broader than a single project, and should be managed as an initiative-level, enterprise-wide program. Continue Reading
-
Feature
20 Apr 2007
Data governance: Information ownership policies and roles explained
Who owns the data? This chapter defines information ownership boundaries and best practices, and outlines the specific roles and responsibilities of all involved in the battle for data governance. Continue Reading
-
News
27 Jul 2006
Backup failure: Five reasons backups fail and tips for prevention
Media failure, human error and hardware failure are among the most common reasons backups fail. Learn what you can do to prevent these issues and others to perform legitimate, usable backups. Continue Reading
-
Answer
16 Mar 2006
Ralph Kimball vs. Bill Inmon approaches to data warehouse design
Learn about the debate between the Ralph Kimball and Bill Inmon approaches to data warehouse design. Continue Reading
-
Feature
21 Nov 2005
Types of DBAs
DBAs can take on many different roles. This excerpt from the "Database administration: The complete guide to practices and procedures" takes a closer look at different types of DBAs. Continue Reading
-
Tip
19 May 2005
What is the difference between DB2 UDB and DB2 OS/390?
Database expert Craig Mullins explains the differences between DB2 UDB and DB2 OS/390. He begins by clarifying that the two are comprised of completely different code bases. Continue Reading
-
News
06 Jan 2005
Data warehousing for government
Surprisingly, Data Warehouses have been slow to be adopted in the government circles. Continue Reading
- Answer 17 Dec 2004
- News 20 May 2004
- Answer 05 Mar 2004
- Answer 05 Sep 2003
- Answer 03 Mar 2003
- Answer 22 Jan 2003
- Answer 04 Oct 2002
-
Answer
21 Jun 2002
Difference between BI in the public sector and private sector
Find out the major difference between business intelligence (BI) in the public sector and BI in the private sector and get an expert's take on trends for those using BI in the public sector. Continue Reading
- Answer 20 Mar 2002