Search

Your search keyword '"Ming-Syan Chen"' showing total 2 results
Start Over Author "Ming-Syan Chen" Journal ieee transactions on software engineering
2 results on '"Ming-Syan Chen"'

1. On workload characterization of relational database environments

Author

Philip S. Yu, Hans-Ulrich Heiss, Ming-Syan Chen, and Seung Goo Lee

Subjects
SQL, Database, Alias, Computer science, View, Relational database, Data definition language, InformationSystems_DATABASEMANAGEMENT, computer.software_genre, Query language, Database design, Query by Example, Database theory, Stored procedure, computer, Software, Database catalog, Database model, computer.programming_language
Abstract

A relational database workload analyzer (REDWAR) is developed to characterize the workload in a DB2 environment. This is applied to study a production DB2 system where a structured query language (SQL) trace for a two-hour interval and an image copy of the database catalog were obtained. The results of the workload study are summarized. The structure and complexity of SQL statements, the makeup and run-time behavior of transactions/queries, and the composition of relations and views are discussed. The results obtained provide the important information needed to build a benchmark workload to evaluate the alternative design tradeoffs of database systems. >

Published
1992

2. On Workload Characterization of Relational Database Environments.

Author

Yu, Philip S., Ming-Syan Chen, Heiss, Hans-Ulrich, and Sukho Lee

Subjects
*RELATIONAL databases, *DATABASES, *DATABASE design, *SQL, *INFORMATION storage & retrieval systems, *SOFTWARE engineering, *COMPUTER software development
Abstract

As relational database systems become increasingly popular, there is a clear need to better understand the workload so that systems can be designed or tuned more effectively. A RElational Database Workload AnalyzeR (REDWAR) is developed to characterize the workload in a DB2 environment. This is applied to study a production DB2 system where an SQL trace for a two-hour interval and an image copy of the database catalog were obtained. The results of the workload study are summarized. Here we focus on the structure and complexity of SQL statements, the makeup and run-time behavior of transactions/queries, and the composition of relations and views. The results obtained provide the important information needed to build a benchmark workload to evaluate alternative design trade-offs of database systems. [ABSTRACT FROM AUTHOR]

Published
1992

Catalog

Books, media, physical & digital resources
See catalog results