AN APPROACH TO C SOFTWARE REUSE BASED ON DATABASE TECHNIQUES

This paper presents a tool for managing, reusing and analysing C software code based on database techniques. The abstract information of entire software code is stored in a program database that is the conceptual scheme of the entire software, whereas the reuse component is a subscheme. Relational algebra can be conveniently used to manage, analyse and reuse C code. In the tool, we can manage, analyse and reuse any components in the program database and rapidly extract source code of any components or construct the program code of a new system. The rule system is introduced in reusing source code.

A MySQL-Based Software System of Urban Land Planning Database of Shanghai in China

With the development of the digital city,data and data analysis have become more and more important.The database is the foundation of data analysis.In this paper,the software system of the urban land planning database of Shanghai in China is developed based on MySQL.The conceptual model of the urban land planning database is proposed,and the entities,attributes and connections of this model are discussed.Then the E-R conceptual model is transformed into a logical structure,which is supported by the relational databasemanagement system(DBMS).Based on the conceptual and logical structures,by using Spring Boot as the back-end framework and using MySQL and Java API as the development tools,a platformwith datamanagement,information sharing,map assistance and other functions is established.The functionalmodules in this platformare designed.The results of J Meter test show that the DBMS can add,store and retrieve information data stably,and it has the advantages of fast response and low error rate.The software system of the urban land planning database developed in this paper can improve the efficiency of storing and managing land data,eliminating redundant data and sharing data.

On Software Application Database Constraint-driven Design and Development

This paper presents a methodology driven by database constraints for designing and developing(database)software applications.Much needed and with excellent results,this paradigm guarantees the highest possible quality of the managed data.The proposed methodology is illustrated with an easy to understand,yet complex medium-sized genealogy software application driven by more than 200 database constraints,which fully meets such expectations.

Soil Database Management Software Development for Optimizing Land Resource Information Utilization to Support National Food Security

Since land resource database development in 1987/1988, a large amount of digital data in spatial, tabular and metadata format has been collected and generated. There are some application softwares of soil database to manage such a large amount of data, i.e.: Side & Horizon (SHDE4), Soil Sample Analysis (SSA), and Land Unit in dbf file, while Site and Horizon is in DataEase formats. The database contains soil physics and chemical property data of each soil horizon from surface to effective soil depth, climate, land surface condi- tions, and other parameters required for soil classification. Currently, database management software for land resources is still based on DOS and is stand alone. The system is not efficient and effectively used as Agri- cultural Land Resource Information System. At present, as a key component of this system requires review and development of new database software is compatible with the development of information technology. This paper explains about development of interactive agricultural land resources information system for op- timizing land resources data utilization. Hopefully, the software can give contributions in national Agricul- tural Land Resources System Information development for supporting food security.

Correlation-based software search by leveraging software term database

Internet-scale open source software （OSS） pro- duction in various communities generates abundant reusable resources for software developers. However, finding the de- sired and mature software with keyword queries from a considerable number of candidates, especially for the fresher, is a significant challenge because current search services often fail to understand the semantics of user queries. In this paper, we construct a software term database （STDB） by analyzing tagging data in Stack Overflow and propose a correlationbased software search （CBSS） approach that performs correlation retrieval based on the term relevance obtained from STDB. In addition, we design a novel ranking method to optimize the initial retrieval result. We explore four research questions in four experiments, respectively, to evaluate the effectiveness of the STDB and investigate the performance of the CBSS. The experiment results show that the proposed CBSS can effectively respond to keyword-based software searches and significantly outperforms other existing search services at finding mature software.

Analysis software for upper atmospheric data developed by the IUGONET project and its application to polar science

