| Basic Information |
The solution is based on client-server model, which works under local area network, in group of networks or in internet network.
The system is fail-resistant, scalable system situated on one or more servers (front-end application servers, back-end database servers, backup servers able for fast fail-over).
The system is consisted of two modules:
- User module
- Administrator module
The role of user part is data entering, reviewing and analyzing.
The administrator&rsquos role is management of user profiles, defining limits of measured parameters, giving permission for publishing strategic important information.
The administrators have the ability to create custom designed reports, and define the privileges for accessing such reports
MOEPP is consisted of three functionally connected elements:
· Acquisitioning measured results and their storage in relational database.
· Review and analyzes of data from database
· Management of user profiles and result validation
1. Acquisitioning measured results and their storage in relational database
The component for acquisitioning measured results and their storage in the relational database is consisted of client and server component.
The roles of server component are:
Acquisition of measured results from users
Users can submit data in various kinds of formats and mediums:
· E-mail. The IS will accept measurement results sent by e-mail from specified e-mail addresses.
· FTP. The measurement results packed as Microsoft Word document or Excel Spreadsheet document can be send to ftp server via File Transfer Protocol.
· Diskette, CD-ROM, ZIP-DRIVE. These removable media are very simple and trusted way for transferring data to IS. Measurement results will be stored in standard file formats (.doc, .xls, .pdf, .txt etc.).
· WWW. For clients where above communication methods are not available, they can still submit results by MOEPP &rsquos web page. For sending results users have to be logged in and the administrators can reject or approve submitted results before they are stored into database.
· Import filters will be developed for transferring data from most popular file formats into IS.
· An interface daemon or service will be developed for automatic transfer and conversion of data from existing applications and automatic monitoring systems.
Processing the results and conversion into format adequate for further analysis and storing into RDMS:
Before conversion of data, additional validation is performed.
This validation includes algorithms for data integrity checks and repair like batch totaling, different type of checksums, MD5 signatures etc.
Sending processed results into RDMS
For each processed record, detailed information about data sender&rsquos name, date/time of sending and name of person who approved validity of data will be stored.
2. Review and analyzes of data from database
Analysis tools specific for each area of examination is provided.
Besides required total/subtotal analysis, period average, extremes, standard deviation, absolute frequency distribution, relative frequency distribution, cumulative frequency distribution, there are much more complex analyzes that can be done just by few clicks in Windows client application thanks to SQL driven database.
Each analysis can be printed or exported into various kinds of formats like Microsoft Word, Microsoft Excel etc.
Results provided by analyzes can be exported into various well-know file formats either with Web application or Windows application. All reports can be printed on local printer or network printer.
3. Management of user profiles and result validation
User&rsquos profile management. Providing security of information is the primary role. According to it, input conditions under which data are inputted, changed and read must be exactly defined.
Built-in user profiles:
Anonymous user. User with the lowest access privileges in system.
Normal user. User can send measurement results. Ways of sending result are described above. Results will be automatically stored into database or with administrator&rsquos assistance.
Privileged user. This profile has all privileges of Anonymous user but also has access to unpublished and strategically important information.
Administrator. User has the highest privileges in IS. Administrators have privileges to publish, reject and modify results. The administrator sets allowed limits and soft-limits for measured parameters.
The restriction is set up in two levels:
· Restriction for accessing parameter. The parameter will not be accessible for previewing to specified user group (for ex. Anonymous user).
· Restriction for previewing values from specified parameter
Restriction for previewing could be applied if some parameter doesn&rsquot accomplish required conditions (for ex. if level of CO2 is greater than 5% the result will be restricted for viewing by anonymous users).
|
|
|
|
