Enterprise data architecture best practices
Top Stories
-
Quiz
31 Aug 2021
Quiz: Test your understanding of the Hadoop ecosystem
This quiz will test your knowledge of Hadoops basics including framework, capabilities and related technologies. Continue Reading
-
Feature
15 Jul 2021
Edge-to-cloud architecture turns key for digital initiatives
Enterprises pursuing digital transformation initiatives may need to reexamine their infrastructure architecture to bring compute and storage closer to data generated at the edge. 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
-
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
-
Feature
18 Apr 2014
Big data vendors should stop dissing data warehouse systems
Wayne Eckerson examines the analytics roles of data warehouses and big data systems and says he's tired of data warehouse bashing by big data vendors. Continue Reading
-
News
28 Feb 2013
Six things Hadoop brings to the BI and analytics table
TechTarget's Wayne Eckerson outlines what is unique about Hadoop and related technologies versus traditional BI and data warehousing tools. Continue Reading
-
Feature
15 Nov 2012
Hadoop World: Just like data warehousing's early days
The buzz-filled Hadoop World 2012 conference reminded TechTarget's Wayne Eckerson of a data warehousing event he attended in 1997. Still to be seen: Can Hadoop live up all to the hype? Continue Reading
-
Feature
05 Nov 2012
Unilever enterprise data warehouse locked to business programmes
Unilever is building a global enterprise data warehouse (EDW) locked into the critical paths of high-profile business programmes. Continue Reading
-
News
30 Oct 2012
Teradata brings big data into the SQL family
Teradata addresses the issue of combining unstructured, semi-structured and traditional row-and-column data warehousing in a single architecture. 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
-
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
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
29 Nov 2011
Creating an enterprise data strategy: Manage your data as an asset
In a BeyeNetwork.com research report, TechTarget’s Wayne Eckerson details the key elements of an enterprise data strategy, starting with executive buy-in to the idea that data is a corporate asset. 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
-
Podcast
30 Jun 2011
Sacred cows of using data warehouse software – and how to tip them
In a video interview, consultant Evan Levy discusses what he calls the sacred cows of data warehousing and explains why such beliefs should be challenged within organizations. 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
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
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
-
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
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
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
-
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
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
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
-
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
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