以存储过程为中心的软件框架设计及实现

Design and implementation of software framework with store procedure as core

中小型金融企业综合业务系统具有业务规则变更频繁、业务种类不断变化等特点,同时,随着中小型金融企业向扁平化发展,其综合业务系统网络结构一般为2层结构,系统通常计算压力不大,在配置高性能小型机的情况下,将主要的计算任务交给DBMS已成为可能。现提出了一个以存储过程为中心、交易码驱动的软件框架,业务规则由存储过程封装,这样的软件框架,扩展能力非常强,完全符合OCP(Open-Closed Principle)原则,具有普遍实用价值。着重讲述该框架的原理及设计过程。

Integrated financial services for the medium and small - scale enterprises are featured frequent changes of business roles and business forms. As these enterprises develop towards flatness, the architecture of their integrated services networks is composed of two layers. Since the underlying system does not bear a heavy computation load, it is possible to commit computation tasks to DBMS with installation of high - performance minicomputer. In this paper, a trade cede - driven, stored procedture - based software framework is presented, with business rules encapsulated in stored procedures. The software framework is of great extending ability, conforms to OCP, and is of general and practical values. The principle and design process are also presented in this paper.