Database Applications - IT Library : ZDNet Asia

White Papers

Case Studies

Vendor Webcast

Show all content

Title Date Added Company

VoIP : qualité et performance pour une utilisation optimale 2006-12-04 07:04:48 Ovum

73 % des entreprises qui ont déployé la VoIP (ou prévoient de le faire) ont déclaré que la qualité et la fiabilité constituaient toujours leur principale préoccupation. Ceci n'est pas surprenant lorsque l'on sait que seulement 8 % d'entre elles surveillent, ou prévoient de surveiller, tous les appels effectués sur leur réseau.* Fournir un excellent service peut être un véritable défi si vous ne possédez pas les informations nécessaires sur la qualité de service offert par votre réseau pour chaque appel voix. Compuware peut vous aider. Téléchargez notre Kit de ressources VoIP GRATUIT. Il inclut : * Un wébinaire en partenariat avec Ovum et BT ; * Le dernier rapport d'Ovum : Répondre aux exigences des applications métiers avec des réseaux de nouvelle génération ; * Le Livre Blanc Visibilité : un facteur indispensable pour la gestion des applications stratégiques sur MPLS. * Étude indépendante réalisée à la demande de Compuware auprès de 300 directeurs informatiques EMEA, octobre 2006.

Create an Excel Report From Several Oracle Databases Using Apache Jakarta POI 2006-11-08 01:00:18 Oracle

Microsoft Excel spreadsheets are ubiquitous in today's business environment. Although Excel can read and display delimited files, the .xls proprietary format provides additional expressive features, including font formatting and multiple sheets per spreadsheet. Many tools - commercial as well as open source - provide a mechanism for producing reports that Excel can read. Depending on the structure and use of particular databases, there are additional reasons why one might produce this type of spreadsheet, but these reasons are dependent upon functional requirements and definitions of particular databases. This paper describes how to use the Apache Jakarta POI open source project to produce a spreadsheet from several different datasources.

Keeping Up With the Times 2006-11-08 01:00:18 Oracle

This paper provides an approach to implementing one of the more demanding types of transformations: the dreaded Type 2 Slowly Changing Dimension (SCD). Although this technique may be applicable to other type of transformations, it is particularly useful for the Type 2 SCD. The focus of this paper is the Type 2 SCD, as it is the most effective and most commonly used variety. The Type 2 SCD provides an approach for completely and elegantly tracking history, while conforming to the dimensional model for optimal performance. Although Oracle9i Warehouse Builder (OWB) does not have "Built-in" support for SCD transformations, one can easily implement them within the OWB framework.

RT: Request Tracker, Part 1 2006-11-01 01:00:29 Sun Microsystems

There are a number of options available for helpdesk/ticketing systems, and they range in price and complexity from free and very simple to extremely expensive and involved. Some popular options include Remedy, Clarify, Quantum, and Request Tracker (RT). The author's preference leans towards RT, coming in at free and extremely flexible on the cost and complexity spectrum. RT works well in small, mid-sized, and some larger environments. RT uses a back-end database, a perl-based main engine, and front-end web and mail interfaces. The recommended database for use with RT is MySQL, but it also works with PostgreSQL. The recommended web interface is the Apache web server with mod_perl or mod_fastcgi.

Oracle Business Intelligence Suite Enterprise Edition Technical Overview 2006-11-30 01:00:16 Oracle

The Oracle Business Intelligence Suite EE is a comprehensive and integrated suite of Analytic Tools designed to bring greater business visibility and insight to the broadest audiences of users, allowing any user in an organization to have Web-based self-service access to up-to-the-moment, relevant, and actionable intelligence.

Creating a Two Node CCR Cluster on Exchange 2007 2006-10-20 01:00:16 Pro Exchange

Exchange 2007 provides support for two different types of clustering. The first one, Single Copy Cluster (SCC), requires shared storage and uses a single database file for each store database. SCC clusters are basically the same as traditional clusters in early versions of Exchange, with some improvements in Exchange 2007. The second type of clustering is Cluster Continuous Replication (CCR). CCR is similar to Local Continuous Replication (LCR) clusters where two copies of the Exchange storage group, and all stores within it, are made. This paper covers setting up and configuring Exchange 2007 in a two node Cluster Continuous Replication (CCR) cluster.

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.