To comprehensively understand the Arctic and Antarctic upper atmosphere, it is often crucial to analyze various data that are obtained from many regions. Infrastructure that promotes such interdisciplinary studies on the upper atmosphere has been developed by a Japanese inter-university project called the Inter-university Upper atmosphere Global Observation Network （1UGONET）. The objective of this paper is to describe the infrastructure and tools developed by IUGONET. We focus on the data analysis software. It is written in Interactive Data Language （IDL） and is a plug-in for the THEMIS Data Analysis Software suite （TDAS）, which is a set of IDL libraries used to visualize and analyze satellite- and ground-based data. We present plots of upper atmospheric data provided by IUGONET as examples of applications, and verify the usefulness of the software in the study of polar science. We discuss IUGONET＇s new and unique developments, i.e., an executable file of TDAS that can run on the IDL Virtual Machine, IDL routines to retrieve metadata from the IUGONET database, and an archive of 3-D simulation data that uses the Common Data Format so that it can easily be used with TDAS.

Construction of life cycle assessment software system platform

There has not been life cycle assessment (LCA) software applicable to China's products. To faciliate the development of LCA software system in China, we built an object-oriented LCA software system plantform based on LCA international standards ISO 14040 to ISO 14043 and the commonness of diverse products. The system includes six modules: disassembly module, data collection module, arithmetic module, drawing module, database module and control module. It evaluates all economic and environmental impacts during the whole life cycle of a product. The integrated life cycle inventory database system allows dynamic expansion, which makes the effort required for data collection reduce with the increase of the system's application. With the improvement of human environmental-awareness, the demand of environment-friendly products is increasing, and ecological design of products has become a critical part in products development. Consummation of the LCA software system will provide a powerful tool for designing and developing Chinese ecological products.

Design and realization of the drawing software for snow/ice stratigraphic profile

Snow/ice stratigraphic profile is one of the traditional and important research fields in glaciology. The profile drawn by hand, however, is a tough job. Using the Object Oriented Programming (OOP) Visual Basic (VB), we developed a Drawing Software for Snow/Ice Stratigraphic Profile (DSSISP). This paper introduces the functions, designing process and realizing methods of the drawing software. It presents the key techniques and aspects that should be payed attention to during the software development. Moreover, it also proposes the ideas for complete development of this drawing system. Legend database is a key aspect in the software designing. The major functions of the software include the stratigraphic profile drawing, edition and data management, which can help researchers draw the stratigraphic profile (including the scale, stratigraphic figure, text note and legend) quickly in a computer. In addition, the database technique is used to manage drawing data, which makes the figure drawing convenient and efficient. The drawing data is also convenient to be preserved, exchanged, processed and used.

A Domain Engineering Approach to Increase Productivity in the Development of a Service for Changes Notification of the Configuration Management Database

This paper presents a domain engineering approach to build a software product line that supports the change notification service in a Configuration Management Database (CMDB) according to the Information Technology Infrastructure Library (ITIL) best practices. For the development of this product line, the proposed approach makes use of a construction of products methodology by analogy: this is a new notation which reports the variability of the products, obtaining metrics as important as the number of products and uses a language that enables, by means of the flexibilization of a product and the development of some generators, to build the rest of the product line. In addition the paper offers a standard for the analysis and design of the CMDB as well. Finally, the paper presents an economic model for the product line, where the profitability and productivity of the proposed solution are analyzed.

A Two-folded Impact Analysis of Schema Changes on Database Applications

Database applications are becoming increasingly popular, mainly due to the advanced data management facilities that the underlying database management system offers compared against traditional legacy software applications. The interaction, however, of such applications with the database system introduces a number of issues, among which, this paper addresses the impact analysis of the changes performed at the database schema level. Our motivation is to provide the software engineers of database applications with automated methods that facilitate major maintenance tasks, such as source code corrections and regression testing, which should be triggered by the occurrence of such changes. The presented impact analysis is thus two-folded： the impact is analysed in terms of both the affected source code statements and the affected test suites concerning the testing of these applications. To achieve the former objective, a program slicing technique is employed, which is based on an extended version of the program dependency graph. The latter objective requires the analysis of test suites generated for database applications, which is accomplished by employing testing techniques tailored for this type of applications. Utilising both the slicing and the testing techniques enhances program comprehension of database applications, while also supporting the development of a number of practical metrics regarding their maintainability against schema changes. To evaluate the feasibility and effectiveness of the presented techniques and metrics, a software tool, called DATA, has been implemented. The experimental results from its usage on the TPC-C case study are reported and analysed.

