Extending the graphical user interface and SQL enhancement for ZIM database system

ZIM数据库系统的图形用户界面扩展和SQL增强

• 批准号: 489928-2015
• 负责人: Ajila, SamuelAdesoye
• 金额: $ 0.91万
• 依托单位: Carleton University
• 依托单位国家: 加拿大
• 项目类别: Engage Plus Grants Program
• 财政年份: 2015
• 资助国家: 加拿大
• 起止时间: 2015-01-01 至 2016-12-31
• 项目状态: 已结题
• 来源: https://www.nserc-crsng.gc.ca/ase-oro/Details-Detailles_eng.asp?id=586475
• 关键词: Extending; graphical; user; interface; SQL

Database and database management systems are central to the day to day running of any large information technology systems (e.g. banking and insurance). Database is a collection of data items related to some big enterprises such as banking information systems. The design of database includes relational data modeling, conceptual modeling using entity relationship (E-R) or unified modeling language (UML), and programing in SQL and/or object oriented languages. Zim Corporation provides software products and services for mobile and database markets. ZIM software is a Relational Database Management System that implements and uses a Data Dictionary that fully adheres to the E-R Model. Zim Corporation's desire is to have graphical capability to model and visualize systems application definitions. Specifically relevant to Zim corporation is to provide a complete software that is highly interactive [with graphical capability] and mechanisms that application developers can use in order to speed up development process, define and embed business rules, and visually guide the understanding of the core business. The objective of this research project is to embed the ZIM E-R modeler into the ZIM's integrated development Environment (ZimIDE) in order to provide three basic functions: modeling new applications, re-engineering of existing applications, and displaying these models (both new and old applications) in either graphical version or a text version. The project will provide a full development process from analysis and design to implementation and verification of a proof of concept.

数据库和数据库管理系统是任何大型信息技术系统（例如银行和保险）日常运行的核心。数据库是与银行信息系统等大型企业相关的数据项的集合。数据库的设计包括关系数据建模、使用实体关系（E-R）或统一建模语言（UML）的概念建模以及SQL和/或面向对象语言的编程。 Zim Corporation为移动的和数据库市场提供软件产品和服务。ZIM软件是一个关系数据库管理系统，它实现并使用完全遵循E-R模型的数据字典。Zim公司的愿望是拥有图形化的能力来建模和可视化系统应用程序定义。与Zim公司特别相关的是提供一个完整的软件，该软件具有高度交互性[具有图形功能]和应用程序开发人员可以使用的机制，以加快开发过程，定义和嵌入业务规则，并直观地指导对核心业务的理解。 本研究项目的目标是将ZIM E-R建模器嵌入到ZIM的集成开发环境（ZimIDE）中，以提供三个基本功能：建模新的应用程序，重新设计现有的应用程序，并显示这些模型（包括新的和旧的应用程序）在图形版本或文本版本。 该项目将提供一个完整的开发过程，从分析和设计到实施和验证概念。