SQL性能优化——表连接的分析

介绍两个表连接的几种常用方式和不同方式的内部机制.在比较3种不同表连接方式的优缺点基础上,选择一种好的方式来优化表连接,以提高查询速度,并结合中国邮政报刊发行系统数据库开发中遇到的生产实际,分析3种表连接方式的优劣.     

The Region 1 & 3 Broadcasting‐Satellite Service Plan after WRC‐03

The 1977 Broadcasting‐Satellite Service (BSS) Plan for Region 1 & 3 had been widely acknowledged to be out‐of‐date by the late 1980s. Development of digital modulation in the early 1990s provided an opportunity to update the technical provisions of the Plan to make it more economically viable. After a decade of work and three World Radiocommunication Conferences (WRCs), the revision of Region 1 & 3 BSS Plan was finally completed in 2003. The new Plan increased channel assignments from 5 to 10 analog‐equivalent channels for each country in Region 1, and from 4 to 12 channels for each country in Region 3. Yet, despite the increase in capacity, the new Plan is surprisingly similar to the original one in terms of the technical parameters. It is still based on national coverage, and the channel plan, orbital location, orbital spacing, and polarization are also the same. As a result, the new Plan is no more economically viable to implement than the old. To create economically viable BSS systems would most likely require modifications to the assignment in the Plan. Yet, modification procedures were made more difficult to apply after replanning. Less future implementation of BSS networks than would otherwise have occurred can be expected, and an inefficient usage of these frequency bands will likely result. On the other hand, less implemented systems will mean more capacity set aside for future use. This is important for countries that currently do not have satellite operations. In the end, BSS replanning reflects the eternal conflict between efficient usage and guaranteed future access. Copyright © 2005 John Wiley & Sons, Ltd.     

SQL语言中量词和空值的使用技术

在ＳＱＬ语言中可以引入全称量词符号ＦＯＲＡＬＬ，使ＳＱＬ语言使用更为自然，方便。本文讨论全称量词，存在量词和ＡＬＬ三种谓词之间的转换，联系和区别，以及空值存在时ＳＱＬ的使用技术。     

自动化服务器对客户端访问的实现

用一个实例说明如何用Delphi来实现服务器对客户的访问。     

一种基于树形结构显示关联数据的设计

论述了在程序设计过程中 ,使用树形控件、SQL 语句、临时表等多种手段 ,达到多个关联数据库的数据由一个可视化树形结构控件显示的方法和技巧     

研究生信息管理系统的设计与实现

基于实践对研究生信息管理系统进行了设计与实践,方便了教师和学生,提高了工作效率。     

C/S与B/S体系结构在信息查询系统中的应用

阐述了将数据库体系结构中的Client/Server结构与Browser/Server结构混合应用于水情信息查询系统，以实现对水情信息的处理和查询。     

基于Lotus Notes软件平台创建江铜办公自动化系统

本文介绍利用LotusNotes软件平台的电子邮件、复合文档数据库、工作流和完全的Client/Server技术 ,建立一个以开放、先进的Intranet/web及消息传递和工作流管理技术为核心的新一代全方位网络办公自动化系统。     

JPEG2000图像压缩标准及其关键算法

JPEG2000是为适应不断发展的图像压缩应用而出现的新的静止图像压缩标准。阐述了JPEG2000图像编码系统的实现过程，对其中采用的基本算法和关键技术进行了描述，介绍了这一新标准的特点及应用场合，并对其性能进行了分析。