Design and implementation of common data calculating based on SQL

Computer Engineering and Applications ›› 2007, Vol. 43 ›› Issue (21): 93-95.

• 产品、研发、测试 • Previous Articles Next Articles

Design and implementation of common data calculating based on SQL

YU Song，FAN Xiao-ping，LIAO Zhi-fang，YANG Xi

Institute of Information Science and Engineering，Central South University，Changsha 410075，China

Received:1900-01-01 Revised:1900-01-01 Online:2007-07-21 Published:2007-07-21
Contact: YU Song

基于SQL通用数据计算工具的设计与实现

郁松，樊晓平，廖志芳，杨玺

中南大学信息科学与工程学院，长沙 410075

通讯作者: 郁松

Abstract

Abstract: Based on the investigation on the common ways of calculating the data of the information system，a kind of fast way of calculating the data has been brought forward，according to the characteristic of the calculating process and taking the advantage of the SQL language on operation the database data.Using this fast calculating way，an universal data calculating control has been designed and carried out which can be used by the users with defining the calculating formula by themselves.

Key words: data-calculate, universal-control, SQL

摘要： 在研究目前信息系统中数据计算常用方法的基础上，根据数据计算过程的特点，利用SQL语言对数据库中数据操作的优势，提出了一种快速计算数据的方法，并利用由用户动态定义计算公式的思路，设计并实现了一个通用数据计算组件。

关键词: 数据计算, 通用组件, SQL

YU Song，FAN Xiao-ping，LIAO Zhi-fang，YANG Xi. Design and implementation of common data calculating based on SQL[J]. Computer Engineering and Applications, 2007, 43(21): 93-95.

郁松，樊晓平，廖志芳，杨玺. 基于SQL通用数据计算工具的设计与实现[J]. 计算机工程与应用, 2007, 43(21): 93-95.

[1]	ZHANG Jun, LIAO Xuehua, YU Xuling, LEI Meng. Research on Realizing Relational Database In-Memory Storage Model [J]. Computer Engineering and Applications, 2021, 57(19): 123-128.
[2]	WANG Yonggui, GUO Xintong. Efficient Frequent Set Mining Algorithm for Adaptive Data Sets on SparkSql [J]. Computer Engineering and Applications, 2020, 56(21): 72-78.
[3]	ZONG Ping1, LI Lei2. Performance comparison of PostgreSQL and MongoDB dealing with unstructured data [J]. Computer Engineering and Applications, 2017, 53(7): 104-108.
[4]	YANG Lei, BI Hongjun. Database security audit system based on bypass monitoring [J]. Computer Engineering and Applications, 2015, 51(8): 138-142.
[5]	XUE Tao, LIU Long. Research and implementation of automatic configuration framework for nosql based on cloud computing [J]. Computer Engineering and Applications, 2015, 51(17): 38-43.
[6]	XIAO Qiuyong, LI Guangqiang. Comparative experimental analysis for capacities of spatial database [J]. Computer Engineering and Applications, 2014, 50(21): 139-142.
[7]	SONG Xiaomei1，2, YE Xiaojun1, ZENG Xiaoqing2，3, XIE Dong2. Study and improvement on equivalence classes of PostgreSQL query optimization [J]. Computer Engineering and Applications, 2014, 50(14): 31-38.
[8]	WU Yanwen, FENG Zhengxi, KANG Ting. Design and implementation of PAAS model—oriented CSCL system [J]. Computer Engineering and Applications, 2013, 49(4): 77-81.
[9]	LUO Jun, WANG Hong, LI Wensheng. Research on eventual consistency of NoSQL database based on vector clocks model [J]. Computer Engineering and Applications, 2013, 49(23): 100-102.
[10]	SU Fang, SHOU Yongxi, SU Yila. Research on metadata driven ETL [J]. Computer Engineering and Applications, 2012, 48(6): 114-118.
[11]	GENG Yinrong, LIU Bo. Conditional functional dependencies for detecting data inconsistencies [J]. Computer Engineering and Applications, 2012, 48(3): 122-125.
[12]	YE Ming-quan¹，WU Chang-rong²，HU Xue-gang³. Research and application on medical data mining based on rough sets [J]. Computer Engineering and Applications, 2010, 46(21): 232-234.
[13]	YANG Yi-zhan,LI Xiao-ping,DUAN Xia-xia. Improved decision tree algorithm based on database query [J]. Computer Engineering and Applications, 2008, 44(15): 148-150.
[14]	WU Xiao-chun^1,2,CUI Wei-hong²,ZHANG Li-hua³. Design and implementation of database for system of transforming scientific and technological achievements [J]. Computer Engineering and Applications, 2007, 43(29): 168-171.
[15]	XIAO Jie¹,XIE Dong². Extendable method for querying quter data resources in spreadsheets [J]. Computer Engineering and Applications, 2007, 43(26): 149-151.

Design and implementation of common data calculating based on SQL

基于SQL通用数据计算工具的设计与实现

PDF

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics