CN110569249A - data change pushing method and device and electronic equipment - Google Patents
data change pushing method and device and electronic equipment Download PDFInfo
- Publication number
- CN110569249A CN110569249A CN201910724443.8A CN201910724443A CN110569249A CN 110569249 A CN110569249 A CN 110569249A CN 201910724443 A CN201910724443 A CN 201910724443A CN 110569249 A CN110569249 A CN 110569249A
- Authority
- CN
- China
- Prior art keywords
- field
- subscriber
- data
- subscription
- data change
- 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
- 230000008859 change Effects 0.000 title claims abstract description 111
- 238000000034 method Methods 0.000 title claims abstract description 41
- 230000007246 mechanism Effects 0.000 claims abstract description 62
- 238000007405 data analysis Methods 0.000 claims abstract description 38
- 238000004590 computer program Methods 0.000 claims description 10
- 230000001360 synchronised effect Effects 0.000 claims description 5
- 238000004458 analytical method Methods 0.000 claims description 3
- 230000002596 correlated effect Effects 0.000 claims description 3
- 230000006870 function Effects 0.000 description 9
- 230000000875 corresponding effect Effects 0.000 description 7
- 230000008569 process Effects 0.000 description 6
- 230000004048 modification Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 238000012508 change request Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 230000006872 improvement Effects 0.000 description 2
- 210000001747 pupil Anatomy 0.000 description 2
- CIWBSHSKHKDKBQ-JLAZNSOCSA-N Ascorbic acid Chemical compound OC[C@H](O)[C@H]1OC(=O)C(O)=C1O CIWBSHSKHKDKBQ-JLAZNSOCSA-N 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000011022 operating instruction Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
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/23—Updating
- G06F16/2358—Change logging, detection, and notification
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application provides a method and a device for pushing data change and electronic equipment. The method comprises the following steps: when data change occurs in a field of a data table, extracting subscription information of the field from a preset storage area of a database, wherein the subscription information comprises subscriber information of the field and a data analysis and identification mechanism customized by a subscriber for the field; judging whether the data change of the field meets the subscription pushing condition of the subscriber or not based on the data analysis and identification mechanism customized for the field by the subscriber; and if the subscription pushing condition is met, pushing related information of the data change of the field to the subscriber.
Description
Technical Field
the embodiment of the application relates to the technical field of data processing, in particular to a data change pushing method and device and electronic equipment.
Background
With the popularization of computer network applications, the capacity of databases is also increasing, and the accompanying data change is more and more frequent. In many scenarios, data in one data table may be depended on by multiple systems, and in order to ensure consistency, after data change occurs in the data table, information related to the change needs to be actively pushed to the systems.
however, in actual situations, the points of interest of the systems for the data tables are different, and how to simply and practically provide customized data change pushing is a technical problem which needs to be solved at present.
disclosure of Invention
The embodiment of the application aims to provide a data change pushing method, a data change pushing device and electronic equipment, which can simply and practically realize customized data change pushing service.
In order to achieve the above purpose, the embodiments of the present application are implemented as follows:
In a first aspect, a data change pushing method is provided, including:
When data change occurs in a field of a data table, extracting subscription information of the field from a preset storage area of a database, wherein the subscription information comprises subscriber information of the field and a data analysis and identification mechanism customized by a subscriber for the field;
Judging whether the data change of the field meets the subscription pushing condition of the subscriber or not based on the data analysis and identification mechanism customized for the field by the subscriber;
And if the subscription pushing condition is met, pushing related information of the data change of the field to the subscriber.
In a second aspect, a data change pushing device is provided, which includes:
The subscription determining module is used for extracting subscription information of a field from a preset storage area of a database when the data of the field of the data table is changed, wherein the subscription information comprises subscriber information of the field and a data analysis and identification mechanism customized by a subscriber for the field;
The pushing judgment module is used for judging whether the data change of the field meets the subscribing pushing condition of the subscriber or not based on the data analysis and identification mechanism customized for the field by the subscriber;
And the pushing execution module is used for pushing the relevant information of the data change of the field to the subscriber if the subscription pushing condition is met.
in a third aspect, an electronic device is provided that includes: a memory, a processor, and a computer program stored on the memory and executable on the processor, the computer program being executed by the processor to:
when data change occurs in a field of a data table, extracting subscription information of the field from a preset storage area of a database, wherein the subscription information comprises subscriber information of the field and a data analysis and identification mechanism customized by a subscriber for the field;
Judging whether the data change of the field meets the subscription pushing condition of the subscriber or not based on the data analysis and identification mechanism customized for the field by the subscriber;
And if the subscription pushing condition is met, pushing related information of the data change of the field to the subscriber.
In a fourth aspect, a computer-readable storage medium is provided, having stored thereon a computer program which, when executed by a processor, performs the steps of:
When data change occurs in a field of a data table, extracting subscription information of the field from a preset storage area of a database, wherein the subscription information comprises subscriber information of the field and a data analysis and identification mechanism customized by a subscriber for the field;
Judging whether the data change of the field meets the subscription pushing condition of the subscriber or not based on the data analysis and identification mechanism customized for the field by the subscriber;
and if the subscription pushing condition is met, pushing related information of the data change of the field to the subscriber.
The scheme of the embodiment of the application adds the subscription function to the fields in the data table. The subscriber can selectively subscribe the fields depended on in the data table and the custom subscription fields to carry out push notification when the data change occurs, thereby realizing customized push service. The whole scheme has simple and definite logic, is easy to develop and maintain at a later stage, and has high practicability.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only some embodiments described in the embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without any creative efforts.
Fig. 1 is a first flowchart of a data change pushing method according to an embodiment of the present application.
fig. 2 is a second flowchart of a data change pushing method according to an embodiment of the present application.
fig. 3 is a schematic structural diagram of a data change pushing device according to an embodiment of the present application.
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
in order to make those skilled in the art better understand the technical solutions in the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
as described above, in many scenarios, data of a data table may be depended on by multiple systems, and in order to ensure data consistency, when data is changed, information related to the change needs to be actively pushed to the systems. In practical application, each system has different dependence on data in a data table, and how to provide customized data change push service on the premise of less increasing development difficulty is a current technical difficulty.
therefore, the application aims to provide a simple, practical and customizable data change pushing scheme.
Fig. 1 is a flowchart of a data change pushing method according to an embodiment of the present application. The method shown in fig. 1 may be performed by a corresponding apparatus, comprising:
Step S102, when data change occurs in a field of the data table, extracting subscription information of the field from a preset storage area of the database, wherein the subscription information comprises subscriber information of the field and a data analysis and identification mechanism customized by a subscriber for the field.
In the embodiment of the present application, any field in the data table may be configured with a subscription function, and any individual having data dependency on the field in the data table may serve as a subscriber to specify a field concerned by the subscription itself.
It should be noted that the field in the embodiment of the present application may refer to an independently divided field in a data table, or may refer to a field on a service semantic level (i.e., a field involved in performing a fixed step in a service).
And step S104, judging whether the data change of the field meets the subscription pushing condition of the subscriber or not based on the data analysis and identification mechanism customized by the subscriber for the field.
Obviously, in the example of the present application, it is not necessary to push a notification to the subscriber when the field has data change, but it is determined whether the field needs to be pushed to the subscriber after the data change according to a data parsing and identifying mechanism customized by the subscriber based on its own requirements.
by way of exemplary presentation:
Assuming that a certain service provider provides adult gifts to clients who step into 18 years old, a field about the client 'age' in a data table is subscribed, and a customized data parsing and identifying mechanism is used for judging whether the client reaches 18 years old or not when the age field is changed. If a certain client reaches 18 years old, pushing to a service provider to inform the service provider that the service provider is ready to give a yearly gift in time; if the customer does not reach age 18 or has exceeded age 18, there is no need to push to the facilitator.
and step S106, if the subscription pushing condition is met, pushing the relevant information of the field with data change to the subscriber.
It should be understood that this step specifically sends only the relevant information of the data change of the field to the subscriber who meets the subscription push condition. Here, the pushed related information is not particularly limited, and any data sending subscriber can be notified that the field subscribed by the subscriber has changed, or the specific data sending subscriber after the field has changed is applied to the scheme of the embodiment of the present application.
based on the data change pushing method shown in fig. 1, it can be known that the scheme of the embodiment of the present application adds a subscription function to a field in a data table. The subscriber can selectively subscribe the fields depended on in the data table and the custom subscription fields to carry out push notification when the data change occurs, thereby realizing customized push service. The whole scheme has simple and definite logic, is easy to develop and maintain at a later stage, and has high practicability.
The method of the examples of the present application is described in detail below.
The data change pushing method of the embodiment of the application can be applied to an operator of a database, such as a database system, and the corresponding main processes include:
step S201, after performing a change operation on data in the database, determining a target field of the data table causing a data change.
Here, the embodiment of the present application does not specifically limit a scenario in which the database performs the data change operation. In addition, after the data in the database is changed, the field for determining the data table accompanying the data change also belongs to the existing function of the database, and therefore, the description is not repeated herein for example.
step S202, obtaining the subscription information of the target field from the preset storage area of the database.
wherein a field can be subscribed to by multiple subscribers simultaneously. Therefore, in the preset storage area, a field may contain at least one subscriber information and a data parsing and identifying mechanism customized for the field by each subscriber.
by way of exemplary presentation:
assume that a data table has an independently partitioned field of "age". The "age" field is simultaneously subscribed to by subscriber a, subscriber B, and subscriber C. The subscription information of the "age" field stored in the preset storage space may include:
Subscriber a information (such as identification information) -data parsing and recognition mechanism of subscriber a; subscriber B information (such as identification information) -data parsing and recognition mechanism of subscriber B; subscriber C information (such as identification information) -data parsing identification mechanism of subscriber C.
In practice, a subscriber may actively configure the database with subscription information for specific fields of interest.
That is, in the method of the embodiment of the present application, the system of the database may receive a subscription request initiated by the target subscriber, where the subscription request carries specified fields (the specified fields are not limited to one) that the target subscriber needs to subscribe, and a data parsing and identifying mechanism that the target subscriber defines for the specified fields. And then, the system of the database stores the data analysis and identification mechanism customized by the target subscriber for the specified field and the target subscriber information as the subscription information of the specified field in a preset storage area in a correlated manner.
The data analysis and identification mechanism may be a script program manufactured in a process of judging whether the data change of the field meets the subscription push condition. In an embodiment of the application, the script program can be provided by the subscriber directly through a subscription request; or, the subscriber only provides a data analysis and identification mechanism through the subscription request, and the database system actively generates a corresponding script program based on the data analysis and identification mechanism in the subscription request after receiving the subscription request.
Step S203, acquiring a data parsing and identifying mechanism of each subscriber in the subscription message, and determining which subscription push conditions of the subscribers are satisfied by data changes occurring in the target field based on the data parsing and identifying mechanism.
The data analysis and identification mechanism is processing logic for judging whether the key value of the designated key in the field meets the subscription push condition after being changed. In practical applications, a field may have one or more keys, wherein only some keys need to be pushed to the subscription scheme after key value changes occur. Therefore, the data parsing and identifying mechanism needs to include a parsing mechanism of the key value of the designated key and an identifying mechanism of whether the key value of the designated key meets a preset standard. It should be understood that, if the key value of the designated key reaches the preset standard after the data change occurs in the field, it is determined that the data change occurring in the field satisfies the subscription push condition.
By way of exemplary presentation:
Assuming that an insurance company provides student insurance business for newborn pupils, the field concerned by the insurance company is the field of 'newborn pupils' in business semantics. Assuming that the business scenario is that the insurance company transacts student insurance business for a new birth up to 6 years old, the field of 'new birth of primary school' relates to two main keys of 'occupation' and 'years'. The data analysis and identification mechanism customized by the insurance company comprises a key value analysis mechanism of occupation and years and an identification mechanism for judging whether the occupation is a student and the years are 6 years old.
Assuming that the birthday of the user A is 6 years old and the birthday of the user B is 8 years old, the key value of the field of the personal information 'age' of the user A is changed from 5 years old to 6 years old, and the key value of the field of the personal information 'age' of the user B is changed from 7 years old to 8 years old. At this point, the database system needs to determine whether it needs to be pushed to the insurance company. Specifically, in the judging process, the system of the database acquires subscription information of a field of 'newborn in primary school' from a local preset storage area, and operates a data analysis and identification mechanism defined by an insurance company in the subscription information, so that the user A is found to be a student and reaches 6 years old, belongs to the newborn in primary school, and meets the subscription pushing condition; the user B is a student, but the age is over 6 years old, belongs to the old of primary school, and does not accord with the subscription pushing condition.
And step S204, pushing the data change message of the target field to the subscriber meeting the subscription pushing condition.
specifically, the subscription message of one field may further include a subscription push manner customized by the subscriber. The data change message can be pushed to the subscribers meeting the subscription push condition according to the self-defined subscription push mode.
the subscription pushing mode is not specifically limited in the embodiment of the application. The pushing mode is taken as an exemplary introduction: assuming that the subscriber is an application server, the subscription push manner may specifically refer to configuration of a connection manner between a system of the database and the application server (e.g., a long polling connection manner, a websocket connection manner, etc.), configuration of a connection duration (active disconnection if the connection duration is exceeded), configuration of connection current limitation (an upper limit of an occupied bandwidth resource of the application server), and the like. Assuming that the subscriber is a user terminal device, the subscription push manner may be configured in a push manner (e.g., mailbox, short message, etc.), push address (e.g., mailbox address, mobile phone number, etc.), and the like.
the method of the embodiment of the present application is described below by way of example with reference to a practical application scenario.
the execution main body of the application scene is assumed to be a cloud system, and the business objects of the cloud system comprise users of service using terminals and application programs of various service providing terminals.
the cloud system is used as a data center, records personal data of a service user end user, and presents the personal data in a data table: user identification, user name, user gender, user age, and user location. Different application programs can use the personal data of the cloud system to provide corresponding services for users of the service users. For example, weather application software may retrieve personal data of users in the cloud system and provide weather forecast of locations of the users to the users.
Specifically, the cloud system is provided with at least two nodes forming a network, one of the nodes serves as a master node, the other nodes serve as slave nodes, each node respectively stores a data table of user personal data, and the data tables of the nodes need to be synchronized with each other to meet data consistency.
In the application scenario, zhang san is a user of a service user, and the information of each person in the cloud system is as follows:
And (3) user identification: zhang three mobile phone number, user name Zhang three, user gender: male, age of user: 17, user location: district XX of Chaojingyang city, Community A, building B, cell C.
Suppose that Zhang three locations move to the cell F room of the D-type building E of the YY community in the sunny region of Beijing, the change request of the locations needs to be initiated to the cloud system. And after the cloud system receives the change request, the main node processes the data change. In the data changing process, the main node firstly changes the 'location' field corresponding to Zhang III in the data table of the main node, and then synchronizes the changed data table to other nodes. It should be noted here that the data tables may be synchronized in an incremental manner, or may be different in a full-scale manner, and the present application does not relate to the improvement in this respect, and therefore, the details are not described herein for example.
After the data tables of all the slave nodes are synchronized to the data table of the master node, the master node (or another node) calls the subscription information of the 'location' field from the preset storage area of the database.
Here, it is assumed that the "take-away application" and the "weather forecast application" subscribe to the field of the "location". Wherein the bond in the "locus" includes: "city of place", "administrative district of place", "community of place", "building of place", "unit of place", and "room of place". Obviously, for the business scene of take-away application, any key is subjected to data change and needs to be pushed by the cloud system; for a business scene of weather application, the cloud system is required to push only when data change occurs to a key of the 'city where the cloud system is located'.
Therefore, in the subscription message of the "place", the customized data parsing and identifying mechanism of the "take-away application" is as follows: identifying whether the key value of any key changes or not, and meeting the subscription push condition as long as the key value of any key is identified to change; the self-defined data analysis and identification mechanism of the weather application is as follows: and only identifying whether the key value of the 'city of the user' is changed or not, and identifying that the key value of the 'city of the user' is changed, wherein the subscription push condition is met.
In the application scenario, after the master node acquires the subscription, based on the data analysis and identification mechanisms of the take-away application and the weather forecast application, the data change request aiming at the location initiated by Zhang III can be judged, and only needs to be pushed to the take-away application.
then, the master node sends a data change push of Zhang III 'location' to the server of the 'take-away application', and after receiving the push, the server of the 'take-away application' can request the information of Zhang III 'location' recorded in the data table from any node in the cloud system so as to locally update the delivery address of Zhang III.
Of course, the master node may also directly encapsulate the updated "location" information of zhang san into the data change push, and the server of the "takeaway application" may directly locally update the delivery address of zhang san after receiving the push.
the above is a description of the method of the embodiments of the present application. It will be appreciated that appropriate modifications may be made without departing from the principles outlined herein, and such modifications are intended to be included within the scope of the embodiments herein.
in correspondence with the above method, as shown in fig. 3, an embodiment of the present application further provides a data change pushing device 300, including:
The subscription determining module 310 extracts subscription information of a field from a preset storage area of a database when the data of the field of the data table is changed, where the subscription information includes subscriber information of the field and a data parsing and identifying mechanism customized by a subscriber for the field.
The pushing determination module 320 determines whether the data change occurring in the field meets the subscription pushing condition of the subscriber based on the data parsing and identifying mechanism customized for the field by the subscriber.
The push execution module 330, if the subscription push condition is satisfied, pushes the relevant information of the data change of the field to the subscriber.
As can be known from the data change pushing apparatus shown in fig. 3, the scheme according to the embodiment of the present application adds a subscription function to a field in a data table. The subscriber can selectively subscribe the fields depended on in the data table and the custom subscription fields to carry out push notification when the data change occurs, thereby realizing customized push service. The whole scheme has simple and definite logic, is easy to develop and maintain at a later stage, and has high practicability.
optionally, the data parsing and identifying mechanism for the field in the subscription includes: and the field comprises an analysis mechanism for the key value of the appointed key in the field and an identification mechanism for judging whether the key value of the appointed key reaches a preset standard or not. And if the key value of the designated key reaches the preset standard after the data change of the field occurs, judging that the data change of the field meets the subscription pushing condition.
optionally, the apparatus in this embodiment of the present application further includes:
The subscription acceptance module receives a subscription request initiated by a target subscriber, wherein the target subscription request carries a specified field to be subscribed by the target subscriber and a data analysis and identification mechanism customized by the target subscriber for the specified field.
And the subscription adding module is used for taking a data analysis and identification mechanism customized by the target subscriber for a specified field and the target subscriber information as the subscription information of the specified field to be stored in the preset storage area in a correlated manner.
Optionally, the subscription information of the field has at least one subscriber information and a data parsing and identifying mechanism that each subscriber individually customizes to the field.
optionally, the database is a database of a cloud system, the cloud system having at least two nodes. The pushing execution module 330 is executed to push the information about the data change of the field to the subscriber, specifically based on one of the at least two nodes.
optionally, one of the at least two nodes serves as a master node, and each node of the cloud system has a data table corresponding to each node and needing to be synchronized with each other. When data change occurs in the fields of the data table, the following means are used: and the main node performs data change on fields in the data table of the main node based on data change operation, and synchronizes the data table after the data change to other nodes.
Optionally, the information about the data change of the field includes: and the field is notified of the data change or the field is subjected to the key value information after the data change.
Obviously, the data change pushing apparatus according to the embodiment of the present application can be used as the execution main body of the data change pushing method shown in fig. 1, and thus can realize the functions of the data change pushing method realized in fig. 1 and fig. 2. Since the principle is the same, the detailed description is omitted here.
Fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present application. Referring to fig. 4, at a hardware level, the electronic device includes a processor, and optionally further includes an internal bus, a network interface, and a memory. The Memory may include a Memory, such as a Random-Access Memory (RAM), and may further include a non-volatile Memory, such as at least 1 disk Memory. Of course, the electronic device may also include hardware required for other services.
the processor, the network interface, and the memory may be connected to each other via an internal bus, which may be an ISA (Industry Standard Architecture) bus, a PCI (peripheral component Interconnect) bus, an EISA (Extended Industry Standard Architecture) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one double-headed arrow is shown in FIG. 4, but that does not indicate only one bus or one type of bus.
And the memory is used for storing programs. In particular, the program may include program code comprising computer operating instructions. The memory may include both memory and non-volatile storage and provides instructions and data to the processor.
the processor reads the corresponding computer program from the nonvolatile memory to the memory and then runs the computer program, and the data change pushing device is formed on the logic level. The processor is used for executing the program stored in the memory and is specifically used for executing the following operations:
When data change occurs in a field of a data table, extracting subscription information of the field from a preset storage area of a database, wherein the subscription information comprises subscriber information of the field and a data analysis and identification mechanism customized by a subscriber for the field;
Judging whether the data change of the field meets the subscription pushing condition of the subscriber or not based on the data analysis and identification mechanism customized for the field by the subscriber;
and if the subscription pushing condition is met, pushing related information of the data change of the field to the subscriber.
Based on the electronic device shown in fig. 4, it can be known that the scheme of the embodiment of the present application adds a subscription function to a field in a data table. The subscriber can selectively subscribe the fields depended on in the data table and the custom subscription fields to carry out push notification when the data change occurs, thereby realizing customized push service. The whole scheme has simple and definite logic, is easy to develop and maintain at a later stage, and has high practicability.
The data change pushing method disclosed in the embodiment of fig. 1 of the present application may be applied to a processor, or may be implemented by a processor. The processor may be an integrated circuit chip having signal processing capabilities. In implementation, the steps of the above method may be performed by integrated logic circuits of hardware in a processor or instructions in the form of software. The Processor may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; but also Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components. The various methods, steps, and logic blocks disclosed in the embodiments of the present application may be implemented or performed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of the method disclosed in connection with the embodiments of the present application may be directly implemented by a hardware decoding processor, or implemented by a combination of hardware and software modules in the decoding processor. The software module may be located in ram, flash memory, rom, prom, or eprom, registers, etc. storage media as is well known in the art. The storage medium is located in a memory, and a processor reads information in the memory and completes the steps of the method in combination with hardware of the processor.
it should be understood that the electronic device according to the embodiment of the present application may implement the functions of the above-described apparatus in the embodiments shown in fig. 1 and fig. 2, and details are not described herein again.
Of course, besides the software implementation, the electronic device of the present application does not exclude other implementations, such as a logic device or a combination of software and hardware, and the like, that is, the execution subject of the following processing flow is not limited to each logic unit, and may also be hardware or a logic device.
Furthermore, an embodiment of the present application also provides a computer-readable storage medium storing one or more programs, where the one or more programs include instructions, which when executed by a portable electronic device including a plurality of application programs, can cause the portable electronic device to perform the method of the embodiment shown in fig. 1, and specifically to perform the following method:
when data change occurs in a field of a data table, extracting subscription information of the field from a preset storage area of a database, wherein the subscription information comprises subscriber information of the field and a data analysis and identification mechanism customized by a subscriber for the field;
Judging whether the data change of the field meets the subscription pushing condition of the subscriber or not based on the data analysis and identification mechanism customized for the field by the subscriber;
and if the subscription pushing condition is met, pushing related information of the data change of the field to the subscriber.
It should be understood that the above-mentioned instructions, when executed by the portable electronic device including a plurality of application programs, can enable the data change pushing apparatus described above to implement the functions of the embodiments shown in fig. 1 and fig. 2, and will not be described in detail herein.
As will be appreciated by one skilled in the art, embodiments of the present description may be provided as a method, system, or computer program product. Accordingly, the description may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the description may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The foregoing description has been directed to specific embodiments of this disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims may be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing may also be possible or may be advantageous.
the above description is only an example of the present specification, and is not intended to limit the present specification. Various modifications and alterations to this description will become apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present specification should be included in the scope of the claims of the present specification.
Claims (10)
1. A data change pushing method comprises the following steps:
When data change occurs in a field of a data table, extracting subscription information of the field from a preset storage area of a database, wherein the subscription information comprises subscriber information of the field and a data analysis and identification mechanism customized by a subscriber for the field;
judging whether the data change of the field meets the subscription pushing condition of the subscriber or not based on the data analysis and identification mechanism customized for the field by the subscriber;
and if the subscription pushing condition is met, pushing related information of the data change of the field to the subscriber.
2. The method of claim 1, wherein the first and second light sources are selected from the group consisting of,
The data parsing and identifying mechanism for the field in the subscription comprises: the field comprises an analysis mechanism for the key value of a designated key in the field and an identification mechanism for judging whether the key value of the designated key reaches a preset standard or not;
And if the key value of the designated key reaches the preset standard after the data change of the field occurs, judging that the data change of the field meets the subscription pushing condition.
3. The method of claim 1, further comprising:
Receiving a subscription request initiated by a target subscriber, wherein the target subscription request carries specified fields to be subscribed by the target subscriber and a data analysis and identification mechanism customized by the target subscriber for the specified fields;
And taking a data analysis and identification mechanism customized by the target subscriber for a specified field and the target subscriber information as the subscription information of the specified field to be stored in the preset storage area in a correlated manner.
4. The method of any one of claims 1-3,
The subscription information of the field comprises at least one subscriber information and a data analysis and identification mechanism which is customized by each subscriber for the field.
5. The method of any one of claims 1-3,
The database is a database of a cloud system, and the cloud system is provided with at least two nodes;
Pushing the relevant information of the data change of the field to the subscriber, including:
Based on one of the at least two nodes, pushing relevant information of the data change of the field to the subscriber.
6. The method of claim 5, wherein the first and second light sources are selected from the group consisting of,
One of the at least two nodes is used as a main node, and each node of the cloud system is provided with a data table which respectively corresponds to each other and needs to be synchronized with each other;
When data change occurs in the fields of the data table, the following means are used: and when the main node performs data change on fields in the data table of the main node based on data change operation and synchronizes the data table after the data change to other nodes.
7. The method of any one of claims 1-3,
the relevant information of the data change of the field comprises: and the field is notified of the data change or the field is subjected to the key value information after the data change.
8. A data change pushing device, comprising:
The subscription determining module is used for extracting subscription information of a field from a preset storage area of a database when the data of the field of the data table is changed, wherein the subscription information comprises subscriber information of the field and a data analysis and identification mechanism customized by a subscriber for the field;
the pushing judgment module is used for judging whether the data change of the field meets the subscribing pushing condition of the subscriber or not based on the data analysis and identification mechanism customized for the field by the subscriber;
and the pushing execution module is used for pushing the relevant information of the data change of the field to the subscriber if the subscription pushing condition is met.
9. an electronic device includes: a memory, a processor, and a computer program stored on the memory and executable on the processor, the computer program being executed by the processor to:
When data change occurs in a field of a data table, extracting subscription information of the field from a preset storage area of a database, wherein the subscription information comprises subscriber information of the field and a data analysis and identification mechanism customized by a subscriber for the field;
judging whether the data change of the field meets the subscription pushing condition of the subscriber or not based on the data analysis and identification mechanism customized for the field by the subscriber;
And if the subscription pushing condition is met, pushing related information of the data change of the field to the subscriber.
10. a computer-readable storage medium having a computer program stored thereon, which when executed by a processor, performs the steps of:
when data change occurs in a field of a data table, extracting subscription information of the field from a preset storage area of a database, wherein the subscription information comprises subscriber information of the field and a data analysis and identification mechanism customized by a subscriber for the field;
Judging whether the data change of the field meets the subscription pushing condition of the subscriber or not based on the data analysis and identification mechanism customized for the field by the subscriber;
And if the subscription pushing condition is met, pushing related information of the data change of the field to the subscriber.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910724443.8A CN110569249A (en) | 2019-08-07 | 2019-08-07 | data change pushing method and device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910724443.8A CN110569249A (en) | 2019-08-07 | 2019-08-07 | data change pushing method and device and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110569249A true CN110569249A (en) | 2019-12-13 |
Family
ID=68774709
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910724443.8A Pending CN110569249A (en) | 2019-08-07 | 2019-08-07 | data change pushing method and device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110569249A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111460014A (en) * | 2020-03-02 | 2020-07-28 | 北京电信易通信息技术股份有限公司 | Third-party application data synchronization method and system based on police database |
| CN112214475A (en) * | 2020-11-04 | 2021-01-12 | 成都中科大旗软件股份有限公司 | Method, system, storage medium and terminal for configuring multiple data sources |
| CN112328672A (en) * | 2020-11-04 | 2021-02-05 | 成都中科大旗软件股份有限公司 | Method, system, storage medium and terminal for mapping API (application program interface) interface by data service |
| CN114265877A (en) * | 2021-12-30 | 2022-04-01 | 中国民航信息网络股份有限公司 | Information pushing method and device, electronic equipment and storage medium |
| CN117407406A (en) * | 2023-10-23 | 2024-01-16 | 上海聚水潭网络科技有限公司 | Method, system and equipment for acquiring data based on subscription mode |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1988551A (en) * | 2005-12-22 | 2007-06-27 | 腾讯科技（深圳）有限公司 | Online user inquiry method and system |
| CN102118735A (en) * | 2010-01-05 | 2011-07-06 | 中兴通讯股份有限公司 | Method for realizing data subscription notification based on lightweight directory access protocol |
| CN109542892A (en) * | 2018-10-19 | 2019-03-29 | 北京全路通信信号研究设计院集团有限公司 | Method, device and system for realizing relation of real-time database |
-
2019
- 2019-08-07 CN CN201910724443.8A patent/CN110569249A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1988551A (en) * | 2005-12-22 | 2007-06-27 | 腾讯科技（深圳）有限公司 | Online user inquiry method and system |
| CN102118735A (en) * | 2010-01-05 | 2011-07-06 | 中兴通讯股份有限公司 | Method for realizing data subscription notification based on lightweight directory access protocol |
| CN109542892A (en) * | 2018-10-19 | 2019-03-29 | 北京全路通信信号研究设计院集团有限公司 | Method, device and system for realizing relation of real-time database |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111460014A (en) * | 2020-03-02 | 2020-07-28 | 北京电信易通信息技术股份有限公司 | Third-party application data synchronization method and system based on police database |
| CN112214475A (en) * | 2020-11-04 | 2021-01-12 | 成都中科大旗软件股份有限公司 | Method, system, storage medium and terminal for configuring multiple data sources |
| CN112328672A (en) * | 2020-11-04 | 2021-02-05 | 成都中科大旗软件股份有限公司 | Method, system, storage medium and terminal for mapping API (application program interface) interface by data service |
| CN114265877A (en) * | 2021-12-30 | 2022-04-01 | 中国民航信息网络股份有限公司 | Information pushing method and device, electronic equipment and storage medium |
| WO2023123755A1 (en) * | 2021-12-30 | 2023-07-06 | 中国民航信息网络股份有限公司 | Information pushing method and apparatus, electronic device and storage medium |
| CN117407406A (en) * | 2023-10-23 | 2024-01-16 | 上海聚水潭网络科技有限公司 | Method, system and equipment for acquiring data based on subscription mode |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110569249A (en) | data change pushing method and device and electronic equipment | |
| CN109639636B (en) | Service data forwarding method, service data processing method, service data forwarding device, service data processing device and electronic equipment | |
| CN111327519A (en) | Method, device, equipment and storage medium for sending multi-channel message content | |
| CN109815261B (en) | Global search function implementation and data real-time synchronization method and device and electronic equipment | |
| CN110035388B (en) | Method for determining user area, computer readable storage medium and terminal device | |
| CN109739873A (en) | A kind of business datum querying method, device, equipment and readable storage medium storing program for executing | |
| US20200257749A1 (en) | Method and a device for friend recommendation | |
| US10115391B2 (en) | Method and apparatus for providing voice feedback information to user in call | |
| KR101521866B1 (en) | Methods and systems for displaying microblog topics | |
| CN111581502A (en) | Information notification method and device | |
| CN110875983B (en) | Method, device, equipment and medium for evaluating terminal service quality | |
| CN113407823A (en) | IOS message pushing method and system | |
| CN112073215A (en) | Method for realizing application and service controller | |
| CN108830298B (en) | Method and device for determining user feature tag | |
| CN114979256B (en) | Message pushing method and device, electronic equipment and computer readable medium | |
| CN109379704B (en) | Method, device and equipment for correcting regional information of short message and storage medium | |
| CN110493735B (en) | Short message processing method and device | |
| CN110472113B (en) | Intelligent interaction engine optimization method, device and equipment | |
| CN113890906A (en) | Call forwarding method and device, electronic equipment and computer readable storage medium | |
| CN111274209A (en) | Call bill file processing method and device | |
| CN113595884A (en) | Message reminding method and application terminal | |
| CN112749169A (en) | Address tree construction method, address planning specification method, device and electronic equipment | |
| CN115080521A (en) | Information display method and device, electronic equipment and storage medium | |
| CN111367634A (en) | Information processing method, information processing device and terminal equipment | |
| CN112328672A (en) | Method, system, storage medium and terminal for mapping API (application program interface) interface by data service |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20200924 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20200924 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Applicant after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |
|
| TA01 | Transfer of patent application right |