课程文献中心 更多>>

关键词： 数据仓库技术   电视台节目   质量控制   模型分析  

摘要： 近年来随着社会经济不断发展,人们的生活水平不断提高,大众作为电视台节目的主要受众群体,对电视台节目的质量提出了更高要求。为进一步保障电视台节目的播出质量,如何合理应用数据仓库技术实现数据库的搜集、分析和处理是近年来研究的重点。

关键词： 财务监控分析   数据仓库   DW核心数据区   测试用例  

摘要： 财务监控分析是集团公司进行企业治理的重要变量,与集团公司的发展战略高度统一。公司制改革推进过程中财务监控暴露问题诸多,通过商业智能软件系统进行财务监控与分析对于加强集团公司的内部管理和持续经营意义颇大。本文基于久其BI商业智能平台进行集团公司财务监控分析系统的设计,该系统资源整合、查询分析、实时监控、动态预警为一体,并就系统的分析主题功能、安全性、性能、数据正确性等方面进行测试,确保数据监控分析流程的规范性,使集团公司财务管理政策的制定更具针对性与科学性。

关键词： 数据仓库构建   数据抽取   多维分析   报表可视化  

摘要： 为了辅助某汽车销售公司在管理上的科学决策,本文通过需求分析、源数据准备、建模、抽取等步骤构建了一个数据仓库,并开展了多维分析、报表可视化等应用。结果表明,该数据仓库能有效支持该公司的销售分析与决策,也为其他企业同类项目的实施提供了一定的经验参考。

关键词： Quality control   Computational biology/methods*   Information storage and retrieval   Humans   Clinical laboratory information systems   COMPLETENESS  

摘要： Objective: To identify common temporal evolution profiles in biological data and propose a semi-automated method to these patterns in a clinical data warehouse (CDW). Materials and Methods: We leveraged the CDW of the European Hospital Georges Pompidou and tracked the evolution of 192 biological parameters over a period of 17 years (for 445,000 + patients, and 131 million laboratory test results). Results: We identified three common profiles of evolution: discretization, breakpoints, and trends. We developed computational and statistical methods to identify these profiles in the CDW. Overall, of the 192 observed biological parameters (87,814,136 values), 135 presented at least one evolution. We identified breakpoints in 30 distinct parameters, discretizations in 32, and trends in 79. Discussion and conclusion: our method allowed the identification of several temporal events in the data. Considering the distribution over time of these events, we identified probable causes for the observed profiles: instruments or software upgrades and changes in computation formulas. We evaluated the potential impact for data reuse. Finally, we formulated recommendations to enable safe use and sharing of biological data collection to limit the impact of data evolution in retrospective and federated studies (e.g. the annotation of laboratory parameters presenting breakpoints or trends). (C) 2018 Published by Elsevier B.V.

关键词： Data management   Data integration   Data analytics   Research trends  

摘要： This paper introduces to the Information Systems special issue, including the four best papers submitted to DOLAP 2018. Additionally, the 20th anniversary of DOLAP motivated the analysis of DOLAP topics, as follows. First, the recent 5-years DOLAP topics were confronted with those of VLDB, SIGMOD, and ICDE. Next, the DOLAP topics were analyzed within its 20 years of history. Finally, the analysis is concluded with the list of the most frequent research topics of the aforementioned conferences and still open research problems. (C) 2019 Published by Elsevier Ltd.

关键词： Materialized view selection   Coral reefs optimization algorithm   Data warehouse   Multiple view processing plan   Randomized algorithms   EVOLUTIONARY ALGORITHM  

摘要： High response time of analytical queries is one of the most challenging issues of data warehouses. Complicated nature of analytical queries and enormous volume of data are the most important reasons of this high response time. The aim of materialized view selection is to reduce the response time of these analytical queries. For this purpose, the search space is firstly constructed by producing the set of all possible views based on given queries and then, the (semi-) optimal set of materialized views will be selected so that the queries can be answered at the lowest cost using them. Various materialized view selection methods have been proposed in the literature, most of which are randomized methods due to the time-consuming nature of this problem. Randomized view selection methods choose a semi-optimal set of proper views for materialization in an appropriate time using one or a combination of some meta-heuristic(s). In this paper, a novel coral reefs optimization-based method is introduced for materialized view selection in a data warehouse. Coral reefs optimization algorithm is an optimization method that solves problems by simulating the coral behaviors for placement and growth in reefs. In the proposed method, each solution of the problem is considered as a coral, which is always trying to be placed and grow in the reefs. In each step, special operators of the coral reefs optimization algorithm are applied on the solutions. After several steps, better solutions are more likely to survive and grow on the reefs. The best solution is finally chosen as the final solution of the problem. The practical evaluations of the proposed method show that this method offers higher quality solutions than other similar random methods in terms of coverage rate of queries.

关键词： Internet of Things   Big data warehouse   Smart meter   Data ETL   Real-time processing   MULTIWAY ANALYSIS  

摘要： With the emerging of the Internet of Things (IoT) technology, we can analyze and real-time monitoring the power consumption data of buildings or equipment. However, over time, many power data will accumulate to even the terabyte level. Traditional data processing techniques will not handle. It is a challenge to monitor and process the data in a reasonable time. In this paper, we construct an efficient and real-time power monitoring platform, based on open source techniques. The power-data of buildings or equipment is provided through smart meters equipped inside campus buildings. The technologies of data collected and stored on the server side were handled by the Hadoop ecosystem and the data process to Hive data warehouse is executed by the Spark. On the particulars of system evaluation, we make some experiments to compare with the performance of record query, use three different technologies separately: Apache Hive, Apache Spark, and Impala had been evaluated regarding query-response performance. Moreover, for the performance estimation on the data ETL processing and SQL functions. The relevant experiments have been conducted on the same three software modules as well. (C) 2019 Elsevier Inc. All rights reserved.

摘要： Following publication of the original article [1], the authors reported the name of R.J. Baatenburg de Jong was incorrectly tagged in the HTML version of the article.