A transaction calendar management method and system

Abstract

This application provides a trading calendar management method and system, relating to the field of financial technology, and more particularly to a trading calendar management method, comprising: determining whether a preset day cut-off time has arrived; if so, obtaining the current date of a data scheduling system; calculating a date parameter based on the current date and a pre-configured date parameter calculation code; updating the trading calendar of the data scheduling system based on the date parameter; and storing the date parameter in a preset database. This application enables unified management and automatic updating of the trading calendar of the data scheduling system, while reducing the probability of scheduling errors.

Description

Technical Field

[0001] The present application relates to the field of financial technology, and in particular to a transaction calendar management method and system. Background Art

[0002] In the securities industry, current data scheduling systems' trading calendar parameter management simply defines fixed parameters such as the trading day and the current date. When other date parameters are needed, developers are required to define their own parameters based on the current calendar day, declare them, and assign values. This approach not only increases developer workload, but also leads to confusing naming and complex nested parameter references during customization, and increases the probability of errors when developers independently customize the parameters.

[0003] Therefore, how to achieve unified management and automatic updating of the transaction calendar of the data scheduling system while reducing the probability of scheduling errors is a technical problem that needs to be urgently solved by those skilled in the art. Summary of the Invention

[0004] To address the above technical issues, this application provides a trading calendar management method that can achieve unified management and automatic updating of the trading calendar of a data scheduling system while reducing the probability of scheduling errors. This application also provides a trading calendar management system with the same technical effects.

[0005] The first purpose of this application is to provide a transaction calendar management method.

[0006] The above-mentioned application objective 1 of this application is achieved through the following technical solutions:

[0007] A transaction calendar management method, comprising:

[0008] Determine whether the preset daily switching time has been reached. If so, then:

[0009] Get the current date of the data scheduling system;

[0010] Calculating a date parameter based on the current date and a pre-configured date parameter calculation code;

[0011] updating the transaction calendar of the data scheduling system according to the date parameter;

[0012] The date parameters are stored in a preset database.

[0013] Preferably, in the trading calendar management method, the date parameters include trading day parameters and natural day parameters, and updating the trading calendar of the data scheduling system according to the date parameters includes:

[0014] Determine whether the current date is a trading day,

[0015] If yes, then the trading calendar of the data scheduling system is updated according to the trading day parameter and the natural day parameter.

[0016] If not, the transaction calendar of the data scheduling system is updated according to the natural day parameter.

[0017] Preferably, in the transaction calendar management method, before updating the transaction calendar of the data scheduling system according to the date parameter, the method further comprises:

[0018] The existing date parameters in the transaction calendar of the data scheduling system are snapshot-archived into a preset ledger.

[0019] Preferably, in the transaction calendar management method, before calculating the code based on the current date and pre-configured date parameters to obtain the date parameters, the method further comprises:

[0020] Performing a validity check on the current date.

[0021] If the verification passes, the step of calculating the date parameter by calculating the code based on the current date and the pre-configured date parameter is executed;

[0022] If the verification fails, an alarm message will be output.

[0023] Preferably, in the transaction calendar management method, the preset database includes a hive database, a clickhouse database and a redis database.

[0024] The second object of this application is to provide a transaction calendar management system.

[0025] The second object of the present application is achieved through the following technical solutions:

[0026] A transaction calendar management system, comprising:

[0027] A judgment unit, used to judge whether the preset day cutting time has been reached;

[0028] an acquiring unit, configured to acquire the current date of the data scheduling system when the determining unit determines that the preset day-cut time has arrived;

[0029] a calculation unit, configured to calculate a code based on the current date and a pre-configured date parameter to calculate the date parameter;

[0030] an updating unit, configured to update a transaction calendar of the data scheduling system according to the date parameter;

[0031] The storage unit is used to store the date parameter in a preset database.

[0032] Preferably, in the trading calendar management system, the date parameters include trading day parameters and natural day parameters, and the updating unit, when executing the updating of the trading calendar of the data scheduling system according to the date parameters, is specifically configured to:

[0033] Determine whether the current date is a trading day,

