Database file management and data structures for creating and/or modifying a database management system to reduce storage requirements
One or more embodiments described herein relate to database and data structure management to improve the storage capabilities and processing accuracy of location data for compliance monitoring. In known database systems, the quantity of location data available and/or collected can pose storage and/or processing challenges. Some embodiments described herein relate to the management of databases and/or data structures, including when data is created, modified, and/or deleted, to improve storage efficiency and/or relevance of stored data. One or more systems and methods described herein may automate the process of monitoring, collecting, storing, analyzing, and utilizing data and information.
1. A system for tracking movements of a user that increases processing efficiency of a computer database, the system comprising:
at least one network interface configured to be communicatively coupled to each device from a plurality of devices and including a location sensor;
a memory, including the computer database; and
a processor communicatively coupled to the network interface and the memory;
the processor being configured to:
receive, using the at least one network interface, tracking information from the location sensor of a first device from the plurality of devices, the tracking information identifying a location of a user at a particular time;
retrieve, from the memory an indicator of a window size, a maximum gap size, and a discard threshold;
applying a moving filter having the window size to form a reduced record set, the moving filter:
deleting records where the tracking information stored in a record indicates that the user has moved less than the discard threshold, and
preserving at least one record when the tracking information of the maximum gap size is not exceeded,
retrieve, from the memory, a plurality of compliance rules;
apply the plurality of compliance rules to the reduced record set to form user tracking data; and
store the user tracking data in the computer database.
2. The system of claim 1 , wherein the first device is a mobile device, a personal computer, a tablet computer, or a wearable computer.
3. The system of claim 1 , wherein the processor is configured to retrieve the tracking information from the location sensor based on event triggers.
4. The system of claim 1 , wherein the tracking information further includes a device identifier associated with the first device.
5. The system of claim 1 , wherein the user tracking data is retrievable via a website.
6. The system of claim 1 , wherein the processor is further configured to:
send, using the at least one network interface, an alert to the user when the user tracking data indicates a violation of a compliance rule from the plurality of compliance rules.
7. The system of claim 1 , wherein the location sensor determines the location tracking information based on at least one of the following: global positioning system (GPS) information, Wi-Fi data, cell tower triangulation, wireless network data, user generated location information, compass data, orientation data, gyroscope data, and accelerometer data.
8. The system of claim 1 , wherein the tracking information further includes an indication of accuracy of the location sensor.
9. The system of claim 8 , wherein the processor further:
deletes records from the database based on the indication of accuracy.
10. A method for tracking movements of a user that increases processing efficiency of a computer database, the method comprising:
receiving, by a processor, first location tracking information from a location sensor of a device, the tracking information identifying a location of a user associated with the device at a particular time;
storing, by the processor, the tracking information for the user in the computer database;
retrieving, by the processor, a window size, a maximum gap size and a discard threshold from a memory;
deleting, by the processor, records in the computer database for the user by applying a moving filter having the window size to form a reduced record set, the moving filter:
deleting records where the tracking information stored in a record indicates that the user has moved less than the discard threshold, and
preserving at least one record when the tracking information of the maximum gap size is not exceeded,
retrieving, by the processor, a plurality of compliance rules from the memory;
applying, by the processor, the plurality of compliance rules to the reduced record set to form user tracking data; and
storing, by the processor, the user tracking data in the computer database.
11. The method of claim 10 , wherein the device is a mobile device, a personal computer, a tablet computer, or a wearable computer.
12. The method of claim 11 , wherein the location sensor determines the location tracking information based on at least one of the following: global positioning system (GPS) information, Wi-Fi data, cell tower triangulation, wireless network data, user generated location information, compass data, orientation data, gyroscope data, and accelerometer data.
13. The method of claim 10 , wherein the processor is configured to retrieve the tracking information from the location sensor based on event triggers.
14. The method of claim 10 , wherein the tracking information further includes an indication of accuracy of the location sensor.
15. The method of claim 14 , wherein the method further comprises:
deleting, by the processor, records from the database based on the indication of accuracy.