Selection strategy of materialized views in data warehouse

为了提高决策支持和OLAP查询的响应效率,数据仓库多采用物化视图的思想。因此,物化视图的选择策略是数据仓库研究的重要问题之一。其目标是选出一组存储、维护代价与查询代价的总和为最小的物化视图。提出一个以MVPP(mul-ti-view processing plan)为视图选择的搜索空间的物化视图选择新算法——VSMF(views selection base on multi-factor)算法。该算法在存储空间约束下同时实现多查询最优化和视图维护最优化。A set of materialized views are stored in the data warehouse for the purpose of efficiently implementing decision-support or OLAP queries.The selection of materialized views is one of the most important issues in the data warehouse development.The goal is to select an appropriate set of views so that the total cost of storage,maintenance and query is minimized.A new algorithm named VSMF(views selection base on multi-factor) algorithm using multi-view processing plan structure as search space is proposed,which solve the problem considering both multi-query optimization and the maintenance process optimization under the storage space constrain.福建省自然科学基金项目(A0310008);; 福建省重点科技基金项目(2003H043

中国宗教思想研究的新进展——《中国宗教思想通论》平议

《中国宗教思想通论》是中国宗教思想研究领域的最新力作,是四川大学道教与宗教文化研究所詹石窗教授主持的国家社会科学基金项目“中国宗教思想的历史发展研究“的最终研究成果,该著共63万字,2010年入选“国家社会科学基金优秀成果文库“,2011年3月由人民出版社出版

Assessment for Quality of Life of adult rural Lao residents using WHOQOL-BREF

　WHO が作成し、世界の40 カ国以上で翻訳され、広く使用されているWHOQOL- BREF（26 項目版）のうち、タイ語版を参考にして、WHOQOL-BREF のラオス語版を作成した。この質問表を用いて、2005 年9 月にラオス国、サバナケット県、ラハナム地域の5 村落に在住する成人を対象として、健康診断受診者の中から226 名（男性98 名、女性126 名；平均年齢28.0 歳（15 歳～ 47 歳））をランダムに抽出し、WHOQOL-BREF ラオス語版を用いて、面接聞き取り法によるQOL(Quality of Life) 調査を実施した。同時に、QOL に関連すると思われる、喫煙、飲酒などの生活習慣、現病歴、保健行動、精神活動などについて聞き取り、QOL との関連性について検討した。その結果、QOL の上昇に関連する要因として、高学歴であること、経済力が豊かであること、病気や体の具合がよいこと、幸せと感じていること、お寺参りを頻回にしていることなどが明らかとなった。さらに、以前に我々が、WHOQOL-BREF 日本語版を用いて、日本人に実施した結果と比較したところ、本研究の対象者は、日本人とほぼ同程度の身体的、環境的QOL と、より高い心理的、社会的、包括的QOL を持つことが推測された。今回の検討によって、QOL とその関連する要因間にいくつかの整合性を認め、また解釈可能な結果が得られたことより、ラオス語版QOL のある程度の妥当性が得られたと考えられる。しかしながら、さらに適切なQOL の調査項目の設定のためには、個別なインタビューなどを実施して詳細な情報を収集する必要があると考えられた。The WHOQOL-BREF containing 26 items was developed for cross-cultural comparison of QOL relevant to global well-being, and is available in more than 40 languages. In this study, we developed the Lao version of the WHOQOL-BREF and tested it on rural Lao residents and examined the relationship between QOL and their lifestyle characteristics. We randomly selected 224 subjects (98 men and 126 women, mean age: 28.0, range　15 to 47 yrs), and executed face-to-face interviews using the WHOQOL -BREF questionnaire and its related factors such as life-styles and health behaviors.Three of 5 QOL sub-scores (physical, psychological and conclusive QOL) showed higher scores as the peoples’ education level become higher. People who have higher economic status showed higher QOL. As for the past and present illness, people who got sick within a month showed lower physical, psychological and conclusive QOL scores. Also, people who feel any discomfort show lower physical and conclusive QOL scores than those without any feeling of discomfort. As for happiness, people who have higher happiness showed higher QOL sub scores except for environment QOL than those who have feeling of lower happiness. About religious behaviors, people who visit the temple many times showed higher psychological QOL scores than those who only go to the temple infrequently, which suggests that spiritual feelings or behaviors may improve psychological well-being. In comparison with our previous data of Japanese healthy community dwellers, QOL sub-scores of the rural Lao residents showed relatively higher psychological, social and conclusive QOL scores, and also showed similar physical and environmental QOL scores. From examining the relationship between QOL scores and its related factors, we found several reasonable and understandable findings. So, we developed a Lao version of WHOQOL-BREF which may be useful. In order to make a better QOL questionnaire, we need to execute face-to-face interviews to gather detailed information about really important things for the well-being of Lao residents

应用ODS 技术解决电子政务系统数据一致性问题

讨论了ODS 技术在电子政务系统中的应用. 将ODS 引入到电子政务系统中形成更为合理的DB2ODS2DW3 层结构,并通过ODS 记录系统和参考表的使用进行全局联机事务处理,使各业务数据库内容可以实时更新,保持数 据的一致性. 从根本上解决密切相关的业务数据库数据不一致的问题

Updating Algorithm for Association Rules Based on Fully Mining Incremental Transactions

目前已提出了许多快速的关联规则增量更新挖掘算法,但是它们在处理对新增事务敏感的问题时,往往会丢失一些重要规则。为此,文章提出了一种新的挖掘增量更新后的数据库中频繁项集的算法EUFIA(Entirety Update Frequent Itemsets Algorithm),该算法先对新增事务数据分区,然后快速扫描各分区,能全面有效地挖掘出其中的频繁项集,且不丢失重要规则。同时,最多只扫描1次原数据库也能获得更新后事务数据库的全局频繁项集。研究表明,该算法具有很好的可测量性。Incremental Association rules Mining is an important content of data mining technology.This study proposes a new algorithm,called the Entirety Update Frequent Itemsets Algorithm(EUFIA)for efficiently incrementally mining association rules from large transaction database.Rather than rescanning the original database for some new generated frequent itemsets,EUFIA partitions the incremental database logically according to unit time interval,then accumulates the occurrence counts of new generated frequent itemsets and deletes infrequent itemsets obviously by backward method.Thus,EUFIA can discover newly generated frequent itemsets more efficiently and need rescan the original database only once to get overall frequent itemsets in the final database if necessary.EUFIA has good scalability in our simulation.国家自然科学基金项目(50474033);; 福建省自然科学基金项目(A0310008);; 福建省高新技术研究开放计划重点项目(2003H043

球烯配合物的研究进展

以C60为代表的球烯与球烯类的化合物是近年来化学、物理和材料等学科领域的研究热点，本文综述了三类球烯配合物的合成、结构与性能，着重介绍其最新研究进展。国家自然科学基

Research on the Mind and Body Reactions of Participants in Forest Therapy and Nordic Walking : The Reactions of Senior Citizens

Journal Article森林セラピーに参加したシルバー世代（60歳以上）の者は、唾液アミラーゼ活性値が森林セラピー実施前と比べて低下したことから、参加者の交感神経が沈静化したと考えられた。またPOMS(Profile of Mood States)（短縮版）を用いた分析からも心身のリラックス反応が認められた。一方、ノルディックウォーキングに参加した別のシルバー世代の者は、POMSの分析から森林セラピーと同様な心身のリラックス反応が認められた。しかし、唾液アミラーゼ活性値の上昇がみられ、交感神経優位の反応が認められた。このことから森林セラピー基地の自然豊かな環境がシルバー世代の者の気分によい影響を与えたが、運動の要素の強いノルディックウォーキングは身体への負荷による新たなストレスを発生させる可能性があり、年齢相応の運動量と個人の運動習慣に合わせたきめ細かな対応が求められることを示した。Considering the fact that the salivary amylase activity showed a decrease after forest therapy compared to before the therapy, it is believed that the sympathetic nerves have calmed in the aged who participated (age, ＞__－60) in the forest therapy. Furthermore, physical and mental relaxation responses were observed in the analysis using profile of mood states (POMS). Using POMS, we also observed similar responses in aged people who participated in Nordic Walking. However, an increase was observed in the amylase activity along with a sympathetic dominance response. Therefore, forest therapy, which is based on a nature-rich environment, had a positive influence on the mood of the elderly; however, with Nordic Walking, the element of exercise is strong, and thus there is a possibility of causing a new stress due to load on the body, indicating that there is a need for a finely-tuned response that is tailored to an age-appropriate amount of exercise and to the individual's exercise habits.原著論文journal articl