[0034] If yes, then the trading calendar of the data scheduling system is updated according to the trading day parameter and the natural day parameter.

[0035] If not, the transaction calendar of the data scheduling system is updated according to the natural day parameter.

[0036] Preferably, the transaction calendar management system further comprises an archiving unit, wherein:

[0037] The archiving unit is used to archive the existing date parameters in the transaction calendar of the data scheduling system into a preset ledger.

[0038] Preferably, the transaction calendar management system further comprises a verification unit, wherein:

[0039] The verification unit is used to verify the validity of the input parameter of the current date;

[0040] The calculation unit, when executing the calculation code according to the current date and the pre-configured date parameter to calculate the date parameter, is specifically configured to: when the verification unit determines that the current date verification passes, calculate the date parameter according to the current date and the pre-configured date parameter calculation code;

[0041] The verification unit is further configured to output an alarm message when it is determined that the current date verification fails.

[0042] Preferably, in the transaction calendar management system, the preset database includes a hive database, a clickhouse database and a redis database.

[0043] The above technical solution determines whether the preset day cut time has been reached. If so, it: obtains the current date of the data scheduling system; calculates the date parameters based on the current date and the pre-configured date parameter calculation code. In this way, the date parameters can be automatically calculated through the pre-configured date parameter calculation code, which can ensure the uniformity of parameter naming and rules and reduce repeated calculations. At the same time, it is convenient for developers to use, without the need for manual calculations and developers to customize them individually, reducing the probability of errors; further, according to the date parameters, the transaction calendar of the data scheduling system is updated; the date parameters are stored in the preset database, thereby realizing the unified management and automatic update of the transaction calendar. In summary, the above technical solution can realize the unified management and automatic update of the transaction calendar of the data scheduling system, while reducing the probability of scheduling errors. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are only some embodiments recorded in this application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0045] Figure 1 A flowchart of a transaction calendar management method in an embodiment of the present application

[0046] Figure 2 This is a structural diagram of a transaction calendar management system in an embodiment of the present application. DETAILED DESCRIPTION

[0047] In order to help those skilled in the art better understand the technical solutions in this application, the technical solutions in the embodiments of this application will be clearly and completely described below. Obviously, the embodiments described are only part of the embodiments of this application, not all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by those skilled in the art without making any creative efforts shall fall within the scope of protection of this application.

[0048] In the embodiments provided in this application, it should be understood that the disclosed methods and systems can be implemented in other ways. The system embodiments described below are merely schematic. For example, the division of units and modules is only a logical function division. There may be other division methods in actual implementation, such as: multiple units or modules can be combined, or can be integrated into another system, or some features can be ignored or not executed. In addition, the coupling, direct coupling, or communication connection between the components shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or modules, which can be electrical, mechanical or other forms.

[0049] In addition, all functional units in the embodiments of the present application may be integrated into one processor, or each unit may be a separate device, or two or more units may be integrated into one device; each functional unit in the embodiments of the present application may be implemented in the form of hardware or in the form of hardware plus software functional units.

[0050] Those skilled in the art will understand that all or part of the steps of the following method embodiments can be implemented by program instructions and related hardware. The aforementioned program instructions can be stored in a computer-readable storage medium. When the program instructions are executed, the steps of the following method embodiments are executed; and the aforementioned storage medium includes: mobile storage devices, read-only memories (ROM), magnetic disks or optical disks, and other media that can store program codes.

[0051] It should be understood that the use of "system," "device," "unit," and / or "module" in this application is merely a method for distinguishing different components, elements, parts, portions, or assemblies at different levels. However, if other terms can achieve the same purpose, the terms may be replaced by other expressions.

[0052] Furthermore, the terms "first" and "second" are used for descriptive purposes only and should not be understood to indicate or imply relative importance or implicitly specify the number of technical features indicated. Thus, a feature specified as "first" or "second" may explicitly or implicitly include one or more of such features. Throughout the description of this application, "plurality" or "several" means two or more, unless otherwise specifically defined.

