Database Management - IT Library : ZDNet Asia

White Papers

Case Studies

Vendor Webcast

Show all content

Title Date Added Company

IBM Information Server Change Data Capture 2008-01-01 IBM

In today's fast-paced world, access to real-time data has never been more important. To be successful, organizations need to be able to report and analyze corporate data quickly and easily, regardless of what applications created the data, what platform they're running on, or what database they're stored in.

IBM Information Server Change Data Capture is a high-performance, low latency, real-time data integration solution that enables customers to easily sense and respond to relevant business data changes throughout the enterprise.

Tags: Data Center,

Top 10 Secrets for DBA Career Success 2008-06-01 Confio Software

Over the years, Confio Software has had the opportunity to learn many tips from the hundreds of DBAs that it has worked with. These tips are based on its experiences tuning databases with its clients and working with them to most positively impact their organization. The goal of this whitepaper is to help you focus on the aspects of your job that will bring you the most success. Along the way, it should show you how to achieve better database performance and maximize the efficiency of the applications that depend on them.

Tags: IT HR - Staffing - Training, Career Development, Database Applications

On BULK COLLECT 2008-03-01 Oracle

The most important thing to remember when one learns about and start to take advantage of features such as BULK COLLECT is that there is no free lunch. There is almost always a trade-off to be made somewhere. The tradeoff with BULK COLLECT, like so many other performance-enhancing features, is "Run faster but consume more memory." Specifically, memory for collections is stored in the Program Global Area (PGA), not the System Global Area (SGA). SGA memory is shared by all sessions connected to Oracle Database, but PGA memory is allocated for each session.

Declarative Data Filtering 2008-03-01 Oracle

In Oracle JDeveloper, one can specify easy-to-understand names for the columns defined in the SQL query encapsulated by a view object. For example, the Managers view object in the starter workspace queries the EMP table. Although the query includes the JOB column, the corresponding view object attribute is named CompanyRole. Previous versions of Oracle JDeveloper made it possible to manually enter custom WHERE and ORDER BY clauses in a view object query, and they included an "Expert mode" that gave full control over the entire SQL statement. Although these modes are both still supported, they require one to remember the names of the underlying database columns - a tedious requirement if one is not intimately familiar with the schema.

Tags: Application Development

Delivering Affordable Information Management Functionality: Oracle Database Standard Edition One 2008-02-26 Oracle

Databases have become key in enabling businesses to efficiently manage their data assets and to effectively use information to better understand their businesses. This document considers the question of what is needed for small and medium-sized businesses (SMBs) to successfully implement and maintain database applications, considering limitations of budget, time, and expertise. It considers such issues as ease of installation, ease of use, reliability, and manageability of relational database management systems (RDBMSs). It also explores how Oracle has delivered such capabilities with Oracle Database Standard Edition One.

Tags: Database Applications

Sun and MySQL: How It Stacks Up for Developers 2008-02-01 Sun Microsystems

Most business analysts have applauded the announced acquisition by Sun Microsystems of open-source database provider MySQL AB. Although the business case for bringing MySQL under the Sun umbrella is clear, the acquisition leaves many developers wondering just what is in store for them. Developers want products that are easy to use during development, that are easy to scale to enterprise levels, and that will last long enough to repay the time investment required to master the technologies. Some MySQL community members wonder if they will continue to enjoy superior open-source products from the combined companies, and if the community will remain strong in the future.

Tags: Application Development

Upgrading From Oracle Database 9i to 10g: What to Expect From the Optimizer 2008-02-01 Oracle

Since its introduction in Oracle 7.0, people have been fascinated and intimidated by the Cost-Based Optimizer (CBO) and the statistics that feed it. It has long been felt that the internals of the CBO were shrouded in mystery and that a degree in wizardry was needed to work with it. One of the most daunting activities a DBA can therefore undertake is upgrading the database to a new version. Having to comprehend all of the new features and to deal with potential plan changes can be overwhelming. This paper aims to dispel the mystery by explaining in detail what to expect from the CBO when one upgrade from Oracle database 9i to 10g.

