Integration of SCADA, GIS, and Call Center Systems for Electrical Power Distribution Management and Planning

In electrical power distribution systems the traditional methods cannot detect the customer fault location in real time and respond to customer complaints at the same time of the outage of the electric power because the required information is scattered among isolated databases. In this paper the combination of Supervisory Control and Data Acquisition (SCADA) and Geographical Information System (GIS) and using SQLCMD against DBSET has been shown to solve this problem better. This paper reducing the response time of the customer waiting when they calling the agent in the call center, creating a model for the integration of real time data in SCADA system against static data in GIS to make online GIS and send data from GIS to CALL CENTER at the same time. The prototype describes the flow of the data between various systems and integrates all in one logical database that contains all data about the customers. The proposed model depends on three major sub-systems: GIS, SCADA, and Call Center systems. The GIS system is base of the model so the change and update in GIS database is available, GIS provides different features like maps, real coordinates and tables. The model contains three different databases, GIS as geo database, SCADA as the real time database and call center as customer information database, all this database will be in one logical global database that contains of spatial information tables, asset information tables, topology information tables, and operation information tables. This method has been shown to significantly improve the accuracy and efficiency of fault detection in distribution networks and to decrease the response time in call centers

Methods To Improve The Accuracy Of One-Terminal Impedance-Based Fault Location On Transmission Lines

Accurate location of faults on overhead transmission lines will facilitate quicker repair, improve system availability and performance, reduce operating costs, and save time and effort of maintenance crew. The objective of this work is to develop new methods to improve the accuracy of one-terminal impedance-based fault location for both single- and double-circuit transmission lines

Pancreatic surgery outcomes: multicentre prospective snapshot study in 67 countries

Background: Pancreatic surgery remains associated with high morbidity rates. Although postoperative mortality appears to have improved with specialization, the outcomes reported in the literature reflect the activity of highly specialized centres. The aim of this study was to evaluate the outcomes following pancreatic surgery worldwide.Methods: This was an international, prospective, multicentre, cross-sectional snapshot study of consecutive patients undergoing pancreatic operations worldwide in a 3-month interval in 2021. The primary outcome was postoperative mortality within 90 days of surgery. Multivariable logistic regression was used to explore relationships with Human Development Index (HDI) and other parameters.Results: A total of 4223 patients from 67 countries were analysed. A complication of any severity was detected in 68.7 percent of patients (2901 of 4223). Major complication rates (Clavien-Dindo grade at least IIIa) were 24, 18, and 27 percent, and mortality rates were 10, 5, and 5 per cent in low-to-middle-, high-, and very high-HDI countries respectively. The 90-day postoperative mortality rate was 5.4 per cent (229 of 4223) overall, but was significantly higher in the low-to-middle-HDI group (adjusted OR 2.88, 95 per cent c.i. 1.80 to 4.48). The overall failure-to-rescue rate was 21 percent; however, it was 41 per cent in low-to-middle-compared with 19 per cent in very high-HDI countries.Conclusion: Excess mortality in low-to-middle-HDI countries could be attributable to failure to rescue of patients from severe complications. The authors call for a collaborative response from international and regional associations of pancreatic surgeons to address management related to death from postoperative complications to tackle the global disparities in the outcomes of pancreatic surgery (NCT04652271; ISRCTN95140761)