网格环境下的数据库系统

目前网格上的各类应用系统几乎郝是使用文件来保存数据，因此人们对如何将数据库系统集成入网格这个问题研完甚少。如果网格要在将来支持更大范围的应用系统，那么必须要解决将数据库系统集成入网格这个问题。本文在分析网格环境对数据库系统的需求的基础上，总结了将数据库系统集成入网格的两种方法，并分别对它们做出评价。

基于交通路网的移动对象数据库系统的研究和设计

给出了在PostgreSQL基础上的基于交通路网的移动对象数据库系统的设计方案,系统地介绍了其体系架构、扩展的数据类型和操作以及代理中间层的功能设计.该系统为进一步研究移动对象更新算法以及移动对象数据索引提供了基础.

面向实时应用的时态数据库系统体系结构

提出了面向实时应用的时态数据库系统Agilor-TDB,详细介绍了系统的体系结构。针对实时应用,实现了实时任务调度。在数据存储方面介绍了基于时间区间的多级文件索引结构和高效的内存数据管理机制;在数据查询方面提出了高速查询缓存优化策略。此外,用PN模型对系统并发控制进行了详细描述。

生态研究数据库系统的设计与开发

列表类型数据是生态研究中最为常见的数据形式。在分析列表类型数据特征及其与元数据关系,数据安全和共享策略等问题基础上,提出了生态研究列表类数据管理系统设计和开发方案。研究认为数据集的元数据不仅是对数据集实体的说明,而且一定程度上决定着数据集实体的内容和数量,以及数据集实体之间的内在联系,这种联系正是进行列表类型数据管理依据所在。

HIRFL控制系统数据库系统设计

HIRFL（兰州重离子加速器）是我国第一个大型重离子物理研究装置。HIRFL控制系统是保证HIRFL系统正常高效运转的重要环节。本文利用数据库技术、网络技术设计了HIRFL控制系统数据库系统，实现了在网络环境中只使用一个应用程序就可对整个HIRFL系统控制进行控制的要求。论文首先介绍了数据库系统理论，然后对软件设计涉及的各部分基础知识进行了阐述，最后详细讨论了整个数据库系统设计中的数据库设计、应用程序人机界面设计等部分。数据库应用SQL Server 2000大型数据库，并使用ODBC技术作为数据库访问手段；人机界面部分使用面向对象编程技术进行Windows编程。整个论文工作在建立了一个包含整个控制系统各部分设备信息的数据库的同时，还提供了一套包含所有基本控制功能的HIRFL分布式控制软件，为HIRPL控制系统数据库系统的进一步完善提供了二次开发平台。

时态数据库系统的设计与实现

随着信息社会各个领域的发展，数据的采集和存储变得越来越重要。传统的数据库技术由于缺乏对时序关系的支持，不能有效地管理与时间相关的数据。时态关系模型的提出拓展了传统的关系模型，对时序关系提供了很好的支持。越来越多的应用需要数据库系统能够有效地存储海量数据并且具有高效的存储结构和良好的查询性能。本文以该目标为出发点，设计并实现了AgiTDB时态数据库系统，并在企业中进行了应用验证，取得了较好的效果。 论文的主要工作如下： 1. 分析了当前时态数据库研究现状，总结了应用中存在的问题；针对当前时态数据库存储和查询性能的不足，设计了AgiTDB的体系结构，给出了该体系结构的主要模块——存储模块、查询模块、压缩模块、并发控制模块、文件访问模块。 2. 设计了高效的数据文件结构和基于时间区间的多级索引结构；给出了系统内核中的数据缓存结构、存储服务工作流程、消息队列管理机制；给出了查询管理器结构及工作流程、高速查询缓存结构和工作流程。 3. 给出了有损压缩算法及其流程和无损压缩算法的统一接口；设计了系统的并发控制机制，实现了基于读写锁的并发控制。 4. 开发并实现了AgiTDB的系统，并作为历史数据管理子系统成功嵌入Agilor实时数据库系统中。 实际应用表明，以AgiTDB系统为历史数据管理子系统的Agilor实时数据库显示了存储海量数据的能力和良好的系统性能。目前，Agilor已经在石化、电力、通信等很多领域得到了应用。

