Add Your Remarks
Showing posts with label Additions. Show all posts
Showing posts with label Additions. Show all posts
Saturday, December 6, 2008
Tuesday, December 2, 2008
Problem with N/W
A network problem has been arisen due to the intrusion of certain viruses in our system. The virus is replicating rapidly into the complete networks and the servers have started behaving abnormally.
The virus attack seems to be spread in the complete network not only in our local area network but also in the VIdyut Bhawan and the remote regional locations like Hamirpur and Kunihar.
Another abnormal behaviour is creating dummy nodes which brings in the IP Address conflict amongst server machines bearing the direct IP address. The conflict keeps on coming even when you detach your node to the local area network as soon as you assign it.
The problem has been discussed with Mr.Anjan Das, Mr. Mohit Malkani of Zyxel in the presence of our local vendor Mr.Anil Sharma. The same problem was also discussed with the executive of Power Grid India Mr. Pradeep Asrani and the gist was further discussed with Mr. Shankar of Swift Mail India.
Add Your Remarks
Saturday, November 15, 2008
Using Open Source RDBMS : MySQL
MySQL is written in C and C++. The SQL parser uses yacc and a home-brewed lexer, sql_lex.cc. MySQL is one of the best RDBMS being used for developing web based software applications. It is currently the most popular open source database server in existence. On top of that, it is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications. It is an Open Source Relational SQL database management system.
There are 3 types of MySQL Server Compilations for Enterprise and Community users:
Standard: The MySQL-Standard binaries are recommended for most users, and include the InnoDB storage engine.
Max: (not MaxDB, which is a cooperation with SAP AG) is mysqld-max Extended MySQL Server. The MySQL-Max binaries include additional features that may not have been as extensively tested or are not required for general usage.
MySQL-Debug binaries: These have been compiled with extra debug information, and are not intended for production use, because the included debugging code may cause reduced performance.
Beginning with MySQL 5.1, MySQL AB has stopped providing these different package variants. There will only be one MySQL server package, which includes a mysqld binary with all functionality and storage engines enabled. Instead of providing a separate debug package, a server binary with extended debugging information is also included in the standard package.
MySQL is used in web applications and acts as the database component of the LAMP software stack. Its popularity for use with web applications is closely tied to the popularity of PHP, which is often combined with MySQL. Several popular and high-traffic web sites including Flickr, Facebook, Wikipedia, Google, Nokia, Auctionmarts and YouTube use MySQL for data storage and logging of user data.
MySQL has been criticized in the past for not supporting all the features of other popular and more expensive DataBase Management Systems. However, MySQL continues to improve with each release (currently version 5), and it has become widely popular with individuals and businesses of many different sizes.
MySQL works on many different system platforms, including AIX, BSDi, FreeBSD, HP-UX, i5/OS, Linux, Mac OS X, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, eComStation, OS/2 Warp, QNX, IRIX, Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos, Tru64 and Microsoft Windows. A port of MySQL to OpenVMS is also available
Before you begin with MySQL it will be an added advantage if you posses the basic knowledge and information on PHP and HTML Scripts. Add Your Remarks
There are 3 types of MySQL Server Compilations for Enterprise and Community users:
Standard: The MySQL-Standard binaries are recommended for most users, and include the InnoDB storage engine.
Max: (not MaxDB, which is a cooperation with SAP AG) is mysqld-max Extended MySQL Server. The MySQL-Max binaries include additional features that may not have been as extensively tested or are not required for general usage.
MySQL-Debug binaries: These have been compiled with extra debug information, and are not intended for production use, because the included debugging code may cause reduced performance.
Beginning with MySQL 5.1, MySQL AB has stopped providing these different package variants. There will only be one MySQL server package, which includes a mysqld binary with all functionality and storage engines enabled. Instead of providing a separate debug package, a server binary with extended debugging information is also included in the standard package.
MySQL is used in web applications and acts as the database component of the LAMP software stack. Its popularity for use with web applications is closely tied to the popularity of PHP, which is often combined with MySQL. Several popular and high-traffic web sites including Flickr, Facebook, Wikipedia, Google, Nokia, Auctionmarts and YouTube use MySQL for data storage and logging of user data.
MySQL has been criticized in the past for not supporting all the features of other popular and more expensive DataBase Management Systems. However, MySQL continues to improve with each release (currently version 5), and it has become widely popular with individuals and businesses of many different sizes.
MySQL works on many different system platforms, including AIX, BSDi, FreeBSD, HP-UX, i5/OS, Linux, Mac OS X, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, eComStation, OS/2 Warp, QNX, IRIX, Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos, Tru64 and Microsoft Windows. A port of MySQL to OpenVMS is also available
Before you begin with MySQL it will be an added advantage if you posses the basic knowledge and information on PHP and HTML Scripts. Add Your Remarks
Friday, July 25, 2008
Hypertext Preprocessor Script : PHP
In order to have some more additions to our website we have put an effort to incorporate PHP Scripts. PHP originally stood for Personal Home Page but now stands for PHP: Hypertext Preprocessor. It is a server-side scripting language, like ASP ie the scripts are executed on the Server. The PHP-enabled web pages are treated just like regular HTML pages and you can create and edit them the same way you normally create regular HTML pages. PHP is relatively new (compared to languages such as Perl (CGI) and Java) but is quickly becomming one of the most popular scripting languages on the internet.
PHP is an open source software which means that it is free to download and use. PHP supports many databases (MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, Generic ODBC, etc.)
PHP files can contain text, HTML tags and scripts, the files are returned to the browser as plain HTML and have a file extension of “.php”, “.php3″, or “.phtml”
With PHP, you have the freedom of choosing an operating system and a web server. Furthermore, you also have the choice of using procedural programming or object oriented programming, or a mixture of them. Although not every standard OOP feature is implemented in PHP 4, many code libraries and large applications (including the PEAR library) are written only using OOP code. PHP 5 fixes the OOP related weaknesses of PHP 4, and introduces a complete object model.
We can make a PHP script to run it without any server or browser. You only need the PHP parser to use it this way. This type of usage is ideal for scripts regularly executed using cron (on *nix or Linux) or Task Scheduler (on Windows). These scripts can also be used for simple text processing tasks. See the section about Command line usage of PHP for more information.
PHP is probably not the very best language to create a desktop application with a graphical user interface, but if you know PHP very well, and would like to use some advanced PHP features in your client-side applications you can also use PHP-GTK to write such programs. You also have the ability to write cross-platform applications this way. PHP-GTK is an extension to PHP, not available in the main distribution. Add Your Remarks
PHP is an open source software which means that it is free to download and use. PHP supports many databases (MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, Generic ODBC, etc.)
PHP files can contain text, HTML tags and scripts, the files are returned to the browser as plain HTML and have a file extension of “.php”, “.php3″, or “.phtml”
With PHP, you have the freedom of choosing an operating system and a web server. Furthermore, you also have the choice of using procedural programming or object oriented programming, or a mixture of them. Although not every standard OOP feature is implemented in PHP 4, many code libraries and large applications (including the PEAR library) are written only using OOP code. PHP 5 fixes the OOP related weaknesses of PHP 4, and introduces a complete object model.
We can make a PHP script to run it without any server or browser. You only need the PHP parser to use it this way. This type of usage is ideal for scripts regularly executed using cron (on *nix or Linux) or Task Scheduler (on Windows). These scripts can also be used for simple text processing tasks. See the section about Command line usage of PHP for more information.
PHP is probably not the very best language to create a desktop application with a graphical user interface, but if you know PHP very well, and would like to use some advanced PHP features in your client-side applications you can also use PHP-GTK to write such programs. You also have the ability to write cross-platform applications this way. PHP-GTK is an extension to PHP, not available in the main distribution. Add Your Remarks
Thursday, March 27, 2008
Values Delivered
With the end of first financial year with the Decision Support System, its time to check the values delivered by the project.
1. All Real time data was successfully downloaded automatically from the respective sources.
2. The relevant data needed was extracted from the downloaded data and stored in the database for further analysis and reporting.
3. Reports as needed by various users and consumers were prepared and sent to the respective beneficiaries (without delay).
4. The public domain data was put on the website hosted at our own server to be accessed by the remotely located end user.
Other distinctive features / accomplishments of the project:
1. All the downloads of the required data from various sources (normally from the websites of NRLDC and NREB) were automatic and no manual intervention was required.
2. Instantaneous updation of data and online monitoring of this data through http://hpsldc.org.
3. As soon as the requisite data is available, many reports get generated automatically without any delay. Add Your Remarks
1. All Real time data was successfully downloaded automatically from the respective sources.
2. The relevant data needed was extracted from the downloaded data and stored in the database for further analysis and reporting.
3. Reports as needed by various users and consumers were prepared and sent to the respective beneficiaries (without delay).
4. The public domain data was put on the website hosted at our own server to be accessed by the remotely located end user.
Other distinctive features / accomplishments of the project:
1. All the downloads of the required data from various sources (normally from the websites of NRLDC and NREB) were automatic and no manual intervention was required.
2. Instantaneous updation of data and online monitoring of this data through http://hpsldc.org.
3. As soon as the requisite data is available, many reports get generated automatically without any delay. Add Your Remarks
Tuesday, March 4, 2008
Processes of Re-Engineering
The strategy adopted for re-engineering the processes, with the use of ICT, in consultation with the stakeholders. The various processes involved (for exampling downloading real time data from NRLDC & NREB website, updation of revisions, etc. etc.) were automated making it possible to monitor all the data with as less human intervention as possible.
A Database was created and configured to store the large amounts of data for its real time analysis as well as its use on any later date.
A GUI was created (using Visual Basic) for various reports (routine and MIS).
The information dissemination to various categories of the users was done through the website http://www.hpsldc.org) hosted at our own web server at SLDC. Add Your Remarks
A Database was created and configured to store the large amounts of data for its real time analysis as well as its use on any later date.
A GUI was created (using Visual Basic) for various reports (routine and MIS).
The information dissemination to various categories of the users was done through the website http://www.hpsldc.org) hosted at our own web server at SLDC. Add Your Remarks
Tuesday, January 15, 2008
DSS Changes Archiving Trends
Our DSS Initiative Changes the Data Archiving Trends as situation before the initiative was quite tedious to control. A large amount of real time data was available from various sources and this needed to be compiled and analysed in a user friendly manner- on real time basis – to efficiently analyse and plan the transaction of Power with other states in the Northern Region as well as within the state.
Due to the high volume of this data, both static as well as real time, the analysis and accounting of the Power transactions was not only error prone but a large amount of data was not being processed, as it was almost impossible to do so manually. Even the amount of work which was being done consumed a lot of human and other resources.
For want of a database management tool, the past data was lost and there was no way to extract historical data, even if it was saved somewhere. Add Your Remarks
Due to the high volume of this data, both static as well as real time, the analysis and accounting of the Power transactions was not only error prone but a large amount of data was not being processed, as it was almost impossible to do so manually. Even the amount of work which was being done consumed a lot of human and other resources.
For want of a database management tool, the past data was lost and there was no way to extract historical data, even if it was saved somewhere. Add Your Remarks
Tuesday, November 27, 2007
Outline of the Functionalities
To access the DSS (Shakti), double-click on the SLDC HP icon on your Windows Desktop. A welcome screen as shown in the figure below will appear. This screen will stay for some time, but can be made to go away by clicking on the window.
You will be prompted to log in. Enter the User name and password in the window to continue.
User Name : ******
Password : ******
Server : ******
A window will appear on a successful log in. Click on Main in the menu bar and a drop down menu will appear. Click on financial year to choose the year applicable.
On clicking financial year a window as shown below will appear in which the current financial year can be chosen.
The following screen will appear. The following things can be seen in the screen.
1. Date and Revision No. of Drawal Schedule in force at the moment.
2. Drawal Schedule – Clicking on the button will take you to another screen where various revisions for the same day or previous days can be viewed.
3. Entitlement Schedules – Clicking on the button will take you to another screen where entitlement for the same day or previous days can be viewed.
4. Implemented Schedules – Clicking on the button will take you to a screen where the latest available Implemented schedules can be viewed.
5. GoHP Share Entitlement – Clicking on the button will take you to a different screen where GoHP entitlement in various projects can be calculated and viewed.
6. REA Comparison – Clicking on the button will take you to a different screen where GoHP share from various projects as reflected in the Implemented Schedule and All Transaction (Implemented) schedule are compared and displayed.
7. Day Ahead Schedule – Clicking on the button displays the day ahead for the current day and the previous days schedules can also be viewed.
Thus by using “Shakti” automation of the downloading, converting and report creation process has been facilitated, which in turn has made it convenient for the end user to focus on the important task of decision making and let the ICT handle the routine and error prone task of handling and processing the large amount of data. Add Your Remarks
You will be prompted to log in. Enter the User name and password in the window to continue.
User Name : ******
Password : ******
Server : ******
A window will appear on a successful log in. Click on Main in the menu bar and a drop down menu will appear. Click on financial year to choose the year applicable.
On clicking financial year a window as shown below will appear in which the current financial year can be chosen.
The following screen will appear. The following things can be seen in the screen.
1. Date and Revision No. of Drawal Schedule in force at the moment.
2. Drawal Schedule – Clicking on the button will take you to another screen where various revisions for the same day or previous days can be viewed.
3. Entitlement Schedules – Clicking on the button will take you to another screen where entitlement for the same day or previous days can be viewed.
4. Implemented Schedules – Clicking on the button will take you to a screen where the latest available Implemented schedules can be viewed.
5. GoHP Share Entitlement – Clicking on the button will take you to a different screen where GoHP entitlement in various projects can be calculated and viewed.
6. REA Comparison – Clicking on the button will take you to a different screen where GoHP share from various projects as reflected in the Implemented Schedule and All Transaction (Implemented) schedule are compared and displayed.
7. Day Ahead Schedule – Clicking on the button displays the day ahead for the current day and the previous days schedules can also be viewed.
Thus by using “Shakti” automation of the downloading, converting and report creation process has been facilitated, which in turn has made it convenient for the end user to focus on the important task of decision making and let the ICT handle the routine and error prone task of handling and processing the large amount of data. Add Your Remarks
Sunday, September 16, 2007
DSS Shakti : An Overview
The manual capturing and processing of all the required data (online and off line modes from various sources) was almost impossible. When done manually, downloading and analyzing even a small amount of data was a cumbersome process. To further compound to the problem a large amount of data was available at random time points, and it was not possible to humanly track it all the time.
This data was also not available in the required form and to manually convert it into a usable form involved a lot effort on the part of the real time operators, who were already overburdened with the job of ensuring the smooth and safe operation of the Power Grid.
By the use of Shakti, the time taken to download and prepare the required reports was brought down to a minimum and with the least human effort. As soon as the data was available online, the software automatically downloads it, converts and stores it in the database in the required formats. The software also gives an audio alarm to the user to inform him that the data is ready and prepared for use.
Thus, by the use of Shakti, major bottlenecks (large amount of data, unusable formats, random time points, etc.) were removed and efficient decision making was facilitated. All stake holders, who were earlier unaware of the transactions till the reports had been prepared and compiled, can now access the data in real time. Add Your Remarks
This data was also not available in the required form and to manually convert it into a usable form involved a lot effort on the part of the real time operators, who were already overburdened with the job of ensuring the smooth and safe operation of the Power Grid.
By the use of Shakti, the time taken to download and prepare the required reports was brought down to a minimum and with the least human effort. As soon as the data was available online, the software automatically downloads it, converts and stores it in the database in the required formats. The software also gives an audio alarm to the user to inform him that the data is ready and prepared for use.
Thus, by the use of Shakti, major bottlenecks (large amount of data, unusable formats, random time points, etc.) were removed and efficient decision making was facilitated. All stake holders, who were earlier unaware of the transactions till the reports had been prepared and compiled, can now access the data in real time. Add Your Remarks
Thursday, August 2, 2007
Real Time Data
The biggest challenge of for the sensitive project Shakti at SLDC is capturing of real time data on various points. The Real Time and other required information is available online to all the stakeholders and beneficiaries.
HPSEB transaction with various constituents of NRPC are being processed and monitored by the use of “Shakti” software. For example, in the last six months 2086 Million Units of energy worth Rs. 1500 Cr and involving the processing and analysis of more than 27 crore records in respect of Government of Himachal Pradesh were transacted/ dispatched to the states of Punjab, Haryana, Rajasthan and Delhi.
Instantaneous processing of all the required transactions. As the updation and processing of the transaction is real time, therefore there are no time lags or delays in service outcomes.
Online information was put on the public domain of HPSLDC website (http://www.hpsldc.org) for its beneficiaries/stakeholders. Also, information on day ahead basis with respect to the demand and supply position in the state was put on the website for its usage by the consumers of the state. Add Your Remarks
HPSEB transaction with various constituents of NRPC are being processed and monitored by the use of “Shakti” software. For example, in the last six months 2086 Million Units of energy worth Rs. 1500 Cr and involving the processing and analysis of more than 27 crore records in respect of Government of Himachal Pradesh were transacted/ dispatched to the states of Punjab, Haryana, Rajasthan and Delhi.
Instantaneous processing of all the required transactions. As the updation and processing of the transaction is real time, therefore there are no time lags or delays in service outcomes.
Online information was put on the public domain of HPSLDC website (http://www.hpsldc.org) for its beneficiaries/stakeholders. Also, information on day ahead basis with respect to the demand and supply position in the state was put on the website for its usage by the consumers of the state. Add Your Remarks
Tuesday, June 12, 2007
Strategy adopted for DSS Project
To develop software to meet the aforementioned needs, the software (Shakti) was developed by HPSEB in association with DOEACC with three basic objectives:
1.Online downloading of all the relevant data from various sources (NRLDC & NRPC website) on the Internet.
2.Extraction of the relevant information from the data and its storage in the database management tool i.e. ORACLE in this case.
3.Also capturing of data from various online sources viz bilaterals and within the state.
4.Generation of the reports in the required formats to help in the decision making process & issuance of instructions w.r.t. schedules, loadings, drawals etc.
End result:
A Friendly GUI was developed using Visual Basic keeping in mind the needs of the end user and also the advancements expected in the technology in the years to come. Add Your Remarks
1.Online downloading of all the relevant data from various sources (NRLDC & NRPC website) on the Internet.
2.Extraction of the relevant information from the data and its storage in the database management tool i.e. ORACLE in this case.
3.Also capturing of data from various online sources viz bilaterals and within the state.
4.Generation of the reports in the required formats to help in the decision making process & issuance of instructions w.r.t. schedules, loadings, drawals etc.
End result:
A Friendly GUI was developed using Visual Basic keeping in mind the needs of the end user and also the advancements expected in the technology in the years to come. Add Your Remarks
Subscribe to:
Posts (Atom)