Database management
As the volume of business data has grown, database management has become vital to data optimization and security. Database management are processes that ensure proper application performance, avoid compliance risk and protect valuable business data. Read database management strategies to make sure data is controlled throughout its lifecycle, from creation to deletion.
Top Stories
-
News
17 Dec 2024
Databricks' record $10 billion funding round to fuel growth
The data lakehouse pioneer has expanded into AI development and plans to use the funding to fuel further investments in AI, make acquisitions and expand go-to-market efforts. Continue Reading
-
News
02 Dec 2024
Couchbase unveils suite of services for developing AI
The new services include access to LLMs and unstructured data transformation aimed at enabling customers to build AI tools. 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
-
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
-
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
-
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
-
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
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
-
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
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
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
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
-
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
-
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
-
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
- Answer 17 Dec 2004
- Answer 05 Mar 2004
- Answer 03 Mar 2003
- Answer 04 Oct 2002
