Active Directory Monitoring System Using Optimized Web Database Application And AJAX Techniques

The process co ntrol network and subscribers to extract information entry and exit, supported them by providing time for the cases of entry and exit, and archiving in databases has become one of the basic requirements of each organization In this paper, we propose designin g a system control and monitoring of participants within the scope (Domain) by taking advantage of the previous reg istration system (Active Directory) throug h the use o f mode rn techniques to ensure speed and protection, that is (ASP.Net) and Asy nchronous JavaScript and

. In this new model, the (single-page) web interface is composed of individual components which can be updated/ replaced independently, so that the entire page does not need to be reloaded on each user action.This, in turn, helps to increase the levels of interactivity, responsiveness and user satisfaction [4] AJAX is a useful tool for creating web database application.Using AJAX provided a lot of facilities through using frameworks that contains the desired functions and procedures that can be used in any webdatabase application, moreover these functions and procedures may have the same duties as using any other server side scripting language but not with the traditional databases which cannot adequately handle rich data such as nested data structures or complex documents, which are characteristic of typical Web content.The XML databases, on the other hand, store XML data natively in its structured, hierarchical form [5].The XML allows developers to create Web pages and to set standards for defining the information that will appear in a document with the related sequence.XML, in combination with other standards, makes it possible to define the content of a document separately from its formatting, and this will help to reuse that content in other applications or for other presentation environments.Most important, XML provides a basic syntax that can be used to share information between different kinds of computers, different applications, and different organizations without needing to pass through many layers of conversion.In addition, XML has been designed to be extremely expressive and very well structured while at the same time being easy for both human beings and computer programs to read and write.
PDF created with pdfFactory Pro trial version www.pdffactory.comThus, it's an obvious choice for exchange languages [6].

The Architecture of Web Applications
The basic architecture of a web application includes browsers, a network and a web server as illustrated in figure (1).Browsers request web pages from the server.Each page is a mix of content and formatting instructions expressed with HTML.Some pages include client side scripts that are interpreted by the browser.These scripts define additional dynamic behavior for the display page and often interact with the browser, page content and additional controls (Applets, ActiveX controls and plugins) contained in the page.The user views and interacts with the content in the page.Sometimes the user enters in information in field elements in the page and submits them to the server for processing [7].The user can also interact with system by navigating to different pages in the system via hyperlinks.In either case, the user is supplying input to the system that may alter the business state of the system [8].

The proposed system objectives
The objectives of the proposed architecture can be summarized as follows: Building a web-database monitoring system supported with strong search engine in addition to taking care of the security and speed in giving exact results and showing the employees logins to their computers regarding all working hours and shifts employees or part time schedules.All this information displayed using a friendly user interface reports showing all the monitoring process automatically as a daily task.Show the architecture of building a standard and secure web database application through adding AJAX technology and its related tools and making use of the XML embedded database as a middle tear database to increase the speed of the data exchanging operation.Using Microsoft facilities that make the link with XML and making XML middle-tier database.The links will be through using the classes and objects for making a link with the relational database, and other link through using the objects of scripting languages (such as VB script, Java script or C# script) that runs inside the website pages either with using the classes and methods that are provided by Microsoft Framework.Mainly to build a fast, dynamic website, but also to save resources.For improving sharing of resources, it is better to use the power of all the client computers rather than just a unique server and network.Ajax allows performing processing on client computer (in JavaScript) with data taken from the server.The processing of web page formerly was only serverside, using web services or ASP.NET scripts, before the whole page was sent within the network.But Ajax can selectively modify a part of a page displayed by the browser, and update it without the need to reload the whole document with all images.
PDF created with pdfFactory Pro trial version www.pdffactory.com

3.2The Architecture of the Proposed
Web-Database Monitoring System This article illustrates the practical implementation for the building of three-tier system using AJAX, ASP.NET and XML as a middle-tier database between the relational database server and the web server.The building of a typical three-tier Web database application system using MSXML Server XMLHTTP to facilitate the communication through the HTTP with reliable software implementation using ASP code, C# COM objects and Microsoft SQL Server 2000 simplifies building Web based database applications.Figure (2) shows the proposed Three-Tier Web-Database Monitoring Architecture.This architecture is used to realize the Employee's Logins Monitoring system.

3.3Employee's Logins Monitoring System
The flowchart of the employees ' logins monitoring system is shown in figure (3), this system has the ability to extract the required information from the database through querying this information in the backend when the user or client's request comes from the web search engine, after the web server pass the request to the database server, the database server will execute the query in the backend and pass the query's result to the web server, here the web server will pass this information in well designed GUI to be previewed nicely to the client as shown in figure (4).Here the powerful of using Microsoft SQL server in storing the data in well designed and protected database spread in a lot of relational tables.The Employees Logins Database tables are shown in figure (5).These tables are designed and implemented using MS SQL server 2000 to store all the information regarding the records comes from the exchange server to be managed later by the employee logins application as an electronic archived data.The communication was done through the HTTP over the WWW.Also, Microsoft Framework classes were been used.
This web-database application enables the authorized users to control and monitor on the data that stored in tables of the SQL 2000 database through the HTTP over the Web by using friendly WebPages and layouts.

System Requirements
The Employees' logins monitoring system requires hardware and software installations on the servers' computer as the following: a Web Release 1.0.

Results & Discussion
As a result a web application was designed and developed successfully that can be run on Intranet or even Internet.This application have the ability to control and monitor all the linked servers inside an organization supported by valuable reports and GUIs that facilitate the process of monitoring, all the important information stored in relational database in order to insure the speed in data management and keep these information safe as much as possible.ASP.NET is used daily by millions of professional developers world-wide.It runs some of the most successful websites and applications in the world, and every day thousands of new developers begin learning ASP.NET for the first time-supported by an incredible developer community of books, blogs, user groups, forums, and developer websites.The goal with ASP.NET AJAX is to enable developers to easily build great ASP.NET applications that fully leverage the power of the browser, and which deliver a smoother and more interactive experience for end users.ASP.NET AJAX works with all modern browsers, and allows to easily building great web applications that work cross-platform on all operating systems.ASP.NET AJAX 1.0 is available as a free, fully supported download for ASP.NET 2.0.It will be built into the standard .NET setup package starting with the .NET Framework 3.5 release of ASP.NET.

Conclusions:
This system was designed, analyzed, developed and tested and all the results matched the goals that were planned in the design model.This monitoring system shows the ability of taking benefit from the Domain controller (from the event window) which has the ability to record every single action to any Computer linked to that domain so all the logs were taken from the domain and placed this information in text files automatically every day in a folder inside the web server, then the action of the web server begins in collecting the information from the text files and putting all the records in the Microsoft SQL server so XML can reach this database and show this information in well designed web reports after using the search engine in querying any employee inside the domain or in other word inside the organization.
Finally, the use of ASP technology has made it easier to design and develop the three-tiered architecture of this application.We were using the Microsoft Software Development Platform for the development of this project, which had given a complete, tight and integrated approach for the process of design and development of the Employee Logins Monitoring System.

Figure
Figure (1): Basic Architecture for Web Applications

com Eng. & Tech. Journal Vol.28, No.18, 2010 Active Directory Monitoring System Using Optimized Web Database Application And AJAX Techniques
PDF created with pdfFactory Pro trial version www.pdffactory.