Off-line log system
First Claim
1. A method to prevent corruption of a central database associated with a server using a plurality of off-line databases associated with a plurality of off-line devices, the method comprising:
- receiving a response to a question in a questionnaire;
based on the response, editing a log in an off-line database in the plurality of off-line databases, the log indicating a received response to the questionnaire, the log comprising at least one record, wherein a record comprises at least one of a name, an age, a gender, a region of origin, a barcode ID, or a radio frequency ID;
storing in the off-line database a timeseries of the log comprising an edited value of the log and a time said editing occurred;
correcting the timeseries of the log by analyzing changes in the log over time, and removing a value of an abnormal log significantly different from values of the abnormal log'"'"'s temporal neighbors;
synchronizing the log with a different database comprising at least one of the central database or a second off-line database in the plurality of off-line databases, the different database including a second timeseries comprising a second value and a second time associated with the second value; and
preventing corruption of the different database by determining a correct ID unique to the off-line database and the different database to associate with the log, said preventing corruption comprising;
determining a time variability of the log, the time variability indicating a period of time during which the log is expected to remain unchanged;
when the time of the timeseries and the second time of the second timeseries are within the time variability of the log and the edited value of the log and the second value are substantially identical, indicating that the timeseries and the second timeseries correspond to a same ID; and
when the time of the timeseries and the second time of the second timeseries are within the time variability of the edited log, and the edited value of the log and the second value are substantially different, indicating that the timeseries and the second timeseries need to be associated with different IDs.
2 Assignments
0 Petitions
Accused Products
Abstract
Introduced are systems and methods that enable modification of logs in multiple off-line databases. Multiple off-line devices can mistakenly associate different respondents with the same identification (ID) unique to the system. When the multiple off-line devices synchronize with each other, or synchronize with a server hosting the central database, the software running on the off-line devices, or on the server detects that the modified logs come from different respondents, and the software assigns two different IDs unique to system to the logs. In another embodiment, multiple off-line devices can mistakenly associate the same respondent with two different IDs unique to the system. When the multiple off-line devices synchronize with each other or with the server, the software running on the off-line devices, or the server detects that the modified logs come from the same respondent, and the software assigns the logs to the same ID unique to system.
-
Citations
29 Claims
-
1. A method to prevent corruption of a central database associated with a server using a plurality of off-line databases associated with a plurality of off-line devices, the method comprising:
-
receiving a response to a question in a questionnaire; based on the response, editing a log in an off-line database in the plurality of off-line databases, the log indicating a received response to the questionnaire, the log comprising at least one record, wherein a record comprises at least one of a name, an age, a gender, a region of origin, a barcode ID, or a radio frequency ID; storing in the off-line database a timeseries of the log comprising an edited value of the log and a time said editing occurred; correcting the timeseries of the log by analyzing changes in the log over time, and removing a value of an abnormal log significantly different from values of the abnormal log'"'"'s temporal neighbors; synchronizing the log with a different database comprising at least one of the central database or a second off-line database in the plurality of off-line databases, the different database including a second timeseries comprising a second value and a second time associated with the second value; and preventing corruption of the different database by determining a correct ID unique to the off-line database and the different database to associate with the log, said preventing corruption comprising; determining a time variability of the log, the time variability indicating a period of time during which the log is expected to remain unchanged; when the time of the timeseries and the second time of the second timeseries are within the time variability of the log and the edited value of the log and the second value are substantially identical, indicating that the timeseries and the second timeseries correspond to a same ID; and when the time of the timeseries and the second time of the second timeseries are within the time variability of the edited log, and the edited value of the log and the second value are substantially different, indicating that the timeseries and the second timeseries need to be associated with different IDs.
-
-
2. A method comprising:
-
receiving a response to a question in a questionnaire; based on the response modifying a log in an off-line database in a plurality of off-line databases, said modifying comprising creating a new log in the off-line database or editing an existing log in the off-line database, the log indicating a received response to the questionnaire; storing in the off-line database the log including a timeseries of the log comprising a modified value of the log and a time said modifying occurred; correcting the timeseries of the log by analyzing changes in the log over time, and removing a value of an abnormal log significantly different from values of the abnormal log'"'"'s temporal neighbors; synchronizing the log with a different database comprising at least one of a central database or a second off-line database in the plurality of off-line databases, the different database including a second timeseries comprising a second value and a second time associated with the second value; and preventing corruption of the different database by determining a correct ID unique to the off-line database and the different database to associate with the log, said preventing corruption comprising; determining a time variability of the modified log, the time variability indicating a period of time during which the log is expected to remain unchanged; when the time of the timeseries and the second time of the second timeseries are within the time variability of the modified log and the modified value and the second value are substantially identical, indicating that the timeseries and the second timeseries correspond to a same ID; and when the time of the timeseries and the second time of the second timeseries are within the time variability of the modified log, and the modified value and the second value are substantially different, indicating that the timeseries and the second timeseries need to be associated with different IDs. - View Dependent Claims (3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. A system comprising:
-
a central database associated with a server; a plurality of off-line databases associated with a plurality of off-line devices; a processor; a storage medium storing computer-executable instructions that, when executed by the processor, cause the system to perform a computer-implemented operation, the instructions comprising; instructions for receiving a response to a question in a questionnaire; instructions for based on the response modifying a log in an off-line database in the plurality of off-line databases, said modifying comprising creating a new log in the off-line database or editing an existing log in the off-line database, the log indicating a received response to the questionnaire; instructions for storing in the off-line database a timeseries of the log comprising a modified value of the log and a time said modifying occurred; instructions for storing correcting the timeseries of the log by analyzing changes in the log over time, and removing a value of an abnormal log significantly different from values of the abnormal log'"'"'s temporal neighbors; instructions for synchronizing the log with a different database comprising at least one of the central database or a second off-line database in the plurality of off-line databases, the different database comprising a second timeseries comprising a second value and a second time associated with the second value; and instructions for preventing corruption of the different database by determining a correct ID unique to the off-line database and the different database to associate with the log, the instructions comprising; instructions for determining a time variability of the modified log, the time variability indicating a period of time during which the log is expected to remain unchanged; when the time of the timeseries and the second time of the second timeseries are within the time variability of the modified log and the modified value and the second value are substantially identical, instructions for indicating that the timeseries and the second timeseries correspond to a same ID; and when the time of the timeseries and the second time of the second timeseries are within the time variability of the modified log, and the modified value and the second value are substantially different, instructions for indicating that the timeseries and the second timeseries need to be associated with different IDs. - View Dependent Claims (17, 18, 19, 20, 21, 22, 23, 24, 25, 27, 28, 29)
-
-
26. The system of 16, comprising:
-
instructions for generating a large random number; and instructions for generating a first ID associated with the log by a device associated with the off-line database by combining a device ID, a time when collection of the log started, and the large random number.
-
Specification