Data warehouse stream view update with multiple streaming.

The main objective of data warehousing is to store information representing an integration of base data from single or multiple data sources over an extended period of time. To provide fast access to the data, regardless of the availability of the data source, data warehouses often use materialized views. Materialized views are able to provide aggregation on some attributes to help Decision Support Systems. Updating materialized views in response to modifications in the base data is called materialized view maintenance. In some applications, for example, the stock market and banking systems, the source data is updated so frequently that we can consider them as a continuous stream of data. To keep the materialized view updated with respect to changes in the base tables in a traditional way will cause query response times to increase. This thesis proposes a new view maintenance algorithm for multiple streaming which improves semi-join methods and hash filter methods. Our proposed algorithm is able to update a view which joins two base tables where both of the base tables are in the form of data streams (always changing). By using a timestamp, building updategrams in parallel and by optimizing the joining cost between two data sources it can reduce the query response time or execution time significantly.Dept. of Computer Science. Paper copy at Leddy Library: Theses & Major Papers - Basement, West Bldg. / Call Number: Thesis2005 .A336. Source: Masters Abstracts International, Volume: 44-03, page: 1391. Thesis (M.Sc.)--University of Windsor (Canada), 2005

Data warehouse stream view update with hash filter.

A data warehouse usually contains large amounts of information representing an integration of base data from one or more external data sources over a long period of time to provide fast-query response time. It stores materialized views which provide aggregation (SUM, MIX, MIN, COUNT and AVG) on some measure attributes of interest for data warehouse users. The process of updating materialized views in response to the modification of the base data is called materialized view maintenance. Some data warehouse application domains, like stock markets, credit cards, automated banking and web log domains depend on data sources updated as continuous streams of data. In particular, electronic stock trading markets such as the NASDAQ, generate large volumes of data, in bursts that are up to 4,200 messages per second. This thesis proposes a new view maintenance algorithm (StreamVup), which improves on semi join methods by using hash filters. The new algorithm first, reduce the amount of bytes transported through the network for streams tuples, and secondly reduces the cost of join operations during view update by eliminating the recompution of view updates caused by newly arriving duplicate tuples. (Abstract shortened by UMI.)Dept. of Computer Science. Paper copy at Leddy Library: Theses & Major Papers - Basement, West Bldg. / Call Number: Thesis2003 .I85. Source: Masters Abstracts International, Volume: 42-05, page: 1753. Adviser: C. I. Ezeife. Thesis (M.Sc.)--University of Windsor (Canada), 2003

Mining Query Plans for Finding Candidate Queries and Sub-Queries for Materialized Views in BI Systems Without Cube Generation

Materialized views are important for optimizing Business Intelligence (BI) systems when they are designed without data cubes. Selecting candidate queries from large number of queries for materialized views is a challenging task. Most of the work done in the past involves finding out frequent queries from the past workload and creating materialized views from such queries by either manually analyzing workload or using approximate string matching algorithms using query text. Most of the existing methods suggest complete queries but ignore query components such as sub queries for creation of materialized views. This paper presents a novel method to determine on which queries and query components materialized views can be created to optimize aggregate and join queries by mining database of query execution plans which are in the form of binary trees. The proposed algorithm showed significant improvement in terms of more number of optimized queries because it is using the execution plan tree of the query as a basis of selection of query to be optimized using materialized views rather than choosing query text which is used by traditional methods. For selecting a correct set of queries to be optimized using materialized views, the paper proposes efficient specialized frequent tree component mining algorithm with novel heuristics to prune search space. These frequent components are used to determine the possible set of candidate queries for creation of materialized views. Experimentation on standard, real and synthetic data sets, and also the theoretical basis, proved that the proposed method is able to optimize a large number of queries with less number of materialized views and showed a significant improvement in performance compared to traditional methods

Environmentally Sustainable Supply Chain Practices, Organisation Culture on Firm Performance. A Mediation Approach

Sustainability is increasingly turning into a strategic business project that firms are recognizing that sustainable carry outs can be economical and ought to make fresh income streams as well as enhance client and worker gratification. Despite this, sustainability and performance of firms have received little research attention. Using Natural Resource-Based View and stakeholder theory, research main purpose was to determine the mediating effect of organization culture on the association amid environmentally sustainable supply chain practices and firm performance. This study used descriptive statistics, Pearson product-moment correlation, and Structural Equation Modeling (SEM) to test the hypothesis. Data collected from 281 Kenyan manufacturing firms were used to test study hypotheses. From bias-corrected bootstrapping Structural Equation Modeling, results showed that organization culture variable fully mediates the association amid environmentally maintainable supply chain methods on the performance of manufacturing firms. Thus, the study infers that a strong organizational culture in the organization leads to the enhanced implementation of environmentally sustainable supply chain practices in the organization which in turn increases the performance of manufacturing firms. Without organization culture, these practices may go unheeded and not contribute to improved performance of manufacturing firms in Kenya. Consequently, this study recommends that the managers of these firms should build an organizational culture with environmental concerns in all their processes. This study hence contributes to theory and practice by the inclusion of organizational culture and also extends natural resource-based view and stakeholder theories of a firm

Organization of Technology and Lithic Analysis: Prehistoric Occupation of the Hayes Site (40ML139)

The Hayes Site (40ML139) is located in the central Duck River Basin of Middle Tennessee. Excavations at the site revealed Middle Archaic, late Middle Archaic, and Late Archaic components. An examination of the lithic assemblage from the Hayes Site aids in assessing and building models of hunter-gatherer organization for the central Duck River Basin. An organizational perspective on technology, results from published flintknapping experiments, and a lithic resource survey provide the means of constructing and employing an interpretive framework for understanding prehistoric occupation of the Hayes Site. It was found that materials from the Middle Archaic components represent forager residences and the Late Archaic component represents both forager and collector residences. These findings support the model of hunter-gatherer organization formulated by Amick (1984) for the central Duck River Basin

Conceptual design of an XML FACT repository for dispersed XML document warehouses and XML marts

Since the introduction of eXtensible Markup Language (XML), XML repositories have gained a foothold in many global (and government) organizations, where, e-Commerce and e-business models have maturated in handling daily transactional data among heterogeneous information systems in multi-data formats. Due to this, the amount of data available for enterprise decision-making process is increasing exponentially and are being stored and/or communicated in XML. This presents an interesting challenge to investigate models, frameworks and techniques for organizing and analyzing such voluminous, yet distributed XML documents for business intelligence in the form of XML warehouse repositories and XML marts. In this paper, we address such an issue, where we propose a view-driven approach for modelling and designing of a Global XML FACT (GxFACT) repository under the MDA initiatives. Here we propose the GxFACT using logically grouped, geographically dispersed, XML document warehouses and Document Marts in a global enterprise setting. To deal with organizations? evolving decision-making needs, we also provide three design strategies for building and managing of such GxFACT in the context of modelling of further hierarchical dimensions and/or global document warehouses

An Interview with Franco Modigliani

These are the page proofs of the interview of Franco Modigliani by William A. Barnett and Robert Solow. The interview was published in the journal, Macroeconomic Dynamics, in 2000. Since William Barnett is one of the two interviewers, he now is permitted, by Cambridge University Press, to make the interview available as a 'working paper.' This interview contains some astonishing revelations about the life of Franco Modigliani, beginning with details of the circumstances regarding his move from Italy to France during the Second World War and his subsequent move to the United States.history of economic thought, Modigliani, Solow, macroeconomics, finance