Data Management: Page

Oracle Exadata Version 2 interest booms a year after release

While the first version of Oracle Exadata generated only a handful of customers, Version 2 has lured customers into spending millions to buy it. But what’s so special about it?

By Mark Fontecchio • July 8, 2010

Is Oracle’s rosy Oracle-Sun merger picture really that rosy?

Oracle painted a pretty picture of its first full quarter with the Oracle-Sun merger under its thumb. But the reality doesn’t entirely jibe with that picture of the Oracle-Sun merger.

By Mark Fontecchio • June 29, 2010

Oracle Fusion Middleware 11g getting updates

Oracle's key sales pitch for its Oracle Fusion Middleware 11g updates is "integration," but according to some, there’s still room for more of it.

By Mark Fontecchio • June 15, 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.

By Pete Stiglich • June 1, 2010

Third-party tools for Oracle: Special report

Learn about the options for third-party tools for Oracle databases and why Oracle third-party tools are growing in popularity.

By Shayna Garlick, Associate Editor • May 25, 2010

Duke Energy emerges from ‘dark period’ with PeopleSoft 8.9 upgrade

Scared to touch a fresh PeopleSoft upgrade for years, Duke Energy finally bit the bullet and moved to 8.9. A new financial data hub helped ease the transition.

By Barney Beal • May 4, 2010

Oracle users in wait-and-see mode with Oracle’s stack computing strategy

Oracle continued to press its stack message of integrated applications, middleware, database and hardware, but some Collaborate attendees have heard it before.

By Barney Beal • April 20, 2010

Oracle updates, reaffirms commitment to MySQL

Speaking to a gathering of open source database users, Oracle's chief architect said the company remains committed to MySQL.

By Barney Beal • April 14, 2010

Oracle grid computing and cloud computing: Special report

In this Oracle grid computing and cloud computing special report, learn about the difference between grid and cloud computing, the cloud and grid products that Oracle offers and users’ future plans for adoption.

By Shayna Garlick, Associate Editor • March 25, 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.

By Mark Whitehorn • March 24, 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.

By Mark Whitehorn • March 24, 2010

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.

Dec. 14, 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.

By Mark Whitehorn • Oct. 7, 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.

By Jill Dyché • Sept. 15, 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.

By Jill Dyché • Sept. 15, 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.

By Mark Whitehorn • June 24, 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.

By Jill Dyché • May 28, 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.

By Mark Whitehorn • April 14, 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.

By Phil Simon • April 10, 2009

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.

By Jill Dyché • Oct. 14, 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.

By Jill Dyché • Oct. 14, 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.

By Mark Whitehorn • Sept. 23, 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é.

July 21, 2008

How much historical data is enough?

There are many factors that impact the amount of historical data a corporation requires.

By Bill Inmon • July 10, 2008

Using BETWEEN with DATETIMEs in SQL

Expert Rudy Limeback is asked if SQL can be used to retrieve data between two dates, including the two dates.

By Rudy Limeback • July 3, 2008