Structure design and establishment of database application system for alien species in Shandong Province,China

This paper presents a case study on structure design and establishment of database application system for alien species in Shan-dong Province, integrating with Geographic Information System, computer network, and database technology to the research of alien species. The modules of alien species database, including classified data input, statistics and analysis, species pictures and distribution maps, and out date input, were approached by Visual Studio.net 2003 and Microsoft SQL server 2000. The alien species information contains the information of classification, species distinction characteristics, biological characteristics, original area, distribution area, the entering fashion and route, invasion time, invasion reason, interaction with the endemic species, growth state, danger state and spatial information, i.e. distribution map. Based on the above bases, several models including application, checking, modifying, printing, adding and returning mod- els were developed. Furthermore, through the establishment of index tables and index maps, we can also spatially query the data like picture, text and GIS map data. This research established the technological platform of sharing information about scientific resource of alien species in Shandong Province, offering the basis for the dynamic inquiry of alien species, the warning technology of prevention and the fast reaction system. The database application system possessed the principles of good practicability, friendly user interface and convenient usage. It can supply full and accurate information inquiry services of alien species for the users and provide functions of dynamically managing the database for the administrator.

Combinatorial Design of Some Database Application Technologies Based on B/S

Evolving From principal-subordinate structure of C /S to flexible multileveled distributed structure, i.e. B/S architecture so as to form a wide, distributed and orderly Internet/Intranet integrated management inf ormation system, is the trend of development of application software of the whol e world. Advantages and disadvantages of the two modes: C/S and B/S are compared . It is pointed out that at present onefold B/S mode cannot yet fully fullfil th e demands of some complicated data processing, information statistics and analys is, etc, therefore it still awaits further development of technology to achieve 100% Internet. In this paper, a mode of B/S-C/S-blended multileveled architect ure is discussed; the logical levels of B/S mode is studied; Furthermore, combin ing some up-to-date software developing technology, combinatorial design of di fferent database application technology based on B/S is discussed. The expatiati on is made with following points: (1) Organic combination of the network distrib uted object technology of CORBA and the computation technology among different n etwork operating system ─ Java; (2) Organic combination of two modes of ASP and Plug_in; (3) JDBC Server and JDBC Client; (4) An expanded B/S model, i.e. the c lient application of browser communicates directly with Web server, and the serv er application communicates directly with database server through middle ware.

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.

基于Oracle和Geodatabase的福建省基础地理信息数据库建设

以福建省基础地理信息数据库的建设为例,分析了基础测绘数据的特点及建库要求,介绍了基于Oracle和Geodatabase数据库建库的技术路线,并对数据库的结构设置,数据组织及数据的数学基础等问题进行了探讨。

IMAGE DATABASE FOR PATTERN DESIGN SYSTEM

This paper discusses a pattern design system in textile industry,the establishment of an imagedatabase which is used to store various kinds of source materials for designers’ reference in order tospeed up design process.Pattern design image database (PDIDB) runs on the double-machine hardware system com-posed of ALTOS-986 and IBM PC/XT microcomputer.The former (host) manages imagedatabase,and the latter works both as a terminal to operate PDIDB and as an image processingstation to input,output,edit and display image data.PDIDB has two mainparts,the image storage management system and the image attributemanagement system and provides some functions,such as retrieval,deleting and updating.

Protein-protein interactions: Methods, databases, and applications in virus-host study

Almost all the cellular processes in a living system are controlled by proteins:They regulate gene expression,catalyze chemical reactions,transport small molecules across membranes,and transmit signal across membranes.Even,a viral infection is often initiated through virus-host protein interactions.Protein-protein interactions(PPIs)are the physical contacts between two or more proteins and they represent complex biological functions.Nowadays,PPIs have been used to construct PPI networks to study complex pathways for revealing the functions of unknown proteins.Scientists have used PPIs to find the molecular basis of certain diseases and also some potential drug targets.In this review,we will discuss how PPI networks are essential to understand the molecular basis of virus-host relationships and several databases which are dedicated to virus-host interaction studies.Here,we present a short but comprehensive review on PPIs,including the experimental and computational methods of finding PPIs,the databases dedicated to virus-host PPIs,and the associated various applications in protein interaction networks of some lethal viruses with their hosts.

Development Method of Wireless Application Based on Wireless Makeup Language and Web Database Technology

Wireless technology is a new emerging delivery networks and development scheme of wireless internet is given widely attention currently. In order to make international visitors to surge education website at any time, anywhere by mobile handsets. The communication method of web database, such as CGI, ISAPI, JDBC and so on have been aralyzed and a new Active Server Page &Wireless Makeup Language (ASP-WML) based approach is presented. The dynamical refreshment of the homepage of wireless website and the automatic query of main information have been realized. At last, the wireless website of Dong Hua University is taken as an example to testify the possibility of wireless website design which is mentioned above.

