CN116578572A - Service date changing method, device, equipment, storage medium and program product - Google Patents
Service date changing method, device, equipment, storage medium and program product Download PDFInfo
- Publication number
- CN116578572A CN116578572A CN202310430445.2A CN202310430445A CN116578572A CN 116578572 A CN116578572 A CN 116578572A CN 202310430445 A CN202310430445 A CN 202310430445A CN 116578572 A CN116578572 A CN 116578572A
- Authority
- CN
- China
- Prior art keywords
- date
- service
- service date
- business
- database node
- 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 62
- 230000008859 change Effects 0.000 claims abstract description 47
- 238000004590 computer program Methods 0.000 claims description 19
- 238000010200 validation analysis Methods 0.000 claims description 8
- 238000010586 diagram Methods 0.000 description 12
- 230000015654 memory Effects 0.000 description 10
- 238000004891 communication Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 7
- 230000007246 mechanism Effects 0.000 description 7
- 238000012360 testing method Methods 0.000 description 7
- 230000004044 response Effects 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000014509 gene expression Effects 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000011084 recovery Methods 0.000 description 2
- 238000011144 upstream manufacturing Methods 0.000 description 2
- 230000002708 enhancing effect Effects 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000004806 packaging method and process Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000000758 substrate Substances 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
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2477—Temporal data queries
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The disclosure provides a business date changing method, relates to the technical field of cloud computing, and can be applied to the technical field of finance. The method is applied to a cloud database, the cloud database comprises at least one database node, each database node is pre-created with a service date table, and the method comprises the following steps: responding to a service date updating request, and acquiring service date adjustment requirement information, wherein the service date adjustment requirement information comprises target database node information and service date changing information; and updating the business date according to the target database node information and the business date change information. The present disclosure also provides a business date changing apparatus, device, storage medium, and program product.
Description
Technical Field
The present disclosure relates to the field of cloud technology, in particular to the field of testing technology, and more particularly, to a service date changing method, device, apparatus, storage medium, and program product.
Background
In banking industry, business date is a very important attribute, such as interest calculation, profit and loss calculation, etc., which is directly related to business date, and in the upstream and downstream of a business, the business date is strictly checked to prevent funds from being wrong. In some situations, the service date needs to be adjusted, for example, the service of testing the special service date (the end of year, the end of month, etc.) in the test environment, the adjustment can be realized by adjusting the system time of the server where the database is located under the traditional locally deployed centralized database, while under the cloud database, because the unified clock service is used in the cloud, the unified clock service is shared by the system and the application, and various mechanisms of the database depend on the unified clock service, thus the system time in the cloud cannot be directly adjusted. There is therefore a need for a general system level business date adjustment scheme.
It should be noted that the information disclosed in the above background section is only for enhancing understanding of the background of the present disclosure and thus may include information that does not constitute prior art known to those of ordinary skill in the art.
Disclosure of Invention
In view of the foregoing, the present disclosure provides a business date changing method, apparatus, device, storage medium, and program product.
According to a first aspect of the present disclosure, there is provided a business date changing method applied to a cloud database, the cloud database including at least one database node, each of the database nodes having a business date table created in advance, the method comprising:
responding to a service date updating request, and acquiring service date adjustment requirement information, wherein the service date adjustment requirement information comprises target database node information and service date changing information; and
and updating the service date according to the target database node information and the service date change information.
According to an embodiment of the present disclosure, the service date change information includes a target service date, a change type, and an adjustment effective date range, and updating the service date according to the target database node information and the service date change information includes:
connecting at least one target database node according to the target database node information;
and updating a service date table of the target database node according to the target service date, the change type and the adjustment effective date range.
According to an embodiment of the present disclosure, the updating the service date table of the target database node according to the target service date, the change type, and the adjustment validation date range includes:
when the change type is determined to be newly added, inserting the target service date and the adjustment effective date range into a service date table of the target database node; and deleting the data of the service date table of the target database node when the change type is determined to be deleted.
According to an embodiment of the present disclosure, the method further comprises:
responding to a service date inquiry request, and acquiring a database system date; and
and determining the service date according to the database system date and the service date table.
According to an embodiment of the disclosure, the determining a business date according to the database system date and the business date table includes:
if the service date record exists in the service date table and the database system date is determined to be in the adjustment effective date range corresponding to the service date record, returning the service date to a service date inquiring party; and
and if the service date record exists in the service date table and the data system date is not in the adjustment effective date range corresponding to the service date record, returning the database system date to the service date inquiring party.
According to an embodiment of the present disclosure, the determining a service date according to the database system date and the service date table further includes:
and if the service date table is determined to have no service date record, returning the database system date to a service date inquiring party.
A second aspect of the present disclosure provides a service date changing apparatus applied to a cloud database, the cloud database including at least one database node, each of the database nodes having a service date table created in advance, the apparatus comprising:
the first acquisition module is used for responding to a service date updating request and acquiring service date adjustment requirement information, wherein the service date adjustment requirement information comprises target database node information and service date change information; and
and the updating module is used for updating the service date according to the target database node information and the service date change information.
According to an embodiment of the present disclosure, further comprising:
the second acquisition module is used for responding to the service date inquiry request and acquiring the database system date; and
and the determining module is used for determining the service date according to the database system date and the service date table.
According to an embodiment of the present disclosure, the service date change information includes a target service date, a change type, and an adjustment effective date range, and the update module includes:
the connection sub-module is used for connecting at least one target database node according to the target database node information;
and the updating sub-module is used for updating the service date table of the target database node according to the target service date, the change type and the adjustment effective date range.
According to an embodiment of the present disclosure, the update sub-module includes: a first determination unit and a second determination unit.
A first determining unit, configured to insert the target service date and the adjustment effective date range into a service date table of the target database node when it is determined that the change type is newly added; and
and the second determining unit is used for deleting the data of the service date table of the target database node when the change type is determined to be deleted.
According to an embodiment of the present disclosure, the determining module includes: a first determination sub-module and a second determination sub-module.
The first determining submodule is used for returning the service date to the service date inquiring party if the service date record exists in the service date table and the database system date is determined to be in the adjustment effective date range corresponding to the service date record; and
and the second determining submodule is used for returning the database system date to the service date inquiring party if the service date record exists in the service date table and the data system date is determined not to be in the adjustment effective date range corresponding to the service date record.
A third aspect of the present disclosure provides an electronic device, comprising: one or more processors; and a memory for storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the business date changing method described above.
A fourth aspect of the present disclosure also provides a computer-readable storage medium having stored thereon executable instructions that, when executed by a processor, cause the processor to perform the business date changing method described above.
A fifth aspect of the present disclosure also provides a computer program product comprising a computer program which, when executed by a processor, implements the business date changing method described above.
According to the business date changing method provided by the embodiment of the disclosure, a business date table is pre-established in each database node, the business date table is used for maintaining business dates, when a business date updating request is received, business date adjustment requirement information is obtained, and the corresponding business date table is updated according to the business date adjustment requirement information. Compared with the related art, the embodiment of the disclosure provides a method for adjusting service date of cloud database system level, which can maintain service date by maintaining service date table, decouple system clock and service clock, and reduce development workload and operation and maintenance difficulty.
Drawings
The foregoing and other objects, features and advantages of the disclosure will be more apparent from the following description of embodiments of the disclosure with reference to the accompanying drawings, in which:
FIG. 1 schematically illustrates a system architecture diagram of a business date changing device according to an embodiment of the present disclosure;
FIG. 2 schematically illustrates an application scenario diagram of a business date changing method, apparatus, device, storage medium and program product according to an embodiment of the present disclosure;
FIG. 3 schematically illustrates a flow chart of a business date altering method provided in accordance with an embodiment of the present disclosure;
FIG. 4 schematically illustrates a flow chart of a business date altering method provided in accordance with another embodiment of the present disclosure;
FIG. 5 schematically illustrates one of the flowcharts of a business date changing method provided in accordance with yet another embodiment of the present disclosure;
FIG. 6 schematically illustrates a second flow chart of a business date changing method provided in accordance with yet another embodiment of the present disclosure;
fig. 7 schematically illustrates a block diagram of a business date changing device according to an embodiment of the present disclosure; and
fig. 8 schematically illustrates a block diagram of an electronic device adapted to implement a business date changing method according to an embodiment of the disclosure.
Detailed Description
Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is only exemplary and is not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the present disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. In addition, in the following description, descriptions of well-known structures and techniques are omitted so as not to unnecessarily obscure the concepts of the present disclosure.
The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The terms "comprises," "comprising," and/or the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.
All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It should be noted that the terms used herein should be construed to have meanings consistent with the context of the present specification and should not be construed in an idealized or overly formal manner.
Where expressions like at least one of "A, B and C, etc. are used, the expressions should generally be interpreted in accordance with the meaning as commonly understood by those skilled in the art (e.g.," a system having at least one of A, B and C "shall include, but not be limited to, a system having a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.).
In banking industry, there are some scenarios that need to adjust service dates, for example, a test environment tests a service of a special service date (end of year, end of month, etc.), in a centralized database deployed in a traditional way, the service can be realized by adjusting the system time of a server where the database is located, in a cloud database, because a unified clock service is used in the cloud and is shared by a system and an application, multiple mechanisms of the database depend on the unified clock service, including a multiple copy mechanism, a high availability switching mechanism, a transaction mechanism, a log switching mechanism, a backup recovery mechanism (recovery at a designated time point), and the like. The solutions that require each application to implement adjustment of business dates on the cloud are different and can lead to large differences in test and production functions. Because no unified implementation scheme exists at present, each application needs to access thousands of database nodes when realizing a complete service line by itself, the implementation scheme of the application upstream and downstream is complex, and the workload is large; in addition, each application realizes the self-adjustment of service time, relies on manual communication, and is easy to cause inconsistency due to human reasons.
Based on the above technical problems, an embodiment of the present disclosure provides a service date changing method applied to a cloud database, where the cloud database includes at least one database node, and each database node has a service date table created in advance, and the method includes: responding to a service date updating request, and acquiring service date adjustment requirement information, wherein the service date adjustment requirement information comprises target database node information and service date changing information; and updating the business date according to the target database node information and the business date change information.
Fig. 1 schematically illustrates a system architecture diagram of a business date changing device according to an embodiment of the present disclosure. As shown in fig. 1, the apparatus 100 includes a business date updating unit 101, a business date adjustment requirement information unit 102, a cloud database management unit 103, a database 104, a business date table 105, and a business date querying unit 106. The service date updating unit 101 is configured to initiate a service date updating request, read the service date adjustment requirement information unit 102, obtain information of an entire service line application node needing to adjust a service date, read the cloud database management unit 103, obtain connection information of an application database, connect to the database a/B104, update a service date table in the database, register an update result in the service date adjustment requirement information unit 102, and notify a requirement provider.
Fig. 2 schematically illustrates an application scenario diagram of a service date changing method, apparatus, device, storage medium and program product according to an embodiment of the present disclosure.
As shown in fig. 2, the application scenario 200 according to this embodiment may include a scenario in which a cloud database has a system-level adjustment business date. The network 204 is the medium used to provide communication links between the terminal devices 201, 202, 203 and the server 205. The network 204 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.
The user may interact with the server 205 via the network 204 using the terminal devices 201, 202, 203 to receive or send messages or the like. Various communication client applications, such as shopping class applications, web browser applications, search class applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only) may be installed on the terminal devices 201, 202, 203.
The terminal devices 201, 202, 203 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablets, laptop and desktop computers, and the like.
The server 205 may be a cloud database management server, where the service date changing method provided by the embodiment of the present disclosure is executed, and in response to a service date update request, service date adjustment requirement information is obtained, information of an entire service line application node needing to adjust a service date is obtained, application database connection information is obtained, the application database connection information is connected to a corresponding database node, and a service date table in the database node is updated. And responding to the service date inquiry request, and determining the service date according to the database system date and the service date table.
It should be noted that, the method for changing a service date provided by the embodiment of the present disclosure may be generally performed by the server 205. Accordingly, the service date changing device provided in the embodiments of the present disclosure may be generally disposed in the server 205. The service date changing method provided by the embodiment of the present disclosure may also be performed by a server or a server cluster that is different from the server 205 and is capable of communicating with the terminal devices 201, 202, 203 and/or the server 205. Accordingly, the service date changing device provided by the embodiments of the present disclosure may also be provided in a server or a server cluster that is different from the server 205 and is capable of communicating with the terminal devices 201, 202, 203 and/or the server 205.
It should be understood that the number of terminal devices, networks and servers in fig. 2 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
It should be noted that, the service date changing method and device determined by the embodiment of the present disclosure may be used in the technical field of cloud computing, or may be used in the technical field of finance, or may be used in any field other than the financial field, and the application field of the service date changing method and device determined by the embodiment of the present disclosure is not limited.
The following will describe in detail the service date changing method according to the embodiment of the disclosure through fig. 3 to 6 based on the system architecture described in fig. 1 and the application scenario described in fig. 2.
Fig. 3 schematically illustrates a flowchart of a business date changing method provided according to an embodiment of the present disclosure. As shown in fig. 3, the business date changing method of this embodiment includes operations S210 to S220, which may be performed by a server or other computing device. The service date changing method provided by the embodiment of the invention is applied to a cloud database, wherein the cloud database comprises at least one database node, and in order to decouple a system clock and a service clock, the normal operation of the cloud database node is not affected when the service date is modified, and a service date table is pre-created in each database node. The service date table stores service date change information.
In operation S210, service date adjustment requirement information is acquired in response to the service date update request.
In operation S220, a service date is updated according to the target database node information and the service date change information.
According to an embodiment of the present disclosure, the service date adjustment requirement information includes target database node information and service date change information.
In one example, after receiving a service date update request initiated by a user, service date adjustment requirement information is determined, where the service date adjustment requirement information includes target database node information and service date change information, where the target database node may be one or more, and in actual test production, a database node under a whole service line is changed usually with the whole service line as a dimension, so as to ensure that service dates under the same service line are consistent.
In one example, the service date adjustment requirement information may directly include database node information that needs to be changed, that is, target database node information, or may maintain a correspondence between a service and different nodes in advance, and determine the target database node information according to the correspondence. After determining the target database node information, the business date in the corresponding target database node is updated according to the business date change information, and the specific process may refer to operation S221 and operation S222 shown in fig. 4.
According to the business date changing method provided by the embodiment of the disclosure, a business date table is pre-established in each database node, the business date table is used for maintaining business dates, when a business date updating request is received, business date adjustment requirement information is obtained, and the corresponding business date table is updated according to the business date adjustment requirement information. Compared with the related art, the embodiment of the disclosure provides a method for adjusting service date of cloud database system level, which can maintain service date by maintaining service date table, decouple system clock and service clock, and reduce development workload and operation and maintenance difficulty.
Fig. 4 schematically illustrates a flowchart of a business date changing method provided according to another embodiment of the present disclosure. As shown in fig. 4, operation S220 includes operation S221 and operation S222.
At least one target database node is connected according to the target database node information in operation S221.
According to an embodiment of the present disclosure, the service date change information includes a target service date, a change type, and an adjustment validation date range.
In operation S222, the service date table of the target database node is updated according to the target service date, the change type, and the adjustment validation date range.
According to an embodiment of the present disclosure, the service date change information includes a target service date, a change type, and an adjustment validation date range.
According to an embodiment of the present disclosure, when the change type is determined to be a new addition, the target service date and the adjustment effective date range are inserted into a service date table of the target database node; and deleting the data of the service date table of the target database node when the change type is determined to be deleted.
In one example, the databases are connected according to target database node information, and the databases may be, for example, in-cloud databases, including Oracle, mySQL, postgreSQL, or domestic databases GaussDB. After the database is connected, updating the service date table of the database node according to the change type, writing service date change information into the service date table, and specifically writing an adjustment target service date and an adjustment effective date range. For example, if the service date request is a new service date request and the service date table has a record, updating the service date request to a new required service date; if no record exists in the service date table, a new required service date is inserted. If the change type is a request for deleting the service date, deleting the record of the service date table in each node, registering the successful or failed adjustment result to the service date adjustment requirement information unit, and notifying a requirement proposer.
Fig. 5 schematically illustrates one of flowcharts of a business date changing method provided according to still another embodiment of the present disclosure, and fig. 6 schematically illustrates the second of the flowcharts of the business date changing method provided according to still another embodiment of the present disclosure. As shown in fig. 5, operations S310 to S320 are included.
In operation S310, a database system date is acquired in response to the business date query request.
In operation S320, a service date is determined according to the database system date and the service date table.
As shown in fig. 6, operation S320 includes operation S321 and operation S322.
In operation S321, according to an embodiment of the present disclosure, if it is determined that there is a service date record in the service date table and it is determined that the database system date is within the adjustment validation date range corresponding to the service date record, the service date is returned to the service date querying party.
If it is determined that there is a service date record in the service date table and it is determined that the data system date is not within the adjustment validation date range corresponding to the service date record, the database system date is returned to the service date querying party in operation S322 according to the embodiment of the present disclosure.
In one example, when a service date of a certain database node needs to be acquired, determining a current database system date, reading a service date table, and if a service date record exists in the service date table and the database system date is in an adjustment effective date range corresponding to the service date record, returning the service date recorded in the table to a service caller. And if no record exists in the service date table or the current database system date does not record the effective date range in the service date table, returning to the current database system date. And the method can be expanded, and the business date and the date content of the system time stamp can be spliced and returned.
Based on the service date changing method, the disclosure also provides a service date changing device. The device will be described in detail below in connection with fig. 7.
Fig. 7 schematically shows a block diagram of a business date changing device according to an embodiment of the present disclosure.
As shown in fig. 7, the service date changing apparatus 700 of this embodiment includes a first acquisition module 710 and an update module 720.
The first obtaining module 710 is configured to obtain, in response to a service date update request, service date adjustment requirement information, where the service date adjustment requirement information includes target database node information and service date change information. In an embodiment, the first obtaining module 710 may be configured to perform the operation S210 described above, which is not described herein.
The updating module 720 is configured to update the service date according to the target database node information and the service date change information. In an embodiment, the updating module 720 may be configured to perform the operation S220 described above, which is not described herein.
According to an embodiment of the present disclosure, further comprising: and the second acquisition module and the determination module.
And the second acquisition module is used for responding to the service date query request and acquiring the database system date. In an embodiment, the second obtaining module may be configured to perform the operation S310 described above, which is not described herein.
And the determining module is used for determining the service date according to the database system date and the service date table. In an embodiment, the determining module may be configured to perform the operation S320 described above, which is not described herein.
According to an embodiment of the present disclosure, the update module includes: the connection sub-module and the update sub-module.
And the connection sub-module is used for connecting at least one target database node according to the target database node information. In an embodiment, the connection sub-module may be used to perform the operation S221 described above, which is not described herein.
And the updating sub-module is used for updating the service date table of the target database node according to the target service date, the change type and the adjustment effective date range. In an embodiment, the update sub-module may be used to perform the operation S222 described above, which is not described herein.
According to an embodiment of the present disclosure, the update sub-module includes: a first determination unit and a second determination unit.
And the first determining unit is used for inserting the target service date and the adjustment effective date range into a service date table of the target database node when the change type is determined to be newly added.
And the second determining unit is used for deleting the data of the service date table of the target database node when the change type is determined to be deleted.
According to an embodiment of the present disclosure, the determining module includes: a first determination sub-module and a second determination sub-module.
And the first determining submodule is used for returning the service date to the service date inquiring party if the service date record exists in the service date table and the database system date is determined to be in the adjustment effective date range corresponding to the service date record.
And the second determining submodule is used for returning the database system date to the service date inquiring party if the service date record exists in the service date table and the data system date is determined not to be in the adjustment effective date range corresponding to the service date record.
According to embodiments of the present disclosure, any of the plurality of modules of the first acquisition module 710 and the update module 720 may be combined in one module to be implemented, or any of the plurality of modules may be split into a plurality of modules. Alternatively, at least some of the functionality of one or more of the modules may be combined with at least some of the functionality of other modules and implemented in one module. According to embodiments of the present disclosure, at least one of the first acquisition module 710 and the update module 720 may be implemented at least in part as hardware circuitry, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or in hardware or firmware, such as any other reasonable way of integrating or packaging circuitry, or in any one of or a suitable combination of any of three implementations of software, hardware, and firmware. Alternatively, at least one of the first acquisition module 710 and the update module 720 may be at least partially implemented as computer program modules, which when executed, may perform the corresponding functions.
Fig. 8 schematically illustrates a block diagram of an electronic device adapted to implement a business date changing method according to an embodiment of the disclosure.
As shown in fig. 8, an electronic device 900 according to an embodiment of the present disclosure includes a processor 901 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 902 or a program loaded from a storage portion 908 into a Random Access Memory (RAM) 903. The processor 901 may include, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or an associated chipset and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), or the like. Processor 901 may also include on-board memory for caching purposes. Processor 901 may include a single processing unit or multiple processing units for performing the different actions of the method flows according to embodiments of the present disclosure.
In the RAM 903, various programs and data necessary for the operation of the electronic device 900 are stored. The processor 901, the ROM 902, and the RAM 903 are connected to each other by a bus 904. The processor 901 performs various operations of the method flow according to the embodiments of the present disclosure by executing programs in the ROM 902 and/or the RAM 903. Note that the program may be stored in one or more memories other than the ROM 902 and the RAM 903. The processor 901 may also perform various operations of the method flow according to embodiments of the present disclosure by executing programs stored in the one or more memories.
According to an embodiment of the disclosure, the electronic device 900 may also include an input/output (I/O) interface 905, the input/output (I/O) interface 905 also being connected to the bus 904. The electronic device 900 may also include one or more of the following components connected to the I/O interface 905: an input section 906 including a keyboard, a mouse, and the like; an output portion 907 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and a speaker; a storage portion 908 including a hard disk or the like; and a communication section 909 including a network interface card such as a LAN card, a modem, or the like. The communication section 909 performs communication processing via a network such as the internet. The drive 910 is also connected to the I/O interface 905 as needed. A removable medium 911 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is installed as needed on the drive 910 so that a computer program read out therefrom is installed into the storage section 908 as needed.
The present disclosure also provides a computer-readable storage medium that may be embodied in the apparatus/device/system described in the above embodiments; or may exist alone without being assembled into the apparatus/device/system. The computer-readable storage medium carries one or more programs that, when executed, implement a business date changing method according to an embodiment of the present disclosure.
According to embodiments of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example, but is not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this disclosure, a computer-readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. For example, according to embodiments of the present disclosure, the computer-readable storage medium may include ROM 902 and/or RAM 903 and/or one or more memories other than ROM 902 and RAM 903 described above.
Embodiments of the present disclosure also include a computer program product comprising a computer program containing program code for performing the methods shown in the flowcharts. The program code, when executed in a computer system, causes the computer system to implement the business date changing method provided by the embodiments of the present disclosure.
The above-described functions defined in the system/apparatus of the embodiments of the present disclosure are performed when the computer program is executed by the processor 901. The systems, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the disclosure.
In one embodiment, the computer program may be based on a tangible storage medium such as an optical storage device, a magnetic storage device, or the like. In another embodiment, the computer program may also be transmitted, distributed, and downloaded and installed in the form of a signal on a network medium, via communication portion 909, and/or installed from removable medium 911. The computer program may include program code that may be transmitted using any appropriate network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the foregoing.
In such an embodiment, the computer program may be downloaded and installed from the network via the communication portion 909 and/or installed from the removable medium 911. The above-described functions defined in the system of the embodiments of the present disclosure are performed when the computer program is executed by the processor 901. The systems, devices, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the disclosure.
According to embodiments of the present disclosure, program code for performing computer programs provided by embodiments of the present disclosure may be written in any combination of one or more programming languages, and in particular, such computer programs may be implemented in high-level procedural and/or object-oriented programming languages, and/or assembly/machine languages. Programming languages include, but are not limited to, such as Java, c++, python, "C" or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of remote computing devices, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., connected via the Internet using an Internet service provider).
The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
Those skilled in the art will appreciate that the features recited in the various embodiments of the disclosure and/or in the claims may be provided in a variety of combinations and/or combinations, even if such combinations or combinations are not explicitly recited in the disclosure. In particular, the features recited in the various embodiments of the present disclosure and/or the claims may be variously combined and/or combined without departing from the spirit and teachings of the present disclosure. All such combinations and/or combinations fall within the scope of the present disclosure.
The embodiments of the present disclosure are described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present disclosure. Although the embodiments are described above separately, this does not mean that the measures in the embodiments cannot be used advantageously in combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be made by those skilled in the art without departing from the scope of the disclosure, and such alternatives and modifications are intended to fall within the scope of the disclosure.
Claims (10)
1. A business date changing method applied to a cloud database, wherein the cloud database comprises at least one database node, and each database node is pre-created with a business date table, and the method is characterized by comprising the following steps:
responding to a service date updating request, and acquiring service date adjustment requirement information, wherein the service date adjustment requirement information comprises target database node information and service date changing information; and
and updating the service date according to the target database node information and the service date change information.
2. The method of claim 1, wherein the business date change information comprises a target business date, a change type, and an adjustment validation date range, and wherein updating the business date based on the target database node information and the business date change information comprises:
connecting at least one target database node according to the target database node information;
and updating a service date table of the target database node according to the target service date, the change type and the adjustment effective date range.
3. The method of claim 2, wherein said updating a business date table of said target database node based on said target business date, said change type, and said adjustment validation date range comprises:
when the change type is determined to be newly added, inserting the target service date and the adjustment effective date range into a service date table of the target database node; and
and deleting the data of the service date table of the target database node when the change type is determined to be deleted.
4. The method according to claim 1, wherein the method further comprises:
responding to a service date inquiry request, and acquiring a database system date; and
and determining the service date according to the database system date and the service date table.
5. The method of claim 4, wherein said determining a business date from said database system date and said business date table comprises:
if the service date record exists in the service date table and the database system date is determined to be in the adjustment effective date range corresponding to the service date record, returning the service date to a service date inquiring party; and
and if the service date record exists in the service date table and the data system date is not in the adjustment effective date range corresponding to the service date record, returning the database system date to the service date inquiring party.
6. The method of claim 5, wherein said determining a business date from said database system date and said business date table further comprises:
and if the service date table is determined to have no service date record, returning the database system date to a service date inquiring party.
7. A business date changing device applied to a cloud database, wherein the cloud database comprises at least one database node, and each database node is pre-created with a business date table, and the device comprises:
the first acquisition module is used for responding to a service date updating request and acquiring service date adjustment requirement information, wherein the service date adjustment requirement information comprises target database node information and service date change information; and
and the updating module is used for updating the service date according to the target database node information and the service date change information.
8. An electronic device, comprising:
one or more processors;
storage means for storing one or more programs,
wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the business date changing method of any of claims 1-6.
9. A computer readable storage medium having stored thereon executable instructions which, when executed by a processor, cause the processor to perform the business date changing method according to any of claims 1 to 6.
10. A computer program product comprising a computer program which, when executed by a processor, implements a business date changing method according to any of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310430445.2A CN116578572A (en) | 2023-04-19 | 2023-04-19 | Service date changing method, device, equipment, storage medium and program product |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310430445.2A CN116578572A (en) | 2023-04-19 | 2023-04-19 | Service date changing method, device, equipment, storage medium and program product |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116578572A true CN116578572A (en) | 2023-08-11 |
Family
ID=87535017
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310430445.2A Pending CN116578572A (en) | 2023-04-19 | 2023-04-19 | Service date changing method, device, equipment, storage medium and program product |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116578572A (en) |
-
2023
- 2023-04-19 CN CN202310430445.2A patent/CN116578572A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111427971B (en) | Business modeling method, device, system and medium for computer system | |
| CN112463729B (en) | Data file warehousing method and device, electronic equipment and medium | |
| WO2023207146A1 (en) | Service simulation method and apparatus for esop system, and device and storage medium | |
| CN111596956A (en) | Block chain-based information processing method and device, electronic device and medium | |
| CN115269352A (en) | Database performance determination method and device, electronic equipment and storage medium | |
| US20230177052A1 (en) | Performance of sql execution sequence in production database instance | |
| CN116578572A (en) | Service date changing method, device, equipment, storage medium and program product | |
| CN110858199A (en) | Document data distributed computing method and device | |
| CN116185806A (en) | Digital currency system testing method and device | |
| CN113762702A (en) | Workflow deployment method, device, computer system and readable storage medium | |
| CN112734373A (en) | Information processing method, information processing apparatus, electronic device, and medium | |
| CN113077241B (en) | Approval processing method, device, equipment and storage medium | |
| CN117131071B (en) | Data processing method, device, electronic equipment and computer readable medium | |
| CN117971804A (en) | Data migration method, apparatus, device, storage medium, and program product | |
| CN115658749B (en) | Fund product ordering method and device based on directed acyclic graph and electronic equipment | |
| CN114817314A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN115033573A (en) | Data checking method, device, electronic equipment and medium | |
| CN117056340A (en) | Account checking data processing method, device, equipment and storage medium | |
| CN113961723A (en) | Credit card rights status updating method, device, electronic equipment and storage medium | |
| CN115237891A (en) | Data source configuration method, device, equipment, medium and program product | |
| CN116244384A (en) | Data synchronization method, data synchronization device, electronic equipment and storage medium | |
| CN116303620A (en) | Accounting method, system, equipment, medium and product based on light database | |
| CN116975200A (en) | Method, device, equipment and medium for controlling working state of server | |
| CN113971007A (en) | Information processing method, information processing apparatus, electronic device, and medium | |
| CN116719538A (en) | Version deployment consistency verification method and device |
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 |