泸州一卡通系统的设计与实现

【作者】 李炜；

【导师】 廖建明；

【作者基本信息】 电子科技大学 ， 计算机应用技术， 2007， 硕士

【摘要】 如今人们生活中的卡越来越多,各种银行卡、交通卡、水卡、气卡、电卡、充值卡、饭卡等不计其数,市民平时出行时身上需要带很多张卡,要记住与管理各种卡的密码并非是件容易的事情,给生活带来很多不便。在如今的家庭生活中,人们常常需要每个月去电信公司交电话费、去水务公司交水费、去电力公司交电费、去天然气公司交天然气费等等。要交完所有这些费用常常需要花费不少的时间。为了解决这些问题,给广大的市民生活带来极大的方便,泸州市政府决定建设城市一卡通系统。本文首先介绍一卡通系统的现状及课题的选题背景和意义,然后对一卡通系统进行系统分析,在进行系统分析后提出对一卡通系统的总体设计方案,最后根据设计方案实现一卡通系统。由于一卡通系统需要存储大量数据、需要与多家单位交换重要数据、需要对数据进行统计分析,因此本文将重点研究一卡通数据库的设计以及与各单位的接口设计与实现。在一卡通数据库设计中主要讨论两方面的内容,一是数据库的逻辑设计,包括对表空间、段、区、块的规划与考虑,二是数据库的物理设计,包括对数据文件与日志文件的布局的考虑。在与各单位的接口设计与实现中,主要讨论与各单位的业务数据包内容的设计与实现,同时也简要讨论了包的传输方式。更多还原

【Abstract】 Nowadays people have more and more cards, including innumerable cards for the bank, traffic, water, gas, electricity, mobile phone and dining. City residents have to take so many cards with them when going out, and it is difficult and inconvenient for them to take care of the cards and remember all the ciphers. Every month people in the modern society are demanded to go to the tele- information coporation to pay the telephone cost, to the water company to pay the water fee, to the electricity company to pay the electricity charge,and the gas company to pay for the gas... It takes people a lot of time to pay all the expenses. To solve all the problems and bring people more convenience, the Lu Zhou government makes a resolution to set up the City YKT System City YKT System.This paper firstly introduces the present situation of the City YKT System and the background and significance of this task. Then it analyses this system completely, after that it proposes an overall design for the City YKT System. And finally it makes this system practicable. Because this system needs to store much data, exchange important data with many working trades, count and analyse the data, therefore i put the stress on the research of the oracle database design and the interface design and realization with the working units in this thesis.Here we mainly discuss two problems in the oracle database design.One is logical design in database,including the plan and consideration for the tablespace,segment,extent and oracle block.The other one is the physical design in database,including the consideration for the data files and log files.During the progress of the intersection design and realization with every working unit.we mainly discuss the design and realization of business data packet,content with the working unit and meanwhile i briefly discuss the way of packet transmission.更多还原