基于判别分析的数据分析库的设计与实现

判别分析是根据所研究的个体的观测指标来推断该个体所属类型的一种统计方法,对已知分类的数据建立由数值指标构成的分类规则，然后把这样的规则应用到未知分类的样本去分类。该文以判别分析中的线形判别分析和Mahalanobis距离判别分析作理论依据, 提出一种数据分析库的设计和实施方案,该系统在数据分析方面的研究和应用中有一定的特色。

基于数量化II类的数据分析库的设计与实现

数量化II类理论研究的是定性资料的分析,它与判别分析根据所研究的个体的观测指标来推断该个体所属类型的方式不一样。文章以数量化II类作理论依据,采用定性分析与定量分析相结合的方法,提出了一种数据分析库的设计和实施方案,该系统在数据分析和决策支持系统方面的研究和应用中有一定的特色。

基于iFIX的监控系统数据分析库的建立

介绍了在VB环境下分别利用ODBC技术和iFIX的EDA技术访问iFIX实时数据库的方法,在此基础上,将读取的实时数据利用DAO技术写入Access数据库,生成了分析数据库,从而为数据分析提供数据源。

Excel的数据分析教学在高职《计算机文化基础》课中的实践与探讨

针对高职院校计算机文化基础课现状,提出了要重视Excel的数据分析教学的观点。简单扼要介绍Excel的数据分析具体功能和Excel数据分析工具库使用方法及操作过程;并结合具体例子说明如何利用Excel进行统计分析。

GIS技术和数字测绘技术在矿山测量中的应用研究

为了提高矿山地质勘查的精度,减轻地质勘查人员的工作负担,本文在地质勘查技术的基础上,论述了CIS数字地质勘查技术。在此基础上,提出了利用三维GIS技术,构建三维GIS,构建地理信息系统,实现信息的数字化。通过对矿山CIS数字制图技术的研究,提出了矿山CIS数字制图技术的几点建议,提高了矿山地质测量的精度。

Design and development of analytical CRM based on OLAM technology

Some key technologies of actualizing customer relationship management(CRM)systems are researched.The customer analysis mining prototype systems on the basis of on-line analytical mining(OLAM)is designed.After transaction analysis,the data warehouse of CRM is constructed.The CLV/CL/CC customer division model based on customer lifetime value,customer loyalty and customer credit is emphatically researched.Three parameters of customer division—customer lifetime value,customer loyalty and customer credit—are calculated by corresponding algorithms,which can realize customer divisions effectively and improve the accuracy of distinguishing among customers.The data of product sales are analyzed by the sequence association rules algorithm,the potential rules of the products relevance are discovered,which can provide evidence for supporting decisions such as promotion strategies.The transaction data such as product sales volumes and order lists are analyzed on-line through multi-dimensional and multi-level up-drills,down-drills,and horizontal/longitudinal sections.The customer property factors are analyzed as well.The theory and practice of OLAM and its visualization are further explored.

Categorical Database Generalization

This paper focuses on the issues of categorical database gen-eralization and emphasizes the roles ofsupporting data model, integrated datamodel, spatial analysis and semanticanalysis in database generalization.The framework contents of categoricaldatabase generalization transformationare defined. This paper presents an in-tegrated spatial supporting data struc-ture, a semantic supporting model andsimilarity model for the categorical da-tabase generalization. The concept oftransformation unit is proposed in generalization.

VCN & Its Role of Engineering in Human Society

A novel broad concept of numbers was given out based upon the analyzing of numbers′ carrying rule. In international mathematics & computer science, all researches on numbers are only confined to same varying rule of the FCN (fixed carrying numbers). The concept of VCN (variable carrying numbers) was presented, and some applied examples of practice were given out. So the engineering application of VCN for n-figures is wider than that of FCN in human society.

The Generation of Typical Meteorological Year and Climatic Database of Turkey for the Energy Analysis of Buildings

For sustainable development, a reduction in energy demand is essential. This could be achieved through improving energy efficiency, effective energy conservation and management. The weather conditions of a given region are the most important consideration for the proper design of space AC （Air Conditioning） systems. In this study, the typical meteorological year and climatic database of Turkey for the energy analysis of buildings were generated by SQL （Structured Query Language） database programmimg language. The Finkelstein-Schafer statistical method was applied to analyze the hourly measured weather data of a 23-year period （1989-2012） and select representative TMMs （Typical Meteorological Months）. The selection criteria were based on 13 meteorological parameters. These parameters are the daily mean, maximum and minimum values and ranges of temperature, dew-point and wind velocity and the daily values of global solar radiation. According to results of TMY （Typical Meteorological Year）, climatic database of Turkey including daily or hourly climate variables was created in SQL data tables.

