Logical Representation of a Conceptual Model for Spatial Data Warehouses

The MultiDimER model is a conceptual model used for representing a multidimensional view of data for Data Warehouse (DW) and On-Line Analytical Processing (OLAP) applications. This model includes a spatial extension allowing spatiality in levels, hierarchies, fact relationships, and measures. In this way decision-making users can represent in an abstract manner their analysis needs without considering complex implementation issues and spatial OLAP tools developers can have a common vision for representing spatial data in a multidimensional model. In this paper we propose the transformation of a conceptual schema based on the MultiDimER constructs to an object-relational schema. We based our mapping on the SQL:2003 and SQL/MM standards giving examples of commercial implementation using Oracle 10g with its spatial extension. Further we use spatial integrity constraints to ensure the semantic equivalence of the conceptual and logical schemas. We also show some examples of Oracle spatial functions, including aggregation functions required for the manipulation of spatial data. The described mappings to the object-relational model along with the examples using a commercial system show the feasibility of implementing spatial DWs in current commercial DBMSs. Further, using integrated architectures, where spatial and thematic data is defined within the same DBMS, facilitates the system management simplifying data definition and manipulation.

Direct manipulation of FFD: efficient explicit solutions and decomposible multiple point constraints

Published online: 25 July 2001     

Optimizing multiple dimensional queries simultaneously in multidimensional databases

Some significant progress related to multidimensional data analysis has been achieved in the past few years, including the design of fast algorithms for computing datacubes, selecting some precomputed group-bys to materialize, and designing efficient storage structures for multidimensional data. However, little work has been carried out on multidimensional query optimization issues. Particularly the response time (or evaluation cost) for answering several related dimensional queries simultaneously is crucial to the OLAP applications. Recently, Zhao et al. first exploited this problem by presenting three heuristic algorithms. In this paper we first consider in detail two cases of the problem in which all the queries are either hash-based star joins or index-based star joins only. In the case of the hash-based star join, we devise a polynomial approximation algorithm which delivers a plan whose evaluation cost is $ O(n^{\epsilon }$) times the optimal, where n is the number of queries and is a fixed constant with . We also present an exponential algorithm which delivers a plan with the optimal evaluation cost. In the case of the index-based star join, we present a heuristic algorithm which delivers a plan whose evaluation cost is n times the optimal, and an exponential algorithm which delivers a plan with the optimal evaluation cost. We then consider a general case in which both hash-based star-join and index-based star-join queries are included. For this case, we give a possible improvement on the work of Zhao et al., based on an analysis of their solutions. We also develop another heuristic and an exact algorithm for the problem. We finally conduct a performance study by implementing our algorithms. The experimental results demonstrate that the solutions delivered for the restricted cases are always within two times of the optimal, which confirms our theoretical upper bounds. Actually these experiments produce much better results than our theoretical estimates. To the best of our knowledge, this is the only development of polynomial algorithms for the first two cases which are able to deliver plans with deterministic performance guarantees in terms of the qualities of the plans generated. The previous approaches including that of [ZDNS98] may generate a feasible plan for the problem in these two cases, but they do not provide any performance guarantee, i.e., the plans generated by their algorithms can be arbitrarily far from the optimal one. Received: July 21, 1998 / Accepted: August 26, 1999     

Robust joint modeling of mean and dispersion through trimming

The Maximum Likelihood Estimator (MLE) and Extended Quasi-Likelihood (EQL) estimator have commonly been used to estimate the unknown parameters within the joint modeling of mean and dispersion framework. However, these estimators can be very sensitive to outliers in the data. In order to overcome this disadvantage, the usage of the maximum Trimmed Likelihood Estimator (TLE) and the maximum Extended Trimmed Quasi-Likelihood (ETQL) estimator is recommended to estimate the unknown parameters in a robust way. The superiority of these approaches in comparison with the MLE and EQL estimator is illustrated by an example and a simulation study. As a prominent measure of robustness, the finite sample Breakdown Point (BDP) of these estimators is characterized in this setting.     

基于语义激活的智能图形处理系统

全面分析了目前知识处理系统所存在的弊病,提出了下一代语义激活系统,探讨了新一代知识系统所应提供的服务;并将之运用于图形处理系统,阐明了图形数据从统一表示到有效存储、建模、再现和检索等一系列智能处理过程;进而提出了图形信息的语义表示和智能推理模型.     

矿业软件在矿产储量评价中的应用

矿产储量评价的基本内容是建立矿床地质模型进行品位估计和储量分类分级．地质控制条件限制是矿床建模的重要手段。地质统计学方法是矿块品位估计以及储量分级等的有效方法．国内的应用实例表明。国际先进矿业软件是矿产储量评价的先进工具，应用矿业软件进行矿产储量评价是市场经济的需要。     

过程自动化中系统建模及自适应理论的应用

集过程实时监测、系统建模、优化和控制等各层次功能于一体的工业生产过程自动化成为工业界的关注热点之一．从系统建模入手,分析了数学建模的过程及其在冶金领域的应用,由此引出自适应控制系统在工业领域的应用和发展,以显示了这种方法在流程工业自动化中的良好前景．     

基于三维实体造型技术的机械制图教学体系的思考

针对三维实体设计的特点,分析机械制图课程学习三维实体造型技术的必要性及三维实体造型技术对机械制图教学的影响,指出应以三维实体造型技术构建全新的机械制图课程教学体系.     

The Densification of Cu／Ti System by Spark Plasma Sintering

In order to unclose the dynamics of SPS densification, a special sintering sample (Cul Ti wires compact) was designed. Characters of the shrinkage rates during sintering process and mierostructures of products fabrieated by the spark plasma sintering( SPS ) and hot-press .sintering were investigated. The experimental results reveal that a higher temperature field is formed at the connected area and conductive net of the compact. These high-temperature parts deformed more easily than other parts, which is believed to be the main cause of SPS fast densification, according to a hard-core and soft-hell material model.     

Probe into Key Techniques of Regional-Oriented 3D GIS On the key techniques of 3D GIS used for regional Geological Information System

Regional Geological Information System combines the multi-dimensional and dynamic spatial information into an integrated spatial information system. 3D geological modeling and its preprocessing or post-processing are the most difficult problems for constructing the system. Based on the current 3D GIS technique, some basic problems in establishing the system are discussed in this paper, including 3D spatial data model, 3D geological modeling, and visualization of 3D geological data. A kind of 3D vector data model based on boundary representation for geological object and its topology was developed in order to model and visualize complex geological structures. In addition, some key techniques are pointed out for further study.