Tuning an SQL-Based PDM System in a Worldwide Client/Server Environment

Müller, Erich and Dadam, Peter and Enderle, Jost (2001) Tuning an SQL-Based PDM System in a Worldwide Client/Server Environment. In: Proc. Int'l Conf. on Data Engineering (ICDE '01), Heidelberg, Germany.

[thumbnail of MDEF01.pdf]
Preview
PDF - Requires a PDF viewer such as GSview, Xpdf or Adobe Acrobat Reader
Download (244kB)

Abstract

The management of product-related data in a uniform and
consistent way is a big challenge for many manufacturing
enterprises, especially the large ones like DaimlerChrysler.
So-called Product Data Management systems (PDMS) are a promising way to achieve this goal. For various reasons
PDMS often sit on-top of a relational DBMS using it (more
or less) as a simple record manager. User interactions with
the PDMS are translated into series of SQL queries. This does not cause too much harm when DBMS and PDMS are located in the same local-area network with high bandwidth and little latency times. The picture may change dramatically,
however, if the users are working in geographically distributed environments. Response times may rise by orders
of magnitude, e. g. from 1-2 minutes in the local context
to 30 minutes and even more in the ”intercontinental” context. The paper shows how a more sophisticated utilization of the (advanced) SQL features coming along with
SQL:1999 can help to cut down response times significantly.

Item Type: Conference or Workshop Item (Paper)
Subjects: DBIS Research > Publications
Divisions: Faculty of Engineering, Electronics and Computer Science > Institute of Databases and Informations Systems > DBIS Research and Teaching > DBIS Research > Publications
Depositing User: Eva Mader
Date Deposited: 21 Apr 2008 10:07
Last Modified: 14 Oct 2011 10:24
URI: http://dbis.eprints.uni-ulm.de/id/eprint/229

Actions (login required)

View Item
View Item