AI 中文总结
本文提出一种基于MS VBA事件驱动过程的伪代码算法，在数据库约束驱动设计框架下强制SQL Server数据库约束，并通过家谱应用示例验证其有效性和跨平台适用性。
AI 中文摘要
本文的目标是在软件工程数据库约束驱动设计与开发的框架下，为基于MS SQL Server数据库构建的软件应用程序，提供一种使用MS VBA事件驱动过程强制数据库约束的严谨方法论。其原创贡献在于一个辅助开发者进行此过程的伪代码算法。我们通过从使用此方法论设计和开发的家谱数据库软件应用中提取的一些VBA代码示例，展示了使用该算法的结果。因此，它强制了所有管理该论域子集的数据库约束（无论是关系型还是非关系型），从而保证了其管理数据的最高质量。我们还表明，所提出的算法不仅适用于其他关系型数据库管理系统，甚至适用于NoSQL平台后端，并且为适应其他类似的SQL嵌入前端平台所需的修改是最小的。
英文摘要
The goal of this paper is to provide a rigorous methodology for enforcing database constraints using MS VBA event-driven procedures for software applications built on top of MS SQL Server databases, in the framework of the software engineering Database Constraint-Driven Design and Development. The original contribution is a pseudo-code algorithm for assisting developers in this process. We exemplify the results of using it with some VBA code examples taken from a genealogy database software application designed and developed using this methodology. Consequently, it enforces all the database constraints -be they relational or not- which govern this sub-universe of discourse, thus guaranteeing the highest possible quality of its managed data. We also show that the proposed algorithm works fine not only for other relational database management systems, but even with NoSQL platform backends, and that the modifications needed to adapt it to other similar SQL embedding frontend platforms are minimal.
CommentsPublished in the Proc. 7th ICDD 2023 Conf., Lucian Blaga Univ., Sibiu, Romania, pp. 123-137, https://conferences.ulbsibiu.ro/icdd/2023/files/ICDD2023_Proceedings.p df
