Database Management - IT Library : ZDNet Asia

White Papers

Case Studies

Vendor Webcast

Show all content

Title Date Added Company

Extending Oracle SQL Developer 2007-07-01 Oracle

There are times when a tool does exactly what one needs it to do and times when one feels that a tool would suit the user better if a few extra features had been implemented. Suppose a tool one use regularly does not include some key functionality one needs, and now suppose the tool is extensible so that one can include that functionality. Oracle SQL Developer provides the framework for the user to do just that. Whether one is a DBA or a database developer, one can add context menus in Oracle SQL Developer to execute a SQL statement or more-involved wizard-driven dialog boxes that step the user through a process.

Tags: Application Development

Microsoft SQL Server 2005: Deployment and Tests in an iSCSI SAN 2007-06-30 Dell EqualLogic

iSCSI SANs offer an alternative for building Storage Area Networks. Consolidating storage in a SAN offers storage management and scaling benefits for datacenters. iSCSI support in Windows Server 2003 makes connecting servers to an iSCSI SAN easy and affordable. This paper describes the deployment and testing results of SQL Server 2005 using the Microsoft iSCSI Initiator with a Dell EqualLogic iSCSI SAN. It helps you understand best practices and the benefits of using an iSCSI SAN with SQL Server 2005.

Tags: SANs, Storage Consolidation, Windows NT - 2000 - 2003, High Performance Computing

Customer XXX: Oracle RAC 10gR2 Installation on IBM BladeCenter Example Final Project Document 2007-06-27 IBM

This paper describes the purpose and details for the implementation of a two node Oracle 10gR2 (10.2.0.3) database with RAC (Real Application Clusters) on XXX's extant HS20 blades and DS4400 disk storage. The purpose of this project is to install Oracle RAC 10gR2 on two IBM HS20 blades, using IBM DS4400 shared storage to address the first-level requirements of the NEW project.

Tags: Blades

DB2 UDB Enterprise Edition V8.1: Basic Performance Tuning Guidelines 2007-06-12 IBM

IBM DB2 Universal DataBase (DB2 UDB) is configured to run on any system that meets its minimum hardware requirements. As a result, the basic configuration provided must be tuned to achieve optimum performance on systems that exceed the these requirements. Tuning a system can be quite involved. Volumes could be written (and often have been) on tuning each system level. Because the subject is quite complex, no single paper can really teach everything about tuning a system for optimum performance. The main purpose of this paper is to provide the basics needed to tune one level of a system and a set of guidelines that can be used to modify the basic configuration of DB2 UDB to improve overall database performance.

Tags: Database Applications

Oracle SaaS Platform: Building On-Demand Applications 2007-06-01 Oracle

The adoption of Software as a Service (SaaS) or On-Demand presents several technical and business challenges for all players involved - Independent Software Vendors (ISVs), hosting services providers and the customers. The technical challenges for SaaS providers include support for multi-tenancy, security, usability and service-level management. Oracle SaaS Platform consisting of database, middleware and systems management software provides a comprehensive platform that addresses these challenges and runs on grid. In simplest terms, SaaS refers to hosted on-demand delivery of applications, as opposed to on premise. However, software as a service is not a singular model but encompasses a spectrum of choices ranging from hosting traditional packaged applications at a remote site to multi-tenant shared applications.

Tags: Database Applications, Application Development

SGeRAC and Oracle RAC 10g R2 on HP-UX 11i Best Practices 2007-06-01 Hewlett-Packard (HP)

This paper describes common best practices for configuring clusters with Serviceguard, Serviceguard Extension for RAC (SGeRAC) and Oracle 10g Real Application Cluster (RAC). A basic configuration is shown and followed by specific preferred configurations with regards to the following topics: availability for the public network, network for Cluster Communication, storage Configuration and Serviceguard Packages.

Tags: HP-UX, Database Applications

IBM System p for Oracle Data Warehousing 2007-05-01 IBM