[0053] If a flow chart is used in this application, the flow chart is used to illustrate the operations performed by the system according to the embodiments of the application. It should be understood that the previous or subsequent operations are not necessarily performed in exact order. Instead, the steps can be processed in reverse order or simultaneously. At the same time, other operations can be added to these processes, or one or more operations can be removed from these processes.

[0054] It should also be noted that, in this document, terms such as "comprises," "includes," or any other variations thereof are intended to encompass non-exclusive inclusion, such that an article or device comprising a series of elements includes not only those elements, but also other elements not explicitly listed, or elements inherent to such article or device. In the absence of further limitations, elements defined by the phrase "comprises a ..." do not exclude the presence of other identical elements in the article or device comprising the above elements.

[0055] The embodiments of the present application are written in a progressive manner.

[0056] like Figure 1 As shown, the embodiment of the present application provides a transaction calendar management method, including:

[0057] S101 determines whether the preset day cut time has been reached, and if so, executes S102;

[0058] In S101, specifically, the preset day-cut time can be set based on actual application requirements, for example, it can be set to 16:30 after the brokerage closes, and this application does not impose specific restrictions on this. When it is determined that the preset day-cut time has been reached, step S102 is executed.

[0059] S102. Get the current date of the data scheduling system;

[0060] In S102, specifically, the data scheduling system, also known as the data platform job scheduling system, is a platform used by financial services companies or securities companies to manage operations such as collection, calculation, and push related to configuration data; in this step, when it is determined that the preset day cut time has been reached, the data scheduling system will be automatically accessed to obtain the current date of the data scheduling system.

[0061] S103. Calculate the date parameters based on the current date and pre-configured date parameter calculation code;

[0062] Specifically, in S103, the required date parameters can be determined based on actual application requirements, and corresponding date parameter calculation code can be pre-configured based on the required date parameters. After determining the current date, the date parameters can be automatically calculated based on the date parameter calculation code. This ensures the uniformity of parameter naming and rules, reduces repeated calculations, and is convenient for developers to use, eliminating the need for manual calculations and developer customization, thereby reducing the probability of error. The date parameter calculation code can be programmed using existing programming languages, and this application does not impose specific limitations on this.

[0063] In some embodiments, the date parameters include trading day parameters and natural day parameters. The trading day parameters refer to date parameters related to the trading day. For example, the trading day parameters may include: the current trading day, the next trading day, the previous n trading days, the nth trading day of the current month, the nth trading day of the previous month, etc. This application does not impose specific restrictions on this; the natural day parameters refer to date parameters that are not related to the trading day. For example, the natural day parameters may include: the current natural day, the previous n natural days, the month to which the previous n months belong, the number of weeks of the current year, etc.; n is a positive integer, and its numerical value can be determined based on actual application requirements.

[0064] In a specific embodiment, specific examples of trading day parameters and natural day parameters are shown in the following table:

[0065] Table 1 Date parameter sample table

[0066]

[0067]

[0068]

[0069] It should be noted that the specific examples of the above trading day parameters and natural day parameters are only examples. The trading day parameters and natural day parameters may include one or more of the date parameters shown in the above table. The trading day parameters and natural day parameters may also include other reasonable date parameters. This application is not limited to this.

[0070] In a specific embodiment, the corresponding date parameter calculation code can be pre-configured according to the parameter type of the required date parameter. The specific example is as follows:

[0071] Taking the previous and next trading day parameters as an example, the corresponding date parameter calculation code can be configured as follows:

[0072]

[0073] Taking the natural day parameters before and after as an example, the corresponding date parameter calculation code can be configured as follows:

[0074]

[0075] It should be noted that the above date parameter calculation code is only an example. The date parameter calculation code can be flexibly configured based on actual application requirements, and this application is not limited to this.

[0076] S104. Update the transaction calendar of the data scheduling system according to the date parameters;

[0077] In S104, specifically, the transaction calendar can be a date parameter information record table for the execution of runs by the data scheduling system; after obtaining the date parameters, the transaction calendar of the data scheduling system can be updated. For example, the date parameter information in the current transaction calendar table can be updated to the newly generated date parameters, thereby realizing unified management and automatic update of the transaction calendar.

[0078] S105. Store the date parameters in the preset database.

