基于用户数据字典的通用动态查询组件的研究与实现

为了提高管理信息系统中查询的通用性，解决系统应用程序对具体数据库结构及开发语言依赖性过大的问题．本文介绍了一种基于用户数据字典的通用动态查询的设计与实现方法，利用组件技术封装了数据库接口、查询功能和用户数据字典维护功能，使查询更加灵活、易操作，并可以在不同数据库和开发语言环境下应用，提高了软件的复用性及系统开发的效率，文末给出了具体的应用。     

基于SOA技术的数字舞台集成系统数据库通用接口设计

为了最大限度提高各个子系统使用快速创意虚实互动数字舞台集成系统数据库的效率,提出了基于SOA技术架构的数字舞台系统基础数据库通用接口设计的新思想。基于SOA体系,建立了数字舞台集成系统数据库通用接口的总体框架,定义SOA接口模块实现整个系统内部各个子系统与数据库之间的数据共享和交换。研究了数据库的访问技术,设计了接口数据模型、典型数据词典、解释提取条件以及数据接口实现的具体定义。基于该设计的快速创意虚实互动数字舞台集成系统数据库可以高效地实现数字舞台系统与其各个子系统之间的数据的互联互通、资源共享。     

基于JdbcTemplate的数据库访问处理

Spring JdbcTemplate简化了对数据库的访问处理,详细讨论了JdbcTemplate实现对数据库表格的增、删、改、查询的操作处理方法。分别针对多行数据结果集、单值结果的查询需求,给出相应的JdbcTemplate的不同方法调用。在数据更新处理中,讨论了完整SQL和带参数填充的SQL的方法调用形式。最后,结合文件内容的保存与恢复处理实例,介绍了大容量数据的读写,通过LobCreator对象的setBlobAsBinaryStream方法实现LOB数据的写入,通过LobHandler接口提供的系列方法可获取LOB数据。     

基于LabVIEW的油滴电量测试系统的数据库访问

在利用基于LabVIEW的虚拟仪器开发平台设计测试系统时,不可避免地需要对大量数据进行存储、查询、处理分析,在此基础上提出LabVIEW中访问数据库的需求。在此结合油滴电量测试系统的功能需要,利用NI的附加数据库接口工具包LabVIEW SQL Toolkit进行编程,完成对数据库的访问,实现了数据存储、查询、更新、修改、删除等操作。并设计了人机交互界面,实时显示所有测试终端的总体进度和各测试终端的详细数据。     

基于组件技术的.NET应用研究

基于组件对象的软件工程方法要求在软件开发的过程中,首先应逐步深入对组件进行功能分析、规划和对外接口的设计,进而落实内部细节的实现,最终完成组件的部署与管理。在开发基于ASP.NET的数据库系统的过程中,灵活使用组件编程,可以实现代码的安全,提高代码复用,并且通过组件实现数据库请求,增加了数据库的安全,提高了数据访问效率。     

基于C＋＋Builder实现炼镁炉监控系统的数据库管理

针对炼铁炉监控系统的数据管理要求,使用C＋＋Builder6．0开发平台,以SQLServer2000数据库管理系统为数据库基础,设计开发了一款炼镁炉监测数据管理系统。该系统利用ADO接口,实现了对SQLServer2000数据库的有效连接和访问,以及对炼镁炉监控系统的实时采集数据的存储和对数据库的动态查询。通过TChart组件用曲线图显示查询到的历史数据,并利用TDatesource和TDBGrid组件浏览数据库的数据,最后通过Excel．Application对象的属性和方法把历史采集数据传送给Excel报表。     

ASP+TXT通用型查询系统的设计

