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
-
Video
19 Nov 2024
Java, JDBC and SQL Server tutorial
This tutorial shows how to create a JDBC connection to Microsoft's SQL Server, and get started creating Java-based applications that are scalable and secure. Continue Reading
-
News
19 Nov 2024
With new Fabric features, Microsoft aims at AI development
New data management and analytics suite features include databases and a data catalog to enable enterprises to develop and operationalize advanced applications. 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
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
-
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
-
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
06 Sep 2007
Introduction to network analysis, architecture and design
Learn tha basics of network analysis, architecture and design, as well as various ways to characterize a network. 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 22 Jan 2003
- Answer 04 Oct 2002
