Partial-sum queries in OLAP data cubes using covering codes

A partial-sum query obtains the summation over a set of specified cells of a data cube. We establish a connection between the covering problem in the theory of error-correcting codes and the partial-sum problem and use this connection to devise algorithms for the partial-sum problem with efficient space-time trade-offs. For example, using our algorithms, with 44 percent additional storage, the query response time can be improved by about 12 percent; by roughly doubling the storage requirement, the query response time can be improved by about 34 percent

THE EFFECT OF BANK INDONESIA CERTIFICATES, COMPOSITE STOCK PRICE INDEX AND EXCHANGE RATE ON MUTUAL FUND PERFORMANCE FOR PERIOD OF 2012-2014

The study aims to analyze the effect of Bank Indonesia (SBI) certificates composite stock price index (JCI), and exchange rate partially and simultaneously on the Performance of 10 mutual funds of Dana Investment Management company. The study adopted quantitative approach by using causal survey method. Secondary data were collected from data published by Bank Indonesia, the Indonesia Stock Exchange and Danareksa Investment Management company (Investment Manager) during the period of 2012 - 2014. Path analysis technique was employed to analyse the data. The research findings have shown that: SBI has a direct significant effect on JCI, SBI has a direct significant effect on exchange rate, JCI has a direct significant effect on Rupiah exchange rate. JCI and exchange rate do not have a direct effect on mutual fund performance, whereas SBI has a direct effect on mutual fund performance. SBI, JCI and exchange rate simultaneously affect directly on the performance of the fund. Mutual funds, stocks mixture, money market and fixed income are still stimulating and have potential to gain return as well as they have somewhat good performance. It is concluded that to determine interesting products, it must be in line with its objective and investor’s ability to take risks. Thus, specific strategy is req

A solution to the materialized view selection problem in data warehousing

One of the most important decisions in the physical designing of a data warehouse is the selection of materialized views and indexes to be created. The problem is to select an appropriate set of views and indexes to storage that minimizes the total query response time, as long as the cost of maintaining them, given a constraint of some resource like storage space, is kept as low as possible.In this work, we have developed a new algorithm for the general problem of se-lection of views considering indexes, as an extension to a well-known algorithm. We present a heuristic for selection of views and indexes to optimize total que-ry response under a materialization time constraint. Finally, we present an ex-perimental comparison of our proposal with the considered state-of-art ap-proach.XI Workshop Bases de Datos y Minería de DatosRed de Universidades con Carreras de Informática (RedUNCI

A solution to the materialized view selection problem in data warehousing

One of the most important decisions in the physical designing of a data warehouse is the selection of materialized views and indexes to be created. The problem is to select an appropriate set of views and indexes to storage that minimizes the total query response time, as long as the cost of maintaining them, given a constraint of some resource like storage space, is kept as low as possible.In this work, we have developed a new algorithm for the general problem of se-lection of views considering indexes, as an extension to a well-known algorithm. We present a heuristic for selection of views and indexes to optimize total que-ry response under a materialization time constraint. Finally, we present an ex-perimental comparison of our proposal with the considered state-of-art ap-proach.XI Workshop Bases de Datos y Minería de DatosRed de Universidades con Carreras de Informática (RedUNCI