Database Applications - IT Library : ZDNet Asia

White Papers

Case Studies

Vendor Webcast

Show all content

Title Date Added Company

Streamlining Information Flow Frees Valuable Time 2006-11-01 01:00:28 Microsoft

When Monta May arrived at Saint Mary's University of Minnesota to become assistant to the graduate programs, she was faced with a monumental organizational task. Since her predecessor departed months earlier, May was mentor-less and faced with a backlog of information to process. Familiar with the benefits of the Microsoft Office suite of products from her prior work as an office manager and accountant, May knew that her department could benefit from the Microsoft Office System by streamlining processes and reusing information across multiple applications. As a result of creating systems for processing the flow of information using Microsoft Office Professional Edition 2003, May's clerical work has been reduced by days each week, allowing the university to tap her other valuable skills.

Simplifying Paperwork Frees Foster Care Staff to Put Clients First 2006-11-01 01:00:28 Microsoft

The fewer hours A Second Chance Inc. (ASCI) staff members spend handling paperwork and other routine tasks, the more time they can devote to helping their clients. Until recently, agency employees were still writing most of their reports by hand and using phone calls or U.S. mail to communicate. The agency's IT new network coordinator recognized that ASCI could operate more efficiently using Microsoft Office Professional Edition 2003 applications. Since the agency adopted Office Professional Edition 2003 along with Internet access on a shared network, it has accelerated key steps of the client intake process from days to minutes, while improving communication and streamlining ASCI's records management.

SQL Server Reporting Services' Rich Integration With Word & Excel Via SoftArtisan's OfficeWriter Solution Provides Major Performance Gains for Momenta 2006-11-01 01:00:29 Microsoft

Momenta, a leading program management consultancy, needed a centralized reporting solution for the Department of Trade and Industry to replace a legacy application that was facing increasing performance problems as data increased. Momenta found that its staff could create reports faster and make them more accessible by using SoftArtisans OfficeWriter with SQL Server Reporting Services. The company has completed the first phase of migrating from a dual database platform (a Microsoft Access 97 database and SQL Server 2000 database with Access 2002 interface) to a SQL Server 2000 and SoftArtisans OfficeWriter solution. In addition to generating user-friendly reports in native Microsoft Excel and Word, Momenta discovered that OfficeWriter for Reporting Services could generate a complex report in 10 seconds.

Greek Paper Mill Reduces Ordering Administration Time by 75 Percent 2006-11-01 01:00:28 Microsoft

To maintain profitability and its position as the largest private paper-making company in Greece, Thrace Paper Mills continuously strives to increase production efficiency and minimize costs. Its most recent efforts included creating a solution based on the Microsoft .NET Framework, Microsoft SQL Server, and Microsoft Commerce Server to automate order entry and provide an online store for customers to place orders directly. As a result of this implementation, the company was able to decrease the administration time per order by 75 percent and reduce administration costs accordingly. Through this solution, Thrace Paper Mills also gained more effective and flexible reporting capabilities, which enhanced business decision making.

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.

Using PivotTables and PivotCharts in Microsoft Access 2002 2006-10-20 01:00:16 Microsoft

This webcast will present an overview of how to use the basic feature set of the PivotTable and PivotChart features in Microsoft Access 2002. Microsoft Access 2002 introduces PivotTable and PivotChart views to tables, queries, views, stored procedures, functions, and forms. One can now perform data analysis and build rich PivotTable and PivotChart views more quickly than ever before.

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.

Deutsche Post AG: More Response Per Cross-Media 2006-10-18 01:00:18 Oracle

Together, Deutsche Post AG, DHL, and Postbank form the Deutsche Post World Net, offering integrated services and custom-made solutions for managing and transporting goods, information, and payment. Deutsche Post AG wanted to conceive cross-media customer services with personalized dialog and develop an online response management for post office customers involved in dialog marketing. They wanted to provide direct access to hosted address databases via an internet portal that is password protected. Deutsche Post AG implemented Oracle Database 10g and Oracle JDeveloper, allowing the company to centrally host databases used for an online order platform. They used JDeveloper to provide a standardized, encrypted procedure for personalized, multi-channel addressing.

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

