CN112711623A - Data pull-through method and device, storage medium and electronic device - Google Patents
Data pull-through method and device, storage medium and electronic device Download PDFInfo
- Publication number
- CN112711623A CN112711623A CN202011531151.1A CN202011531151A CN112711623A CN 112711623 A CN112711623 A CN 112711623A CN 202011531151 A CN202011531151 A CN 202011531151A CN 112711623 A CN112711623 A CN 112711623A
- Authority
- CN
- China
- Prior art keywords
- data
- user
- service systems
- different service
- pull
- 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
- 238000000034 method Methods 0.000 title claims abstract description 56
- 238000004590 computer program Methods 0.000 claims description 14
- 238000004140 cleaning Methods 0.000 claims description 10
- 230000004044 response Effects 0.000 claims description 4
- 238000005516 engineering process Methods 0.000 abstract description 5
- 230000000875 corresponding effect Effects 0.000 description 45
- 238000010586 diagram Methods 0.000 description 17
- 238000012545 processing Methods 0.000 description 8
- 230000005540 biological transmission Effects 0.000 description 6
- 238000013499 data model Methods 0.000 description 6
- 238000009434 installation Methods 0.000 description 5
- 238000010219 correlation analysis Methods 0.000 description 4
- 238000012098 association analyses Methods 0.000 description 3
- 238000006243 chemical reaction Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 3
- 238000010276 construction Methods 0.000 description 3
- 230000011218 segmentation Effects 0.000 description 3
- 230000006399 behavior Effects 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000008439 repair process Effects 0.000 description 2
- 238000012216 screening Methods 0.000 description 2
- 230000002596 correlated effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000018109 developmental process Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000001939 inductive effect Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
- G06F21/6245—Protecting personal data, e.g. for financial or medical purposes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/01—Customer relationship services
- G06Q30/015—Providing customer assistance, e.g. assisting a customer within a business location or via helpdesk
- G06Q30/016—After-sales
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
- G06Q30/0635—Processing of requisition or of purchase orders
Abstract
The invention discloses a data pull-through method and device, a storage medium and an electronic device, wherein the method comprises the following steps: acquiring user data and equipment data of different service systems, wherein the service systems comprise at least one of the following: an online order system, an online order placing system, a member center system and an after-sales work order system; and performing data pull-through on the user data and the equipment data of the different service systems, and storing the pulled-through data in a target database, namely performing data pull-through on the obtained user data and the equipment data of the different service systems. By adopting the technical scheme, the problems that data related to different service systems and users cannot be unified and the like in the related technology are solved.
Description
Technical Field
The present invention relates to the field of communications, and in particular, to a data pull-through method and apparatus, a storage medium, and an electronic apparatus.
Background
With the development of society, the ways of purchasing products are more and more diversified, and the products can be purchased online and offline and can be purchased online and offline in various ways; therefore, when a user wants to inquire about information such as a purchased product and the time of purchase of the product, the user needs to inquire about a plurality of pieces of software or a plurality of stores, and the user cannot intuitively and uniformly know about the purchased information.
Aiming at the problems that data related to different service systems and users cannot be unified and the like in the related technology, an effective solution is not provided.
Disclosure of Invention
The embodiment of the invention provides a data pull-through method and device, a storage medium and an electronic device, which are used for at least solving the problems that data related to different service systems and users cannot be unified in the related technology and the like.
According to an embodiment of the present invention, there is provided a data pull-through method, including: acquiring user data and equipment data of different service systems, wherein the service systems comprise at least one of the following: an online order system, an online order placing system, a member center system and an after-sales work order system; and performing data pull-through on the user data and the equipment data of the different service systems, and storing the pulled-through data in a target database.
In an exemplary embodiment, before performing data pull-through on the user data and the device data of the different service systems, the method further includes: acquiring user identification information from the user data, wherein the user identification information is used for uniquely identifying the user; and identifying the users corresponding to the same user identification information by different service systems as the same user.
In an exemplary embodiment, before performing data pull-through on the user data and the device data of the different service systems, the method further includes: obtaining a selling order and an after-sale order; extracting a first corresponding relation between a user and an equipment identifier from the selling order, and acquiring a second corresponding relation between the user and the equipment identifier from the after-sale order, wherein the equipment identifier is used for uniquely identifying equipment; and integrating the first object relationship and the second corresponding relationship to output the corresponding relationship between the same user and different equipment identifications.
In an exemplary embodiment, after performing data pull-through on the user data and the device data of the different service systems, and storing the pulled-through data in the target database, the method further includes: acquiring address information of different users recorded in the different service systems; cleaning the address information of different users to obtain cleaned address information; and dividing different users corresponding to the same address into the same family list.
In an exemplary embodiment, after performing data pull-through on the user data and the device data of the different service systems, and storing the pulled-through data in the target database, the method further includes: receiving a data query request sent by an index interface of an application layer, wherein the data query request is used for acquiring target data from the target database; and responding to the data query request, and feeding the target data back to the application layer.
In an exemplary embodiment, feeding back the target data to the application layer in response to the data query request includes: determining whether private data exists in the target data; and under the condition that privacy data exist, desensitizing the target data, feeding the desensitized data back to the application layer, or acquiring identification information corresponding to the privacy data, adding the identification information into the target data, and feeding the identification information back to the application layer.
According to another embodiment of the present invention, there is further provided a data pull-through apparatus, including an obtaining module, configured to obtain user data and device data of different service systems, where the service system includes at least one of: an online order system, an online order placing system, a member center system and an after-sales work order system; and the pull-through module is used for carrying out data pull-through on the user data and the equipment data of the different service systems and storing the pulled-through data in a target database.
In an exemplary embodiment, the obtaining module is further configured to obtain user identification information from the user data, where the user identification information is used to uniquely identify the user; and identifying the users corresponding to the same user identification information by different service systems as the same user.
According to a further embodiment of the present invention, a computer-readable storage medium is also provided, in which a computer program is stored, wherein the computer program is configured to carry out the steps of any of the above-described method embodiments when executed.
According to yet another embodiment of the present invention, there is also provided an electronic device, including a memory in which a computer program is stored and a processor configured to execute the computer program to perform the steps in any of the above method embodiments.
The invention can be used for acquiring the user data and the equipment data of different service systems, wherein the service systems comprise at least one of the following: an online order system, an online order placing system, a member center system and an after-sales work order system; and performing data pull-through on the user data and the equipment data of the different service systems, and storing the pulled-through data in a target database, namely performing data pull-through on the obtained user data and the equipment data of the different service systems. By adopting the technical scheme, the problems that user data and equipment data in different service systems cannot be unified and the like in the related technology are solved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
fig. 1 is a block diagram of a hardware structure of a computer terminal of a data pull-through method according to an embodiment of the present invention;
FIG. 2 is a flow diagram of a data pull-through method according to an embodiment of the invention;
FIG. 3 is a schematic diagram of a simple logic for user identification in a data pull-through method according to an alternative embodiment of the present invention;
FIG. 4 is a logic diagram illustrating details of user identification in a data pull-through method according to an alternative embodiment of the present invention;
FIG. 5 is a schematic diagram of user-identified output content of a user identification in a data pull-through method according to an alternative embodiment of the present invention;
FIG. 6 is a logic diagram illustrating the details of device identification in a data pull-through method according to an alternative embodiment of the present invention;
FIG. 7 is a logic diagram illustrating address identification in a data pull-through method in detail according to an alternative embodiment of the present invention;
FIG. 8 is a diagram of a data model architecture for a data pull-through method in accordance with an alternative embodiment of the present invention;
fig. 9 is a block diagram of a data pull-through device according to an embodiment of the present invention.
Detailed Description
The invention will be described in detail hereinafter with reference to the accompanying drawings in conjunction with embodiments. It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order.
The method provided by the embodiment of the application can be executed in a computer terminal or a similar operation device. Taking the example of the operation on a computer terminal, fig. 1 is a hardware structure block diagram of a computer terminal of a data pull-through method according to an embodiment of the present invention. As shown in fig. 1, the computer terminal may include one or more (only one shown in fig. 1) processors 102 (the processors 102 may include, but are not limited to, a processing device such as a microprocessor MCU or a programmable logic device FPGA) and a memory 104 for storing data, and in an exemplary embodiment, may also include a transmission device 106 for communication functions and an input-output device 108. It will be understood by those skilled in the art that the structure shown in fig. 1 is only an illustration and is not intended to limit the structure of the computer terminal. For example, the computer terminal may also include more or fewer components than shown in FIG. 1, or have a different configuration with equivalent functionality to that shown in FIG. 1 or with more functionality than that shown in FIG. 1.
The memory 104 may be used to store computer programs, for example, software programs and modules of application software, such as computer programs corresponding to the data pull-through method of the computer terminal in the embodiment of the present invention, and the processor 102 executes various functional applications and data processing by running the computer programs stored in the memory 104, so as to implement the above-mentioned method. The memory 104 may include high speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 104 may further include memory located remotely from the processor 102, which may be connected to a computer terminal over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The transmission device 106 is used for receiving or transmitting data via a network. Specific examples of the network described above may include a wireless network provided by a communication provider of the computer terminal. In one example, the transmission device 106 includes a Network adapter (NIC), which can be connected to other Network devices through a base station so as to communicate with the internet. In one example, the transmission device 106 may be a Radio Frequency (RF) module, which is used for communicating with the internet in a wireless manner.
In this embodiment, a data pull-through method is provided, which is applied to the computer terminal, and fig. 2 is a flowchart of the data pull-through method according to the embodiment of the present invention, where the flowchart includes the following steps:
step S202, user data and equipment data of different service systems are obtained, wherein the service systems comprise at least one of the following: an online order system, an online order placing system, a member center system and an after-sales work order system;
and step S204, performing data pull-through on the user data and the equipment data of the different service systems, and storing the pulled-through data in a target database.
By the technical scheme, user data and equipment data of different service systems are acquired, wherein the service systems comprise at least one of the following: an online order system, an online order placing system, a member center system and an after-sales work order system; and performing data pull-through on the user data and the equipment data of the different service systems, and storing the pulled-through data in a target database, namely performing data pull-through on the obtained user data and the equipment data of the different service systems.
It should be noted that the data pull-through is to unify user basic data (including a mobile phone number, a user ID, a mailbox, a level, and the like), device data, and a user address from all sources, integrate data related to each system and a user, and promote the construction of a user pull-through data platform, so as to finally realize data pull-through between the user and the device.
In an optional embodiment, before performing data pull-through on user data and device data of different service systems, user identification information is obtained from the user data, wherein the user identification information is used for uniquely identifying the user; and identifying the users corresponding to the same user identification information by different service systems as the same user.
Specifically, there are multiple user data for different business systems, where the user data includes, but is not limited to, one of: the UESR IDs and the user identification information (which may be understood as a user mobile phone number) of different service systems obtain the user identification information from the user data, and because the user identification information indicates a unique user, a user with the same user identification information in different systems is used as the same user. In addition, under the condition that the user changes the mobile phone number, the mobile phone number identifies the same user within the validity period of the mobile phone number; if the user changes the mobile phone number and the validity period of the mobile phone number is over, the mobile phone number does not identify the same user, and if the user is in the service system, the mobile phone number is obtained again and is used for identifying the newly added user.
In an optional embodiment, before performing data pull-through on the user data and the device data of the different service systems, a selling order and an after-sale order are obtained; extracting a first corresponding relation between a user and an equipment identifier from the selling order, and acquiring a second corresponding relation between the user and the equipment identifier from the after-sale order, wherein the equipment identifier is used for uniquely identifying equipment; and integrating the first object relationship and the second corresponding relationship to output the corresponding relationship between the same user and different equipment identifications.
That is to say, a sales order (which may be understood as a retail order) and an after-sales order (which may be understood as an installation work order and a maintenance work order) are obtained in different business systems, a first corresponding relationship between a user and a device identifier in the sales order and a second corresponding relationship between a user of the after-sales order and the device identifier are obtained, the first corresponding relationship and the second corresponding relationship are integrated together, and finally the first corresponding relationship and the second corresponding relationship are integrated into a corresponding relationship in which the same user corresponds to a plurality of different device identifiers, so that device information such as a purchased device identifier, a device name, a device description and the like can be output when the user identifier is input.
And after the user data and the equipment data of different service systems are pulled through and the pulled through data are stored in a target database, address information needs to be integrated. In an embodiment of the present invention, address information of different users recorded in the different service systems is obtained; cleaning the address information of different users to obtain cleaned address information; and dividing different users corresponding to the same address into the same family list.
Specifically, the address information of the user in the online order system, the online order placing system, the member center system and the post-sale work order system is cleaned, and the corresponding relation between the user and the address information of the family, the province, the city, the district and the district can be output according to certain logic processing according to national standard logics of the province, the city, the district and the district. Before the address information of different users is cleaned, the address data in the service system needs to be repaired and leaked. And further performing correlation analysis on the cleaned address data and the address data information in the address base. It should be noted that the address data information in the address base is obtained by collecting all cell information including cell names (building number-unit number-house number), and storing the cell information in the unified address base after cleaning. The association analysis of the address data after cleaning and the address data information in the address database is realized through intelligent algorithm address word segmentation, primary approximate matching of inverted indexes, regularization, pinyin conversion and secondary matching. And further screening and storing the associated address information to a database, and outputting a result through sql execution. After the correlation analysis, the highly suspected home address list is determined by virtue of manual work and an APP terminal and then is stored in a database, and different users corresponding to the same address are classified into the same home list.
In an optional embodiment, a data query request sent by an index interface of an application layer is received after data pull-through is performed on user data and device data of different business systems and the pulled-through data is stored in a target database, wherein the data query request is used for acquiring target data from the target database; and responding to the data query request, and feeding the target data back to the application layer.
That is, in the case that the user queries data, target data is obtained from a target database, and the obtained target data is fed back to the application layer, where the data includes but is not limited to: user points, equipment models, equipment numbers, logistics and other data.
Because the data pull-through relates to privacy and sensitive information such as names, mobile phone numbers and the like of users, the data after pull-through is opened to protect the privacy data of the users, safety control of the user information is done, and the data query request is responded; and under the condition that privacy data exist, desensitizing the target data, feeding the desensitized data back to the application layer, or acquiring identification information corresponding to the privacy data, adding the identification information into the target data, and feeding the identification information back to the application layer.
In order to better understand the process of the data pull-through method, the following describes the flow of the data pull-through method with reference to an optional embodiment, but the flow is not limited to the technical solution of the embodiment of the present invention.
Fig. 3 is a schematic diagram of a simple logic of user identification in a data pull-through method according to an alternative embodiment of the present invention, and as shown in fig. 3, the process of user identification of the data pull-through method may be implemented by the following steps:
when a user purchases a product on line, the reserved mobile phone number is replaced by a unique UserID, when the user replaces the mobile phone number, the UserID can be bound with a new mobile phone number, and the bound data is migrated, and the 'original address' is released (the situation that the data under the original mobile phone number is empty can be understood); the UserID can also be cancelled, and after cancellation, the online trace ' looks up the person ' without the user '. When a user purchases a product on line, confirming the reserved mobile phone number purchased on line, and identifying the mobile phone number as an aged person when the mobile phone number has a UserID, and merging data; and confirming that the mobile phone number has no UserID, identifying the mobile phone number as a new user, and performing profiling and user building.
The core identification logic of a plurality of users in different online and offline service systems determined as the same user is that the unique user identification is associated by the mobile phone number and represents the unique user. It should be noted that, as long as the product is purchased through the online flagship store and the authorized stores, the reserved mobile phone number is replaced with the unique user id.
Fig. 4 is a schematic diagram of detailed logic of user identification in a data pull-through method according to an alternative embodiment of the present invention, and as shown in fig. 4, the specific logic is as follows:
firstly, the UserID of each system related by the mobile phone number in the online order and the information in the user center are associated and integrated, and the integrated data fields comprise: the system comprises a source system, each system UserID, a user center UserID, a big data UserID, an online and offline mark, a user mobile phone number, registration time and logout time.
Then, the big data UserID and related information in the online order are integrated with information in the user center, the unique user identification corresponding to the mobile phone number in the online order and the mobile phone number on line is regarded as the same user, and the user center UserID can be filled in a correlated mode; and (4) setting null on the non-related fields, wherein the fields after integration comprise: the system comprises a source system, a user mobile phone number, an order label, a big data UserID and a user center UserID.
And finally, integrating the online order placing information and the user center information to generate a user identification wide table, wherein the fields of the user identification wide table comprise: the system comprises a source system, each system UserID, a user center UserID, a big data UserID, an online and offline mark, a user mobile phone number, registration time, logout time, user attributes and a user tag.
It should be noted that, if a user changes a mobile phone number, the mobile phone number belongs to the same user within the validity period of the mobile phone number online and offline, and does not belong to the same user after the validity period, then the user id obtained by registering the mobile phone number is subjected to new user processing, after the user changes the mobile phone number, the user id can be bound, a new mobile phone number is bound, and data after binding is migrated, and an "original address" is released (which can be understood as data under the original mobile phone number is emptied); the UserID can also be cancelled, and after cancellation, the online trace ' looks up the person ' without the user '.
As shown in fig. 5, fig. 5 is a schematic diagram of output content of a user identification in a data pull-through method according to an alternative embodiment of the present invention.
Fig. 6 is a schematic diagram of detailed logic of device identification in a data pull-through method according to an alternative embodiment of the present invention, and as shown in fig. 6, specific logic is as follows:
first, of the retail order data, the logistics distribution delivery work order data, and the after-sales installation work order data, the first part of data (corresponding to the first correspondence relationship in the above-described embodiment) having the explicit delivery work order data and the explicit installation work order data and forming the "person-model (product)" correlation is filtered.
It should be noted that the retail order data, the logistics distribution and delivery work order data, and the post-sale installation work order data are model level data, and the model level data may be understood as model data of each product purchased.
Then, after the after-sales repair work order data and the member interest scenario user actively submit data (which can also be understood as an order actively submitted by a member center), the web server manipulates the scenario user actively submit data (which can also be understood as a web server actively bound by the user in the app), and filters the data to form a second part of data (corresponding to the second corresponding relationship in the above embodiment) of the comparison relationship of "person-model (product)".
It should be noted that, because the after-sales repair work order data and the member rights and interests scenario user actively submit data (which may also be understood as an order actively submitted by a member center), the website operator manipulates the scenario user actively submitted data (which may also be understood as a website operator actively bound by the user at the app) to be bar code level, the filtering mode is bar code comparison deduplication, and the bar code level data is unique identification data of a purchased product.
And finally, filtering and integrating the first part of data and the second part of data, and outputting information such as a user, a user name, a owned product model, a product code, a product description and the like.
It should be noted that: the first part of data and the second part of data are filtered by removing the duplicate according to the acquired date and model within a preset period of +/-30 days.
Fig. 7 is a schematic diagram of detailed logic of address identification in a data pull-through method according to an alternative embodiment of the present invention, and as shown in fig. 7, specific logic is as follows:
step S701: acquiring order data of different business systems, wherein the order data comprises an ID and an address;
step S702: cleaning address data in order data, such as leakage repairing, revising and standardizing;
step S703: collecting information of all cells, including cell names (building number-unit number-house number);
step S704: cleaning the information of all cells;
step S705: the information of the cleaned cell is stored in a unified standard library; for example, a level 6 address base (province-city-district-street-cell-house number);
step S706: performing association analysis on the cleaned address data and address information in a standard library by using intelligent algorithm address word segmentation, primary approximate matching of inverted indexes, regularization, pinyin conversion and secondary matching;
step S707: after data are screened, storing the data in a database;
step S708: outputting the result through sql execution; the results were: the same family, single family and multiple families;
step S709: acquiring character similarity between the cleaned address data and address information in a standard library;
step S710: obtaining a list of highly suspected passing home addresses;
step S711: the address information is determined by means of manual work and an APP terminal.
It can be understood that address information in all online and offline orders of the user is integrated, and address information of the user, the family, the province, the city, the district and the district is output according to standard logic of the province, the city, the district and the district unified in the country and certain logic processing.
As shown in fig. 8, fig. 8 is a diagram of a data model architecture of a data pull-through method according to an alternative embodiment of the present invention, where the data model architecture is divided into four layers:
1. data pull-through: and the data source at the bottom layer summarizes all the posting layer data of all the user, user interaction, user transaction, service, user care, product and third-party data, and the data does not need any logic processing.
2. Data mart: the method is divided into a data model and a result model. The data model needs to be processed but not limited to a same person model, an address model, a family model, a product model, an order model, a behavior model and other different independent models. The result model may output, but is not limited to, user wide table, user relationship wide table, product wide table, order wide table, user label wide table, rights and interests wide table, service wide table, behavior wide table, and the like. The indexes are the number of registered users, the number of active users, the number of families in the whole network, the number of recognized families, the number of smart families, the number of users purchasing a whole set of shops, the number of issued points, the number of used points, the number of exchanged commodities and the number of exchanged persons.
3. An application layer: this section is mainly the pointer interface. The system comprises a user basic information interface, a user order interface, a user product interface, a sound data interface and a user service interface.
4. And (3) service application: and (5) inducing and classifying the interface content of the application layer according to the service requirement. Three identifications: user identification, product identification, family identification and 8 topics: my relationship, my information, my interests, my transaction, my service, my device, my interaction, my recommendation.
According to the method, after all user-related source layer data are gathered, data of a service system are loaded to a data warehouse (ETL) for processing after being extracted, cleaned and converted, and an index interface required by a service is output and provided for a service scene. The user data pull-through relates to privacy and sensitive information such as names and mobile phone numbers of users, the pulled-through data can protect the privacy data of the users after being opened, safety control of the user information is well conducted, unification of all source users, all terminal products and all user addresses is achieved, data related to the users of all platforms is integrally pulled through, construction of a user pull-through data platform is promoted, and application of the user data pull-through based on the users and the products is finally achieved.
And after the construction of the omnibearing user data model is completed, providing a real-time interface or offline data for a business party to display on an APP end or a front end page. And the related data acquired by the user are comprehensive and unified, and a data center station related to the user is constructed.
The invention can be used for acquiring the user data and the equipment data of different service systems, wherein the service systems comprise at least one of the following: an online order system, an online order placing system, a member center system and an after-sales work order system; and performing data pull-through on the user data and the equipment data of the different service systems, and storing the pulled-through data in a target database, namely performing data pull-through on the obtained user data and the equipment data of the different service systems, so that the problem that the basic information, the product information, the address information and the like of a user are dispersed in the different service systems, and a service party cannot uniformly call all user information for front-end use is solved. The invention uniformly pulls all the data related to the user and stores the data in the data warehouse, constructs a uniform user data middle platform, establishes strict data input, index output and user sensitive data access standards, and constructs a good data pull-through standard.
Through the above description of the embodiments, those skilled in the art can clearly understand that the method according to the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but the former is a better implementation mode in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
In this embodiment, a data pull-through device is further provided, and the device is used to implement the foregoing embodiments and preferred embodiments, and the description of the device that has been already made is omitted. As used below, the term "module" may be a combination of software and/or hardware that implements a predetermined function. Although the means described in the embodiments below are preferably implemented in software, an implementation in hardware, or a combination of software and hardware is also possible and contemplated.
Fig. 9 is a block diagram of a data pull-through device according to an embodiment of the present invention; as shown in fig. 9, includes:
an obtaining module 902, configured to obtain user data and device data of different service systems, where the service systems include at least one of: an online order system, an online order placing system, a member center system and an after-sales work order system;
and a pull-through module 904, configured to pull through the user data and the device data of the different service systems, and store the pulled-through data in the target database.
By the technical scheme, user data and equipment data of different service systems are acquired, wherein the service systems comprise at least one of the following: an online order system, an online order placing system, a member center system and an after-sales work order system; and performing data pull-through on the user data and the equipment data of the different service systems, and storing the pulled-through data in a target database, namely performing data pull-through on the obtained user data and the equipment data of the different service systems. By adopting the technical scheme, the problems that user data and equipment data in different service systems cannot be unified and the like in the related technology are solved.
In an optional embodiment, the obtaining module is further configured to obtain user identification information from the user data before performing data pull-through on the user data and the device data of the different service systems, where the user identification information is used to uniquely identify the user; and identifying the users corresponding to the same user identification information by different service systems as the same user.
Specifically, there are multiple user data for different business systems, where the user data includes, but is not limited to, one of: the UESR IDs and the user identification information (which may be understood as a user mobile phone number) of different service systems obtain the user identification information from the user data, and because the user identification information indicates a unique user, a user with the same user identification information in different systems is used as the same user. In addition, under the condition that the user changes the mobile phone number, the mobile phone number identifies the same user within the validity period of the mobile phone number; if the user changes the mobile phone number and the validity period of the mobile phone number is over, the mobile phone number does not identify the same user, and if the user is in the service system, the mobile phone number is obtained again and is used for identifying the newly added user.
In an optional embodiment, the obtaining module is further configured to obtain a sell order and an after-sell order before performing data pull-through on the user data and the device data of the different service systems; extracting a first corresponding relation between a user and an equipment identifier from the selling order, and acquiring a second corresponding relation between the user and the equipment identifier from the after-sale order, wherein the equipment identifier is used for uniquely identifying equipment; and integrating the first object relationship and the second corresponding relationship to output the corresponding relationship between the same user and different equipment identifications.
That is to say, a sales order (which may be understood as a retail order) and an after-sales order (which may be understood as an installation work order and a maintenance work order) are obtained in different business systems, a first corresponding relationship between a user and a device identifier in the sales order and a second corresponding relationship between a user of the after-sales order and the device identifier are obtained, the first corresponding relationship and the second corresponding relationship are integrated together, and finally the first corresponding relationship and the second corresponding relationship are integrated into a corresponding relationship in which the same user corresponds to a plurality of different device identifiers, so that device information such as a purchased device identifier, a device name, a device description and the like can be output when the user identifier is input.
And after the user data and the equipment data of different service systems are pulled through and the pulled through data are stored in a target database, address information needs to be integrated. In an embodiment of the present invention, the obtaining module is configured to obtain address information of different users recorded in different service systems; cleaning the address information of different users to obtain cleaned address information; and dividing different users corresponding to the same address into the same family list.
Specifically, the address information of the user in the online order system, the online order placing system, the member center system and the post-sale work order system is cleaned, and the corresponding relation between the user and the address information of the family, the province, the city, the district and the district can be output according to certain logic processing according to national standard logics of the province, the city, the district and the district. Before the address information of different users is cleaned, the address data in the service system needs to be repaired and leaked. And further performing correlation analysis on the cleaned address data and the address data information in the address base. It should be noted that the address data information in the address base is obtained by collecting all cell information including cell names (building number-unit number-house number), and storing the cell information in the unified address base after cleaning. The association analysis of the address data after cleaning and the address data information in the address database is realized through intelligent algorithm address word segmentation, primary approximate matching of inverted indexes, regularization, pinyin conversion and secondary matching. And further screening and storing the associated address information to a database, and outputting a result through sql execution. After the correlation analysis, the highly suspected home address list is determined by virtue of manual work and an APP terminal and then is stored in a database, and different users corresponding to the same address are classified into the same home list.
After performing data pull-through on the user data and the device data of the different service systems and storing the pulled-through data in the target database, in an optional embodiment, the apparatus further includes: the response module is used for receiving a data query request sent by an index interface of an application layer, wherein the data query request is used for acquiring target data from the target database; and responding to the data query request, and feeding the target data back to the application layer.
That is, in the case that the user queries data, target data is obtained from a target database, and the obtained target data is fed back to the application layer, where the data includes but is not limited to: user points, equipment models, equipment numbers, logistics and other data.
In the embodiment of the invention, a response module is used for responding to the data query request and determining whether the target data has the private data before feeding the target data back to the application layer; and under the condition that privacy data exist, desensitizing the target data, feeding the desensitized data back to the application layer, or acquiring identification information corresponding to the privacy data, adding the identification information into the target data, and feeding the identification information back to the application layer.
An embodiment of the present invention further provides a storage medium including a stored program, wherein the program executes any one of the methods described above.
In an exemplary embodiment, in the present embodiment, the storage medium may be configured to store a computer program for executing the steps of:
s1, obtaining user data and device data of different service systems, wherein the service systems include at least one of the following: an online order system, an online order placing system, a member center system and an after-sales work order system;
and S2, performing data pull-through on the user data and the device data of the different service systems, and storing the pulled-through data in a target database.
In an exemplary embodiment, in the present embodiment, the storage medium may include, but is not limited to: various media capable of storing computer programs, such as a usb disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic disk, or an optical disk.
Embodiments of the present invention also provide an electronic device comprising a memory having a computer program stored therein and a processor arranged to run the computer program to perform the steps of any of the above method embodiments.
In an exemplary embodiment, the electronic apparatus may further include a transmission device and an input/output device, wherein the transmission device is connected to the processor, and the input/output device is connected to the processor.
In an exemplary embodiment, in the present embodiment, the processor may be configured to execute the following steps by a computer program:
s1, obtaining user data and device data of different service systems, wherein the service systems include at least one of the following: an online order system, an online order placing system, a member center system and an after-sales work order system;
and S2, performing data pull-through on the user data and the device data of the different service systems, and storing the pulled-through data in a target database.
In an exemplary embodiment, for specific examples in this embodiment, reference may be made to the examples described in the above embodiments and optional implementation manners, and details of this embodiment are not described herein again.
It will be apparent to those skilled in the art that the various modules or steps of the invention described above may be implemented using a general purpose computing device, which may be centralized on a single computing device or distributed across a network of computing devices, and in one exemplary embodiment may be implemented using program code executable by a computing device, such that the steps shown and described may be executed by a computing device stored in a memory device and, in some cases, executed in a sequence different from that shown and described herein, or separately fabricated into individual integrated circuit modules, or multiple ones of them fabricated into a single integrated circuit module. Thus, the present invention is not limited to any specific combination of hardware and software.
The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, or improvement made within the principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. A data pull-through method, comprising:
acquiring user data and equipment data of different service systems, wherein the service systems comprise at least one of the following: an online order system, an online order placing system, a member center system and an after-sales work order system;
and performing data pull-through on the user data and the equipment data of the different service systems, and storing the pulled-through data in a target database.
2. The method of claim 1, wherein before pulling through the user data and the device data of the different service systems, the method further comprises:
acquiring user identification information from the user data, wherein the user identification information is used for uniquely identifying the user;
and identifying the users corresponding to the same user identification information by different service systems as the same user.
3. The method of claim 2, wherein before pulling through the user data and the device data of the different service systems, the method further comprises:
obtaining a selling order and an after-sale order;
extracting a first corresponding relation between a user and an equipment identifier from the selling order, and acquiring a second corresponding relation between the user and the equipment identifier from the after-sale order, wherein the equipment identifier is used for uniquely identifying equipment;
and integrating the first object relationship and the second corresponding relationship to output the corresponding relationship between the same user and different equipment identifications.
4. The method according to claim 1, wherein after the user data and the device data of the different service systems are pulled through and the pulled-through data is stored in the target database, the method further comprises:
acquiring address information of different users recorded in the different service systems;
cleaning the address information of different users to obtain cleaned address information;
and dividing different users corresponding to the same address into the same family list.
5. The method according to claim 1, wherein after the user data and the device data of the different service systems are pulled through and the pulled-through data is stored in the target database, the method further comprises:
receiving a data query request sent by an index interface of an application layer, wherein the data query request is used for acquiring target data from the target database;
and responding to the data query request, and feeding the target data back to the application layer.
6. The method of claim 5, wherein feeding back the target data to the application layer in response to the data query request comprises:
determining whether private data exists in the target data;
and under the condition that privacy data exist, desensitizing the target data, feeding the desensitized data back to the application layer, or acquiring identification information corresponding to the privacy data, adding the identification information into the target data, and feeding the identification information back to the application layer.
7. A data pull-through device, comprising:
an obtaining module, configured to obtain user data and device data of different service systems, where the service system includes at least one of the following: an online order system, an online order placing system, a member center system and an after-sales work order system;
and the pull-through module is used for carrying out data pull-through on the user data and the equipment data of the different service systems and storing the pulled-through data in a target database.
8. The apparatus of claim 7, comprising:
the acquisition module is further used for acquiring user identification information from the user data, wherein the user identification information is used for uniquely identifying the user; and identifying the users corresponding to the same user identification information by different service systems as the same user.
9. A computer-readable storage medium, comprising a stored program, wherein the program is operable to perform the method of any one of claims 1 to 6.
10. An electronic device comprising a memory and a processor, characterized in that the memory has stored therein a computer program, the processor being arranged to execute the method of any of claims 1 to 6 by means of the computer program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011531151.1A CN112711623A (en) | 2020-12-22 | 2020-12-22 | Data pull-through method and device, storage medium and electronic device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011531151.1A CN112711623A (en) | 2020-12-22 | 2020-12-22 | Data pull-through method and device, storage medium and electronic device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112711623A true CN112711623A (en) | 2021-04-27 |
Family
ID=75545255
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011531151.1A Pending CN112711623A (en) | 2020-12-22 | 2020-12-22 | Data pull-through method and device, storage medium and electronic device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112711623A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113434549A (en) * | 2021-06-25 | 2021-09-24 | 青岛海尔科技有限公司 | Data processing method and device, storage medium and electronic device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107798541A (en) * | 2016-08-31 | 2018-03-13 | 苏宁云商集团股份有限公司 | A kind of monitoring method and system being used in line service |
| CN108388675A (en) * | 2018-03-26 | 2018-08-10 | 深圳市买买提信息科技有限公司 | Circulation method and terminal device are drawn in a kind of identity |
| CN110866070A (en) * | 2018-08-17 | 2020-03-06 | 阿里巴巴集团控股有限公司 | Data processing method, device, processing equipment and system |
-
2020
- 2020-12-22 CN CN202011531151.1A patent/CN112711623A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107798541A (en) * | 2016-08-31 | 2018-03-13 | 苏宁云商集团股份有限公司 | A kind of monitoring method and system being used in line service |
| CN108388675A (en) * | 2018-03-26 | 2018-08-10 | 深圳市买买提信息科技有限公司 | Circulation method and terminal device are drawn in a kind of identity |
| CN110866070A (en) * | 2018-08-17 | 2020-03-06 | 阿里巴巴集团控股有限公司 | Data processing method, device, processing equipment and system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113434549A (en) * | 2021-06-25 | 2021-09-24 | 青岛海尔科技有限公司 | Data processing method and device, storage medium and electronic device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110807085B (en) | Fault information query method and device, storage medium and electronic device | |
| KR20170032448A (en) | Data information transaction method and system | |
| CN105931123A (en) | Method and apparatus for recommending friends based on network account | |
| US20070090179A1 (en) | Procurance data management system | |
| CN108256721A (en) | A kind of method for scheduling task, terminal device and medium | |
| CN111966866A (en) | Data asset management method and device | |
| CN112632405A (en) | Recommendation method, device, equipment and storage medium | |
| CN110580587A (en) | Real estate project purchasing client affiliation management system and method | |
| CN108491408B (en) | Activity information processing method and device, electronic equipment and storage medium | |
| CN111414410A (en) | Data processing method, device, equipment and storage medium | |
| CN112711623A (en) | Data pull-through method and device, storage medium and electronic device | |
| CN111047387A (en) | Recovery management method and device | |
| CN112328760B (en) | Service providing method, device and system | |
| CN107784591B (en) | Method and device for processing list data | |
| CN109902196B (en) | Trademark category recommendation method and device, computer equipment and storage medium | |
| CN110753323A (en) | Card resource allocation method and server | |
| CN108021588B (en) | Integration method and device for user first purchase data facing electronic commerce | |
| CN110471926B (en) | File establishing method and device | |
| CN112860700A (en) | Data table generation method and device, storage medium and electronic device | |
| CN110782380B (en) | Aviation change information management method and device and storage medium | |
| CN112561391A (en) | Material management method and device, storage medium and electronic device | |
| CN111625711A (en) | New house source push processing method and device, electronic equipment and storage medium | |
| CN113327146A (en) | Information tracking method and device | |
| EP3511843A1 (en) | Method and system for integrating data received from one or more data sources | |
| CN112200605B (en) | Marketing strategy configuration method, execution method, terminal device and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210427 |
|
| RJ01 | Rejection of invention patent application after publication |