we have created a simple asp.net/sqlserver 2000 based Business Process Management tool in which we have a feature that user can create simple one column form and attached to the process and define rules and path.
我们创建了一个简单的基于asp.net/sqlserver 2000的业务流程管理工具,其中我们有一个功能,用户可以创建简单的一个列表单并附加到流程并定义规则和路径。
We save the dynamically created forms controls values in EAV design tables but as the transactions is increasing we are have the performance issue on reporting on that custom forms values , my question is whats the alternative to this problem in which main requirement of the BPM solution is that user will create forms dynamically ,and what do u guys think the implementation of other big vendors of BPM like Skelta/ultimus/K2.net are managing this requirement. Do u thing xml can save me ?? if yes then how or How u guys will design the model of BPM applications
我们将动态创建的表单控件值保存在EAV设计表中,但随着事务的增加,我们在报告自定义表单值时遇到性能问题,我的问题是如何替代BPM解决方案的主要要求的问题是该用户将动态创建表单,你们认为像Skelta / ultimus / K2.net这样的其他BPM大厂商的实现正在管理这个要求。你用xml可以救我吗?如果是,那么你们将如何或如何设计BPM应用程序的模型
1 个解决方案
#1
I'm not a fan of EAV. It's using a relational database to solve a problem relational databases are not designed to solve.
我不是EAV的粉丝。它使用关系数据库来解决问题关系数据库不是为解决而设计的。
I'd recommend you design a Domain-Specific Language to represent your forms definitions. You can use XML as a format.
我建议您设计一个特定于域的语言来表示您的表单定义。您可以使用XML作为格式。
Or else you should use RDF for dynamically-structured data.
否则,您应该将RDF用于动态结构化数据。
#1
I'm not a fan of EAV. It's using a relational database to solve a problem relational databases are not designed to solve.
我不是EAV的粉丝。它使用关系数据库来解决问题关系数据库不是为解决而设计的。
I'd recommend you design a Domain-Specific Language to represent your forms definitions. You can use XML as a format.
我建议您设计一个特定于域的语言来表示您的表单定义。您可以使用XML作为格式。
Or else you should use RDF for dynamically-structured data.
否则,您应该将RDF用于动态结构化数据。