Title	Date Added	Company
Streamlining Information Flow Frees Valuable Time	2006-11-01 01:00:28	Microsoft
When Monta May arrived at Saint Mary's University of Minnesota to become assistant to the graduate programs, she was faced with a monumental organizational task. Since her predecessor departed months earlier, May was mentor-less and faced with a backlog of information to process. Familiar with the benefits of the Microsoft Office suite of products from her prior work as an office manager and accountant, May knew that her department could benefit from the Microsoft Office System by streamlining processes and reusing information across multiple applications. As a result of creating systems for processing the flow of information using Microsoft Office Professional Edition 2003, May's clerical work has been reduced by days each week, allowing the university to tap her other valuable skills.
Simplifying Paperwork Frees Foster Care Staff to Put Clients First	2006-11-01 01:00:28	Microsoft
The fewer hours A Second Chance Inc. (ASCI) staff members spend handling paperwork and other routine tasks, the more time they can devote to helping their clients. Until recently, agency employees were still writing most of their reports by hand and using phone calls or U.S. mail to communicate. The agency's IT new network coordinator recognized that ASCI could operate more efficiently using Microsoft Office Professional Edition 2003 applications. Since the agency adopted Office Professional Edition 2003 along with Internet access on a shared network, it has accelerated key steps of the client intake process from days to minutes, while improving communication and streamlining ASCI's records management.
SQL Server Reporting Services' Rich Integration With Word & Excel Via SoftArtisan's OfficeWriter Solution Provides Major Performance Gains for Momenta	2006-11-01 01:00:29	Microsoft
Momenta, a leading program management consultancy, needed a centralized reporting solution for the Department of Trade and Industry to replace a legacy application that was facing increasing performance problems as data increased. Momenta found that its staff could create reports faster and make them more accessible by using SoftArtisans OfficeWriter with SQL Server Reporting Services. The company has completed the first phase of migrating from a dual database platform (a Microsoft Access 97 database and SQL Server 2000 database with Access 2002 interface) to a SQL Server 2000 and SoftArtisans OfficeWriter solution. In addition to generating user-friendly reports in native Microsoft Excel and Word, Momenta discovered that OfficeWriter for Reporting Services could generate a complex report in 10 seconds.
Greek Paper Mill Reduces Ordering Administration Time by 75 Percent	2006-11-01 01:00:28	Microsoft
To maintain profitability and its position as the largest private paper-making company in Greece, Thrace Paper Mills continuously strives to increase production efficiency and minimize costs. Its most recent efforts included creating a solution based on the Microsoft .NET Framework, Microsoft SQL Server, and Microsoft Commerce Server to automate order entry and provide an online store for customers to place orders directly. As a result of this implementation, the company was able to decrease the administration time per order by 75 percent and reduce administration costs accordingly. Through this solution, Thrace Paper Mills also gained more effective and flexible reporting capabilities, which enhanced business decision making.
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.
Using PivotTables and PivotCharts in Microsoft Access 2002	2006-10-20 01:00:16	Microsoft
This webcast will present an overview of how to use the basic feature set of the PivotTable and PivotChart features in Microsoft Access 2002. Microsoft Access 2002 introduces PivotTable and PivotChart views to tables, queries, views, stored procedures, functions, and forms. One can now perform data analysis and build rich PivotTable and PivotChart views more quickly than ever before.
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.
Deutsche Post AG: More Response Per Cross-Media	2006-10-18 01:00:18	Oracle
Together, Deutsche Post AG, DHL, and Postbank form the Deutsche Post World Net, offering integrated services and custom-made solutions for managing and transporting goods, information, and payment. Deutsche Post AG wanted to conceive cross-media customer services with personalized dialog and develop an online response management for post office customers involved in dialog marketing. They wanted to provide direct access to hosted address databases via an internet portal that is password protected. Deutsche Post AG implemented Oracle Database 10g and Oracle JDeveloper, allowing the company to centrally host databases used for an online order platform. They used JDeveloper to provide a standardized, encrypted procedure for personalized, multi-channel addressing.