Setting Up Oracle9i Database and PHP on Mac OS X 2006-10-17 01:00:14 Oracle

With Apple's move to a UNIX base with Mac OS X, many developers have been excited about the prospects of a development platform that combines legendary ease of use with a rock-solid foundation. Considering that Oracle has a developer release of the Oracle9i Database Release 2 for OS X 10.2 (Jaguar) and that OS X is now a fully supported platform for Oracle Database 10g, things are looking even brighter. One of the most exciting aspects of OS X as a development platform is support for thousands of open source tools and frameworks that have been developed for UNIX-like systems.

Generate External Tables From an Excel Spreadsheet Using Apache Jakarta POI 2006-10-17 01:00:14 Oracle

DBAs and application developers frequently face the task of loading data from Excel spreadsheets into Oracle databases. With the advent of Oracle 10g's spreadsheet-like model capabilities, it is likely that more data that is currently stored and viewed in spreadsheets will be loaded into Oracle databases for manipulation and processing. Oracle provides a variety of methods for loading data from a spreadsheet into a database. Most Oracle DBAs and developers are familiar with the capabilities of SQL*Loader. Oracle HTML DB can be used to load Excel data in batch as well. This paper presents and alternative method for loading data from an Excel spreadsheet that takes advantage of open source technology and external tables.

Building an Ajax Memory Tree 2006-10-17 01:00:14 Oracle

Ajax (Asynchronous javascript and xml) is not a technology itself, but rather a combination of several technologies - HTML, CSS, JavaScript, and XML - delivered via a Web page. Essentially, Ajax extends client-server-like functionality to the Web. This paper shows how to build an Ajax-based memory tree in Oracle Application Express (formerly HTML DB), based on any table that contains hierarchical data. As the tree makes use of Ajax to fetch nodes as they are expanded, it can easily scale to support a table with thousands or more rows.

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