One of the major areas of concern for business is the effort involved in architecting, developing and deploying complex data warehouses and the associated components of the business intelligence solution around Extract, Transform and Load (ETL) and analytic applications. IBM and Oracle have developed a powerful architectural model and approach to simplifying the deployment and reducing the risk of data warehouses based on the IBM System p for Oracle Data Warehousing. This solution fully supports the Oracle Information Appliance Initiative and provides a family of optimized and validated pre-sized configuration building blocks for data warehouses to support a range of raw data, user and query workload requirements.

Tags: Business Intelligence - Data Warehousing

Database Design and Management: "Getting It Right the First Time" 2007-05-01 CA (Computer Associates)

In the world of databases, "Getting it right" is a phrase filled with ambiguity, for who can say what "Right" truly is? Frankly, it's a lot easier to spot "Bad" or "Not right" database schemas than it is to confirm that a database schema is "Right". Database management processes that tie database design to performance tuning, administration and backup/recovery, then the database project is headed down the path to failure. Integrating the best schema design that one knows how to do, along with best practices in, for example, performance management and properly tuned and deployed SQL code will go a very long way toward ensuring the database environment is functioning at optimal levels.

Tags: Database Applications

Application Migration Workshop 2007-05-01 Oracle

Many small and medium businesses use Microsoft Access to manage mission-critical business functions. As businesses grow or their requirements expand, however, they may need to migrate their existing Access applications to a more-robust architecture and a function-rich tool. This column describes a migration path from Access to Oracle Application Express running on an Oracle database. This Oracle solution migrates the Access data, forms, and reports to a pure browser-based application.

Tags: Upgrades and Migration, Database Applications

Now Reporting 2007-05-01 Oracle

In March 2006, Oracle announced the availability of Oracle SQL Developer, a GUI for Oracle Database. Oracle SQL Developer provides an easy-to-install, lightweight, multiplatform GUI that enables database developers to do a variety of database activities, including browsing, creating, and updating data. In the area of reporting, Oracle SQL Developer provides a collection of data dictionary reports for querying the system details and also offers the user the ability to create their own reports and share them. This column shows the user different report styles available in Oracle SQL Developer and how one can store and share reports.

Tags: Database Applications, Application Development

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

