Database Management - IT Library : ZDNet Asia

White Papers

Case Studies

Vendor Webcast

Show all content

Title Date Added Company

Managing Data Quality 2006-11-08 01:00:18 Oracle

Oracle Warehouse Builder is a design tool for modeling and maintaining a data warehouse. Its datasources are not limited to Oracle databases. Oracle Warehouse Builder also supports other databases, including DB2, SQL Server, Sybase, Informix, and Teradata. It also works with file and enterprise application datasources, so it supports the complete collection of data for the organization. Oracle Warehouse Builder provides profiling and auditing capabilities through its user interface, allowing for complete data quality management when combined with the previously mentioned user participation and process improvements.

Oracle Berkeley DB Java Edition Vs. Apache Derby: A Performance Comparison 2006-12-14 01:00:24 Oracle

In the tests described in this white paper, Berkeley DB Java Edition performance exceeds Derby performance by up to a factor of 10. Oracle Berkeley DB Java Edition (JE) is an open source, embeddable, transactional storage engine written entirely in Java. The innovative architecture of JE delivers excellent performance under highly concurrent read-intensive and write-intensive workloads. JE's design provides Java programmers with a highly scalable transactional storage engine. This paper compares the performance of Oracle Berkeley DB Java Edition to Apache's pure Java RDBMS, Derby.

Best Practices for Highly Available HP Integrity Servers and Microsoft SQL Server 2006-12-27 01:00:55 Hewlett-Packard

HP Integrity servers and Microsoft SQL Server combine to create a formidable team in the marketplace - running applications in all industries and in all sizes, ranging from small-to-medium businesses to world-class enterprise systems. Nowadays the customers' needs for reliability, resiliency and recoverability of the underlying technology are approaching those historically found in solutions costing tens (or hundreds) of times more money to implement and support.

Protecting Microsoft SQL Server White Paper 2006-12-27 01:00:55 Hewlett-Packard

One of the most popular DataBase Management Systems (DBMS) products in the world is Microsoft SQL Server. Like most database management systems, Microsoft SQL Server stores all of the data in a handful of database containers, or files. If one of these containers is damaged or corrupted, all of the data it contains is lost. The end result: a serious failure of one system could impair the ability to do business for hours, days, even permanently. This white paper discusses data protection strategies for Microsoft SQL Server.

Deploying Business Intelligence Solutions on Microsoft SQL Server 2005 and HP Integrity Servers 2006-12-27 01:00:55 Hewlett-Packard

This white paper is the first in a planned series of related BI-focused papers. The paper presents an example hardware and software configuration that demonstrates deploying the Data Warehouse and Data Transformation Services (DTS) and/or Extract Transform and Load (ETL) DTS/ETL components of a mid-range BI solution, capitalizing on the scalable power of HP 64-bit Integrity systems and Microsoft SQL Server 2005.

Testing Database Security 2006-11-01 Oracle

The Oracle Database 10g: New Features for Administrators exam enables Oracle Certified Professionals (OCPs) certified on Oracle9i Database to upgrade their certifications to Oracle Database 10g. This is the only exam OCPs certified on Oracle9i Database need to take to upgrade their certification credentials to Oracle Database 10g. This column focuses on the Fine-Grained Auditing (FGA) and Virtual Private Database (VPD) features in Oracle Database 10g. FGA, introduced in Oracle9i Database, captures user activities at a very detailed level and helps prevent the need for manual, trigger-based auditing. Introduced in Oracle8i Database, VPD (also known as fine-grained access control) provides powerful row-level security capabilities.

Tags: Security Management, Training and Certification

Oracle Architecture and Tuning on AIX 2006-11-01 IBM

This paper contains best practices that have been collected during the extensive period of time that the authors team colleagues and the author have spent working in the Oracle RDBMS based environment. Current version is primarily focused on the AIX versions 5.2 & 5.3 and Oracle 9i & 10g. This paper provides a short description of the most important Oracle DB architectural elements. It continues with the coverage of the AIX related tuning elements that are the crucial for the optimal DB activity.

Tags: AIX

IBM Solutions Technical Brief: Diagnosing Oracle Database Performance on AIX Using IBM NMON and Oracle Statspack Reports 2006-10-31 IBM

For Oracle Database environments, ongoing performance monitoring and tuning activities are essential to getting the most of your systems investment. In order to be most effective, monitoring and tuning must be performed at multiple levels of the solution stack. This includes the hardware, Operating System, Database and Application levels. This paper discusses two commonly available performance monitoring tools - Oracle Statspack and IBM NMON - and how they can be used to monitor and analyze possible performance issues for Oracle Database applications running in an AIX/System p server environment. In Oracle10g environments, Automatic Workload Repository (AWR) reports can be used in place of Statspack. A number of real-world examples of Statspack and NMON data are provided.

Tags: AIX

Define DB2 Library in the SAS Management Console 2006-10-30 SAS Institute

The purpose of this paper is to explain how to define DB2 library in the SAS Management Console, when SAS server is running on the UNIX and PC Hosts. This library can be used with Business Intelligence (BI) clients. SAS/Access Interface to DB2 software provides an interface between the SAS System and the DB2 database. SAS/Access Interface to DB2 requires Base SAS, SAS/Access Interface to DB2 and DB2 Client.

Tags: UNIX, Business Intelligence - Data Warehousing

Entering Data in Access 2003 2006-11-01 01:00:29 Pearson Education

The author explains how to enter data into a database table, creating the records for the database table. She also covers how to work with the records, edit data, sort records, and print data. In Access, a table is divided into fields, and each field contains one piece of information such as a last name or a price. One completed set of fields is a record. For instance, in a contact database, the name, address, phone, and other entries for one contact is one record.

