Enhancement of a global lake and reservoir database to aid climate studies and resource monitoring utilizing satellite radar altimetry

Here, we describe the expansion and enhancement of a large (surface area ≥100 km²) lake and reservoir database (1.GREALD). These efforts have also resulted in the spin-off of two additional databases, one containing lakes and reservoirs (2.GREALD, area 10–99 km²), and the other containing ephemeral lakes (3.GELD, area ≥100 km²). These databases are unique sources for projects that utilize satellite radar altimeter data to monitor surface water levels. While 1.GREALD aims to be a complete catalog, 2.GREALD focuses on reservoirs in response to applied sciences programs that monitor water and energy resources. The creation of 3.GELD has climate change objectives as well as water resources and ecosystem conservation applications. The recording of information pertaining to the potential overpasses (waterbody crossings) of the current and archive satellite altimeters is a primary objective as is the need to highlight any form of controlled water level variation. The permanent water databases now contain 6282 entries, half experience some form of anthropogenic influence and ～430 have been identified as potential climatically sensitive terminal lakes. The revised integral surface area distribution is a power law with exponent ?1.016. Statistics reveal that with altimetric repeat visit times of 10-day to monthly, at least 80% of the permanent water bodies (≥10 km²) have been overflown at some period since the 1990s. Current information on water use and reservoir formation date show that the primary use of the reservoir class is hydroelectric power, and that China, Brazil, India, Turkey, and Vietnam dominate the dam building in recent decades.     

Rapidly finding CAD features using database optimization

Automatic feature recognition aids downstream processes such as engineering analysis and manufacturing planning. Not all features can be defined in advance; a declarative approach allows engineers to specify new features without having to design algorithms to find them. Naive translation of declarations leads to executable algorithms with high time complexity. Database queries are also expressed declaratively; there is a large literature on optimizing query plans for efficient execution of database queries. Our earlier work investigated applying such technology to feature recognition, using a testbed interfacing a database system (SQLite) to a CAD modeler (CADfix). Feature declarations were translated into SQL queries which are then executed.The current paper extends this approach, using the PostgreSQL database, and provides several new insights: (i) query optimization works quite differently in these two databases, (ii) with care, an approach to query translation can be devised that works well for both databases, and (iii) when finding various simple common features, linear time performance can be achieved with respect to model size, with acceptable times for real industrial models. Further results also show how (i) lazy evaluation can be used to reduce the work performed by the CAD modeler, and (ii) estimating the time taken to compute various geometric operations can further improve the query plan. Experimental results are presented to validate our main conclusions.     

选矿优化控制软件平台的设计与开发

选矿生产作为流程工业的一部分,随着新一代信息技术和人工智能技术的发展,迫切需要一个可以快速部署、功能完善的综合性智能优化控制工业软件为其智能生产提供服务。基于这一需求,从生产应用的实际出发,简要描述了一套选矿智能优化控制软件的设计和实现方法。     

Engineering knowledge formalization and proposition for informatics development towards a CAD-integrated DfX system for product design

Target design methodologies (DfX) were developed to cope with specific engineering design issues such as cost-effectiveness, manufacturability, assemblability, maintainability, among others. However, DfX methodologies are undergoing the lack of real integration with 3D CAD systems. Their principles are currently applied downstream of the 3D modelling by following the well-known rules available from the literature and engineers’ know-how (tacit internal knowledge).This paper provides a method to formalize complex DfX engineering knowledge into explicit knowledge that can be reused for Advanced Engineering Informatics to aid designers and engineers in developing mechanical products. This research work wants to define a general method (ontology) able to couple DfX design guidelines (engineering knowledge) with geometrical product features of a product 3D model (engineering parametric data). A common layer for all DfX methods (horizontal) and dedicated layers for each DfX method (vertical) allow creating the suitable ontology for the systematic collection of the DfX rules considering each target. Moreover, the proposed framework is the first step for developing (future work) a software tool to assist engineers and designers during product development (3D CAD modelling).A design for assembly (DfA) case study shows how to collect assembly rules in the given framework. It demonstrates the applicability of the CAD-integrated DfX system in the mechanical design of a jig-crane. Several benefits are recognized: (i) systematic collection of DfA rules for informatics development, (ii) identification of assembly issues in the product development process, and (iii) reduction of effort and time during the design review.     

A method of constructing an inspiration library driven by user-perceived preference evaluation data for biologically inspired design

Biologically inspired design (BID) is one of the common methods for product design. To solve the problem of inaccurate acquisition of inspirational creatures due to the lack of user perception preference analysis, a data-driven intelligent service model for BID considering user perception needs is proposed based on Kansei engineering. Firstly, by extracting the perceptual features of creatures from the semantic source elements of products through mapping and encodes them, we proposed a data acquisition method based on intuitionistic fuzzy sets considering different customer preference distributions, bridging the gap caused by the asymmetry between designers and users. Secondly, the functional relationship between biometric features and user-perceived attributes is identified and predicted, and a predictive model of biodata considering user preferences is obtained by multiple linear regression analysis. Finally, based on the data clustering and reorganization theory to understand the organization and dynamics of the database, the construction of a BID library was completed, and the design resources in the library were used as analyzed knowledge for designers to plan design activities. Taking the bionic design of a UAV product as an example, a prototype of a computer-aided design service system was developed based on the theory proposed in the article, and the analyzed knowledge was used to improve the efficiency and science of the design, effectively verifying the usefulness of this study for design. To a certain extent, this study addresses the problem of cognitive limitations of designers and cognitive differences between designers and users, promotes the application of bioinspiration in product design, and improves the marketability of design solutions.     

矿山生态治理计算机管理系统(MEIS)软件规划

与传统数据库系统相比，GIS在管理属性数据库时，还包括对空间矢量数据的管理功能，其管理更具有空间概念。本文从矿山实际出发，利用GIS软件工程技术设计带有大量图形信息的露天矿山生态治理管理信息系统，选择结构化分析方法进行了系统定义，提出实用的系统组成。     

地学多源信息数字化在个旧锡矿的应用

随着矿山勘探和开发工作的不断深入，矿山获得了海量多源地学信息，如地质、地球物理、地球化学和遥感等资料，对这些海量地学信息进行保护并以系统的、全面的观点进行“二次开发”获得找矿有利信息，实现综合信息找矿将是目前地学研究的重点和方向。本次研究通过运用现代计算机技术及相应软件在个旧锡矿对多源地学信息进行了数字化和数学处理，并建立了三维可视化的模型，实现了矿山海量地学信息的保护和“二次开发利用”，为矿山深边部的找矿提供了科学的依据。     

现代集成制造系统在平果铝业公司的应用

介绍了平果铝业公司计算机集成制造系统(PGL-CIMS)的体系结构,信息集成方案及主要集成内容。PGL-CIMS的成功实现为大型铝冶炼企业提供了经验。     

基于Oracle数据库的数字矿山管理信息系统

在Geoview平台下，开发了基于Oracle数据库的数字矿山管理信息系统。该数字矿山管理信息系统实现了矿山矿产资源管理可视化、网络化、智能化、体系化。介绍了该管理信息系统的框架结构，描述了Oracle数据库中数据表的设计，阐述了实现数字矿山管理信息系统的重点和难点。