Tags: High Performance Computing, Database Applications

Oracle Database Security: Preventing Enterprise Data Leaks at the Source 2008-02-01 IDG (International Data Group)

This paper presents a preemptive approach to IPC. It discusses the growing internal threats to business information, the impact of government regulations on the protection of data, and how enterprises must adopt database security best practices to prevent sensitive customer data or company information from being distributed within or outside the enterprise in violation of regulatory or company policies. It also highlights how Oracle provides security products that enterprises can leverage to protect themselves from costly data breaches.

Tags: Security Management

Performance of Environments Using DB2 Connect Enterprise Edition 2008-02-01 IBM

DB2 Connect Enterprise Edition V9.1 for Linux on zSeries (DB2 Connect) connects LAN-based systems and their applications to the company's mainframe host DB2 databases. Additionally, DB2 Connect can be used in a three tier environment and can act as a gateway concentrating large numbers of SQL connections from various clients to a fewer, well-defined number of connections to the DB2 database on z/OS. The focus of this paper is on the connection concentrator functions of DB2 Connect. This feature enables a predictable, controlled load on the database on z/OS from a DB2 Connect server and may reduce mainframe resource usage as fewer DB2 threads may be defined.

Oracle Database: 11g Standard Edition ONE 2008-01-29 Oracle

Oracle Database 11g Standard Edition One is a full-featured data management solution ideally suited to the needs of fast-growing businesses. It is easy to install on Windows and Linux operating systems, easy to manage with automated management capabilities and easy to scale as your business and IT needs grow. Oracle Database 11g Standard Edition One manages all data types and enables all your business applications to take advantage of the performance, reliability, security and scalability for which Oracle is renowned, at a low cost. Oracle Database 11g Standard Edition One provides complete upward compatibility with other Oracle Database Editions, protecting your investment as your requirements grow.
Read this white paper to see the major benefits and features of Oracle Database 11g Standard Edition ONE for your organisation.

Tags: Database Applications

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