Software Vulnerabilities Overview:A Descriptive Study

Computer security is a matter of great interest.In the last decade there have been numerous cases of cybercrime based on the exploitation of software vulnerabilities.This fact has generated a great social concern and a greater importance of computer security as a discipline.In this work,the most important vulnerabilities of recent years are identified,classified,and categorized individually.A measure of the impact of each vulnerability is used to carry out this classification,considering the number of products affected by each vulnerability,as well as its severity.In addition,the categories of vulnerabilities that have the greatest presence are identified.Based on the results obtained in this study,we can understand the consequences of the most common vulnerabilities,which software products are affected,how to counteract these vulnerabilities,and what their current trend is.

Development and application of software packages in welding engineering

The weldabiUty of some material is analyzed with simple calculating program in this paper, and weldability testing data are shared through database system. The welding procedures are designed with help of expert systems, and the knowledge is shared among welding engineers. Not only the preparing progress of the welding documents is completed with database systems but also the complex decision on the necessity of the qualification test according to the present procedure qualification records （PQRs） and manufacture codes is made. Moreover, the artificial neural network （ANN） technique is proven to be one of the effective ways to predict mechanical properties of welded joints when there are enough tested data to train the models. Finally, the achievements in modeling microstructure of welded joints are introduced, especially in solid transformation and grain growth in both heat-affected zone （HAZ） and welded molten pool.

Towards Connecting Discrete Mathematics and Software Engineering

To enhance training in software development,we argue that students of software engineering should be exposed to software development activities early in the curriculum.This entails meeting the challenge of engaging students in software development before they take the software engineering course.In this paper,we propose a method to connect courses in the software engineering curriculum by setting comprehensive development projects to students in prerequisite courses for software development.Using the Discrete Mathematics(DM)course as an example,we describe the implementation of the proposed method and teaching practices using several practical and comprehensive projects derived from topics in discrete mathematics.Detailed descriptions of the sample projects,their application,and training results are given.Results and lessons learned from applying these practices show that it is a promising way to connect courses in the software engineering curriculum.

Data Comparison and Software Design for Easy Selection and Application of CRISPR-based Genome Editing Systems in Plants

CRISPR-based genome editing systems have been successfully and effectively used in many organisms.However,only a few studies have reported the comparison between CRISPR/Cas9 and CRISPR/Cpf1 systems in the whole-genome applications.Although many web-based toolkits are available,there is still a shortage of comprehensive,user-friendly,and plant-specific CRISPR databases and desktop software.In this study,we identified and analyzed the similarities and differences between CRISPR/Cas9 and CRISPR/Cpf1 systems by considering the abundance of proto-spacer adjacent motif(PAM)sites,the effects of GC content,optimal proto-spacer length,potential universality within the plant kingdom,PAM-rich region(PARR)inhibiting ratio,and the effects of G-quadruplex(G-Q)structures.Using this information,we built a comprehensive CRISPR database(including 138 plant genome data sources,www.grapeworld.cn/pc/index.html),which provides search tools for the identification of CRISPR editing sites in both CRISPR/Cas9 and CRISPR/Cpf1 systems.We also developed a desktop software on the basis of the Perl/Tk tool,which facilitates and improves the detection and analysis of CRISPR editing sites at the whole-genome level on Linux and/or Windows platform.Therefore,this study provides helpful data and software for easy selection and application of CRISPR-based genome editing systems in plants.

Open life science research,open software and the open century

At the age of knowledge explosion and mass scientific information,I highlighted the importance of conducting open science in life and medical researches through the extensive usage of open software and documents.The proposal of conducting open science is to reduce the limited repeatability of researches in life science.I outlined the essential steps for conducting open life science and the necessary standards for creating,reusing and reproducing open materials.Different Creative Commons licenses were presented and compared of their usage scope and restriction.As a conclusion,I argued that open materials should be widely adopted in doing life and medical researches.

Information schema constructs for defining warehouse databases of genotypes and phenotypes of system manifestation features

