Dynamic database modelling for compliance related software applications

合规性相关软件应用程序的动态数据库建模

• 批准号: 485867-2015
• 负责人: Gulliver, Aaron
• 金额: $ 1.82万
• 依托单位: University of Victoria
• 依托单位国家: 加拿大
• 项目类别: Engage Grants Program
• 财政年份: 2015
• 资助国家: 加拿大
• 起止时间: 2015-01-01 至 2016-12-31
• 项目状态: 已结题
• 来源: https://www.nserc-crsng.gc.ca/ase-oro/Details-Detailles_eng.asp?id=585242
• 关键词: Dynamic; database; modelling; compliance; related

The focus is on a dynamic database schema and the corresponding User Interface (UI) design for innovative mobile apps that are developed by the partner company. Dynamic database schema refers to the concept of a flexible database modelling wherein the table structure can easily be extended or altered by its users even after the application is released for production. AirSenze Solutions Inc. (partnering company) has pioneered the development of mobile applications to increase efficiency and accountability in bylaw compliance at provincial and municipality levels. These mobile applications enrich the conventional site inspection processes that include standard paper-based checklists by adding innovative mobile-based functionalities like GPS tracking, multimedia attachments, cloud-based data storage, and digital time-stamped signatures. However, minor alterations in the inspection checklist requires a redesign of the entire database schema and user interface. A dynamic database design that self-adapts to minor changes in the input parameters will greatly reduce the development cost and application timeline for the company. This will help AirSenze to effectively cater to the technological demands of its growing customer base. Estimates indicate that the software development timeline will be reduced by more than 1/3 as a result of this project. Dynamic database design is a relatively new concept and many questions remain to be answered. A comprehensive analysis of multiple DB modelling approaches will be conducted to explore various capabilities and challenges associated the design problem. This research project will result in a significant increase in app design efficiency and revenue for the company. Currently a majority of government inspection are carried out by using archaic paper-based forms. This is an expensive and inefficient process which can be greatly improved and streamlined through the use of mobile apps. An adaptable database design will help the company cater to multiple government sectors by developing cost-effective software solutions in a timely manner.

重点是动态数据库模式和相应的用户界面 (UI) 设计，以实现创新 由合作伙伴公司开发的移动应用程序。动态数据库模式是指一个概念 灵活的数据库建模，即使在之后，用户也可以轻松扩展或更改表结构 该应用程序已发布用于生产。 AirSenze Solutions Inc.（合作公司）率先推出了 开发移动应用程序，以提高省级规章制度合规性的效率和问责制 和市级。这些移动应用程序丰富了传统的现场检查流程 通过添加基于移动设备的创新功能（例如 GPS 跟踪、 多媒体附件、基于云的数据存储和数字时间戳签名。然而，轻微 检查清单的更改需要重新设计整个数据库模式和用户界面。一个 动态数据库设计，自适应输入参数的微小变化，将大大减少 公司的开发成本和应用时间表。这将有助于 AirSenze 有效地满足 不断增长的客户群的技术需求。估计表明软件开发时间表 由于该项目，将减少 1/3 以上。动态数据库设计是一个相对较新的 概念和许多问题仍有待回答。多DB建模综合分析 将采取多种方法来探索与设计问题相关的各种能力和挑战。 该研究项目将显着提高公司的应用程序设计效率和收入。 目前，大多数政府检查都是使用陈旧的纸质表格进行的。这是一个 昂贵且低效的流程可以通过使用移动设备得到极大的改进和简化 应用程序。适应性强的数据库设计将帮助该公司通过开发来满足多个政府部门的需求 及时提供具有成本效益的软件解决方案。