IP Library › Granted Patent US 11,960,599
Granted Patent B2
US 11,960,599 · App. 17/186,220 · Granted Apr 16, 2024

Classifying users of a database

Inventors: Ofer Haim Biller (Neve Boker, IL); Oded Sofer (Midreshet Ben Gurion, IL)
Assignee: International Business Machines Corporation
G06F21/552G06F11/34G06F11/3423G06F17/14G06F18/214G06N20/00G06F2201/80
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,960,599
App. No.
17/186,220
Granted
Apr 16, 2024
Kind
B2
Abstract

A computer-based system and method for classifying users of a database including obtaining an activity rate time series describing activity level of a database user versus time, extracting features from the activity rate time series, the features including a measure of repetition in the activity level, mean activity load and a percentage of the time in which the user is active, and determining a type of the database user based on the extracted at least one feature. The measure of repetition in the user activity is calculated by performing a Fourier transform on the activity rate time series to produce a transformed series; detecting spikes in the transformed series; and measuring a percentage of information in the transformed series which is included in the spikes.

Claims (52)

1. A method for classifying users of a database, the method comprising:

obtaining an activity rate time series describing activity level of a database user versus time;

extracting at least one feature from the activity rate time series, wherein the at least one feature comprises a measure of repetition in the activity level;

determining a type of the database user based on the extracted at least one feature; and

wherein determining the type of the database user comprises determining if the user is a direct user or an application user, wherein the application user aggregates activity of multiple users of the application.

2. The method of claim 1 , wherein the at least one feature further comprises at least one of a mean activity load and a percentage of the time in which the user is active.

3. The method of claim 2 , wherein the measure of repetition in the user activity is calculated by:

performing a Fourier transform on the activity rate time series to produce a transformed series;

detecting spikes in the transformed series; and

measuring a percentage of information in the transformed series which is included in the spikes.

4. The method of claim 3 , wherein the spikes are detected by:

applying a convolution with a smoothing kernel to the transformed series to produce a resultant series; and

determining that a value in the transformed series is a spike if the resultant series is lower than the transformed series by a predetermined factor.

5. The method of claim 1 , comprising:

obtaining a plurality of labeled activity rate time series;

training a machine learning model using the labeled activity rate time series; and

using the trained machine learning model to determine the type of the user based on the extracted features.

6. The method of claim 5 , wherein the machine learning model is a linear regression model.

7. The method of claim 1 , comprising:

applying a first security policy if the user is a first type of user and a second security policy if the user is a second type of user.

8. The method of claim 1 , comprising:

assigning a first significance level to security events associated with a first type of users and a second significance level to security events associated with a second type of user.

9. A method for determining a type of a user of a database, the method comprising:

obtaining a time series describing an activity volume of the user versus time;

extracting a plurality of features from activity rate time series, wherein at least one feature comprises a measure of repetitive behavior of the user;

classifying user to user types based on the extracted feature; and

wherein classifying the user to user types comprises determining if the user is a direct user or an application user, wherein the application user aggregates activity of multiple users of the application.

10. A system for monitoring of movement of data in a computer network, the system comprising:

a memory; and

a processor configured to:

obtain an activity rate time series describing activity level of a database user versus time;

extract at least one feature from the activity rate time series, wherein the at least one feature comprises a measure of repetition in the activity level;

determine a type of the database user based on the extracted at least one feature; and

wherein the processor is configured to determine if the user is a direct user or an application user, wherein the application uses the database user for aggregating activity of multiple users of the application.

11. The system of claim 10 , wherein the at least one feature further comprises at least one of a mean activity load and a percentage of the time in which the user is active.

12. The system of claim 11 , wherein processor is configured to calculate the measure of repetition in the user activity by:

performing a Fourier transform on the activity rate time series to produce a transformed series;

detecting spikes in the transformed series; and

measuring a percentage of information in the transformed series which is included in the spikes.

13. The system of claim 12 , wherein processor is configured to detect the spikes by:

applying a convolution with a smoothing kernel to absolute values of the transformed series to produce a resultant series; and

determining that a value in the transformed series is a spike if the resultant series is lower than the transformed series by a predetermined factor.

14. The system of claim 10 , wherein processor is configured to:

obtain a plurality of labeled activity rate time series;

train a machine learning model using the labeled activity rate time series; and

use the trained machine learning model to determine the type of the user based on the extracted features.

15. The system of claim 14 , wherein the machine learning model is a linear regression model.

16. The system of claim 10 , wherein processor is configured to:

apply a first security policy if the user is a first type of user and a second security policy if the user is a second type of user.

17. The system of claim 10 , wherein processor is configured to:

assign a first significance level to security events associated with a first type of users and a second significance level to security events associated with a second type of user.

18. The system of claim 10 , wherein the processor is further configured to determine if the user is a machine user.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 1, 2021
From: BILLER, OFER HAIM; SOFER, ODED
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 055439/0398 →
Continuity (1)
Related Publication 20220277074A1 · Sep 1, 2022