Standard and interoperable database for pre-paid electricity metering systems in Bangladesh

Abstract

A generalized database has becn dcsigncd Illr thc prcpaid system to be used for thc uetering purpose in electrical utility organizations. Thc prepaid metering systems currently used under different utility organizations have bccn studied thoroughly. The variations of the databases and systcms from onc utility to other are pointcd out and generalization is dcvised in the ncw dcsign. Considcring thc cxisting prepaid systems the proposed system has becn dcsigncd. In the proposed systcm, a new conccpt of vcnding has bccn cmcrgcd. This is tcrmcd as "Disintegrated Vending Systcm". It has madc thc prcpaid systcm casy and user-friendly. In the proposed system, thc vending units can be cstablished by small business houses, thereby users can easily make their vending at their doorstep. Based on the proposed vcnding systcm. thc gcncralizcd database has bccn designed following the guidclinc dcpicted in ilL 7 Rcfcrcncc Inj(JrInation modcl. Thc design has been completed by drawing thc E-R model for an application. Thc logical design is then ~xtended to physical model which in turn is uscd to dcsign thc table structurcs for thc JlOposed databasc. Finally, the implementation guidelinc of the proposed databasc has been formulated. The software issues during implementation of the designed databasc have also been addressed in this thesis.