SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 156 | Next

Robert Wrembel and Christian Koncilia

"Data Warehouses and Olap: Concepts, Architectures and Solutions"

The global priority is left blank and will be defined in a later phase.
As an example, user U2 (Maria Lopez) has declared that a query she will be
posing regularly is ???Number of monthly contracts per sales representative.???
Data Quality-Based Requirements Elicitation for Decision Support Systems
Copyright ?© 2007, Idea Group Inc. Copying or distributing in print or electronic forms without written permission
of Idea Group Inc. is prohibited.
The entry in QRY_USR, for user U2 will be 24hs,50sec>.
???. Query.analysis: here we perform data recollection and validation against the
data dictionary. The goal of the former is the discovery of atomic data required
for satisfying each query defined in the previous step. However, initially the
QRY_USR form may contain queries with redundant, ambiguous, or even
incorrect terms. Thus, analysts and users review the queries and agree on a
(possibly) new set of queries, using the information obtained from the data and
aggregations dictionaries. For example, in query Q1 from user U2, the word
contracts will be replaced by the word sales, according to the information in
the data dictionary. These queries must be validated against the data dictionary,
and all terms not present in this dictionary must be added, using the form
DIC_DATA. This is a cyclic process, which results in a final QRY_USR form
where data referred in the queries are absolutely consistent with data in the
dictionaries.


Pages:
144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168