Data Management: Page

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

How to evaluate data warehouse software in five steps

Get five steps to evaluating data warehouse software from a data warehouse expert.

By Rick Sherman • June 26, 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.

By Pete Stiglich • May 21, 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.

By Pete Stiglich • April 22, 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.

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

By Mark Whitehorn • Jan. 22, 2008

The ETL process and MySQL

Get advice on the ETL process and ETL tools for transforming raw data in MySQL.

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

By Pete Stiglich • Oct. 23, 2007

LOB tables missing with exp/imp move of schema

I have a problem when moving a schema using exp/imp. After import, the tables with LOBs are missing.

By Brian Peasland • Aug. 15, 2007

How to increase SGA_MAX_SIZE in Oracle

How to increase SGA_MAX_SIZE in Oracle? I got the error "ORA-03113: end-of-file on communication channel" during startup.

By Phillip Bracken • May 22, 2007

Employees with the same first and last names in SQL

How do I SELECT a list of employees who have the same last and first name in SQL?

By Rudy Limeback • May 11, 2007

ILM vs. DLM: The importance of data management

Knowing the differences between information lifecycle management (ILM) and data lifecycle management (DLM) will ultimately determine which storage offerings you bring to a client's table.

By Serdar Yegulalp • May 8, 2007

When will support for Oracle 9i be discontinued?

When will general support for Oracle 9i be discontinued?

By Maria Anderson • April 23, 2007

Sorting a clob column

I'm trying to sort a column type asc as well as desc. I'm able to sort the clob column desc but not able to sort it asc. Can you please help me out?

Dec. 18, 2006

Gartner makes Oracle CRM predictions

Plenty of Siebel users are still concerned and confused over the direction of their CRM tool. Analysts at the Gartner CRM Summit offered some clues.

By Barney Beal • Sept. 14, 2006

Oracle vs. Sybase: 10 reasons to use Sybase on Linux

Despite its fall from market leadership, Sybase is still a strong enterprise offering, says database consultant Dr. Mich Talebzadeh. In this tip, he gives 10 reasons why Sybase on Linux bests other databases, particularly Oracle.

By Mich Talebzedah • Aug. 14, 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.

By Rick Cook • July 27, 2006

Spotlight on compliance

This special report compiles news and analysis on regulatory compliance, a top priority for anyone working with Oracle or in IT.

By SearchOracle.com editorial staff • July 5, 2006

ON DELETE RESTRICT

I would like to know where we use DELETE RESTRICT?

By Rudy Limeback • May 4, 2006

field

A field is an area in a fixed or known location in a unit of data such as a record, message header, or computer instruction that has a purpose and usually a fixed size.

By TechTarget Contributor • Sept. 21, 2005

record

In computer data processing, a record is a collection of data items arranged for processing by a program.

By TechTarget Contributor • Sept. 21, 2005

Multiple instances on a single database

Is it possible for Oracle to have parallel servers (single database, multiple instances)? Is it impossible to have the inverse (that is, multiple databases, single instance)?

Aug. 16, 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.

By Craig Mullins • May 19, 2005

Data warehousing for government

Surprisingly, Data Warehouses have been slow to be adopted in the government circles.

By Bill Inmon • Jan. 6, 2005