汉字微机数据库及其在东北电力系统中的应用

汉字微机数据库的最大缺点是速度太慢,因此难以实用化。本文提出了一种新的汉字检索方法——标志域法,解决了这个关键问题,使查找速度提高了近十倍;再采用单层连续提问等一系列措施,还可节省相当多的存储空间,扩大了微型机的应用范围。本数据库非常适合于“最终用户”使用,即使是不懂计算机的人,也能在一、两分钟内学会使用它。

胜利勘探数据中心及勘探辅助决策系统研究

In the paper through extensive study and design, the technical plan for establishing the exploration database center is made to combine imported and self developed techniques. By research and repeated experiment a modern database center has been set up with its hardware and network having advanced performance, its system well configured, its data store and management complete, and its data support being fast and direct. Through study on the theory, method and model of decision an exploration decision assistant schema is designed with one decision plan of well location decision support system being evaluated and put into action. 1. Study on the establishment of Shengli exploration database center Research is made on the hardware configuration of the database center including its workstations and all connected hardware and system. The hardware of the database center is formed by connecting workstations, microcomputer workstations, disk arrays, and those equipments used for seismic processing and interpretation. Research on the data store and management includes the analysis of the contents to be managed, data flow, data standard, data QC, data backup and restore policy, optimization of database system. A reasonable data management regulation and workflow is made and the scientific exploration data management system is created. Data load is done by working out a schedule firstly and at last 200 more projects of seismic surveys has been loaded amount to 25TB. 2. Exploration work support system and its application Seismic data processing system support has the following features, automatic extraction of seismic attributes, GIS navigation, data order, extraction of any sized data cube, pseudo huge capacity disk array, standard output exchange format etc. The prestack data can be accessed by the processing system or data can be transferred to other processing system through standard exchange format. For supporting seismic interpretation system the following features exist such as auto scan and store of interpretation result, internal data quality control etc. the interpretation system is connected directly with database center to get real time support of seismic data, formation data and well data. Comprehensive geological study support is done through intranet with the ability to query or display data graphically on the navigation system under some geological constraints. Production management support system is mainly used to collect, analyze and display production data with its core technology on the controlled data collection and creation of multiple standard forms. 3. exploration decision support system design By classification of workflow and data flow of all the exploration stages and study on decision theory and method, target of each decision step, decision model and requirement, three concept models has been formed for the Shengli exploration decision support system including the exploration distribution support system, the well location support system and production management support system. the well location decision support system has passed evaluation and been put into action. 4. Technical advance Hardware and software match with high performance for the database center. By combining parallel computer system, database server, huge capacity ATL, disk array, network and firewall together to create the first exploration database center in China with reasonable configuration, high performance and able to manage the whole data sets of exploration. Huge exploration data management technology is formed where exploration data standards and management regulations are made to guarantee data quality, safety and security. Multifunction query and support system for comprehensive exploration information support. It includes support system for geological study, seismic processing and interpretation and production management. In the system a lot of new database and computer technology have been used to provide real time information support for exploration work. Finally is the design of Shengli exploration decision support system. 5. Application and benefit Data storage has reached the amount of 25TB with thousand of users in Shengli oil field to access data to improve work efficiency multiple times. The technology has also been applied by many other units of SINOPEC. Its application of providing data to a project named Exploration achievements and Evaluation of Favorable Targets in Hekou Area shortened the data preparation period from 30 days to 2 days, enriching data abundance 15 percent and getting information support from the database center perfectly. Its application to provide former processed result for a project named Pre-stack depth migration in Guxi fracture zone reduced the amount of repeated process and shortened work period of one month and improved processing precision and quality, saving capital investment of data processing of 30 million yuan. It application by providing project database automatically in project named Geological and seismic study of southern slope zone of Dongying Sag shortened data preparation time so that researchers have more time to do research, thus to improve interpretation precision and quality.

Authenticated Index Structures for Aggregation Queries in Outsourced Databases

