Data Management
Top Stories
-
Opinion
17 Sep 2026
Does setting data guardrails slow innovation?
Governance and speed are treated as opposites, but the real variable is design. Four control domains determine whether data guardrails help or hinder. Continue Reading
-
News
17 Sep 2026
New features position Alation's AIOS as AI management layer
Lineage tracing in AI Governance and governed access to unstructured data advance the platform and keep the vendor in step with what competitors are offering. 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
-
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
-
Feature
13 Mar 2009
How to use SQL Developer to run SQL statements
In this chapter, learn how to use SQL Developer to enter and execute SQL statements and scripts, work with a Snippets window, solve common syntax errors and more. 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'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
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
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
-
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
03 Jul 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. 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
-
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
-
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
-
Answer
15 Aug 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. 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
-
Answer
22 May 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. Continue Reading
-
Answer
11 May 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? 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
-
Answer
23 Apr 2007
When will support for Oracle 9i be discontinued?
When will general support for Oracle 9i be discontinued? 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
-
Answer
18 Dec 2006
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? Continue Reading
-
News
14 Sep 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. Continue Reading
-
Tutorial
01 Sep 2006
Oracle database performance tuning guide
Learn the tricks of industry experts for identifying and eliminating performance problems in this guide. Topics include tuning fundamentals and fallacies, explanations of performance tuning tools, disk I/O and SQL tuning specifics, and common problem areas. Continue Reading
-
Tip
14 Aug 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. 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
-
News
05 Jul 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. Continue Reading
- Answer 04 May 2006
-
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
-
Definition
21 Sep 2005
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. Continue Reading
-
Definition
21 Sep 2005
record
In computer data processing, a record is a collection of data items arranged for processing by a program. Continue Reading
-
Answer
16 Aug 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)? 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
28 Sep 2004
Purpose of roll forward and roll backward
What are rolling forward and rolling backward in backup and recovery? Continue Reading
- Answer 23 Sep 2004
- Answer 07 Jun 2004
-
Tip
15 Mar 2004
Merging datasets with NULL values
A MERGE may appear to work properly, but it's important you check your target dataset to make sure it does. This tip explains why and how. Continue Reading
- Answer 25 Jun 2003
- Answer 18 Feb 2003
- Answer 25 Nov 2002
- Answer 11 Nov 2002
- Answer 11 Nov 2002
- Answer 05 Nov 2002
- Answer 13 Aug 2002
- Answer 18 Jun 2002