为适应大坝监测系统中对大量数据进行快速复杂计算的要求,利用SQL语言对数据集灵活操作的优势,提出了一种基于SQL数据计算的运算结构,通过对SQL软件的二次开发,并结合大坝监测系统中统计计算建模的特点,将原本软件对数据的运算操作转化为SQL的直接运算,最终达到数据计算集成的一体化。系统运行结果显示,新方法的应用提高了系统的运算速度和软件的操作性能,简化了系统算法的编写,达到了系统的优化开发。
To meet the requirements of complex calculations with large amounts of data quickly,using the advantages of flexible operation of data sets by SQL language.Presents a calculation based on SQL data computing.Combined with the secondary development of the SQL and statistical computing modeling features of dam monitoring system,change the software computing by SQl computing directly,ultimately achieve the integration of data calculation.The results show that the application of new methods improve the system operational performance and computing speed,simplify the preparation of the algorithmand achieve the optimal development of the system.