Food Additives-Ascorbic Acid Quality Assay Test Intelligent Management

In this paper, based on the analysis and test methods of national standards （GB 14754-2010） and chemical analysis and test items carried out by chemical enterprises, a set of automatic processing of quality analysis test data of ascorbic acid products was developed by using access database technology and Visual Basic programming language system, and its stability was investigated. The results show that the software can manage intelligently all aspects of the quality analysis and test of ascorbic acid products, uploading timely the data and results of the analysis and inspection to the network and saving it for users, enterprises and quality management, which set up a network of information sharing platform to ensure the authenticity and reliability of measurement results, improving greatly the speed of data processing, saving valuable time, reducing production costs with good economic efficiency and social benefit. It has practical value for ascorbic acid quality analysis test data processing automatically the results of the implementation of intelligent management.

Workflow logs analysis system for enterprise performance measurement

Workflow logs that record the execution of business processes offer very valuable data resource for real-time enterprise performance measurement. In this paper, a novel scheme that uses the technology of data warehouse and OLAP to explore workflow logs and create complex analysis reports for enterprise performance measurement is proposed. Three key points of this scheme are studied: 1) the measure set; 2) the open and flexible architecture for workflow logs analysis system; 3) the data models in WFMS and data warehouse. A case study that shows the validity of the scheme is also provided.

Epoch-based Application Collaboration for Sensing Data Analysis

The application collaboration was addressed to provide energy-efficient data services for distributed sensing applications to collaboratively interacting to achieve a desired global objective not detectable by any single cluster. An epoch-based transaction model was proposed by using the concept of sphere of control （SoC）, and a collaborative sensing application can be dynamically formed as a nested architecture composed of time-synchronized applications. By loosening the rigid constraints of ACID to adapt the requirements of sensor networks, the submission, rollback and consistency rules ware educed and a two-phrase submission protocol was designed. Finally, it was illustrated that the model is capable of providing an adaptive formal template for sensing application collaboration. Our performance evaluations show that by applying the two-phrase submission protocol, we can significantly improve the number of reported answers and response time, raise resource utilization, and reduce the energy cansumption and data loss.

Carbon dioxide insufflation for endoscopic retrograde cholangiopancreatography:A meta-analysis and systematic review

AIM:To assess the safety and efficacy of carbon dioxide (CO2) insufflation during endoscopic retrograde cholangiopancreatography (ERCP). METHODS:The Cochrane Library, Medical Literature Analysis and Retrieval System Online, Excerpta Medica Database, Science Citation Index Expanded, Chinese Biomedical Literature Database, and references in relevant publications were searched up to December 2011 to identify randomized controlled trials (RCTs) comparing CO2 insufflation with air insufflation during ERCP. The trials were included in the review irrespec-tive of sample size, publication status, or language. Study selection and data extraction were performed by two independent authors. The meta-analysis was performed using Review Manager 5.1.6. A random-effects model was used to analyze various outcomes.Sensitivity and subgroup analyses were performed if necessary. R ESULTS:Seven double-blind RCTs involving a total of 818 patients were identified that compared CO2 insufflation (n = 404) with air insufflation (n = 401) during ERCP. There were a total of 13 post-random- ization dropouts in four RCTs. Six RCTs had a high risk of bias and one had a low risk of bias. None of the RCTs reported any severe gas-related adverse events in either group. A meta-analysis of 5 RCTs (n = 459) indicated that patients in the CO2 insufflation group had less post-ERCP abdominal pain and distension for at least 1 h compared with patients in the air insuf-flation group. There were no significant differences in mild cardiopulmonary complications [risk ratio (RR) = 0.43, 95% CI:0.07-2.66, P = 0.36], cardiopulmonary (e.g., blood CO2 level) changes [standardized mean difference (SMD) = -0.97, 95% CI: -2.58-0.63, P = 0.23], cost analysis (mean difference = 3.14, 95% CI:-14.57-20.85, P = 0.73), and total procedure time (SMD = -0.05, 95% CI:-0.26-0.17, P = 0.67) between the two groups. C ONCLUSION:CO2 insufflation during ERCP appears to be safe and reduces post-ERCP abdominal pain and discomfort.

The Study of BIM-Based MRT Structural Inspection System