[0079] In S105, specifically, by storing the calculated date parameters in a preset database, it is convenient for subsequent scheduling. In some embodiments, the preset database includes a hive database, a clickhouse database and a redis database. Among them, Hive is a data warehouse built on the Hadoop file system. It provides a series of tools that can extract, convert and load data stored in HDFS (Hadoop Distributed File System). ClickHouse is an open source columnar database management system for online analysis, mainly used for online analysis and processing queries, and can use SQL queries to generate analysis data reports in real time. Redis, whose full English name is Remote Dictionary Server (remote dictionary service), is an open source log-type, Key-Value database written in ANSI C language, supports the network, can be based on memory or persisted, and provides APIs in multiple languages. Redis data is stored in memory, and its read and write speed is very fast, and it can handle more than 100,000 read and write operations per second. In some embodiments, the data scheduling system obtains the corresponding date parameters through the redis database and uses them in scheduling. It should be noted that the execution order of S104 and S105 can be interchanged, which does not affect the implementation of this embodiment.

[0080] In the securities industry, current data scheduling systems' trading calendar parameter management simply defines fixed parameters such as the trading day and the current date. When other date parameters are needed, developers are required to define their own parameters based on the current calendar day, declare them, and assign values. This approach not only increases developer workload, but also leads to confusing naming and complex nested parameter references during customization, and increases the probability of errors when developers independently customize the parameters.

[0081] The above embodiment determines whether the preset day cut time has been reached. If so, the following steps are performed: obtaining the current date of the data scheduling system; calculating the date parameters based on the current date and the pre-configured date parameter calculation code. This allows the pre-configured date parameter calculation code to automatically calculate the date parameters, ensuring the uniformity of parameter naming and rules and reducing repeated calculations. This also makes it easier for developers to use, eliminating the need for manual calculations and customization by developers, and reducing the probability of errors. Furthermore, the transaction calendar of the data scheduling system is updated based on the date parameters; the date parameters are stored in a preset database, thereby achieving unified management and automatic updates of the transaction calendar. In summary, the above embodiment can achieve unified management and automatic updates of the transaction calendar of the data scheduling system, while reducing the probability of scheduling errors.

[0082] In other embodiments of the present application, the date parameter includes a trading day parameter and a natural day parameter. One implementation of the step of updating the trading calendar of the data scheduling system according to the date parameter includes:

[0083] S201. Determine whether the current date is a trading day. If so, execute S202; if not, execute S203;

[0084] In S201, specifically, the period of stock market transactions is the trading day. Generally speaking, the trading day is Monday to Friday. In addition to the trading days, the natural days also include Saturdays, Sundays and other statutory holidays. Based on the current date, it can be judged whether the current date is within the pre-configured stock market transaction period to determine whether the current date is a trading day.

[0085] S202. Update the trading calendar of the data scheduling system based on the trading day parameters and natural day parameters;

[0086] In S202, specifically, when it is determined that the current date is a trading day, the trading calendar of the data scheduling system is updated according to the trading day parameters and natural day parameters; specifically, the date parameter information in the current trading calendar table can be updated to the newly generated trading day parameters and natural day parameters.

[0087] S203. Update the transaction calendar of the data scheduling system according to the natural day parameters.

[0088] In S203, specifically, when it is determined that the current date is not a trading day, the trading calendar of the data scheduling system is updated according to the natural day parameter. Specifically, the date parameter information in the current trading calendar table can be updated to the newly generated natural day parameter.

[0089] In this embodiment, by introducing the judgment of whether it is a trading day, if the current date is a trading day, the trading calendar is updated using the trading day parameter and the natural day parameter. If the current date is not a trading day, only the natural day parameter is used to update the trading calendar, thereby improving the efficiency of trading calendar updates. For example, on December 1, 2023 (Friday), the current trading day TD in the trading day parameter is 20231130 before the preset day cut time 16:30, and changes to 20231201 after 16:30; then on December 2, 2023 (Saturday) and December 3, 2023 (Sunday), the corresponding current trading day is still 20231201, and is not updated until December 4, 2023 (next Monday) 16:30, and is updated to 20231204. The current date CD in the natural day parameter will be updated at 16:30 every afternoon from December 1, 2023 (Friday) to December 4, 2023 (next Monday) and will be updated to the server system date of that day.

