CAJ | 학술논문

针对某集团ERP系统SSH（Strust,Spring,Hibernate）环境下需要研发销售＂3-1分栏报表＂时遇到的数据操作过于频繁和算法复杂度太高的问题,给出了解决问题的思路,以业务员、区域、客户、产品系列4个分栏使用＂Groupby＂HQL语句生成List集合,再转换为二维字符串数组,进而给出了算法假设、设计和实现,最终生成数据矩阵,使复杂度降低为O（n3）,经测试该方法比＂通常方法＂约快19倍。
침대모집단ERP계통SSH（Strust,Spring,Hibernate）배경하수요연발소수＂3-1분란보표＂시우도적수거조작과우빈번화산법복잡도태고적문제,급출료해결문제적사로,이업무원、구역、객호、산품계렬4개분란사용＂Groupby＂HQL어구생성List집합,재전환위이유자부천수조,진이급출료산법가설、설계화실현,최종생성수거구진,사복잡도강저위O（n3）,경측시해방법비＂통상방법＂약쾌19배。
The train of thought of solution was given to the problem of the frequent data operation and the high algorithm complexity met by a ERP of the group when researching sales "3-1 Split Report" in SSH.That is to produce the collection the clerk using "Group by" List HQL statement by regional,customer,product series of 4 columns,and then to convert to only two string array,and then to give the algorithm assumptions,design and implementation,finally to generate data matrix,which resulting in algorithm complexity reduction.According to the test,the method is 19 times faster than the "usually way" approximately.