Design of the Data Warehouse of the Securities Broker-operation

Abstract

Abstract: This paper designs a securities broker operation data warehouse based on the demand of the securities company headquarters. The idea of the design is to decentralize the risk and collect data. The function structure，the network structure and the realization of the modules are explained here. Then it introduces some new applications of data warehouse.

摘要： 针对券商经纪业务管理总部的需求，根据"风险分散，数据集中"的设计思想设计了相应的数据仓库，着重介绍了数据仓库的网络结构、功能结构、模块实现，并在此基础上提出了数据仓库的一些新的应用。

关键词: 数据仓库, 证券, 联机分析, 数据挖掘, SQL, Server2000

CLC Number:

TP311.13

ZHU Xiaowu，ZHANG Shuguang. Design of the Data Warehouse of the Securities Broker-operation[J]. , 2003, 29(04): 87-.

朱晓武,张曙光. 证券经纪业务数据仓库设计[J]. , 2003, 29(04): 87-.

[1]	DING Lin, YANG Yang, GUO Caili, GUO Jianzhang, LI Zheng. A Text-to-SQL Method Based on Fine-Tuning Large Language Models with Table Creation Information [J]. Computer Engineering, 2026, 52(11): 402-411.
[2]	LIN Xiaoqing,ZHANG Fu,CHENG Jingwei. SPARQL Query Optimization Based on Longest Property Path Filtering [J]. Computer Engineering, 2018, 44(11): 7-13.
[3]	YANG Xiujuan,DONG Jun,LI Huihui,YUAN Yanzhong,CHEN Xiaodan. Reverse Furthest Neighbor Query Method Based on Improved Metric Index [J]. Computer Engineering, 2017, 43(4): 234-238.
[4]	YUE Guohua,CHEN Peng. Fast Output Algorithm of Embedded Electronic Map Based on MapInfo Data [J]. Computer Engineering, 2017, 43(1): 93-97.
[5]	GAO Jun,HAO Zhongxiao. Credible Nearest Neighbor Query in Constraint Fuzzy Network [J]. Computer Engineering, 2015, 41(1): 54-60.
[6]	SUN Hailong,WANG Nihong,WANG Chunyan. CKNN Query Based on Constraint of Directional Relation in Road Network [J]. Computer Engineering, 2014, 40(12): 50-56.
[7]	HAO Xiao-hong, ZHANG Li-ping, ZHAO Ling-qiang, LI Song. 3DR39-3d Orientation Relation Model and Reverse Orientation Relation [J]. Computer Engineering, 2014, 40(7): 258-262.
[8]	SUN Hai-long, WANG Ni-hong. CKNN Query Based on RRN-Tree in Road Network [J]. Computer Engineering, 2014, 40(6): 306-311.
[9]	DI Liang, DU Yong-ping. Application of LDA Model in Microblog User Recommendation [J]. Computer Engineering, 2014, 40(5): 1-6,11.
[10]	LU Ti-guang, LIU Xin, LIU Ren-ren. Universal Crawling Algorithm for Microblogging Data [J]. Computer Engineering, 2014, 40(5): 12-16,20.
[11]	GAI Wei-lin, XIN Dan, WANG Lu, LIU Xin, HU Jian-bin. Review of Date Fusion and Decision-making Methods in Situation Awareness [J]. Computer Engineering, 2014, 40(5): 21-25,30.
[12]	GAO Jun, HAO Zhong-xiao. Nearest Neighbor Query for Fuzzy Object in Constraint Network [J]. Computer Engineering, 2014, 40(3): 39-45.
[13]	YIN Shao-hong, FAN Gui-dan. Top-k Frequent Itemsets Mining Algorithm over Data Streams Based on Matrix [J]. Computer Engineering, 2014, 40(3): 55-58,75.
[14]	FENG Jia-jun, WANG Xiao-lin, TIAN Qing. Text Retrieval Model Based on Counting Bloom Filter [J]. Computer Engineering, 2014, 40(2): 58-61.
[15]	SUN Tao, SUN Hong-feng, CHEN Wei-heng, LIANG Sai-ting. Skyline Query in Dataset with Normally Distributed Attributes [J]. Computer Engineering, 2014, 40(1): 45-48.

Please choose a citation manager

Content to export