Title	Date Added	Company
VoIP : qualité et performance pour une utilisation optimale	2006-12-04 07:04:48	Ovum
73 % des entreprises qui ont déployé la VoIP (ou prévoient de le faire) ont déclaré que la qualité et la fiabilité constituaient toujours leur principale préoccupation. Ceci n'est pas surprenant lorsque l'on sait que seulement 8 % d'entre elles surveillent, ou prévoient de surveiller, tous les appels effectués sur leur réseau.* Fournir un excellent service peut être un véritable défi si vous ne possédez pas les informations nécessaires sur la qualité de service offert par votre réseau pour chaque appel voix. Compuware peut vous aider. Téléchargez notre Kit de ressources VoIP GRATUIT. Il inclut : * Un wébinaire en partenariat avec Ovum et BT ; * Le dernier rapport d'Ovum : Répondre aux exigences des applications métiers avec des réseaux de nouvelle génération ; * Le Livre Blanc Visibilité : un facteur indispensable pour la gestion des applications stratégiques sur MPLS. * Étude indépendante réalisée à la demande de Compuware auprès de 300 directeurs informatiques EMEA, octobre 2006.
Create an Excel Report From Several Oracle Databases Using Apache Jakarta POI	2006-11-08 01:00:18	Oracle
Microsoft Excel spreadsheets are ubiquitous in today's business environment. Although Excel can read and display delimited files, the .xls proprietary format provides additional expressive features, including font formatting and multiple sheets per spreadsheet. Many tools - commercial as well as open source - provide a mechanism for producing reports that Excel can read. Depending on the structure and use of particular databases, there are additional reasons why one might produce this type of spreadsheet, but these reasons are dependent upon functional requirements and definitions of particular databases. This paper describes how to use the Apache Jakarta POI open source project to produce a spreadsheet from several different datasources.
Keeping Up With the Times	2006-11-08 01:00:18	Oracle
This paper provides an approach to implementing one of the more demanding types of transformations: the dreaded Type 2 Slowly Changing Dimension (SCD). Although this technique may be applicable to other type of transformations, it is particularly useful for the Type 2 SCD. The focus of this paper is the Type 2 SCD, as it is the most effective and most commonly used variety. The Type 2 SCD provides an approach for completely and elegantly tracking history, while conforming to the dimensional model for optimal performance. Although Oracle9i Warehouse Builder (OWB) does not have "Built-in" support for SCD transformations, one can easily implement them within the OWB framework.
RT: Request Tracker, Part 1	2006-11-01 01:00:29	Sun Microsystems
There are a number of options available for helpdesk/ticketing systems, and they range in price and complexity from free and very simple to extremely expensive and involved. Some popular options include Remedy, Clarify, Quantum, and Request Tracker (RT). The author's preference leans towards RT, coming in at free and extremely flexible on the cost and complexity spectrum. RT works well in small, mid-sized, and some larger environments. RT uses a back-end database, a perl-based main engine, and front-end web and mail interfaces. The recommended database for use with RT is MySQL, but it also works with PostgreSQL. The recommended web interface is the Apache web server with mod_perl or mod_fastcgi.
Oracle Business Intelligence Suite Enterprise Edition Technical Overview	2006-11-30 01:00:16	Oracle
The Oracle Business Intelligence Suite EE is a comprehensive and integrated suite of Analytic Tools designed to bring greater business visibility and insight to the broadest audiences of users, allowing any user in an organization to have Web-based self-service access to up-to-the-moment, relevant, and actionable intelligence.
Creating a Two Node CCR Cluster on Exchange 2007	2006-10-20 01:00:16	Pro Exchange
Exchange 2007 provides support for two different types of clustering. The first one, Single Copy Cluster (SCC), requires shared storage and uses a single database file for each store database. SCC clusters are basically the same as traditional clusters in early versions of Exchange, with some improvements in Exchange 2007. The second type of clustering is Cluster Continuous Replication (CCR). CCR is similar to Local Continuous Replication (LCR) clusters where two copies of the Exchange storage group, and all stores within it, are made. This paper covers setting up and configuring Exchange 2007 in a two node Cluster Continuous Replication (CCR) cluster.
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.
Setting Up Oracle9i Database and PHP on Mac OS X	2006-10-17 01:00:14	Oracle
With Apple's move to a UNIX base with Mac OS X, many developers have been excited about the prospects of a development platform that combines legendary ease of use with a rock-solid foundation. Considering that Oracle has a developer release of the Oracle9i Database Release 2 for OS X 10.2 (Jaguar) and that OS X is now a fully supported platform for Oracle Database 10g, things are looking even brighter. One of the most exciting aspects of OS X as a development platform is support for thousands of open source tools and frameworks that have been developed for UNIX-like systems.
Generate External Tables From an Excel Spreadsheet Using Apache Jakarta POI	2006-10-17 01:00:14	Oracle
DBAs and application developers frequently face the task of loading data from Excel spreadsheets into Oracle databases. With the advent of Oracle 10g's spreadsheet-like model capabilities, it is likely that more data that is currently stored and viewed in spreadsheets will be loaded into Oracle databases for manipulation and processing. Oracle provides a variety of methods for loading data from a spreadsheet into a database. Most Oracle DBAs and developers are familiar with the capabilities of SQL*Loader. Oracle HTML DB can be used to load Excel data in batch as well. This paper presents and alternative method for loading data from an Excel spreadsheet that takes advantage of open source technology and external tables.
Building an Ajax Memory Tree	2006-10-17 01:00:14	Oracle
Ajax (Asynchronous javascript and xml) is not a technology itself, but rather a combination of several technologies - HTML, CSS, JavaScript, and XML - delivered via a Web page. Essentially, Ajax extends client-server-like functionality to the Web. This paper shows how to build an Ajax-based memory tree in Oracle Application Express (formerly HTML DB), based on any table that contains hierarchical data. As the tree makes use of Ajax to fetch nodes as they are expanded, it can easily scale to support a table with thousands or more rows.