智能卡管理信息系统中数据库技术的应用

The Application of Database Technique in Smart Card Management In formation System

介绍了数据库技术在智能卡管理信息系统中的应用。以智能卡酒店消费管理信息系统为例,在系统分析的基础上采用实体-联系法对服务器端数据库进行建模;平衡规范化和非规范化规则,采用完整性约束机制构建数据库表结构;存储过程技术与事务机制配合使用,来减少网络数据流量,增强数据访问的完整性和一致性;最后介绍了基于角色和用户的系统访问管理机制。

This paper introduces the application of database technique in Smart Card Management Information System.As an example of Smart Card Hotel Consumption Management Information System,on the basis of system analysis,the writers apply the Entity-Relationship Approach to the database modeling.On the consideration of the standardization principle and the none-standardization principle,the paper creates tables with the integrity constraint.The storage process cooperates with the transaction to reduce the information flows transferred in the network and improve s the integrity and consistency of visiting the database.At the end,the paper introduces the system access management mechanism based on role-and-user.