[0090] In other embodiments of the present application, before executing the step of updating the transaction calendar of the data scheduling system according to the date parameter, the method further includes:

[0091] S301. Archive the existing date parameters in the transaction calendar of the data scheduling system into a preset ledger.

[0092] Specifically, in S301, before updating the transaction calendar of the data scheduling system according to the date parameters, the existing date parameters in the transaction calendar of the data scheduling system are first snapshotted and archived to a preset ledger. Snapshot refers to a fast data protection technology. A snapshot is a mirror image of a data set at a specific moment, also known as an instant copy, which is a complete and usable copy of the data set. Technical methods for implementing snapshots include: copy-on-write, I / O redirection, image separation, clone snapshot, continuous data protection, etc., which are not limited by this application; the preset ledger can be set based on actual application requirements, which are not limited by this application.

[0093] In this embodiment, by performing snapshot archiving and storage of existing date parameters in the transaction calendar, online data recovery can be performed. When an application failure or file corruption occurs in the storage device, timely data recovery can be performed to restore the data to the state at the time when the snapshot was generated, which facilitates the re-running of historical data and problem tracing in the event of a failure.

[0094] In other embodiments of the present application, before executing the step of calculating the date parameter based on the current date and the pre-configured date parameter calculation code, the step further includes:

[0095] S401. For the current date, the legality of the input parameter is checked. If the check passes, the code is calculated based on the current date and the pre-configured date parameters to calculate the date parameter step. If the check fails, S402 is executed.

[0096] In S401, specifically, the input parameter validity check can be to check the current date to determine whether it complies with the processing regulations of the database field, for example, whether the content of the current date complies with the processing regulations, whether the format of the current date complies with the processing regulations, etc.

[0097] In a specific embodiment, the process of performing input parameter validity check on the current date may be, according to a pre-set validity comparison table, comparing the current date with the validity comparison table, for example, comparing whether the content of the current date is the content recorded in the validity comparison table, for example, judging whether the year digit, month digit and date data in the current date are within a preset value range, etc.; comparing whether the format of the current date is the parameter format recorded in the validity comparison table, for example, judging whether the digital format of the current date is an 8-digit format, etc.; judging whether the current date meets the input parameter validity check regulations based on the comparison result, if so, the verification passes, and continuing to the next step, that is, continuing to execute the step of calculating the date parameter according to the current date and the pre-configured date parameter calculation code, if not, the verification fails, and executing S402;

[0098] S402. Output alarm information.

[0099] In S402, specifically, a list of staff members can be pre-set, and then an alarm message can be output to the corresponding staff members via SMS or email to remind the staff members to perform manual processing. This application does not impose any specific restrictions on this.

[0100] In this embodiment, by introducing a validity verification mechanism and an alert mechanism for the current date, the accuracy of transaction calendar updates can be effectively improved. In other embodiments, if the verification fails, the process can return to the step of obtaining the current date from the data scheduling system and then perform a validity verification on the newly obtained current date until the verification passes. This application does not impose any restrictions on this.

[0101] like Figure 2 As shown, in other embodiments of the present application, a transaction calendar management system is further provided, including:

[0102] The judging unit 10 is used to judge whether the preset day cutting time has been reached;

[0103] The acquiring unit 11 is configured to acquire the current date of the data scheduling system when the determining unit 10 determines that the preset day-cutting time has arrived;

[0104] The calculation unit 12 is used to calculate the code according to the current date and the pre-configured date parameter to calculate the date parameter;

[0105] An updating unit 13, configured to update the transaction calendar of the data scheduling system according to the date parameter;

[0106] The storage unit 14 is used to store the date parameters in a preset database.

[0107] In other embodiments of the present application, in the above-mentioned trading calendar management system, the date parameter includes a trading day parameter and a natural day parameter. When updating the trading calendar of the data scheduling system according to the date parameter, the updating unit 13 is specifically used to:

