loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
17th International Conference on Data Engineering (ICDE'01)
Tuning an SQL-Based PDM System in a Worldwide Client/Server Environment
Heidelberg, Germany
April 02-April 06
ISBN: 0-7695-1001-9
E. Müller, University of Ulm
P. Dadam, University of Ulm
J. Enderle, University of Ulm
M. Feltes, DaimlerChrysler
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.
Citation:
E. Müller, P. Dadam, J. Enderle, M. Feltes, "Tuning an SQL-Based PDM System in a Worldwide Client/Server Environment," icde, pp.0099, 17th International Conference on Data Engineering (ICDE'01), 2001
Usage of this product signifies your acceptance of the Terms of Use.