2933. High-Access Employees

Problem Description

The goal is to identify employees who have accessed a system frequently within short periods of time. Assuming we have each employee's access records for a single day, we are to determine which of them have accessed the system three or more times within any one-hour period.

To clarify, the period must be less than or equal to 60 minutes, but cannot span across the start and end of the day. For example, times such as "0815" and "0915" are not considered within the same hour, and neither are times like "0005" and "2350" since they are at the start and end of the day, respectively.

We are presented with a 2D array access_times, where each entry contains an employee's name and their access time. The access time is given in 24-hour format without a colon, so "0800" represents 8:00 AM and "2250" represents 10:50 PM. We need to return a list of names of employees who are considered high-access, without any specific order of the names.

Intuition

To solve this problem, we use a hashmap (or in Python, a defaultdict) to group all access times by the employee’s name. The keys in this hashmap are the names of the employees, and the corresponding values are lists containing all their access times converted to minutes since midnight. This conversion simplifies the comparison of times by translating all access times into a single numerical format.

Once we've grouped all the access times for each employee, the next step is to sort these times in ascending order to easily check for any instances where three or more accesses occurred within a 60-minute window.

After sorting, we iterate over the access times for each employee. If at any point we find three consecutive times t1, t2, and t3 such that t3 - t1 is less than 60 minutes, it implies that those accesses happened within the same one-hour period, and we can conclude that the employee is a 'high-access' employee.

The intuition behind this approach is that if an employee has accessed the system three or more times in any one-hour period, sorting the times makes it straightforward to check for a 60-minute window containing at least three timestamps.

In summary, the solution involves:

1. Grouping and converting all access times to a numerical format.
2. Sorting the access times to identify potential one-hour periods.
3. Checking for the presence of three accesses within these periods for each employee.
4. Collecting the names of employees who meet the 'high-access' criteria.

Learn more about Sorting patterns.

Solution Approach

The solution uses a hash table (specifically a defaultdict from Python's collections module), which is an ideal data structure for grouping elements based on a key. In this implementation, the key for the hash table is the employee's name, and the value is a list of their access times in minutes.

The first step is iterating over the access_times array to build the hash table with the employees and their respective access times. Within this loop, we convert the access time to minutes by taking the first two characters of the access time string as hours, converting them to an integer and multiplying by 60 to obtain the equivalent minutes, and adding the minutes, which are obtained by converting the last two characters of the access time string to an integer.

Now, the key aspect of this solution is to sort the times to make the checks for the one-hour period straightforward. Sorting ensures that we can look at each consecutive triplet of access times to check if they are within 60 minutes of each other.

After sorting each employee's access times, we loop through the sorted times and use a sliding window approach to check for consecutive triplets. The sliding window comprises three consecutive elements at a time because we are interested in periods where there are at least three accesses.

We check if the difference between the first and the third access time in the sliding window is less than 60 minutes. If this condition is true for any triplet, the employee's name is added to the ans list which records the names of high-access employees.

The final step is to return the list ans, containing all the high-access employee names identified by the algorithm.

Here's the approach translated into pseudo code:

1. Initialize hash table d for grouping access times by employee names.
2. For each name and time in access_times:
   • Calculate total minutes from 00:00 and group it under the equivalent employee name in d.
3. Initialize ans as an empty list to store results.
4. For each employee name and its access times in d:
   • Sort the list of times.
   • For i from 2 to the length of the list of times:
     • If the time at index i minus time at index i - 2 is less than 60:
       • Add employee name to ans.
5. Return the ans list.

By combining the hash table for organization, the sorting for temporal ordering, and a simple iteration with conditional checks, we elegantly solve the problem without the need for complex algorithms. This approach is efficient as it takes advantage of the easily sortable nature of times and the straightforward conditions set by the problem to identify high-access employees.

Example Walkthrough

Let's take an example access records data:

1Alice 0800
2Bob   0830
3Alice 0835
4Carol 0855
5Alice 0900
6Bob   0840
7Carol 0905
8Bob   0920
9Carol 0950
10Alice 0915

Following the solution approach, we'll process the records:

1. Initialize hash table d for grouping access times by employee names. d would look like this after processing:

   1{
   2  "Alice": [],
   3  "Bob": [],
   4  "Carol": []
   5}

2. For each name and time in access_times: We convert access times for Alice, Bob, and Carol to minutes: Alice's times: [480, 515, 540, 555] (8:00 AM, 8:35 AM, 9:00 AM, 9:15 AM) Bob's times: [510, 540, 560] (8:30 AM, 9:00 AM, 9:20 AM) Carol's times: [535, 545, 590] (8:55 AM, 9:05 AM, 9:50 AM)

   Now, d would look like this:

   1{
   2  "Alice": [480, 515, 540, 555],
   3  "Bob": [510, 540, 560],
   4  "Carol": [535, 545, 590]
   5}

3. Initialize ans as an empty list to store results. ans = []

4. For each employee name and its access times in d:

   • Sort the list of times. (In our case, times are already sorted)
   • Loop through each employee's times checking for a window where three accesses are within 60 minutes.

   For Alice:

   • We check at index 2 (540) - index 0 (480) = 60 minutes, but we need less than 60.
   • Move to next window and check index 3 (555) - index 1 (515) = 40 minutes. It's within 60 minutes, so we identify Alice as a high-access employee and add her to ans.

   For Bob:

   • We check at index 2 (560) - index 0 (510) = 50 minutes. It's within 60 minutes, so we add Bob to ans.

   For Carol:

   • Since there are only three records and the difference between the last and first is greater than 60 minutes (590 - 535 = 55 minutes), Carol is not added.

So the ans list after the checks:

1["Alice", "Bob"]

5. Return the ans list. The returned result is the list of employees who accessed the system three or more times in any one-hour period. For our example, the final output is:

   1["Alice", "Bob"]

Through this example, we've illustrated how the solution approach effectively identifies 'high-access' employees by leveraging a hash table, sorting, and a sliding window check.

Solution Implementation

Time and Space Complexity

Time Complexity

The time complexity of the algorithm is composed of several parts:

1. Creating the defaultdict for employees' access times — This takes O(n) time where n is the number of access records, as we loop through the access_times list once.

2. Casting times to minutes and appending to the list in the dictionary — Each conversion takes constant time, so with n access records this part is also O(n).

3. Sorting the timestamps for each employee — Sorting is commonly O(k \times log(k)) where k is the number of timestamps for an employee. As we need to perform this for all employees, the total time is O(m \times k \times log(k)) where m is the number of unique employees. In the worst case, where all timestamps belong to the same employee, this is equivalent to O(n \log n).

4. Checking within each sorted list for the violation condition — We iterate over sorted timestamps for each employee which could be at worst O(n) if all timestamps are for a single employee. However, since the comparison is a constant time operation, it does not change the sorting time complexity we calculated earlier.

Hence, we combine the time complexities: O(n) + O(n \log n) which simplifies to O(n \log n) because O(n \log n) is the dominant term.

Space Complexity

The space complexity can be analyzed as follows:

1. The dictionary storing employee names and their access times — If m is the number of unique employees and k is the average number of access timestamps per employee, the space complexity would be O(m \times k). However, as m \times k is essentially n, we get O(n) space complexity.

2. The sorted list of timestamps — This doesn't take additional space beyond what is used in the dictionary as it sorts the timestamps in place.

3. The answer list — In the worst case, where every employee name is added to the answer list, the space complexity would again be O(m), which is a subset of O(n).

Combining all parts, the space complexity of this algorithm is O(n).

Learn more about how to find time and space complexity quickly using problem constraints.