In an outsourced database system the data owner publishes information through a number of remote, untrusted servers with the goal of enabling clients to access and query the data more efficiently. As clients cannot trust servers, query authentication is an essential component in any outsourced database system. Clients should be given the capability to verify that the answers provided by the servers are correct with respect to the actual data published by the owner. While existing work provides authentication techniques for selection and projection queries, there is a lack of techniques for authenticating aggregation queries. This article introduces the first known authenticated index structures for aggregation queries. First, we design an index that features good performance characteristics for static environments, where few or no updates occur to the data. Then, we extend these ideas and propose more involved structures for the dynamic case, where the database owner is allowed to update the data arbitrarily. Our structures feature excellent average case performance for authenticating queries with multiple aggregate attributes and multiple selection predicates. We also implement working prototypes of the proposed techniques and experimentally validate the correctness of our ideas.

Managing digital libraries using semantic web technologies

The aim of this work is to improve retrieval and navigation services on bibliographic data held in digital libraries. This paper presents the design and implementation of OntoBib¸ an ontology-based bibliographic database system that adopts ontology-driven search in its retrieval. The presented work exemplifies how a digital library of bibliographic data can be managed using Semantic Web technologies and how utilizing the domain specific knowledge improves both search efficiency and navigation of web information and document retrieval.

A study on the authentication method for TAmI in ambient intelligence (secure group decision making toolkit)

It is difficult to get the decision about an opinion after many users get the meeting in same place. It used to spend too much time in order to find solve some problem because of the various opinions of each other. TAmI (Group Decision Making Toolkit) is the System to Group Decision in Ambient Intelligence [1]. This program was composed with IGATA [2], WebMeeting and the related Database system. But, because it is sent without any encryption in IP / Password, it can be opened to attacker. They can use the IP / Password to the bad purpose. As the result, although they make the wrong result, the joined member can’t know them. Therefore, in this paper, we studied the applying method of user’s authentication into TAmI.

A web-DB model on multicast and anycast

Most of the current web-based database systems suffer from poor performance, complicated heterogeneity, and synchronization issues. In this paper, we propose a novel mechanism for web-based database system on multicast and anycast protocols to deal with these issues. In the model, we put a castway, a network interface for database server, between database server and Web server. Castway deals with the multicast and anycast requests and responses. We propose a requirement-based server selection algorithm and an atomic multicast update algorithm for data queries and synchronizations. The model is independent from the Internet environment, it can synchronise the databases efficiently and automatically. Furthermore, the model can reduce the possibility of transaction deadlocks.

Integrating data to facilitate clinical research : a case study

The integration of routine clinical administrative activities into ongoing rigorous clinical research poses challenges for both clinicians and researchers. This case study describes the development of a responsive database system used to facilitate comprehensive longitudinal research into the outcomes of patients waiting for hip and knee replacement surgery in a large public teaching hospital. The initial research procedure was paper-based, with manual patient matching and data entry. This process was time-consuming and associated with substantial risk of error and omissions, necessitating the design of a better system. An integrated database system was designed to receive daily electronic updates of the orthopaedic waiting-list and scheduled clinic and surgery dates. Using readily available software (Microsoft Access), new patients were identified through specifying inclusion and exclusion criteria which allowed rapid and complete recruitment at time of entry to the waiting-list. The integrated system specified the appropriate timing of multiple follow-up assessments, provided prompt information on recruitment for reporting purposes and integrated multiple linked research projects within one database. Seamless exporting of data to statistical programs for analysis was also enabled. This simple integrated approach facilitated efficient execution of a longitudinal study from recruitment to statistical analysis while maximising confidentiality and minimising resources required. This case study describes the development and design of a simple system which could be easily adapted for database management in hospital or clinic-based settings according to local requirements.

Coordination of multiple cameras to track multiple people

In this paper, we present a distributed surveillance system that uses multiple cheap static cameras to track multiple people in indoor environments. The system has a set of Camera Processing Modules and a Central Module to coordinate the tracking tasks among the cameras. Since each object in the scene can be tracked by a number of cameras, the problem is how to choose the most appropriate camera for each object. We propose a novel algorithm to allocate objects to cameras using the object-to-camera distance while taking into account occlusion. The algorithm attempts to assign objects in the overlapping fields of view to the nearest camera which can see the object without occlusion. Experimental results show that the system can coordinate cameras to track people properly and can deal well with occlusion.