Research and Practice on Security Protection and Disaster Recovery Strategy of Oracle Database in Colleges and Universities

Database security protection, database backup and disaster recovery are important tasks for all colleges and universities to ensure the safe and stable operation of information systems. Based on the operating environment of the Oracle production database in China University of Geosciences (Beijing), combined with the practical operation and maintenance experience, this paper provides a design and implementation case of Oracle database security protection system and disaster recovery architecture. The network security protection architecture of the three-layer firewall and fortress machine, the detection and repair of security vulnerabilities, the management of system accounts and permissions, data encryption and database audit constitute the security protection system of the database. Oracle RAC (Real Application Clusters), Oracle DataGuard, redundant backup management and backup recovery constitute the disaster recovery architecture of the database. The case has practical significance for database operation and maintenance management in other colleges and universities.

甲骨文推出数据库安全产品Oracle Database Vault

日前，甲骨文公司在美国“协作06用户大会”上宣布推出Oracle Database Vault。该新产品以甲骨文公司25年的数据保护经验为基础，是业界先进的数据库安全产品，可保护和限制对敏感数据及应用的访问。Oracle Database Vault加强了预防控制能力，可限制数据库管理员等拥有较高权限的用户未经授权访问特定信息，帮助企业满足各项法规要求。

基于Geodatabase的基础地理信息数据库集成应用框架

探讨了专项地理信息数据库的集成方式,开发了地理信息数据库管理系统集成框架程序。通过应用实践证明,该框架可有效解决各专项测绘成果分别建库和管理带来的各种问题,推动各数据库的集成应用。

Cache-Conscious Index Mechanism for Main-Memory Databases

最近的研究探讨了缓存行为在主要存储器索引结构的设计是重要的。象 CSB~+ 树那样的缓存有意识的索引被显示超过象 AVL 树和 T 树那样的常规主要记忆索引。这篇论文建议 T 树的一个缓存有意识的版本， CST 树，根据 cache-consciousdefinition 定义。为了在一个节点以内把钥匙分开成二，分开， CST 树能更高增加缓存点击比率。

使用Oracle Web Application Server开发Web数据库系统

本文先对当前几种流行的Ｗｅｂ数据库技术进行了分析，然后介绍了Ｏｒａｃｌｅ Ｗｅｂ Ａｐｐｌｉｃａｔｉｏｎ Ｓｅｒｖｅｒ对于Ｗｅｂ数据库的解决方案，并以一个实例描述了使用Ｏｒａｃｌｅ Ｗｅｂ Ａｐｐｌｉｃａｔｉｏｎ Ｓｅｒｖｅｒ构建动态页面的过程。

Digital Evidence for Database Tamper Detection

Most secure database is the one you know the most. Tamper detection compares the past and present status of the system and produces digital evidence for forensic analysis. Our focus is on different methods or identification of different locations in an oracle database for collecting the digital evidence for database tamper detection. Starting with the basics of oracle architecture, continuing with the basic steps of forensic analysis the paper elaborates the extraction of suspicious locations in oracle. As a forensic examiner, collecting digital evidence in a database is a key factor. Planned and a modelled way of examination will lead to a valid detection. Based on the literature survey conducted on different aspects of collecting digital evidence for database tamper detection, the paper proposes a block diagram which may guide a database forensic examiner to obtain the evidences.

Oracle Web Application Server在教材管理系统中的应用

本文对当前几种流行的Web数据库技术进行了分析 ,介绍了OracleWebApplicationServer的Web数据库解决方案 。

基于遗传算法的医院Oracle数据库容灾备份方法

常规的医院Oracle数据库容灾备份方法数据恢复时间过长,因此设计一种全新的医院Oracle数据库容灾备份方法。先以成本和时间有效的容灾系统模型体系(Cost and Time Effective Disaster Recovery System,ETDRS)为基础,结合遗传算法选取了有效的Oracle容灾备份编码例子,再根据智能合约构建了有效的数据库容灾备份平台,从而实现了Oracle数据库容灾备份。实验结果表明,设计方法在不同数量数据块下的数据恢复时间均较短,备份效果较好,有一定的应用价值。

Windows Oracle 10g到Linux Oracle19c RAC的升级实现

目的探讨Oracle数据库系统跨版本跨平台升级实现的可行性方案。方法从制订方案、方案实施、数据验证方面,详细介绍了Oracle数据库升级的具体实施方法与技术要点。结果实现Oracle数据库从10g for Windows到19c RAC for Linux的跨多版本系统升级,系统稳定运行。结论采用数据泵(expdp/im‐pdp)工具,通过建立中间库的方式升级,安全可靠,可操作性强,对相同功能需求具有参考借鉴价值。