CA3144129A1 - User access data processing method, device and computer system - Google Patents
User access data processing method, device and computer system Download PDFInfo
- Publication number
- CA3144129A1 CA3144129A1 CA3144129A CA3144129A CA3144129A1 CA 3144129 A1 CA3144129 A1 CA 3144129A1 CA 3144129 A CA3144129 A CA 3144129A CA 3144129 A CA3144129 A CA 3144129A CA 3144129 A1 CA3144129 A1 CA 3144129A1
- Authority
- CA
- Canada
- Prior art keywords
- access
- codes
- date
- access data
- code
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title abstract description 3
- 238000000034 method Methods 0.000 claims abstract description 32
- 238000012545 processing Methods 0.000 claims description 18
- 238000007405 data analysis Methods 0.000 abstract description 5
- 238000012423 maintenance Methods 0.000 abstract description 2
- 230000006399 behavior Effects 0.000 description 6
- 238000005192 partition Methods 0.000 description 6
- 238000004891 communication Methods 0.000 description 4
- 238000012216 screening Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The present application makes public a user access data processing method, device and computer system. The method comprises: obtaining first access data, wherein the access data includes user codes, access dates and target dimension values; generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds; and generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond. The present application merges user access data according to access dates and target dimension values, merges plural pieces of primary first access data and generates an access record, greatly reduces data volumes of historical user data, enhances data analysis efficiency, and can update the new access data, when subsequently generated, into the access record by updating date codes, thus ensuring subsequent maintenance efficiency.
Description
USER ACCESS DATA PROCESSING METHOD, DEVICE AND COMPUTER
SYSTEM
BACKGROUND OF THE INVENTION
Technical Field [0001] The present invention relates to the field of data processing, and more particularly to a method of and a device for processing user access data, and a corresponding computer system.
Description of Related Art
SYSTEM
BACKGROUND OF THE INVENTION
Technical Field [0001] The present invention relates to the field of data processing, and more particularly to a method of and a device for processing user access data, and a corresponding computer system.
Description of Related Art
[0002] With the development of data analysis technology, user behavior data indices exert an essential function on decisions and operations of enterprises. However, in order to collect and analyze user behavior data indices, it is required to compare incremental data with historically associated data. Nonetheless, the historical user behavior data is usually not processed, and stored in different partitions. Therefore, whenever it is required to extract historically associated data, the corresponding user behavior data should be extracted from each partition, and subsequently processed to generate historically associated data.
However, as there are large quantities of details in the log domain of the partition, large quantities of TO resources are consumed in reading; moreover, large quantities of CPU
computational resources are also consumed in the data processing process, and the time consumed is very long.
SUMMARY OF THE INVENTION
However, as there are large quantities of details in the log domain of the partition, large quantities of TO resources are consumed in reading; moreover, large quantities of CPU
computational resources are also consumed in the data processing process, and the time consumed is very long.
SUMMARY OF THE INVENTION
[0003] In order to address the deficiencies in the state of the art, main objectives of the present invention are to provide a method of and a device for processing user access data, and a corresponding computer system, so as to solve the aforementioned problems pending in Date Recue/Date Received 2021-12-29 prior-art technology.
[0004] In order to achieve the above objectives, according to the first aspect, the present invention provides a method of processing user access data, and the method comprises:
[0005] obtaining first access data, wherein the access data includes user codes, access dates and target dimension values;
[0006] generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds; and
[0007] generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond.
[0008] In some embodiments, the step of generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds, includes:
[0009] generating an initial code, wherein the initial code includes coding bits for recording code values;
[0010] obtaining and sorting access dates, to which the first access data with identical user codes and target dimension values corresponds, and determining a sorting order to which each of the obtained access dates corresponds;
[0011] determining a coding bit to which each of the obtained access dates corresponds according to the sorting orders to which the obtained access dates correspond;
[0012] setting the code value of the corresponding coding bit included in the initial code as a second code value, and setting code values of coding bits except for the corresponding coding bit as first code values; and
[0013] determining the set initial code as a corresponding date code.
[0014] In some embodiments, the method comprises:
[0015] obtaining second access data;
[0016] determining a target access record that contains target dimension values and user codes Date Recue/Date Received 2021-12-29 included in the second access data as a target access record to which the second access data corresponds;
[0017] generating updated date codes according to access dates to which the second access data corresponds and date codes to which the corresponding target access record corresponds;
and
and
[0018] updating the date codes to which the corresponding target access record corresponds as the updated date codes.
[0019] In some embodiments, the step of obtaining first access data includes:
[0020] obtaining user primary access data from a datasheet to be processed;
and
and
[0021] generating the first access data according to user codes, access dates and target dimension values to which target dimensions correspond included in the user primary access data.
[0022] In some embodiments, the date code is a binary code.
[0023] In some embodiments, the method comprises:
[0024] counting the number of second code values included in each of the date codes, and generating a first statistic value;
[0025] counting the number of consecutive second code values included in each of the date codes, and generating a second statistic value; and
[0026] visually displaying the first statistic value and the second statistic value.
[0027] According to the second aspect, the present application provides a device for processing user access data, and the device comprises:
[0028] an obtaining module, for obtaining first access data, wherein the access data includes user codes, access dates and target dimension values;
[0029] a coding module, for generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds; and Date Recue/Date Received 2021-12-29
[0030] a generating module, for generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond.
[0031] In some embodiments, the coding module is further usable for generating an initial code, wherein the initial code includes coding bits for recording code values;
obtaining and sorting access dates, to which the first access data with identical user codes and target dimension values corresponds, and determining a sorting order to which each of the obtained access dates corresponds; determining a coding bit to which each of the obtained access dates corresponds according to the sorting order to which each access date corresponds; setting the code value of the corresponding coding bit included in the initial code as a second code value, and setting code values of coding bits except for the corresponding coding bit as first code values; and determining the set initial code as a corresponding date code.
obtaining and sorting access dates, to which the first access data with identical user codes and target dimension values corresponds, and determining a sorting order to which each of the obtained access dates corresponds; determining a coding bit to which each of the obtained access dates corresponds according to the sorting order to which each access date corresponds; setting the code value of the corresponding coding bit included in the initial code as a second code value, and setting code values of coding bits except for the corresponding coding bit as first code values; and determining the set initial code as a corresponding date code.
[0032] In some embodiments, the device further comprises a counting module and a displaying module, wherein the counting module is employed for counting the number of second code values included in each of the date codes, and generating a first statistic value, and counting the number of consecutive second code values included in each of the date codes, and generating a second statistic value; and the displaying module is employed for visually displaying the first statistic value and the second statistic value.
[0033] According to the third aspect, the present application provides a computer system, and the system comprises:
[0034] one or more processor(s); and
[0035] a memory, associated with the one or more processor(s), wherein the memory is employed to store a program instruction, and the program instruction performs the following operations when it is read and executed by the one or more processor(s):
[0036] obtaining first access data, wherein the access data includes user codes, access dates and target dimension values;
Date Recue/Date Received 2021-12-29
Date Recue/Date Received 2021-12-29
[0037] generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds; and
[0038] generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond.
[0039] The present invention achieves the following advantageous effects.
[0040] The present application proposes a method of processing user access data, which method comprises obtaining first access data, wherein the access data includes user codes, access dates and target dimension values; generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds; and generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond.
The present application merges access data of users according to access dates and target dimension values, whereby plural pieces of primary first access data are merged and an access record is generated, data volumes of historical user data are greatly reduced, data analysis efficiency is enhanced, and it is made possible, when new access data is subsequently generated, to update the new access data into the access record by updating date codes, thus ensuring subsequent maintenance efficiency.
The present application merges access data of users according to access dates and target dimension values, whereby plural pieces of primary first access data are merged and an access record is generated, data volumes of historical user data are greatly reduced, data analysis efficiency is enhanced, and it is made possible, when new access data is subsequently generated, to update the new access data into the access record by updating date codes, thus ensuring subsequent maintenance efficiency.
[0041] Moreover, the present application further proposes that the step of obtaining first access data includes: obtaining user primary access data from a datasheet to be processed; and generating the first access data according to user codes, access dates and target dimension values to which target dimensions correspond included in the user primary access data.
By extracting such data as target dimension values from the primary access data in advance and basing on the extracted data to generate a target access record, the present application avoids the situation in which it is required at each round of data analysis to extract primary data from various partitions for processing, thereby enhancing data reading/writing efficiency.
Date Recue/Date Received 2021-12-29 BRIEF DESCRIPTION OF THE DRAWINGS
By extracting such data as target dimension values from the primary access data in advance and basing on the extracted data to generate a target access record, the present application avoids the situation in which it is required at each round of data analysis to extract primary data from various partitions for processing, thereby enhancing data reading/writing efficiency.
Date Recue/Date Received 2021-12-29 BRIEF DESCRIPTION OF THE DRAWINGS
[0042] To more clearly describe the technical solutions in the embodiments of the present invention, drawings required to illustrate the embodiments will be briefly introduced below. Apparently, the drawings introduced below are merely directed to some embodiments of the present invention, while persons ordinarily skilled in the art may further acquire other drawings on the basis of these drawings without spending creative effort in the process.
[0043] Fig. 1 is a view schematically illustrating a data processing flow provided by the embodiments of the present application;
[0044] Fig. 2 is a flowchart illustrating the method provided by the embodiments of the present application;
[0045] Fig. 3 is a view illustrating the structure of the device provided by the embodiments of the present application; and
[0046] Fig. 4 is a view illustrating the structure of the computer system provided by the embodiments of the present application.
DETAILED DESCRIPTION OF THE INVENTION
DETAILED DESCRIPTION OF THE INVENTION
[0047] To make more lucid and clear the objectives, technical solutions and advantages of the present invention, the technical solutions in the embodiments of the present invention will be clearly and comprehensively described below with reference to the accompanying drawings in the embodiments of the present invention. Apparently, the embodiments as described are merely partial, rather than the entire, embodiments of the present invention.
Any other embodiments makeable by persons ordinarily skilled in the art on the basis of the embodiments in the present invention without creative effort shall all fall within the Date Recue/Date Received 2021-12-29 protection scope of the present invention.
Any other embodiments makeable by persons ordinarily skilled in the art on the basis of the embodiments in the present invention without creative effort shall all fall within the Date Recue/Date Received 2021-12-29 protection scope of the present invention.
[0048] As noted in the Description of Related Art, historical behavior data of users is often stored unprocessed in data partitions in the state of the art, and it is required during reading to extract and process corresponding primary user behavior data from each partition, whereby not only reading/writing resources are wasted, but great quantities of CPU
computational resources are also consumed.
computational resources are also consumed.
[0049] To solve the above technical problems, the present application proposes a method of processing user access data, merges access data of users according to access dates and target dimension values, whereby plural pieces of primary first access data are merged and an access record is generated, data volumes of historical user data are greatly reduced, and data analysis efficiency is enhanced.
Embodiment 1
Embodiment 1
[0050] Specifically, as shown in Fig. 1, the process of processing data by employing the aforementioned method includes the following steps.
[0051] Step 1 ¨ screening and obtaining corresponding access data from a datasheet to be processed according to preset screening rules.
[0052] Table 1 illustrates an exemplary datasheet to be processed, including dimension values to which dimensions A-E respectively correspond, member codes and browse dates.
Exemplarily, when it is prescribed in the screening rules that dimension values to which dimensions A, B, C respectively correspond, member codes and browse dates are required to be obtained, the access data as obtained is as shown in Table 2. The screening rules can be determined according to specific business requirements.
Date Recue/Date Received 2021-12-29 Dimension Dimension Dimension Dimension Dimension Member Browse A B C D E Code Date Table 1 Table 2 Dimension A Dimension B Dimension C Member Code Browse Date
Exemplarily, when it is prescribed in the screening rules that dimension values to which dimensions A, B, C respectively correspond, member codes and browse dates are required to be obtained, the access data as obtained is as shown in Table 2. The screening rules can be determined according to specific business requirements.
Date Recue/Date Received 2021-12-29 Dimension Dimension Dimension Dimension Dimension Member Browse A B C D E Code Date Table 1 Table 2 Dimension A Dimension B Dimension C Member Code Browse Date
[0053] Step 2 ¨ merging access data with identical user codes and identical target dimension Date Recue/Date Received 2021-12-29 values of each dimension.
[0054] Table 3 illustrates an intermediate table after such merging. After merging, the browse date fields in each data row are generated in the form of an array of ARRAY<string>, target dimension values and member codes are primary keys, and corresponding browse dates are array elements. Specifically, each of the browse date fields in the array can be processed in the form of an orderly list through a corresponding array sorting function.
Table 3 Dimension A Dimension B Dimension C Member Code Browse Date A01 B001 C000001 100001 20190701, 20190702, A01 B002 C000003 100002 20190701, 20190704, 20190705,
Table 3 Dimension A Dimension B Dimension C Member Code Browse Date A01 B001 C000001 100001 20190701, 20190702, A01 B002 C000003 100002 20190701, 20190704, 20190705,
[0055] Step 3 ¨ converting browse date(s) contained in each data row into code value(s) according to preset conversion logic.
[0056] Specifically, the code value can be binary. It is possible to base on the sorted orderly browse dates to determine the latest date and the earliest date therefrom, and base on the number of days between the earliest date and the latest date to determine the bit(s) required to be contained in the code value. Subsequently, the coding bit to which each browse date corresponds is determined according to the bit(s) required to be contained Date Recue/Date Received 2021-12-29 and the sorting order to which each browse date corresponds. When there is a browse date corresponding to the coding bit, the value of the corresponding coding bit is set as 1; if not, the value of the corresponding coding bit is set as 0, as shown in the Browse Record column of Table 4.
[0057] A target access record can be generated according to the generated code values, dimension values and member codes. As shown in Table 4, all target access records constitute an access record table.
Table 4 Dimension A Dimension B Dimension C Member Code Browse Record
Table 4 Dimension A Dimension B Dimension C Member Code Browse Record
[0058] Specifically, in order to further lower data volumes and enhance data reading/writing efficiency, it is possible to convert each dimension value into a binary code, or to take all dimension values contained in each row of target access record as a dimension set, to convert the dimension set into a corresponding binary code and to store a correspondence relation between each dimension set and a binary code.
[0059] Step 5¨ determining a corresponding target access record, when newly added access data is generated, according to member codes and dimension values contained in the newly added access data.
[0060] Step 6¨ generating updated code values and storing the updated code values in the target access record according to code values contained in the target access record and browse dates contained in the newly added access record.
Date Recue/Date Received 2021-12-29
Date Recue/Date Received 2021-12-29
[0061] Specifically, it is possible to determine the bit(s) required for a code value to move according to the number of day(s) between a newly added browse date and the latest day in the code values. For instance, 1110000 in the browse record represents the access record from 20190701 to 20190707, whereas when the newly added browse date is 20190801, the number of days between the newly added browse date and the latest day to which the browse record corresponds exceeds the bits of the browse record, then the code value of the target access record is directly updated as 0000001; when the newly added browse date is 20190709, the code value is moved two bits forward, and the updated code value is 1000001.
[0062] Step 7 ¨ generating statistic values according to the target access record.
[0063] Specifically, it is possible to count and visually display such statistic values as the number of 1, the number of consecutive 1, and the number of times by which such consecution occurs as contained in the code values, so as to facilitate the analyzing personnel to carry out corresponding analyses.
Embodiment 2
Embodiment 2
[0064] Corresponding to the aforementioned Embodiment, the present application provides a method of processing user access data, as shown in Fig. 2, the method comprises the following steps.
[0065] 210 - obtaining first access data, wherein the access data includes user codes, access dates and target dimension values.
[0066] Preferably, the step of obtaining first access data includes:
[0067] 211 - obtaining user primary access data from a datasheet to be processed; and
[0068] 212 - generating the first access data according to user codes, access dates and target Date Recue/Date Received 2021-12-29 dimension values to which target dimensions correspond included in the user primary access data.
[0069] 220 - generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds.
[0070] Preferably, the step of generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds, includes:
[0071] 221 - generating an initial code, wherein the initial code includes coding bits for recording code values;
[0072] 222 - obtaining and sorting access dates, to which the first access data with identical user codes and target dimension values corresponds, and determining a sorting order to which each of the obtained access dates corresponds;
[0073] 223 - determining a coding bit to which each of the obtained access dates corresponds according to the sorting orders to which the obtained access dates correspond;
[0074] 224 - setting the code value of the corresponding coding bit included in the initial code as a second code value, and setting code values of coding bits except for the corresponding coding bit as first code values; and
[0075] 225 - determining the set initial code as a corresponding date code.
[0076] 230 - generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond.
[0077] Preferably, the method comprises:
[0078] 240 - obtaining second access data;
[0079] 241 - determining a target access record that contains target dimension values and user codes included in the second access data as a target access record to which the second access data corresponds;
Date Recue/Date Received 2021-12-29
Date Recue/Date Received 2021-12-29
[0080] 242 - generating updated date codes according to access dates to which the second access data corresponds and date codes to which the corresponding target access record corresponds; and
[0081] 243 - updating the date codes to which the corresponding target access record corresponds as the updated date codes.
[0082] Preferably, the date code is a binary code.
[0083] Preferably, the method comprises:
[0084] 250 - counting the number of second code values included in each of the date codes, and generating a first statistic value;
[0085] 251 - counting the number of consecutive second code values included in each of the date codes, and generating a second statistic value; and
[0086] 253 - visually displaying the first statistic value and the second statistic value.
Embodiment 3
Embodiment 3
[0087] Corresponding to the aforementioned embodiments, the present application provides a device for processing user access data, as shown in Fig. 3, the device comprises:
[0088] an obtaining module 310, for obtaining first access data, wherein the access data includes user codes, access dates and target dimension values;
[0089] a coding module 320, for generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds; and
[0090] a generating module 330, for generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond.
[0091] Preferably, the coding module 320 is further usable for generating an initial code, wherein the initial code includes coding bits for recording code values; obtaining and sorting Date Recue/Date Received 2021-12-29 access dates, to which the first access data with identical user codes and target dimension values corresponds, and determining sorting order to which each of the obtained access dates corresponds; determining a coding bit to which each of the obtained access dates corresponds according to the sorting order to which each access date corresponds; setting the code value of the corresponding coding bit included in the initial code as a second code value, and setting code values of coding bits except for the corresponding coding bit as first code values; and determining the set initial code as a corresponding date code.
[0092] Preferably, the device further comprises a counting module and a displaying module, of which the counting module is employed for counting the number of second code values included in each of the date codes, and generating a first statistic value, and counting the number of consecutive second code values included in each of the date codes, and generating a second statistic value; and the displaying module is employed for visually displaying the first statistic value and the second statistic value.
[0093] Preferably, the obtaining module 310 is further usable for obtaining second access data;
and the coding module 320 is further usable for determining a target access record that contains target dimension values and user codes included in the second access data as a target access record to which the second access data corresponds; generating updated date codes according to access dates to which the second access data corresponds and date codes to which the corresponding target access record corresponds; and updating the date codes to which the corresponding target access record corresponds as the updated date codes.
and the coding module 320 is further usable for determining a target access record that contains target dimension values and user codes included in the second access data as a target access record to which the second access data corresponds; generating updated date codes according to access dates to which the second access data corresponds and date codes to which the corresponding target access record corresponds; and updating the date codes to which the corresponding target access record corresponds as the updated date codes.
[0094] Preferably, the obtaining module 310 is further usable for obtaining user primary access data from a datasheet to be processed; and generating the first access data according to user codes, access dates and target dimension values to which target dimensions correspond included in the user primary access data.
Date Recue/Date Received 2021-12-29
Date Recue/Date Received 2021-12-29
[0095] Embodiment 4
[0096] Corresponding to the aforementioned method, device and system, this embodiment of the present application provides a computer system that comprises: one or more processor(s);
and a memory, associated with the one or more processor(s), wherein the memory is employed to store a program instruction, and the program instruction performs the following operations when it is read and executed by the one or more processor(s):
and a memory, associated with the one or more processor(s), wherein the memory is employed to store a program instruction, and the program instruction performs the following operations when it is read and executed by the one or more processor(s):
[0097] obtaining first access data, wherein the access data includes user codes, access dates and target dimension values;
[0098] generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds; and
[0099] generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond.
[0100] Fig. 4 exemplarily illustrates the framework of the computer system that can specifically include a processor 1510, a video display adapter 1511, a magnetic disk driver 1512, an input/output interface 1513, a network interface 1514, and a memory 1520. The processor 1510, the video display adapter 1511, the magnetic disk driver 1512, the input/output interface 1513, the network interface 1514, and the memory 1520 can be communicably connected with one another via a communication bus 1530.
[0101] The processor 1510 can be embodied as a general CPU (Central Processing Unit), a microprocessor, an ASIC (Application Specific Integrated Circuit), or one or more integrated circuit(s) for executing relevant program(s) to realize the technical solutions provided by the present application.
[0102] The memory 1520 can be embodied in such a form as an ROM (Read Only Memory), an RAM (Random Access Memory), a static storage device, or a dynamic storage device.
The memory 1520 can store an operating system 1521 for controlling the running of a Date Recue/Date Received 2021-12-29 computer system 1500, and a basic input/output system (BIOS) 1522 for controlling lower-level operations of the computer system 1500. In addition, the memory can also store a web browser 1523, data storage administration 1524, and an icon font processing system 1525, etc. The icon font processing system 1525 can be an application program that specifically realizes the aforementioned various step operations in the embodiments of the present application. To sum it up, when the technical solutions provided by the present application are to be realized via software or firmware, the relevant program codes are stored in the memory 1520, and invoked and executed by the processor 1510.
The memory 1520 can store an operating system 1521 for controlling the running of a Date Recue/Date Received 2021-12-29 computer system 1500, and a basic input/output system (BIOS) 1522 for controlling lower-level operations of the computer system 1500. In addition, the memory can also store a web browser 1523, data storage administration 1524, and an icon font processing system 1525, etc. The icon font processing system 1525 can be an application program that specifically realizes the aforementioned various step operations in the embodiments of the present application. To sum it up, when the technical solutions provided by the present application are to be realized via software or firmware, the relevant program codes are stored in the memory 1520, and invoked and executed by the processor 1510.
[0103] The input/output interface 1513 is employed to connect with an input/output module to realize input and output of information. The input/output module can be equipped in the device as a component part (not shown in the drawings), and can also be externally connected with the device to provide corresponding functions. The input means can include a keyboard, a mouse, a touch screen, a microphone, and various sensors etc., and the output means can include a display screen, a loudspeaker, a vibrator, an indicator light etc.
[0104] The network interface 1514 is employed to connect to a communication module (not shown in the drawings) to realize intercommunication between the current device and other devices. The communication module can realize communication in a wired mode (via USB, network cable, for example) or in a wireless mode (via mobile network, WIFI, Bluetooth, etc.).
[0105] The bus 1530 includes a passageway transmitting information between various component parts of the device (such as the processor 1510, the video display adapter 1511, the magnetic disk driver 1512, the input/output interface 1513, the network interface 1514, and the memory 1520).
[0106] Additionally, the computer system 1500 may further obtain information of specific Date Recue/Date Received 2021-12-29 collection conditions from a virtual resource object collection condition information database 1541 for judgment on conditions, and so on.
[0107] As should be noted, although merely the processor 1510, the video display adapter 1511, the magnetic disk driver 1512, the input/output interface 1513, the network interface 1514, the memory 1520, and the bus 1530 are illustrated for the aforementioned device, the device may further include other component parts prerequisite for realizing normal running during specific implementation. In addition, as can be understood by persons skilled in the art, the aforementioned device may as well only include component parts necessary for realizing the solutions of the present application, without including the entire component parts as illustrated.
[0108] As can be known through the description to the aforementioned embodiments, it is clearly learnt by person skilled in the art that the present application can be realized through software plus a general hardware platform. Based on such understanding, the technical solutions of the present application in essence, or the parts which made contributions thereby over the state of the art, can be embodied in the form of a software product, and such a computer software product can be stored in a storage medium, such as an ROM/RAM, a magnetic disk, an optical disk etc., and includes plural instructions enabling a computer equipment (such as a personal computer, a server, or a network device etc.) to execute the methods described in various embodiments or some sections of the embodiments of the present application.
[0109] The various embodiments are progressively described in the Description, identical or similar sections among the various embodiments can be inferred from one another, and each embodiment stresses what is different from other embodiments.
Particularly, with respect to the system or system embodiment, since it is essentially similar to the method embodiment, its description is relatively simple, and the relevant sections thereof can be inferred from the corresponding sections of the method embodiment. The system or Date Recue/Date Received 2021-12-29 system embodiment as described above is merely exemplary in nature, units therein described as separate parts can be or may not be physically separate, parts displayed as units can be or may not be physical units, that is to say, they can be located in a single site, or distributed over a plurality of network units. It is possible to base on practical requirements to select partial modules or the entire modules to realize the objectives of the embodied solutions. It is understandable and implementable by persons ordinarily skilled in the art without spending creative effort in the process.
Particularly, with respect to the system or system embodiment, since it is essentially similar to the method embodiment, its description is relatively simple, and the relevant sections thereof can be inferred from the corresponding sections of the method embodiment. The system or Date Recue/Date Received 2021-12-29 system embodiment as described above is merely exemplary in nature, units therein described as separate parts can be or may not be physically separate, parts displayed as units can be or may not be physical units, that is to say, they can be located in a single site, or distributed over a plurality of network units. It is possible to base on practical requirements to select partial modules or the entire modules to realize the objectives of the embodied solutions. It is understandable and implementable by persons ordinarily skilled in the art without spending creative effort in the process.
[0110] What is described above is merely directed to preferred embodiments of the present invention, and is not meant to restrict the present invention. Any amendment, equivalent replacement and improvement makeable within the spirit and principle of the present invention shall all fall within the protection scope of the present invention.
Date Recue/Date Received 2021-12-29
Date Recue/Date Received 2021-12-29
Claims (10)
1. A method of processing user access data, characterized in that the method comprises:
obtaining first access data, wherein the access data includes user codes, access dates and target dimension values;
generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds; and generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond.
obtaining first access data, wherein the access data includes user codes, access dates and target dimension values;
generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds; and generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond.
2. The method according to Claim 1, characterized in that the step of generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds, includes:
generating an initial code, wherein the initial code includes coding bits for recording code values;
obtaining and sorting access dates, to which the first access data with identical user codes and target dimension values corresponds, and determining a sorting order to which each of the obtained access dates corresponds;
determining a coding bit to which each of the obtained access dates corresponds according to the sorting orders to which the obtained access dates correspond;
setting the code value of the corresponding coding bit included in the initial code as a second code value, and setting code values of coding bits except for the corresponding coding bit as first code values; and determining the set initial code as a corresponding date code.
generating an initial code, wherein the initial code includes coding bits for recording code values;
obtaining and sorting access dates, to which the first access data with identical user codes and target dimension values corresponds, and determining a sorting order to which each of the obtained access dates corresponds;
determining a coding bit to which each of the obtained access dates corresponds according to the sorting orders to which the obtained access dates correspond;
setting the code value of the corresponding coding bit included in the initial code as a second code value, and setting code values of coding bits except for the corresponding coding bit as first code values; and determining the set initial code as a corresponding date code.
3. The method according to Claim 2, characterized in comprising:
obtaining second access data;
Date Recue/Date Received 2021-12-29 determining a target access record that contains target dimension values and user codes included in the second access data as a target access record to which the second access data corresponds;
generating updated date codes according to access dates to which the second access data corresponds and date codes to which the corresponding target access record corresponds; and updating the date codes to which the corresponding target access record corresponds as the updated date codes.
obtaining second access data;
Date Recue/Date Received 2021-12-29 determining a target access record that contains target dimension values and user codes included in the second access data as a target access record to which the second access data corresponds;
generating updated date codes according to access dates to which the second access data corresponds and date codes to which the corresponding target access record corresponds; and updating the date codes to which the corresponding target access record corresponds as the updated date codes.
4. The method according to anyone of Claims 1 to 3, characterized in that the step of obtaining first access data includes:
obtaining user primary access data from a datasheet to be processed; and generating the first access data according to user codes, access dates and target dimension values to which target dimensions correspond included in the user primary access data.
obtaining user primary access data from a datasheet to be processed; and generating the first access data according to user codes, access dates and target dimension values to which target dimensions correspond included in the user primary access data.
5. The method according to anyone of Claims 1 to 3, characterized in that the date code is a binary code.
6. The method according to Claim 2 or 3, characterized in comprising:
counting the number of second code values included in each of the date codes, and generating a first statistic value;
counting the number of consecutive second code values included in each of the date codes, and generating a second statistic value; and visually displaying the first statistic value and the second statistic value.
counting the number of second code values included in each of the date codes, and generating a first statistic value;
counting the number of consecutive second code values included in each of the date codes, and generating a second statistic value; and visually displaying the first statistic value and the second statistic value.
7. A device for processing user access data, characterized in that the device comprises:
an obtaining module, for obtaining first access data, wherein the access data includes user codes, access dates and target dimension values;
a coding module, for generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds; and Date Recue/Date Received 2021-12-29 a generating module, for generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond.
an obtaining module, for obtaining first access data, wherein the access data includes user codes, access dates and target dimension values;
a coding module, for generating corresponding date codes according to access dates, to which the first access data with identical user codes and target dimension values corresponds; and Date Recue/Date Received 2021-12-29 a generating module, for generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond.
8. The device according to Claim 7, characterized in that the coding module is further usable for generating an initial code, wherein the initial code includes coding bits for recording code values; obtaining and sorting access dates, to which the first access data with identical user codes and target dimension values corresponds, and determining a sorting order to which each of the obtained access dates corresponds; determining a coding bit to which each of the obtained access dates corresponds according to the sorting order to which each access date corresponds; setting the code value of the corresponding coding bit included in the initial code as a second code value, and setting code values of coding bits except for the corresponding coding bit as first code values; and determining the set initial code as a corresponding date code.
9. The device according to Claim 8, characterized in that the device further comprises a counting module and a displaying module, wherein the counting module is employed for counting the number of second code values included in each of the date codes, and generating a first statistic value, and counting the number of consecutive second code values included in each of the date codes, and generating a second statistic value; and the displaying module is employed for visually displaying the first statistic value and the second statistic value.
10. A computer system, characterized in comprising:
one or more processor(s); and a memory, associated with the one or more processor(s), wherein the memory is employed to store a program instruction, and the program instruction performs the following operations when it is read and executed by the one or more processor(s):
obtaining first access data, wherein the access data includes user codes, access dates and target dimension values;
generating corresponding date codes according to access dates, to which the first access data Date Recue/Date Received 2021-12-29 with identical user codes and target dimension values corresponds; and generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond.
Date Recue/Date Received 2021-12-29
one or more processor(s); and a memory, associated with the one or more processor(s), wherein the memory is employed to store a program instruction, and the program instruction performs the following operations when it is read and executed by the one or more processor(s):
obtaining first access data, wherein the access data includes user codes, access dates and target dimension values;
generating corresponding date codes according to access dates, to which the first access data Date Recue/Date Received 2021-12-29 with identical user codes and target dimension values corresponds; and generating a target access record according to the date codes, and the target dimension values and user codes to which the date codes correspond.
Date Recue/Date Received 2021-12-29
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011579066.2A CN112685456A (en) | 2020-12-28 | 2020-12-28 | User access data processing method and device and computer system |
| CN202011579066.2 | 2020-12-28 |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CA3144129A1 true CA3144129A1 (en) | 2022-06-28 |
Family
ID=75452616
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA3144129A Pending CA3144129A1 (en) | 2020-12-28 | 2021-12-29 | User access data processing method, device and computer system |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN112685456A (en) |
| CA (1) | CA3144129A1 (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114461615A (en) * | 2021-12-20 | 2022-05-10 | 中盈优创资讯科技有限公司 | Method and device for analyzing recent behavior index of user |
| CN116821139B (en) * | 2023-08-25 | 2024-01-23 | 南方电网数字电网研究院有限公司 | Mixed load method and system for partition table design based on distributed database |
Family Cites Families (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102694802B (en) * | 2012-05-22 | 2015-10-21 | 中国联合网络通信集团有限公司 | Network access information recording method and device |
| US10235400B2 (en) * | 2015-05-15 | 2019-03-19 | Xactly Corporation | Database keying with encoded filter attributes |
| CN105893421A (en) * | 2015-12-02 | 2016-08-24 | 乐视网信息技术（北京）股份有限公司 | UV calculation method and apparatus |
| CN109002386A (en) * | 2018-07-02 | 2018-12-14 | 北京小米移动软件有限公司 | The recording method of user's active time, device, storage medium and electronic equipment |
| CN110109812A (en) * | 2019-05-10 | 2019-08-09 | 广州英睿科技有限公司 | Statistical method, device, computer equipment and the storage medium of access log data |
| CN110535944B (en) * | 2019-08-29 | 2023-04-18 | 广州方硅信息技术有限公司 | Method and device for processing user active data |
| CN111274291B (en) * | 2020-01-20 | 2024-04-05 | 中国平安人寿保险股份有限公司 | Query method, device, equipment and medium for user access data |
| CN112035415B (en) * | 2020-08-28 | 2024-08-30 | 北京金山云网络技术有限公司 | Processing system, method, equipment and storage medium for user access data |
| CN112084249B (en) * | 2020-09-11 | 2024-06-21 | 浙江立元科技有限公司 | Access record extraction method and device |
-
2020
- 2020-12-28 CN CN202011579066.2A patent/CN112685456A/en active Pending
-
2021
- 2021-12-29 CA CA3144129A patent/CA3144129A1/en active Pending
Also Published As
| Publication number | Publication date |
|---|---|
| CN112685456A (en) | 2021-04-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6393805B2 (en) | Efficient query processing using histograms in the columnar database | |
| EP3404899A1 (en) | Adaptive computation and faster computer operation | |
| US10552390B2 (en) | Root cause analysis of performance problems | |
| US20150213631A1 (en) | Time-based visualization of the number of events having various values for a field | |
| CN110795509A (en) | Method and device for constructing index blood relationship graph of data warehouse and electronic equipment | |
| US9798782B2 (en) | Re-sizing data partitions for ensemble models in a mapreduce framework | |
| CN111666304B (en) | Data processing device, data processing method, storage medium, and electronic apparatus | |
| CN110807016B (en) | Data warehouse construction method and device applied to financial business and electronic equipment | |
| WO2022088632A1 (en) | User data monitoring and analysis method, apparatus, device, and medium | |
| CN111078695B (en) | Method and device for calculating association relation of metadata in enterprise | |
| CA3144129A1 (en) | User access data processing method, device and computer system | |
| CN111523677A (en) | Method and device for explaining prediction result of machine learning model | |
| CN110795478A (en) | Data warehouse updating method and device applied to financial business and electronic equipment | |
| CN113327136A (en) | Attribution analysis method and device, electronic equipment and storage medium | |
| CN107016115B (en) | Data export method and device, computer readable storage medium and electronic equipment | |
| CN111210109A (en) | Method and device for predicting user risk based on associated user and electronic equipment | |
| US11489731B2 (en) | Techniques and architectures for efficient allocation of under-utilized resources | |
| JP2017513252A (en) | Optimized data condenser and method | |
| EP3504637B1 (en) | Dynamically render large dataset in client application | |
| US11627193B2 (en) | Method and system for tracking application activity data from remote devices and generating a corrective action data structure for the remote devices | |
| US20240320587A1 (en) | System for quantitative software risk determination and visualization | |
| CN110119784B (en) | Order recommendation method and device | |
| CN113792038A (en) | Method and apparatus for storing data | |
| CN115759742A (en) | Enterprise risk assessment method and device, computer equipment and storage medium | |
| CN115511187A (en) | Asset recovery prediction method, device, equipment, medium and computer program product |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| EEER | Examination request |
Effective date: 20220916 |
|
| EEER | Examination request |
Effective date: 20220916 |
|
| EEER | Examination request |
Effective date: 20220916 |
|
| EEER | Examination request |
Effective date: 20220916 |
|
| EEER | Examination request |
Effective date: 20220916 |