随着信息技术的快速发展和Internet应用水平的逐步提高,在企业信息化应用中对数据的查询应用涉及面很广,而且存在迫切的应用需求,目前企业信息化系统软件中的数据库存在多样化和不统一等问题,所以用户要想获取数据库信息,需要简单、实用、统一的系统来实现数据的查询工作。为了提高工作效率、实现数据查询的通用性,使信息化软件的数据得到方便快捷的读取,那么研究信息高效率查询是企业信息化建设的迫切要求。所以如何让数据通用,使用户方便快捷获取信息是本文研究的重点,本文采用的ASP是面向对象的编程技术和TXT文本数据库;可使复杂数据库查询简单化,发挥其实用性,该系统可广泛应用到工资查询、证书查询、物业费查询、成绩查询等诸多信息查询领域。     

语音搜寻功能的学习对象管理系统设计研究——以大学语文为例

文章通过对系统的需求分析,构建了可应用于大学语文语言学习者的学习管理管理系统,并对系统的功能、整体架构、数据库等进行了设计,并采用Java Applet和Java Servlet技术,实现了对系统的访问和数据请求。同时在网页代码中添加语音搜索功能,使得语言学习者通过语音搜索的方式即可实现对不同学习内容的搜索。     

ASP访问数据库的三种方式

随着Internet/Intranet技术的飞速发展,Web成了新的商家必争之地,各家厂商都希望通过Internet/Intranet技术与最终用户建立直接的联系,比如在Web上向用户推销产品、方便用户在网上查询自己喜欢的商品并提供网上订购服务等。于是基于Web方式的数据库技术应运而生。但是在传统的HTML页面中,访问数据库一般是通过公用网关接口(CGI)来实现的,这种方式不仅开发困难,而且在出现大量并发请求时会显著地降低服务器的运行效率,而采用ASP(Active ServerPages)技术实现数据库访问就能较好地解决这个问题。     

基于C#.NET的通用数据访问接口的实现与应用

在信息管理系统开发中,数据库访问技术尤为关键,几乎所有的逻辑处理均会基于底层数据库访问技术,它也决定了系统性能和效率的重要因素之一。本文采用C#开发语言,基于.NET框架下,实现针对不同的数据库采用通用数据访问类。     

Communicating the Message:Translating tasks into queries in a database context

This paper examines two components of the user-database interface: the data modeling constructs used to represent the database structure and the query language constructs used for data retrieval. From a theoretical perspective, if both the data modeling and query language support high-level abstractions (HLAs), such as generalization and composition, then the "semantic distance" between the user and the interface will be reduced. We used an in-depth verbal protocol study to explore how users were able to effectively complete two tasks: constructing a data model with HLAs and formulating queries against the data model. Results suggest that a successful strategy for modeling with HLAs involves the systematic transition between higher and lower levels of abstraction. In addition, there is some support for the idea that there is a "productivity payoff" to modeling with HLAs, because subsequent query can be simplified.     

基于Android的火车时刻表查询系统设计与实现

为方便手机用户即时查询火车时刻信息,在Eclipse平台上,采用Java语言,设计实现基于Android平台的火车时刻表查询系统。设计包括三大部分:界面设计、Web Service请求和SQlite数据库访问。各界面使用Activity作为容器,部署Button等控件,并为控件设置监听器,使用Intent对象在各Activity之间传递信息;采用httpClient.execute()方法提出Web Service请求,对返回的XML通过Dom4j进行解析并显示在界面;最后将感兴趣的信息保存在本地数据库。该系统的功能包括按发车站-到达站查询,按车次查询,按本地查询。系统的特色是将从Internet上获得的信息进行本地化,即对查询得到信息进行重复利用。     

软件质量平台中关联规则挖掘的应用

本文介绍了软件质量平台中关联规则挖掘的应用,利用关联规则挖掘的原理,将其运用到软件开发过程中,依据大量的客观数据来支持关联规律,提高规律的可信度。根据规模、配置申请、风险问题、错误缺陷、小组士气、任务进度六种属性来测量关联规则。     

Optimized management of large-scale data sets stored on tertiary storage systems

