The Design And Implementation Of The Information Management System For PTR Domain User

With the information Age progresses, the oil enterprise software development and applicationgradually towards integration, standardization, and network direction. In order to facilitate the promotionof applications, the software developed and promoted by PetroChina always used adopting DomainAuthentication. As the software increases, the increasing scope of applications has increased the domainusers, domain user account management is becoming increasingly difficult. This paper is aimed atimproving the domain user management status of Daqing Oilfield to achieve a network environment ofthe human-machine interaction system .As of June 2008, PetroChina there were hundreds of thousands of domain users, Daqing OilfieldCo., Ltd.'s existing domain users to nearly 10 million. At present, the financial system, labor system,document system, etc. more than 10 software systems used in PTR Domain Authentication. However,The management and daily maintenance of Daqing Oilfield domain users are handled manually. Due tofrequent staff mobility led to a domain account information are not accurate. It is difficulty to change theuser information that staff mobility between the two Oil Production Company units and company-levelunits . Thus, Repeat the application user account is serious , domain user information management isdifficult, demanding accuracy. If you write software to achieve domain user information networkmanagement, then it will greatly improve the efficiency of management, and can also improve themaintenance of modern management level, and can also escort more and more information systems thatneeds domain authentication.This paper introduces the developing background for the Information Management System for PTRDomain User, the developing significance of this software and the developing status firstly. Then thepaper discusses the related major developing environment of the Information Management System forPTR Domain User, the system design principle , the system made-up of and two types of databaseconstruction, etc. Then this paper elaborates three Mission Modules, the major technology and theimplementation. In the end, the summary for this system is given.The program frame of this system adopts an advanced triple levels B/S structure. The InformationManagement System for PTR Domain User , is made up of seven sub-systems. It includes informationinput, information inquiry, data statistics, application management, auditing management, datamaintenance and user management. Database is the basis of the whole domain user management systemoperation. This system involves two types of databases: one is the Active Directory database which is thehierarchical database for storing domain user account information. In the Visual Studio development environment using the ADSI interface in conjunction with LDAP To manage the Active Directorydatabase; The second is a common database–Microsoft SQL Server2000, which is a relational databaseused to store information on reporting and auditing. Database includes more than ten tables. It includesLogin-users information table, account application information table, deleting account information table,error attribute information table, posted away information table, posted in information table, etc.Corresponding, in Visual Studio development environment, to access SQL Server 2000 database, thebest way is using ADO.NET. These two database provides a complete data source for the entire system,ensures the system's basic operation.This paper focuses on the implementation of domain user's system login registry, the realization ofActive Directory Tree and the implementation of Intelligent Recommended User Account. Firstly,security of the system is a software application first issues to be considered. All users of this system arein the PetroChina domain user, the system requires users to submit their own user name (PTR DomainAccount) and password as login credentials, only authenticated to use the system. The system uses formsauthentication, and describes how to properly configure IIS and Web.config, how to prepare programs byC# to achieve PTR domain authentication under the LDAP. Secondly, PTR domain user information isstored in Active Directory (abbr.: AD), AD is a tree structure. This article describes how to programmingto reproduce AD information in treeview structure. Thirdly, In view of the same name within PetroChina,very often, different oil fields have their own different ways of account naming, different branches havetheir own naming convention, it is difficult reunification. To solve this problem, the system design adistinct feature - intelligent recommendation of domain user account. This feature can quickly give anaccount of Chinese name only solve the problem of the same name for the unique account.We use the visualized integrated developing tools–Visual Studio 2005 to develop The InformationManagement System for PTR Domain User, and improve the software performance and maintainability.It also simplified the software developing progress and improve the software quality. The InformationManagement System for PTR Domain User, based on white-box testing and black box testing, andfurther completed a number of tests: Module testing, functional testing and system testing . Such effortsto ensure that the program modules and interface specifications, external specifications and productconsistency of the initial goals. These reasonable testing results show that this system can complete thefunction and meet the requirement successfully.To sum up, The Information Management System for PTR Domain User, is developed with theadvanced developing tool, matches two types reasonable databases, and the system has good scalabilityand stability characteristics. This system is operated successfully in No.10 Oil Production Company andit is approbated and accepted.