[0108] Determine whether the current date is a trading day.

[0109] If so, the trading calendar of the data scheduling system is updated according to the trading day parameters and natural day parameters.

[0110] If not, the transaction calendar of the data scheduling system is updated according to the natural day parameters.

[0111] In other embodiments of the present application, the transaction calendar management system further includes an archiving unit, wherein:

[0112] The archiving unit is used to archive the existing date parameters in the transaction calendar of the data scheduling system and snapshots to the preset ledger.

[0113] In other embodiments of the present application, the transaction calendar management system further includes a verification unit, wherein:

[0114] The verification unit is used to verify the validity of the input parameters of the current date;

[0115] The calculation unit 12, when executing the calculation code based on the current date and the pre-configured date parameter to calculate the date parameter, is specifically configured to: when the verification unit determines that the current date verification passes, calculate the date parameter based on the current date and the pre-configured date parameter calculation code;

[0116] The verification unit is further configured to output an alarm message when it is determined that the current date verification fails.

[0117] In other embodiments of the present application, in the above-mentioned transaction calendar management system, the preset databases include a hive database, a clickhouse database, and a redis database.

[0118] The above description of the disclosed embodiments is intended to enable one skilled in the art to implement or use the present application. Various modifications to these embodiments will be readily apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application is not limited to the embodiments shown herein, but is intended to conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A transaction calendar management method, characterized in that: include: Determine whether the preset daily switching time has been reached. If so, then: Get the current date of the data scheduling system; Calculating a date parameter based on the current date and a pre-configured date parameter calculation code; updating the transaction calendar of the data scheduling system according to the date parameter; Storing the date parameters in a preset database; The date parameters include trading day parameters and natural day parameters, and updating the trading calendar of the data scheduling system according to the date parameters includes: Determine whether the current date is a trading day, If yes, then the trading calendar of the data scheduling system is updated according to the trading day parameter and the natural day parameter. If not, updating the transaction calendar of the data scheduling system according to the natural day parameter; The code is calculated based on the current date and the pre-configured date parameter, and before the date parameter is calculated, the method further includes: Performing a validity check on the current date. If the verification passes, the step of calculating the date parameter by calculating the code based on the current date and the pre-configured date parameter is executed; If the verification fails, an alarm message will be output.

2. The method according to claim 1, wherein Before updating the transaction calendar of the data scheduling system according to the date parameter, the method further includes: The existing date parameters in the transaction calendar of the data scheduling system are snapshot-archived into a preset ledger.

3. The method according to claim 1, wherein The preset databases include hive database, clickhouse database and redis database.

4. A transaction calendar management system, characterized in that: include: A judgment unit, used to judge whether the preset day cutting time has been reached; an acquiring unit, configured to acquire the current date of the data scheduling system when the determining unit determines that the preset day-cut time has arrived; a calculation unit, configured to calculate a code based on the current date and a pre-configured date parameter to calculate the date parameter; an updating unit, configured to update a transaction calendar of the data scheduling system according to the date parameter; A storage unit, used for storing the date parameter in a preset database; The date parameters include trading day parameters and natural day parameters. When the updating unit updates the trading calendar of the data scheduling system according to the date parameters, it is specifically configured to: Determine whether the current date is a trading day, If yes, then the trading calendar of the data scheduling system is updated according to the trading day parameter and the natural day parameter. If not, updating the transaction calendar of the data scheduling system according to the natural day parameter; A verification unit, configured to verify the validity of an input parameter of the current date; The calculation unit, when executing the calculation code according to the current date and the pre-configured date parameter to calculate the date parameter, is specifically configured to: when the verification unit determines that the current date verification passes, calculate the date parameter according to the current date and the pre-configured date parameter calculation code; The verification unit is further configured to output an alarm message when it is determined that the current date verification fails.

5. The system as claimed in claim 4, characterized in that Also included is an archiving unit, wherein: The archiving unit is used to archive the existing date parameters in the transaction calendar of the data scheduling system into a preset ledger.

6. The system as claimed in claim 4, characterized in that The preset databases include hive database, clickhouse database and redis database.

Images