• 主题
高级搜索  >
历史搜索 清空历史
首页> 外文学位 >Automated creation of database forms.
【24h】

Automated creation of database forms.

机译：自动创建数据库表单。

获取原文
获取原文并翻译 | 示例
页面导航
  • 摘要
  • 著录项
  • 相似文献
  • 相关主题

摘要

A form-based query interface is usually the preferred means to provide an unsophisticated user access to a database. Not only is such an interface easy to use, requiring no technical training, but it also requires little or no knowledge of how the data is structured. However, forms do have drawbacks compared to other querying mechanisms. Firstly, forms are highly restrictive, i.e., they only support a precise set of queries and disallow all others. Secondly, the form developer is required to have complete knowledge of the database schema and also have expertise in a structured query language to create useful forms. Thirdly, generating forms is repetitive, tedious and largely manual. This thesis addresses these shortcomings of forms-based interfaces while maintaining ease-of-use.;First, the schema and content of the database are used to identify query foci and build forms centered on these entities. Choosing entities, attributes and relationships of likely interest to users and the types of query operations to support is the major challenge of this interface design approach.;If queries posed by users to a database are known, form-design can be query-driven and this can improve upon schema-based form generation. Given a trace history of queries to a database the system can generate a minimal set of forms that can be used by subsequent users to express any query similar to any in the workload.;Traditional forms are static and can only express a limited set of queries. Users are often unable to issue a desired query to the database because the available forms do not support it. This thesis presents a mechanism that lets a user modify an existing form to express the desired query. These modifications can be specified using operations no harder than form-filling.;Finally, unlike auto-generated forms, forms in use today make use of creative layout design, helper text and advanced form controls and widgets to make query specification easier. While these features can be hard to automate and generalize, many of them are incorporated into this automatic form generation system improving usability.
机译：基于表单的查询界面通常是为用户提供对数据库的简单访问的首选方法。这样的界面不仅易于使用，不需要技术培训，而且几乎不需要或根本不需要数据的结构知识。但是，与其他查询机制相比，表单确实有缺点。首先，表单具有严格的限制，即，它们仅支持一组精确的查询，而不允许所有其他查询。其次，表单开发者需要具有数据库模式的完整知识，还必须具有结构化查询语言的专业知识才能创建有用的表单。第三，生成表格是重复的，乏味的并且很大程度上是手动的。本文在保持易用性的同时解决了基于表单的界面的这些缺点。首先，数据库的模式和内容用于识别查询焦点并以这些实体为中心构建表单。选择用户可能感兴趣的实体，属性和关系以及要支持的查询操作类型是此界面设计方法的主要挑战。;如果已知用户对数据库提出的查询，则可以进行表单驱动的查询设计和这可以改进基于模式的表单生成。给定对数据库的查询跟踪历史记录，系统可以生成最少的一组表单，供后续用户用来表达与工作负载中的任何查询相似的任何查询。;传统形式是静态的，只能表达有限的一组查询。用户经常无法向数据库发出所需的查询，因为可用的表单不​​支持该查询。本文提出了一种机制，使用户可以修改现有的表单来表达所需的查询。最后，与自动生成的表单不同，与自动生成的表单不同，如今使用的表单利用了创意版式设计，助手文本以及高级的表单控件和小部件来简化查询规范，从而可以指定这些修改。虽然这些功能很难实现自动化和通用化，但许多功能已合并到此自动表单生成系统中，从而提高了可用性。

著录项

  • 作者

    Jayapandian, Magesh.;

  • 作者单位

    University of Michigan.;

  • 授予单位 University of Michigan.;
  • 学科 Computer Science.
  • 学位 Ph.D.
  • 年度 2009
  • 页码 162 p.
  • 总页数 162
  • 原文格式 PDF
  • 正文语种 eng
  • 中图分类
  • 关键词

  • 入库时间 2022-08-17 11:38:25

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱：kefu@zhangqiaokeyan.com

京公网安备：11010802029741号 ICP备案号：京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有

  • 客服微信

  • 服务号