Our long-term objective is to develop a software toolbox for pre-embodiment design of complex and heterogeneous systems, such as cyber-physical systems. The novelty of this toolbox is that it uses system manifestation features(SMFs) for transdisciplinary modeling of these systems. The main challenges of implementation of the toolbox are functional design- and language-independent computational realization of the warehouses, and systematic development and management of the various evolving implements of SMFs(genotypes, phenotypes, and instances). Therefore, an information schema construct(ISC) based approach is proposed to create the schemata of the associated warehouse databases and the above-mentioned SMF implements. ISCs logically arrange the data contents of SMFs in a set of relational tables of varying semantics. In this article we present the ISCs necessary for creation of genotypes and phenotypes. They increase the efficiency of the database development process and make the data relationships transparent. Our follow-up research focuses on the elaboration of the SMF instances based system modeling methodology.

肝癌热消融的研究热点和趋势可视化分析

目的探讨肝癌热消融治疗的研究现状、合作情况、热点及发展趋势。方法检索Web of Science核心合集数据库,利用CiteSpace软件对近年来核心文献完成文献可视化分析。结果共纳入1385篇核心合集,中国是发文量最多的国家。Bruix等发表的文献被引次数最多。关键词有射频消融术、微波消融术、经皮乙醇注射、免疫治疗、融合成像等。形成6个聚类,15个突现词。结论肝癌热消融一直是肝癌治疗的研究热点,逐步走向成熟,并不断联合影像技术和其他治疗方法应用,在肝癌治疗中发挥重要作用。

剑桥晶体数据库和钻石晶体软件在药物化学教学中的应用

药物结构的掌握之于药物化学的学习是切入点、立足点与主攻点,但由于药物分子往往具有复杂的结构又或是教材受限于二维平面不利于展示药物分子的三维空间结构,导致学生对教材中的有关描述不甚理解,阻碍了后续学习的脚步。本课程组拟借助计算机技术,通过对剑桥晶体数据库(Cambridge structural database,CSD)和钻石(Diamond)晶体学软件的使用,凭借其高度立体化、可视化和动态化的特点,将药物分子结构全方位、无死角地呈现在学生的面前,使原本抽象晦涩的结构描述得以形象化,有助于学生对复杂药物结构的理解与掌握,以此疏通药物结构教与学中长期存在的堵点,进而提升教学质量。文章列举了2例CSD与Diamond软件相结合应用于药物化学教学中的案例,并详细地介绍了案例具体实施过程,为其在药物化学课程中的应用提供了可借鉴的经验。

地热井用潜水泵选型应用软件研究与开发

针对地热井用潜水泵选型效率低、校核工况点计算成本过大等问题,借助计算机辅助选型技术,采用Python作为编程语言,PyQt构建图形化用户界面,MySQL作为选型数据库系统,基于Windows系统开发了地热井用潜水泵选型应用软件。该软件一方面根据潜水泵产品属性,建立了样本数据库模块;依据潜水泵现场运行数据和管路阻力曲线,以最高效率下降5%为界,建立了高效数据库模块;基于样本数据库和高效数据库构建潜水泵初选系统,筛选出满足现场作业要求并且在高效区间内运行的初选泵型号;基于地热井用潜水泵的性能参数、经济成本、运维费用和耐久性,采用熵权TOPSIS法建立潜水泵效能评价体系,对各初选泵方案进行优劣排序,最后高效简便地为用户提供最优潜水泵型号;另一方面基于高效区间数据库建立了潜水泵运行工况反馈模块,根据泵型号对应转速下的运行参数,反馈潜水泵运行状态,非高效运行时根据相似定律和调速区间给出合理的转速范围。

计算机软件开发中Java编程语言的应用研究

Java编程语言作为一种易学易用、语法简单的编程语言,近年深受计算机软件开发者的喜爱,成为一种主流的编程语言工具,并在计算机软件开发领域展现出其显著优势,帮助开发者解决了许多软件开发难题。基于Java编程语言的优势特征,进一步阐述了计算机软件开发对Java编程语言的需求,进而详细探讨了计算机软件开发中Java编程语言的应用。