Title	Date Added	Company
IBM Information Server Change Data Capture	2008-01-01	IBM
In today's fast-paced world, access to real-time data has never been more important. To be successful, organizations need to be able to report and analyze corporate data quickly and easily, regardless of what applications created the data, what platform they're running on, or what database they're stored in. IBM Information Server Change Data Capture is a high-performance, low latency, real-time data integration solution that enables customers to easily sense and respond to relevant business data changes throughout the enterprise. Tags: Data Center,
Top 10 Secrets for DBA Career Success	2008-06-01	Confio Software
Over the years, Confio Software has had the opportunity to learn many tips from the hundreds of DBAs that it has worked with. These tips are based on its experiences tuning databases with its clients and working with them to most positively impact their organization. The goal of this whitepaper is to help you focus on the aspects of your job that will bring you the most success. Along the way, it should show you how to achieve better database performance and maximize the efficiency of the applications that depend on them. Tags: IT HR - Staffing - Training, Career Development, Database Applications
On BULK COLLECT	2008-03-01	Oracle
The most important thing to remember when one learns about and start to take advantage of features such as BULK COLLECT is that there is no free lunch. There is almost always a trade-off to be made somewhere. The tradeoff with BULK COLLECT, like so many other performance-enhancing features, is "Run faster but consume more memory." Specifically, memory for collections is stored in the Program Global Area (PGA), not the System Global Area (SGA). SGA memory is shared by all sessions connected to Oracle Database, but PGA memory is allocated for each session.
Declarative Data Filtering	2008-03-01	Oracle
In Oracle JDeveloper, one can specify easy-to-understand names for the columns defined in the SQL query encapsulated by a view object. For example, the Managers view object in the starter workspace queries the EMP table. Although the query includes the JOB column, the corresponding view object attribute is named CompanyRole. Previous versions of Oracle JDeveloper made it possible to manually enter custom WHERE and ORDER BY clauses in a view object query, and they included an "Expert mode" that gave full control over the entire SQL statement. Although these modes are both still supported, they require one to remember the names of the underlying database columns - a tedious requirement if one is not intimately familiar with the schema. Tags: Application Development
Delivering Affordable Information Management Functionality: Oracle Database Standard Edition One	2008-02-26	Oracle
Databases have become key in enabling businesses to efficiently manage their data assets and to effectively use information to better understand their businesses. This document considers the question of what is needed for small and medium-sized businesses (SMBs) to successfully implement and maintain database applications, considering limitations of budget, time, and expertise. It considers such issues as ease of installation, ease of use, reliability, and manageability of relational database management systems (RDBMSs). It also explores how Oracle has delivered such capabilities with Oracle Database Standard Edition One. Tags: Database Applications
Sun and MySQL: How It Stacks Up for Developers	2008-02-01	Sun Microsystems
Most business analysts have applauded the announced acquisition by Sun Microsystems of open-source database provider MySQL AB. Although the business case for bringing MySQL under the Sun umbrella is clear, the acquisition leaves many developers wondering just what is in store for them. Developers want products that are easy to use during development, that are easy to scale to enterprise levels, and that will last long enough to repay the time investment required to master the technologies. Some MySQL community members wonder if they will continue to enjoy superior open-source products from the combined companies, and if the community will remain strong in the future. Tags: Application Development
Upgrading From Oracle Database 9i to 10g: What to Expect From the Optimizer	2008-02-01	Oracle
Since its introduction in Oracle 7.0, people have been fascinated and intimidated by the Cost-Based Optimizer (CBO) and the statistics that feed it. It has long been felt that the internals of the CBO were shrouded in mystery and that a degree in wizardry was needed to work with it. One of the most daunting activities a DBA can therefore undertake is upgrading the database to a new version. Having to comprehend all of the new features and to deal with potential plan changes can be overwhelming. This paper aims to dispel the mystery by explaining in detail what to expect from the CBO when one upgrade from Oracle database 9i to 10g. Tags: High Performance Computing, Database Applications
Oracle Database Security: Preventing Enterprise Data Leaks at the Source	2008-02-01	IDG (International Data Group)
This paper presents a preemptive approach to IPC. It discusses the growing internal threats to business information, the impact of government regulations on the protection of data, and how enterprises must adopt database security best practices to prevent sensitive customer data or company information from being distributed within or outside the enterprise in violation of regulatory or company policies. It also highlights how Oracle provides security products that enterprises can leverage to protect themselves from costly data breaches. Tags: Security Management
Performance of Environments Using DB2 Connect Enterprise Edition	2008-02-01	IBM
DB2 Connect Enterprise Edition V9.1 for Linux on zSeries (DB2 Connect) connects LAN-based systems and their applications to the company's mainframe host DB2 databases. Additionally, DB2 Connect can be used in a three tier environment and can act as a gateway concentrating large numbers of SQL connections from various clients to a fewer, well-defined number of connections to the DB2 database on z/OS. The focus of this paper is on the connection concentrator functions of DB2 Connect. This feature enables a predictable, controlled load on the database on z/OS from a DB2 Connect server and may reduce mainframe resource usage as fewer DB2 threads may be defined.
Oracle Database: 11g Standard Edition ONE	2008-01-29	Oracle
Oracle Database 11g Standard Edition One is a full-featured data management solution ideally suited to the needs of fast-growing businesses. It is easy to install on Windows and Linux operating systems, easy to manage with automated management capabilities and easy to scale as your business and IT needs grow. Oracle Database 11g Standard Edition One manages all data types and enables all your business applications to take advantage of the performance, reliability, security and scalability for which Oracle is renowned, at a low cost. Oracle Database 11g Standard Edition One provides complete upward compatibility with other Oracle Database Editions, protecting your investment as your requirements grow. Read this white paper to see the major benefits and features of Oracle Database 11g Standard Edition ONE for your organisation. Tags: Database Applications