Jump to 1 2 3 4 5 6 7 8 9 [10]

Title	Date Added	Company
Managing Data Quality	2006-11-08 01:00:18	Oracle
Oracle Warehouse Builder is a design tool for modeling and maintaining a data warehouse. Its datasources are not limited to Oracle databases. Oracle Warehouse Builder also supports other databases, including DB2, SQL Server, Sybase, Informix, and Teradata. It also works with file and enterprise application datasources, so it supports the complete collection of data for the organization. Oracle Warehouse Builder provides profiling and auditing capabilities through its user interface, allowing for complete data quality management when combined with the previously mentioned user participation and process improvements.
Oracle Berkeley DB Java Edition Vs. Apache Derby: A Performance Comparison	2006-12-14 01:00:24	Oracle
In the tests described in this white paper, Berkeley DB Java Edition performance exceeds Derby performance by up to a factor of 10. Oracle Berkeley DB Java Edition (JE) is an open source, embeddable, transactional storage engine written entirely in Java. The innovative architecture of JE delivers excellent performance under highly concurrent read-intensive and write-intensive workloads. JE's design provides Java programmers with a highly scalable transactional storage engine. This paper compares the performance of Oracle Berkeley DB Java Edition to Apache's pure Java RDBMS, Derby.
Best Practices for Highly Available HP Integrity Servers and Microsoft SQL Server	2006-12-27 01:00:55	Hewlett-Packard
HP Integrity servers and Microsoft SQL Server combine to create a formidable team in the marketplace - running applications in all industries and in all sizes, ranging from small-to-medium businesses to world-class enterprise systems. Nowadays the customers' needs for reliability, resiliency and recoverability of the underlying technology are approaching those historically found in solutions costing tens (or hundreds) of times more money to implement and support.
Protecting Microsoft SQL Server White Paper	2006-12-27 01:00:55	Hewlett-Packard
One of the most popular DataBase Management Systems (DBMS) products in the world is Microsoft SQL Server. Like most database management systems, Microsoft SQL Server stores all of the data in a handful of database containers, or files. If one of these containers is damaged or corrupted, all of the data it contains is lost. The end result: a serious failure of one system could impair the ability to do business for hours, days, even permanently. This white paper discusses data protection strategies for Microsoft SQL Server.
Deploying Business Intelligence Solutions on Microsoft SQL Server 2005 and HP Integrity Servers	2006-12-27 01:00:55	Hewlett-Packard
This white paper is the first in a planned series of related BI-focused papers. The paper presents an example hardware and software configuration that demonstrates deploying the Data Warehouse and Data Transformation Services (DTS) and/or Extract Transform and Load (ETL) DTS/ETL components of a mid-range BI solution, capitalizing on the scalable power of HP 64-bit Integrity systems and Microsoft SQL Server 2005.
Testing Database Security	2006-11-01	Oracle
The Oracle Database 10g: New Features for Administrators exam enables Oracle Certified Professionals (OCPs) certified on Oracle9i Database to upgrade their certifications to Oracle Database 10g. This is the only exam OCPs certified on Oracle9i Database need to take to upgrade their certification credentials to Oracle Database 10g. This column focuses on the Fine-Grained Auditing (FGA) and Virtual Private Database (VPD) features in Oracle Database 10g. FGA, introduced in Oracle9i Database, captures user activities at a very detailed level and helps prevent the need for manual, trigger-based auditing. Introduced in Oracle8i Database, VPD (also known as fine-grained access control) provides powerful row-level security capabilities. Tags: Security Management, Training and Certification
Oracle Architecture and Tuning on AIX	2006-11-01	IBM
This paper contains best practices that have been collected during the extensive period of time that the authors team colleagues and the author have spent working in the Oracle RDBMS based environment. Current version is primarily focused on the AIX versions 5.2 & 5.3 and Oracle 9i & 10g. This paper provides a short description of the most important Oracle DB architectural elements. It continues with the coverage of the AIX related tuning elements that are the crucial for the optimal DB activity. Tags: AIX
IBM Solutions Technical Brief: Diagnosing Oracle Database Performance on AIX Using IBM NMON and Oracle Statspack Reports	2006-10-31	IBM
For Oracle Database environments, ongoing performance monitoring and tuning activities are essential to getting the most of your systems investment. In order to be most effective, monitoring and tuning must be performed at multiple levels of the solution stack. This includes the hardware, Operating System, Database and Application levels. This paper discusses two commonly available performance monitoring tools - Oracle Statspack and IBM NMON - and how they can be used to monitor and analyze possible performance issues for Oracle Database applications running in an AIX/System p server environment. In Oracle10g environments, Automatic Workload Repository (AWR) reports can be used in place of Statspack. A number of real-world examples of Statspack and NMON data are provided. Tags: AIX
Define DB2 Library in the SAS Management Console	2006-10-30	SAS Institute
The purpose of this paper is to explain how to define DB2 library in the SAS Management Console, when SAS server is running on the UNIX and PC Hosts. This library can be used with Business Intelligence (BI) clients. SAS/Access Interface to DB2 software provides an interface between the SAS System and the DB2 database. SAS/Access Interface to DB2 requires Base SAS, SAS/Access Interface to DB2 and DB2 Client. Tags: UNIX, Business Intelligence - Data Warehousing
Entering Data in Access 2003	2006-11-01 01:00:29	Pearson Education
The author explains how to enter data into a database table, creating the records for the database table. She also covers how to work with the records, edit data, sort records, and print data. In Access, a table is divided into fields, and each field contains one piece of information such as a last name or a price. One completed set of fields is a record. For instance, in a contact database, the name, address, phone, and other entries for one contact is one record.