Abstract: System and method for detecting anomalies in the recorded consumption of data volume and charging of data services in a communication network is described. Data records for each session may be captured from multiple sources. The data records may comprise parameters indicating usage volume pertaining to services being consumed for each session. Further, the data records may be aggregated and reconciled to detect volume gap in each session. Each session may be categorized into a session category based upon the detection of the volume gap. The data records may further be enriched by tagging each data record with the session category. The data records enriched may then be aggregated across the parameters. Finally, a root-cause parameter for the volume gap pertaining to each session may be identified by computing a total volume, a total volume gap and a probability of gap root-cause for each parameter using the aggregated data records.
Abstract: The present invention relates to a system, method and computing apparatus to isolate a database in a database system. The disclosure of the present invention enables more efficient and more secured implementation of “database isolation” in a multi-tenant or multi-user database system storing service data belonging to different users. The user identifier(s) are extracted from the default database, creating a user table according to the extracted user identifier(s), creating a service table in the main database with owner user identifier column and owner group identifier column inserted, it can efficiently create view to a user when the user requests to access the service data which the user owns or the user is authorized to access. The created service table with owner user identifier column and owner group identifier column inserted achieve database isolation at database level, and the created view achieves database isolation at application level.