小区物业管理系统毕业设计（论文）开题报告.doc

指导文件5：毕业设计（论文）开题报告 计算机科学与信息工程 系（院） 届题 目（中文） 小区物业管理系统 （英文 ）Community Property Management System课题类型 课题来源 自选 学生姓名 专业班级 指导教师 职 称 填写日期： 年 月 日一、本课题研究的主要内容、目的和意义本文重点介绍了本课题的开发背景、系统功能以及开发本系统的具体步骤与过程小区物业管理信息系统的目标是保障小区业务管理、基建所需的各类小区物业的供应工作，通过有效管理、提高小区的工作效率，降低资金占用。随着市场经济的发展和人们生活水平的提高，住宅小区已经成为人们安家置业的首选，几十万到几百万的小区住宅比比皆是。人们不但对住宅的本身的美观、质量要求越来越高，同时对物业小区的服务和管理也要求很高，诸如对小区的维修维护，甚至对各项投诉都要求小区管理者做的好，做的完善。这样要求小区管理者对物业管理进行宏观的和微观的细致管理，其中最好的办法是用计算机操作的小区物业管理系统来实现对小区物业的管理，这就为设计小区物业管理系统提供了市场需要。二、文献综述（国内外相关研究现况和发展趋向）生活小区的物业管理是物业管理公司都必须切实面对的工作,但一直以来人们使用传统的人工方式管理,这种管理方式存在着许多缺点,如:效率低且较为烦琐,另外随着物业管理项目的增加,工作量也将大大增加,这必然增加物业管理者的工作量和劳动强度,这将给物业管理信息的查找、更新和维护都带来了很多困难。目前我国有相当一部分物业管理公司还停留在人工管理的基础上,这样的管理机制已经不能适应时代发展,其管理方法将浪费许多人力和物力。随着科学技术的不断提高,这种传统的手工管理方法必然被以计算机为基础的信息管理方法所取代。物业管理系统作为计算机应用的一个分支,有着手工管理所无法比拟的优点,如:检索迅速、查找方便、可靠性高、存储量大、保密性好、寿命长、成本低等。这些优点能够极大地提高物业管理的效率。因此,开发一套能够为用户提供规范化的事务管理、充足的信息和快捷的查询手段的小区物业管理系统成为很有必要的事情。随着我国经济发展和城市开发,住宅小区越来越成为居住的主流.小区随着我国经济发展和城市开发,住宅小区越来越成为居住的主流.小区物业管理系统正是针对小区的物业管理公司作为使用对象而开发的,作为一个典型的信息管理系统(MIS),其系统开发任务主要包括数据库的设计与维护、客户端应用程序的开发等两个方面.对于前者要求建立起的数据库具有完整性和一致性,且具有一定的数据安全性,如用户需要密码才能使用等;而对于后者则要求程序界面友好、功能完备等特点.经过详细的分析,选用Borland公司的Delphi作为前端开发工具,利用其提供的集成开发环境及各种控件,尤其是对数据库的支持完成对数据库的各种操作,达到对小区物业进行管理的目的.首先建立系统应用原型,然后对原型系统进行需求迭代,不断修正和改进,直到形成可行系统 。三、拟采取的研究方法（方案、技术路线等）和实现的可行性论证由企业面对的实际问题，我们的研究步骤是：（1） 分析用户需求，明确用户的系统功能要求；（2） 系统体系结构设计；（3） 系统主要模块设计；（4） 数据库设计；（5） 界面设计；在选择开发工具的时候，主要考虑到了以下工具的优点： Delphi7.0提供了强有力的数据库存取能力，将Windows的各种先进特性与强大的数据库管理功能有机地结合在一起，可以用它所集成的可视化数据库管理工具来管理和访问数据库，给编程带来了许多方便。在Delphi7.0中，可用的数据访问接口有三种：ADO，BDE和ODBC。为什么在Delphi7.0 中有三种数据访问接口呢？因为数据访问技术总是在不断进步，而这三种接口的每一种都分别代表了该技术的不同发展阶段。最新的是ADO，它是比BDE和ODBC更加简单，然而更加灵活的对象模型。对于新工程，应该使用ADO作为数据访问接口。 SQL Server 2000是为创建数据仓储解决方案而设计的真正意义上的关系型数据库管理与分析系统，成为数据仓库解决方案的卓越的数据库平台。它功能强大，操作方便，日益为广大数据库用户所喜爱，越来越多的开发工具提供了与SQL Server的接口。SQL Server提供了很多功能强大的工具，便于数据库的管理和维护，该系统具有很高的安全性。四、预期结果（或预计成果）本文实现了一个小区的物业管理系统，小区物业管理系统面向小区的的各项事务，包括小区基本信息管理，物业收费管理，维修管理等业务处理工作，是为了利用计算机进行集中管理而开发的系统.系统共分为住户信息管理、物业信息管理、收费信息管理、投诉信息管理、报修信息管理以及维修物资信息管理,系统管理模块，其功能基本涵盖了小区物业管理的各个方面。五、研究进度安排对作业提交系统的相关资料术语对于需求分析的理解对E-R图的理解总体设计过程数据库的设计数据库的连接专题部分的编码毕业论文的内容设计毕业论文内容的撰写对毕业论文进行最后的效验准备答辩资料的搜集和论文内容的复查六、主要参考文献1. 王珊,陈红等.数据库系统原理教程M.北京:清华大学出版社,1998.72. 许家玳.软件工程:理论与实践M.北京:高等教育出版社,2004,73. 刘斌,李文革等.Delphi7高级数据库教程M.北京:清华大学出版社,2004.34. 杨帆.住宅小区物业管理信息系统设计N.武汉化工学院报,2002(04)5. 刘亚臣,张长胜,郑谋等.城市住宅小区物业管理系统设计N.辽宁经济,2001(02)6. 周仲良7. 张海藩编著.软件工程导论M.清华大学出版社，2003.12 8. 陈保平.开发小区物业管理智能化系统的探讨N.长江建设报,2001(02)9. 廖琪梅,刘欣等.小区物业管理系统的实现N.第四军医大学学报,2001(S1)10. 马莉.基于C/S模式的普通小区物业管理系统的设计N.北京石油化工学院报,2002(02),2、外文参考文献翻译（译文大于5000汉字）见附件“毕业设计（论文）外文参考文献翻译” 七、审核意见指导教师对开题的意见：指导教师签字： 年 月 日系（院）审核意见：审核人签字： 年 月 日说明：1、该表每生一份，系（院）妥善存档；2、课题来源填：“自选”或“教师指定”或“其它”，课题类型填：“理论研究”或“应用研究”或“技术开发”或“实验设计”或“其它”。附件：毕业设计（论文）外文参考文献翻译 系（院） 届题 目（中文） 小区物业管理系统 （英文） Community Property Management System 学生姓名 专业班 完成日期： 年 月 日 目 录Spatial data management has been an activearea of research in the database field for two decades，with much of the research being focused on develop-ing data structures for storing and indexing spatialdata. However, no commercial database system pro-vides facilities for directly defining and storing spa-tial data, and forniulating queries based on researchconditions on spatial data. We believe the followingare the relevant issues on which near-term researchshould be focused (in the order of decreasing impor-tance and urgency) First, relational query optimization techniquesneed to be extended to deal with spatial queries，thatis，queries that contain search conditions on spatialpredicates to be developed. Second, more work needs to be done on experi-mental validation of the relative performance of someof the more promising data structures and indexingstructures proposed thus far, with consideration of amuch broader set of operations than just a few opera-tions that have typically been used in the limited per-formance studies conducted thus far. Third, it is difficult to build into a single data-base system multiple data structures for spatial index-ing, and all spatial operators that are useful for awide variety of spatial applications，as such, it isdesirable to build a database system so that it will beas easy as possible to extend the system with addi-tional data structures and spatial operatorsIf the DBMS provides a way to interactively and update the database, as well as interrogate it capability allows for managing personal data-Aces however, it does not automatically leave an audit trail of actions and does not provide the kinds of controla necessary in a multiuser organization. These-controls are only available when a set of application programs are customized for each data entry and updating function. Software for personal computers which perform me of the DBMS functions have been very popular arsenal computers were intended for use by individuals for personal information storage and process- These machines have also been used extensively small enterprises, professionals like doctors, acrylics, engineers, lawyers and so on By the nature of. intended usage, database systems on these machines except from several of the requirements of full doge database systemsSince data sharing is not：Tended, concurrent operations even less so, the) fewer can be less complex. Security and integrity7aintenance are de-emphasized or absent. As data-) limes will be small, performance efficiency Is also important. In fact, the only aspect of a database system that is Important is data Independence. Data-.dependence, as stated earlier. Means that applicant programs and user queries need not recognizantphysical organization of data on secondary storage. The importance of this aspect, particularly for the personal computer user, is that this greatly simplifies database usage. The user can store, access and manipulate data at a high level (close to the application) and be totally shielded from the low level (close to the machine) details of data organization. We will not discuss details of specific PC DBMS software packages hereLet us summarize in the following the strengths and weaknesses of personal computer data-base software systems： The most obvious positive factor is the user friendliness of the software. A user with no prior computer background would be able to use the system to store personal and professional data, retrieve and perform relayed processing. The user should, of course, satiety himself about the quality of software and the freedom from errors (bugs) so that invest-merits in data arc protected. For the programmer implementing applications with them, the advantage lies in the support for applications development in terms of input screen generations, output report generation etcoffered by theses stems The main negative point concerns absence of data protection featuresUnless encrypted, data cane accessed by whoever has access to the machine Data can be destroyed through mistakes or maliciousintent. The second weakness of manv of the PC-basedsystems is that of performance. If data volumes growup to a few thousands of records，performance couldbe a bottleneck For organization where growth in data volumesis expected, availability of, the same or compatiblesoftware on large machines should be considered.This is one of the most common misconceptionsabout database management systems that are used inpersonal computersThoroughly comprehensive andsophisticated business systems can be developed indBASh, Paradox and other DBMSsHowever, theyare created by experienced programmers using theDBMSs own programming language. That is not thesame as users who create and manage personal filesthat are not part of the mainstream company systemData security prevents unauthorized users from viewing or updating the databaseUsing passwords, the database, called subschema(pronounced sub-scheme)，For example, an employee database can contain all the data about an individual employee, but one group of users may be authorized to view only payroll data, while others are allowed access to only work history and medical data. The DBMS can maintain the integrity of the database by not allowing more than one user to up-date the same record at the same time, The DBMS can keep duplicate records out of the database, for example, no two customers with the same customer numbers (Key fields) can be entered into the Data-Base. When a DBMS is used, the detailed knowledge of the physical organization of the data does not have to be built into every application program. The application program asks the DBMS for data by field pine, for example, I coded representation of give customer name and balance due would be sent to he DBMSWithout a DBMS, the programmer must secrecy space for the full structure of the in the program, Any change in data structure requireshangs in all the applications programsThe multiple-database model is represented by proposals for shared and private database architect rues, checkout and checking of data to and from shared and private databasesEach user may populates/her private database with data checked out of the shared database, perform updates against the data. and check them back into the shared Database. The multiple-database model can be used to work around the conflict situations inherent in long lunation database sessionsSince each user from the shared database and work against. is/her private database, disconnected from the、hared database (at least on the surface)，the usersan avoid the conflict situationsIn particular, multile users may be simultaneously updating the same thought having to wait for other users to comate late their updatesHowever, when updated is to benecked into the shared database, it may have to be checked in as a new version, necessitating version management. Further, when data in a private data-base references data in the shared data，or vice versa, a private database is not really disconnected from the shared database. For example, the evaluation of query in general will require the database system to access both a private database and the shared data-base, even if the query may have been formulated against a private databaseThe multiple-database model is more appropriate than the single-database model in an environment where it is easy to determine in advance logical partitions of the database that correspond to work to be performed.The single-database model has received considerably more attention than the multiple- database modelThe focus of research into single-database model has been on addressing the twin problem of long waits and loss of work that the long duration of transactions brings about. The single-database model requires the intro-diction of a notion of database consistency, and protocols for concurrency control and recovery, that are different from those supported in traditional database systemsIf a reasonable notion of database consistency is to be supported (Ic. the database system is to enforce it automatically), there are bound to be” conflict situations where one transaction comes into an access conflict against some other transaction. If await is to be avoided，some means of a negotiated settlement of the conflict must be provided, thereby dragging the users into the details of concurrency controlThe single-database model is more appropriate-ate than the multiple-database model in an environment where it is difficult to determine in advance logical partitions of the database that correspond to work to be performed, and the users closely cooperate.The objective of long-duration transactions is to model long-duration, interactive Database access sessions in application environmentsThe fundamental assumption about short-duration of transactions that underlies the traditional model of transactions is inappropriate for long-duration transactionsThe implementation of the traditional model of transactions may cause intolerably long waits when transactions aleph to acquire locks before accessing data, and may also cause a large amount of work to be lost when transactions are backed out in response to user-initiated aborts or system failure situations The objective of a transaction model is to pro-vide a rigorous basis for automatically enforcing criterion for database consistency for a set of multiple concurrent read and write accesses to the database in the presence of potential system failure situationsThe consistency criterion adopted for traditional transactions is the notion of scrializabilityScrializa-bility is enforced in conventional database systems through the use of locking for automatic concurrency control, and logging for automatic recovery from system failure situationsA transaction”that doesnt provide a basis for automatically enforcing data-base consistency is not really a transaction. To be sure, a long-duration transaction need not adopt seri-alizability as its consistency criterionHowever. there must be some consistcricv criterionDespite a large number of proposals on version support in the context of computer aided design and software engineering, the absence of a consensus on version semantics has been a key impediment to version support in database systemsBecause of the differences between files and databases, it is intuitively clear that the model of versions in database systems cannot be as simple as that adopted in file systems to support software engineeringFor data-bases, it may be necessary to manage not only versions of single objects (e.g. a software module, document, but also versions of a collection of objects (e.g. a compound document, a user manual，etcand perhaps even versions of the schema of database (c.g. a table or a class, a collection of tables or classes) Broadly, there are three directions of research and development in versioningFirst is the notion of a parameterized versioning，that is, designing and implementing a versioning system whose behavior may be tailored by adjusting system parameters This may be the only viable approach, in view of the fact that there are various plausible choices for virtually every single aspect of versioningThe second is to revisit these plausible choices for every aspect of versioning, with the view to discarding some of themes either impractical or flawed. The third is the investigation into the semantics and implementation of versioning collections of objects and of versioning the database schema. 数据库的空间组织 二十年来空间数据管理一直是数据库研究领域的活跃区，研究的焦点集中在发展存储和索引空间数据的数据结构上。但是，没有商业数据库系统直接为确定和存储空间数据提供设备，明确地表达以空间数据为研究条件的询问。我们相信下列条件是一些相关问题，在这些问题上，应把焦点集中在近期研究，（按照重要程度和迫切程度排列） 第一，关系询问最恰当技术，需要扩展以应付空间询问，也就是说，对包含查询条件的询问，需要得以发展。 第二对于迄今提出的一些更有希望的数据结构和索引结构有关效率的实验有一效性，需要做更多的工作，还要考虑涉及面很广的一套操作，而不仅仅是迄今进行的有限的效率研究方面被作典型使用的七个操作。 第三，很难在单个数据库系统内加入空间索引的多个数据结构和对十各种各样空间应用有的所有空间操作员。因此建立一个数据库是很理想的，这样将会尽可能容易地用额外的数据结构和空间操作员来扩大此系统。 数据库的查询登记和修改 如果数据库管理系统提供一种方法来相互作用地进入和修改数据库，同时查询数据库，这种方法就为管理个人数据库创造了条件。但是，它不能自动留下一串查账行动，也不能在多用户组织中提供那种必要的控制。只有当一套应用程序为每一个数据进入和修改功能设定客户规格时，才有可能得到这些控制。 当前，执行数据库系的一些功能的个人计算机软件一直很流行。个人计算机是供个人信息存储和处理而用。这些机器也广泛地被一些小企业、职业家如建筑师，医师、工程师、律师等等所使用。从使用意图的性质看，这些机器上的数据库系统没有正式数据库系统的一些要求。由于不需要数据分享，也不需要同时操作。软件也就不那么复杂。安全和整体维护也不那么重要，甚至没有随着数据容量变性能效率也不那么重要。事实上，数据库系统唯一重要的方面是数据独立。正如以前所述，数据独立是指在辅助存储器上，应用程序和用户询问不必知道数排的物理组织。这个方面的重要性，尤其对个人计算机用户来说，大大简化了数据库的使用。用户能够高层次地存储，存取和操纵数据，并且能够完全不受数据组织低层次细节的影响。在这里我们将不讨论一个特定个人计算机数据库管理系统软件包细节。我们将在下面总结一下个人计算机数据库软件系统的优缺点： 最明显的积极方面是软件的用户友好型。一个事先不了解计算机知识的用户能够使用该系统来储存个人和职业数据，检索和执行有关处理。当然，用户应该使自己对软件质量感到满足，高质量的软件仗数据的出错率减少从而使数据投资 得到保护。 对于完成应用的程序员而言，这个优点存在于支持这些系统所提供的在输入屏幕产生，输出报告产生方面的应用发展。 主要消极点是缺少数据保护特征。除非被译成密码，数据不能被任何接触机器的人所存取。数据也能由于错误或被怀有恶意的人毁掉。以个人计算机为基础的许多系 统的第二个缺点是效率方面的缺点。如果数据发展到几千个记录，效率问题可能是一个难关。 由于数据容量的增长是一种发展趋势，所以应该考虑在较大的权器上获得相同或相容的软件。 这是对用个人计算机数据库管理系统的最常见的错误概念之一：高综合和复杂的商业系统可以在dBASE，Paradox和其它数据库誉理系统中得以发展。但是，这些商业系统是由富有经验的程序设计员通过使用数据库管理系统专用的程序语言而建立的，这与建立和管理不是公司主要系统部分的个人文件的用户有所不同。数据的安全性和独立性 数据安全防止未经批准的用户阅览和修改数据库。通过使用密码，用户才允许接近整个数据库或叫子结构的数据库子集合。例如，一个雇员数据库装有关于雇员个人的全部数据，但是只允许一组用户看一个工资单数据，而其他用户只允许看工作历史和医疗方面的数据。 数据库管理系统通过阻止一六以上用户在相同时间更改同一记录的方法来保持数据库的完整。数具库管理系