The effects of information request ambiguity and construct incongruence on query development

This paper examines the effects of information request ambiguity and construct incongruence on end user's ability to develop SQL queries with an interactive relational database query language. In this experiment, ambiguity in information requests adversely affected accuracy and efficiency. Incongruities among the information request, the query syntax, and the data representation adversely affected accuracy, efficiency, and confidence. The results for ambiguity suggest that organizations might elicit better query development if end users were sensitized to the nature of ambiguities that could arise in their business contexts. End users could translate natural language queries into pseudo-SQL that could be examined for precision before the queries were developed. The results for incongruence suggest that better query development might ensue if semantic distances could be reduced by giving users data representations and database views that maximize construct congruence for the kinds of queries in typical domains. (C) 2001 Elsevier Science B.V. All rights reserved.

The effects of normalisation on the ability of business end-users to detect data anomalies: An experimental evaluation

With the proliferation of relational database programs for PC's and other platforms, many business end-users are creating, maintaining, and querying their own databases. More importantly, business end-users use the output of these queries as the basis for operational, tactical, and strategic decisions. Inaccurate data reduce the expected quality of these decisions. Implementing various input validation controls, including higher levels of normalisation, can reduce the number of data anomalies entering the databases. Even in well-maintained databases, however, data anomalies will still accumulate. To improve the quality of data, databases can be queried periodically to locate and correct anomalies. This paper reports the results of two experiments that investigated the effects of different data structures on business end-users' abilities to detect data anomalies in a relational database. The results demonstrate that both unnormalised and higher levels of normalisation lower the effectiveness and efficiency of queries relative to the first normal form. First normal form databases appear to provide the most effective and efficient data structure for business end-users formulating queries to detect data anomalies.

The structure of middle management remuneration packages: An application to Australian mine managers

This paper investigates the composition of remuneration packages for middle managers and relates the structure of remuneration contracts to firm-specific attributes. A statutorily defined position in a single industry is studied as an example of middle management. This allows us to control for differences in task complexity across managers and industry-induced factors that could determine differences in remuneration contracts. Higher-risk firms are expected to pay their mine managers a greater proportion of variable salaries and market and/or accounting-based compensation than low-risk firms. Results indicate that high-risk firms pay a higher proportion of variable salaries and more compensation based on market and/or accounting performance.

Developing community-based watershed management in Greater Sao Paulo: the case of Santo Andre

This paper describes how watershed protection is being combined with settlement upgrading and land-use management within an area that serves as one of Greater Sao Paulo's main sources of fresh water. This is being undertaken in the municipality of San to Andre. Unlike previous watershed protection measures, which proved ineffective, it recognizes the need to combine the protection of water-sheds with the improvement of conditions in existing settlements and guiding, rather than prohibiting, further settlement. The paper describes how, the community-based watershed management involves the inhabitants of illegal settlements and other stakeholders in an adaptive planning framework that first seeks consensus on what is to be planned before developing the plan, its implementation and its operation, maintenance and monitoring.