Data Management
Top Stories
-
Opinion
31 Jul 2026
AI value comes from continuous learning, not automation
The companies pulling ahead in AI aren't doing it by deploying more tools. Rather, they're building the data foundations that make intelligence reusable, scalable and reliable. Continue Reading
-
Tip
31 Jul 2026
Integrate structured and unstructured data for better AI outputs
For AI agents to give the most accurate, informed responses, organizations must provide them with all the facts. Even those that are hidden in an old email or customer claim. Continue Reading
-
News
05 Apr 2012
Oracle vs. HP- Or, how the corporate world is really a lot like grade school
In the case of the ill-fated Itanium chip, multiple companies, including HP and Intel, got a lesson in failure. The now famous debacle has been coined “the joke of the chip industry” by tech blogger Ashlee Vance . 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
23 Mar 2012
Larry Ellison’s new toy in New Zealand
Most people have hobbies of some sort. Some people build model cars. Others enjoy knitting. But Larry Ellison owns a very expensive milling machine in New Zealand and uses it to build ships. Continue Reading
-
News
15 Mar 2012
Note to Oracle: Nobody likes a nuisance
By now, you probably know that Oracle is in the middle of a multi-billion dollar lawsuit against Google for patent infringement regarding Google’s use of patents Oracle feels are related to the Java programing language. Continue Reading
-
News
08 Mar 2012
Larry Ellison demoted to 7th wealthiest person on earth
Bad news for Larry Ellison- He’s no longer among the top five richest people on earth, and will have to settle for the slightly less luxurious position of number seven, according to Bloomberg’s most recent list of billionaires. 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
-
News
27 Feb 2012
Larry Ellison — Philanthropist?
When you think of philanthropic CEOs, who crosses your mind? Bill and Melinda Gates? Sir Richard Branson? Mark Zuckerberg, perhaps? Larry Ellison usually doesn’t even register. 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
-
Opinion
08 Sep 2011
Test of Scheduled Publish August 30 - BizAnalytics
Opinion Test - Carolyn Opinion Test - Carolyn Opinion Test - Carolyn Opinion Test - Carolyn Opinion Test - Carolyn Opinion Test - Carolyn Opinion Test - Carolyn Opinion Test - Carolyn 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
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
-
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
-
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
-
Feature
14 Mar 2011
Starting an Oracle virtualization project
Contributor Frank Ohlhorst gives tips on how to start a server virtualization project in an Oracle shop. 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
20 Dec 2010
Oracle upgrades: Tips and trends
If you’re planning an Oracle upgrade, start here to learn about the latest Oracle upgrade trends. Also, get expert advice from Oracle gurus and learn about the current state of Oracle Fusion Middleware upgrades. 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
-
Feature
18 Nov 2010
Oracle Professionals’ Challenges and Priorities Survey 2010
Almost 450 Oracle professionals answered survey questions from SearchOracle.com this year on topics such as budget, database and application challenges, virtualization and support. Here are the results. 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
19 Aug 2010
A nutritional supplement company does Oracle E-Business Suite upgrade
USANA Health Sciences tackled three key business issues when it performed an Oracle E-Business Suite upgrade: third-party integration, employee turnover and new software modules. 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
-
News
08 Jul 2010
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? 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
-
News
29 Jun 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. Continue Reading
-
News
15 Jun 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. 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
-
News
25 May 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. Continue Reading
-
News
04 May 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. Continue Reading
-
News
20 Apr 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. Continue Reading
-
News
14 Apr 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. Continue Reading
-
News
25 Mar 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. 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
-
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
-
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
-
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
-
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
-
Tutorial
28 Oct 2009
Oracle virtualization introduction guide
This introductory guide to Oracle virtualization is designed to help you define and understand the basics of Oracle virtualization including Oracle's VM. 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
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
-
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
-
Tutorial
01 Sep 2009
Oracle applications learning guide
This learning guide is a one-stop shop for information on Oracle's changing role in the enterprise applications space, with news, analysis and tips on Oracle's acquisitions, Project Fusion, E-Business Suite and other apps, the battle between Oracle and SAP and more. 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
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
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
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
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 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
-
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