Dissertation > Excellent graduate degree dissertation topics show

Research and Realization of Database’s Key Technology in Power Bill Management System

Author: XinYing
Tutor: HeDeHua
School: Huazhong University of Science and Technology
Course: Communication and Information System
Keywords: Power Management Database Mixed mode structure ADO.NET Consistency Optimize
CLC: TP311.13
Type: Master's thesis
Year: 2011
Downloads: 9
Quote: 0
Read: Download Dissertation

Abstract


Currently, domestic telecom operators generally have some problems, such as overloaded maintenance work for equipments and weak management capacity. The electric charge of communication equipments is the main cost for telecom operators. Due to the lack of effective management, the abnormal electrical situation of communication equipments is difficult to be detected in time. In that case, the cost of telecom operators increased. This system provides solutions and technical support for problems mentioned above, and gives some references to design the same type of electric management systems.According to system structure division rules, the design and implementation of Power Bill Management and Analysis System is divided into interface representation layer, business logic layer and data access and storage layer. Based on the database design theory, the database logical structure classifies with levels, and functions classifies with modules. The physical structure of the database is designed strictly to comply with the paradigm requirements and to minimize data redundancy. During the implementation of the system, we use the ADO.NET component as the interface among the system data access, storage layer and the database. Meanwhile, to improve the efficiency of database development and maintenance, the database is designed in standard design language. During the implementation of the database, we use mutex exclusive lock to guarantee the consistency of the system data. In order to avoid decrease of operation efficiency due to data increasing, we selected some tools to optimize SQL language, such as storage process, flip-flop, cursor, transaction, and so on. Furthermore, we establish some effective schemes to improve operating efficiency such as the primary key, foreign key, indexing, and the zoning and so on.After lab testing and operating by Huaihua Telecom over a year, it certifies the operability, professionalism, stability and expansibility of the system. Besides, the database design has considered the security problem, so the system of data security management scheme guarantees the system’s long-term and stable operation.

Related Dissertations

  1. Characteristic Study of Combustion in Central Reverse Flame Chamber,TK223.21
  2. Study on System of Electronic Documetnt Security Signature,TN918.2
  3. Force Online Examination System Design and Implementation,TP311.52
  4. Xinjiang Oilfield Ground Construction Cost Indicators and Management Information System Study and Application,F284
  5. The Studying of University Students’ Community Management Based on GIS,G647
  6. Motor assist system for motorized units,TP311.52
  7. Refining Technology and Its Mechanism for Sack Paper,TS752
  8. Structure of Wenzhou Agricultural Resource Management Information System Based on GIS,S126
  9. Design and Implementation of Network Data Management System Based on LabVIEW,TP274
  10. Design and Implementation of Heterogeneous Data Exchange System Based on XML,TP311.52
  11. Incremental rough set attribute reduction,TP18
  12. Hotel Management System Based on WEB,TP311.52
  13. Design and Development of Management Information System for Liaohe Estuary Wetland Based on WebGIS,TP311.52
  14. Research and Development of Information Identification and Analysis System Oriented to Measurement Clients,TP311.52
  15. Research of Course Scheduling Algorithm Based on PRI,TP391.6
  16. Credit Card Credit Management System Design and Implementation,TP311.52
  17. Research and Implementation of Assets Information Management System for University,TP311.52
  18. The Enterprise Financial Management System Based on the J2EE Technology,TP311.52
  19. College Students Leaving System Design and Relization-Based on ASP.NET,TP311.52
  20. The Research of Personalized Categorization Approach for Web Database Query Results,TP311.13
  21. Research on Web Cache Technology,TP333

CLC: > Industrial Technology > Automation technology,computer technology > Computing technology,computer technology > Computer software > Program design,software engineering > Programming > Database theory and systems
© 2012 www.DissertationTopic.Net  Mobile