Title	Date Added	Company
Extending Oracle SQL Developer	2007-07-01	Oracle
There are times when a tool does exactly what one needs it to do and times when one feels that a tool would suit the user better if a few extra features had been implemented. Suppose a tool one use regularly does not include some key functionality one needs, and now suppose the tool is extensible so that one can include that functionality. Oracle SQL Developer provides the framework for the user to do just that. Whether one is a DBA or a database developer, one can add context menus in Oracle SQL Developer to execute a SQL statement or more-involved wizard-driven dialog boxes that step the user through a process. Tags: Application Development
Microsoft SQL Server 2005: Deployment and Tests in an iSCSI SAN	2007-06-30	Dell EqualLogic
iSCSI SANs offer an alternative for building Storage Area Networks. Consolidating storage in a SAN offers storage management and scaling benefits for datacenters. iSCSI support in Windows Server 2003 makes connecting servers to an iSCSI SAN easy and affordable. This paper describes the deployment and testing results of SQL Server 2005 using the Microsoft iSCSI Initiator with a Dell EqualLogic iSCSI SAN. It helps you understand best practices and the benefits of using an iSCSI SAN with SQL Server 2005. Tags: SANs, Storage Consolidation, Windows NT - 2000 - 2003, High Performance Computing
Customer XXX: Oracle RAC 10gR2 Installation on IBM BladeCenter Example Final Project Document	2007-06-27	IBM
This paper describes the purpose and details for the implementation of a two node Oracle 10gR2 (10.2.0.3) database with RAC (Real Application Clusters) on XXX's extant HS20 blades and DS4400 disk storage. The purpose of this project is to install Oracle RAC 10gR2 on two IBM HS20 blades, using IBM DS4400 shared storage to address the first-level requirements of the NEW project. Tags: Blades
DB2 UDB Enterprise Edition V8.1: Basic Performance Tuning Guidelines	2007-06-12	IBM
IBM DB2 Universal DataBase (DB2 UDB) is configured to run on any system that meets its minimum hardware requirements. As a result, the basic configuration provided must be tuned to achieve optimum performance on systems that exceed the these requirements. Tuning a system can be quite involved. Volumes could be written (and often have been) on tuning each system level. Because the subject is quite complex, no single paper can really teach everything about tuning a system for optimum performance. The main purpose of this paper is to provide the basics needed to tune one level of a system and a set of guidelines that can be used to modify the basic configuration of DB2 UDB to improve overall database performance. Tags: Database Applications
Oracle SaaS Platform: Building On-Demand Applications	2007-06-01	Oracle
The adoption of Software as a Service (SaaS) or On-Demand presents several technical and business challenges for all players involved - Independent Software Vendors (ISVs), hosting services providers and the customers. The technical challenges for SaaS providers include support for multi-tenancy, security, usability and service-level management. Oracle SaaS Platform consisting of database, middleware and systems management software provides a comprehensive platform that addresses these challenges and runs on grid. In simplest terms, SaaS refers to hosted on-demand delivery of applications, as opposed to on premise. However, software as a service is not a singular model but encompasses a spectrum of choices ranging from hosting traditional packaged applications at a remote site to multi-tenant shared applications. Tags: Database Applications, Application Development
SGeRAC and Oracle RAC 10g R2 on HP-UX 11i Best Practices	2007-06-01	Hewlett-Packard (HP)
This paper describes common best practices for configuring clusters with Serviceguard, Serviceguard Extension for RAC (SGeRAC) and Oracle 10g Real Application Cluster (RAC). A basic configuration is shown and followed by specific preferred configurations with regards to the following topics: availability for the public network, network for Cluster Communication, storage Configuration and Serviceguard Packages. Tags: HP-UX, Database Applications
IBM System p for Oracle Data Warehousing	2007-05-01	IBM
One of the major areas of concern for business is the effort involved in architecting, developing and deploying complex data warehouses and the associated components of the business intelligence solution around Extract, Transform and Load (ETL) and analytic applications. IBM and Oracle have developed a powerful architectural model and approach to simplifying the deployment and reducing the risk of data warehouses based on the IBM System p for Oracle Data Warehousing. This solution fully supports the Oracle Information Appliance Initiative and provides a family of optimized and validated pre-sized configuration building blocks for data warehouses to support a range of raw data, user and query workload requirements. Tags: Business Intelligence - Data Warehousing
Database Design and Management: "Getting It Right the First Time"	2007-05-01	CA (Computer Associates)
In the world of databases, "Getting it right" is a phrase filled with ambiguity, for who can say what "Right" truly is? Frankly, it's a lot easier to spot "Bad" or "Not right" database schemas than it is to confirm that a database schema is "Right". Database management processes that tie database design to performance tuning, administration and backup/recovery, then the database project is headed down the path to failure. Integrating the best schema design that one knows how to do, along with best practices in, for example, performance management and properly tuned and deployed SQL code will go a very long way toward ensuring the database environment is functioning at optimal levels. Tags: Database Applications
Application Migration Workshop	2007-05-01	Oracle
Many small and medium businesses use Microsoft Access to manage mission-critical business functions. As businesses grow or their requirements expand, however, they may need to migrate their existing Access applications to a more-robust architecture and a function-rich tool. This column describes a migration path from Access to Oracle Application Express running on an Oracle database. This Oracle solution migrates the Access data, forms, and reports to a pure browser-based application. Tags: Upgrades and Migration, Database Applications
Now Reporting	2007-05-01	Oracle
In March 2006, Oracle announced the availability of Oracle SQL Developer, a GUI for Oracle Database. Oracle SQL Developer provides an easy-to-install, lightweight, multiplatform GUI that enables database developers to do a variety of database activities, including browsing, creating, and updating data. In the area of reporting, Oracle SQL Developer provides a collection of data dictionary reports for querying the system details and also offers the user the ability to create their own reports and share them. This column shows the user different report styles available in Oracle SQL Developer and how one can store and share reports. Tags: Database Applications, Application Development