中小型企业的OA设计探究摘要办公自动化是一个新兴的、复杂的、综合性的领域，它以计算机和网络技术为核心，同时涉及到自然科学、管理学、社会学、系统工程学等多种学科的内容。实现办公自动化可以极大地提高办公效率以及办公质量。本程序实现了OA办公系统的部分主要功能，即文档管理，电子邮件管理，发文管理等，同时使用了角色访问控制，增强了系统的安全性。其开发主要包括后台数据库的建立、管理和前端应用程序的开发两个方面。本文首先介绍了基于角色访问控制的OA系统的整体系统架构及MicrosoftSQLSERVER数据库的建立，然后对数据库进行了相关的设计，最后介绍了各个功能子模块的设计思路与具体实现方法。关键词：OA系统；角色访问控制；SQL；数据库DesignandRealizationofOASystemBasedonRBACAbstractOAisarising,complex,all-aroundfield.Itmakescomputernetworktechnologythemainpoints,andinvolvesscience,managementscience,sociology,systemengineeringandotherdisciplines.Torealizeofficeautomationcangreatlyimproveofficeefficiencyandqualityoffice.SomefunctionsoftheOASystembasedonRBAC,suchasfilemanagement,e-mailmanagementanddocumentmanagement,arerealizedintheprogram.Atthesametime,theuseofrolesbasedonaccesscontrolletsthesystemmoresecurity.Itinvolvestheestablishmentandmanagementofthedatabaseandthedevelopmentofthefront-endapplication.Firstofall,thispaperintroducesthearchitectureoftheOAsystembasedonBRACandthefundamentofMicrosoftSQLSERVERdatabase.Secondly,itmakesadesignintherelateddatabasetables.Atlast,thedesignandtheimplementationofeachmoduleisintroducedindetail.Keywords：OASystem;RBAC;SQLServerDatabase目录论文总页数：26页1引言.....................................................................................................................................................21.1课题背景.......................................................................................................................................21.2国内外研究现状...........................................................................................................................21.3本课题研究的意义.......................................................................................................................31.4本课题的研究方法.......................................................................................................................32数据库概论.............................................................................................................................................32.1数据库的发展...............................................................................................................................32.1.1数据库的发展.......................................................................................................................32.1.2数据库技术...........................................................................................................................42.2数据库理论基础...........................................................................................................................42.2.1数据库模型...........................................................................................................................43开发工具及RBAC知识简介................................................................................................................53.1DELPHI6.0简介.................................................................................................................................