We focus on extending RasDaMan's multidimensional query language using a new concept called object framing. With this extension, users no longer are restricted to performing range queries in the shape of multidimensional hypercubes. It can be able to formulate range queries by indicating complex frames. Thus, object framing represents a generalization of geometric operations. A new system, optimized toward high-performance computing, extends the RasDaMan (Raster Data Management) database management system to allow flexible management of multidimensional spatiotemporal data and to reduce tertiary storage access time.     

Query by templates: using the shape of information to search next-generation databases

We present a user-centered database query language called QBT (Query By Templates) for user communication with databases containing complex structured data, such as data stored in the Extensible Markup Language (XML). XML has revolutionized data storage as well as representation and transfer methods in today's internet applications. The growing popularity of XML as a language for the representation of data has enabled its use for several applications involving storage, interchange, and retrieval of data. Several textual query languages have been proposed for XML retrieval, including the World Wide Web Consortium's (W3C) recommendation of XQuery. Native XML database systems have been implemented, all of which provide methods for user communication with the database, although most communication methods use text-based query languages or form-based interfaces. QBT, the language presented here, is one of the first attempts toward a generalized alternative language that is based on human factors of familiarity. It is ideal for documents with a simple yet highly recognizable layout (e.g., poems, dictionaries, journals, etc.). We present the QBT language and report results from an initial usability test that shows promise for this type of an interface as a generalized user-database communication method.     

A Tool for Query Formulation based on Entities and Roles

In order to formulate valid queries on a relational database, one must be fluent in SQL (Structured Query Language), the concepts that it involves (entities, relationships, attributes) and the data schema describing the elements of the domain. However, casual users are not familiar with query languages and database structures, but would like to access data in a more user friendly way. The goal of this paper is to present a query formulation tool that allows casual users to easily build a query using an almost natural language, on a step by step basis, guided by the tool.     

科技信息港西文数据库统一检索平台

根据科技信息港西文数据库统一检索的要求，首先利用现有数据库的检索平台，将所有数据检索出来，并以文本文件的形式存在；然后建立一个全新的数据库，将数据从文本文件中提取出来输入新的数据库；最后使用动态服务器网页(ASP)技术访问新的数据库，以浏览器／服务器(B/S)方式实现数据库统一界面检索。     

Influencing public policy through information sharing

The data collected in electronic databases by government agencies, universities, and private organizations could be of use to a public increasingly interested in participating in public policy formation. However, because most users lack skill in communicating with computers and because institutions resist the dissemination of databases, this information is not widely accessible to the public in forms it can use. The authors propose establishing a public access `data hub' to process requests for database access, download a copy of the requested data from the original source database (databases would not reside at the hub), and display the data in the form requested. The `bridge' between user and data would be an interface to process the request for data and then shape and interpret the data for the user. A single interface would allow users access to information that resides on many different computers without their having to learn to `talk' to each different system. Helping to design and implement this interface would be the task of the professional communicator     

Efficient and distributed access control for sensor networks

Sensor networks are a promising computing paradigm for monitoring the physical environment and providing observations for various uses. In hostile situations, it is critical to enforce network access control to ensure the integrity, availability, and at times confidentiality of the sensor data. A natural idea is to adopt a centralized design where every access request from users goes through a trusted base station. However, this idea is not practical due to the cost and efficiency issues. This paper proposes two efficient and distributed access control methods, uni-access query and multi-access query. The uni-access query uses only symmetric cryptographic operations; it allows (1) a user to directly access the data on any sensor node in the network without going through the base station and (2) a sensor to protect its data so that only authorized users can access. Compared to existing solutions, this scheme is much more flexible and efficient. In addition, this scheme can also support privilege delegation, which allows a user to delegate all or part of its privilege to others without using the base station. The multi-access query applies public key cryptography to provide an additional feature, which allows a user to access the data on many sensor nodes via a single query. Compared to existing solutions that require a user to send at least one request for every sensor node to be queried, the multi-access query reduces the communication overhead significantly. The theoretical analysis and simulation evaluation show that the proposed schemes are practical for access control in sensor networks.