DefinePK

Abstract

One of the services that DNV GL Netherlands provides to its customers is to continuously monitor distribution cable circuits for upcoming defects. This system monitors over 100 circuits with an average of 5 discharges per circuit per minute. Regardless of the amount of circuits and pulse discharges per minute, the system should be able to complete all processes within one hour or even less. Meanwhile, the current database design using SQL Server cannot adapt to the new requirement of the user and low query performance for inserting and retrieving Partial Discharges (PD) data. Thus, to meet the new requirements, database remodeling should be done. To increase query performance for inserting and retrieving PD data, a new design to store PD data were introduced with remodel database structure and implementing partitioning.