The Taipei MRT （Metropolitan Rapid Transit） system has been operated since 1996. Facing the challenge of safety and sustainability of MRT, it is urgent to develop a structural inspection strategy and maintenance system based on the concept of life cycle management. In the mean while, BIM （Building Information Modeling） has become an emerging technology in the architecture and construction industries. BIM utilizes the 3D （3 Dimensions） CAD objects to simulate the real word building elements and with the ability to maintain life cycle information for a building. BIM is an ideal tool and platform for developing an inspection and maintenance system. The goal of this research is to establish a MRT structural inspection system concept based on BIM and life cycle management. In this study, a BIM model of shield tunnel was established to demonstrate the integration of 3D CAD with inspection records. A MRT structural maintenance database, which includes structural deterioration types, inspection records, and repair methods, was designed to interact with the BIM. An inspection prototype system was designed and implemented to perform the MRT structural inspection. The proposed system was designed with mobile-side and server-side systems. The mobile-side system was designed to perform on mobile devices such as tablet computer or smart phones with the ability to mark defects on BIM, as well as to fill in inspection sheets and photos; the server-side system can assign inspection tasks, maintains all inspection records, automatically output inspection reports, and analyze the database to prioritize all maintenance tasks.

Self-Adaptive Topic Model： A Solution to the Problem of ＂Rich Topics Get Richer＂

The problem of "rich topics get richer"(RTGR) is popular to the topic models,which will bring the wrong topic distribution if the distributing process has not been intervened.In standard LDA(Latent Dirichlet Allocation) model,each word in all the documents has the same statistical ability.In fact,the words have different impact towards different topics.Under the guidance of this thought,we extend ILDA(Infinite LDA) by considering the bias role of words to divide the topics.We propose a self-adaptive topic model to overcome the RTGR problem specifically.The model proposed in this paper is adapted to three questions:(1) the topic number is changeable with the collection of the documents,which is suitable for the dynamic data;(2) the words have discriminating attributes to topic distribution;(3) a selfadaptive method is used to realize the automatic re-sampling.To verify our model,we design a topic evolution analysis system which can realize the following functions:the topic classification in each cycle,the topic correlation in the adjacent cycles and the strength calculation of the sub topics in the order.The experiment both on NIPS corpus and our self-built news collections showed that the system could meet the given demand,the result was feasible.

SOME ISSUES ON URBAN CENSUS GIS DESIGNING

This paper first briefly looks back on the history of census GIS around the world,and then summarizes some preponderances of developing urban census GIS in China.And then a three-tier construction architecture for the urban census GIS is proposed.Finally,using the illustration of the census data of Guangzhou city,the paper analyzes and elaborates some issues on the urban census GIS designing,such as data management,data warehouse building,and data analysis.

A public Cloud-based China's Landslide Inventory Database(Cs LID): development, zone, and spatiotemporal analysis for significant historical events, 1949-2011

Landslide inventory plays an important role in recording landslide events and showing their temporal-spatial distribution. This paper describes the development, visualization, and analysis of a China's Landslide Inventory Database(Cs LID) by utilizing Google's public cloud computing platform. Firstly, Cs LID(Landslide Inventory Database) compiles a total of 1221 historical landslide events spanning the years 1949-2011 from relevant data sources. Secondly, the Cs LID is further broken down into six zones for characterizing landslide cause-effect, spatiotemporal distribution, fatalities, and socioeconomic impacts based on the geological environment and terrain. The results show that among all the six zones, zone V, located in Qinba and Southwest Mountainous Area is the most active landslide hotspot with the highest landslide hazard in China. Additionally, the Google public cloud computing platform enables the Cs LID to be easily accessible, visually interactive, and with the capability of allowing new data input to dynamically augment the database. This work developed a cyber-landslide inventory and used it to analyze the landslide temporal-spatial distribution in China.

Visualizing Data Tree-Table Based on the Database

The data tree table is a type of data structure consisting of data tree and table, which has a wide field of applications. The visual and dynamic growing algorithm of data tree table and its software method are presented based on the theory of the data structure and visual technology of software. The method of the expression and management of data tree table with relational mode are explored.

Research on Multidimensional Data Model in Data Warehouse

Data structure and semantics of the traditional data model cannot effectively represent the data warehouse, it is difficult to effectively support online analytical processing （referred to as OLAP）. This paper is propose a new multidimensional data model based on the partial ordering and mapping. The data model can fully express the complex data structure and semantics of data warehouse, and provide an OLAP operation as the core of the operation of algebra, support structure in levels of complex aggregation operation sequence, which can effectively support the application of OLAE The data model supports the concept of aggregation function constraint, and provides constraint mechanism of the hierarchy aggregation function.