[go: up one dir, main page]

WO2018214599A1 - 可扩展数据上报方法、系统、及存储介质 - Google Patents

可扩展数据上报方法、系统、及存储介质 Download PDF

Info

Publication number
WO2018214599A1
WO2018214599A1 PCT/CN2018/076469 CN2018076469W WO2018214599A1 WO 2018214599 A1 WO2018214599 A1 WO 2018214599A1 CN 2018076469 W CN2018076469 W CN 2018076469W WO 2018214599 A1 WO2018214599 A1 WO 2018214599A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
reported
scalable
configuration
configuration table
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.)
Ceased
Application number
PCT/CN2018/076469
Other languages
English (en)
French (fr)
Inventor
陈莹
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Technology Shenzhen Co Ltd
Original Assignee
Ping An Technology Shenzhen Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Ping An Technology Shenzhen Co Ltd filed Critical Ping An Technology Shenzhen Co Ltd
Publication of WO2018214599A1 publication Critical patent/WO2018214599A1/zh
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes

Definitions

  • the present invention relates to the field of database technologies, and in particular, to a scalable data reporting method, system, and storage medium.
  • the main purpose of the present invention is to provide a scalable data reporting method, system, and storage medium, which aims to solve the problem that the same data reporting system in the prior art is difficult to be compatible with multiple regulatory agencies, resulting in the development and maintenance process of the data reporting system. In addition, it requires not only a lot of manpower and material resources, but also technical problems of duplication of work and low work efficiency.
  • the present invention provides an expandable data reporting method, where the scalable data reporting method includes:
  • the filtered data to be reported is adapted by using a preset restore function, and the adapted data to be reported is uploaded to the data platform.
  • the step of performing compatibility and matching verification on the configuration table with the data platform comprises:
  • the preset field includes one of a service field name, a service field type, a document field name, and a document field type. Item or multiple items.
  • the source of the data to be reported includes a counter report data and a non-counter report data
  • the step of differently configuring the report data according to the source of the data to be reported includes:
  • the asynchronously configured processing is performed on the to-be-reported data.
  • the step of performing real-time configuration processing on the to-be-reported data includes:
  • the step of performing asynchronous configuration processing on the to-be-reported data includes:
  • the step of screening the pre-processed data to be reported includes:
  • the pre-processed data to be reported is filtered according to the mapping relationship between the service field name and the service sequence number in the configuration table.
  • the method further includes:
  • the filtered data to be reported is fed back to the preset intermediate temporary array.
  • the step of adapting the filtered data to be reported by using the preset reduction function, and uploading the adapted data to be reported to the data platform includes:
  • the present invention further provides an expandable data reporting system, the scalable data reporting system comprising: a memory, a processor, and a memory stored on the memory and operable on the processor
  • the data reporting program is extended, and the scalable data reporting program is executed by the processor to implement various steps corresponding to the scalable data reporting method.
  • the present invention further provides a storage medium on which an expandable data reporting program is stored, and the scalable data reporting program is implemented by the processor to implement the scalable data reporting method. Corresponding steps.
  • the scalable data reporting method, system, and storage medium provided by the present invention can be implemented by first establishing a configuration table according to the type of the data platform, and performing compatibility and matching check on the configuration table, and secondly, according to the data to be reported.
  • the source is configured to differentiate the reported data, and then pre-processes and filters the configured data to be reported. Finally, the filtered data to be reported is adapted and uploaded to the data platform.
  • the present invention by performing a series of processes such as differential configuration, pre-processing, filtering, and adaptation on the reported data, the purpose of quickly performing data reporting according to the type of the data platform is realized, so that multiple regulatory agencies can share one.
  • the data reporting system for enterprises, only needs to develop and maintain a data reporting system, and can complete the task of reporting data to multiple regulatory agencies, thereby effectively reducing the manpower and material resources, improving work efficiency, and solving the present problem.
  • the same data reporting system is difficult to be compatible with multiple regulatory agencies, resulting in the development and maintenance of the data reporting system, which not only requires a lot of manpower and material resources, but also causes repeated labor and low technical efficiency.
  • FIG. 1 is a schematic flowchart of a first embodiment of a method for reporting scalable data according to the present invention
  • FIG. 2 is a schematic flow chart of the refinement step of step S40 shown in FIG. 1 of the present invention.
  • FIG. 3 is a schematic diagram of a system structure of a software running environment involved in the scalable data reporting system of the present invention.
  • the following embodiments of the present invention provide a scalable data reporting method, in which a configuration table is first established according to the type of the data platform, and compatibility and matching check is performed on the configuration table, and second, according to the source of the data to be reported. Differentiate the reported data, and then pre-process and filter the configured data to be reported. Finally, the filtered data to be reported is adapted and uploaded to the data platform. That is to say, in the present invention, a plurality of processes can be shared by a plurality of supervisory organizations by performing a series of processes such as differential configuration, preprocessing, screening, and adaptation to report the data, and for the enterprise, only one development and maintenance is required.
  • the data reporting system can complete the task of reporting data to multiple regulatory agencies, thus effectively reducing the manpower and material resources and improving work efficiency.
  • FIG. 1 is a schematic flowchart of a first embodiment of a scalable data reporting method according to the present invention.
  • the scalable data reporting method includes:
  • Step S10 Establish a configuration table according to the type of the data platform, and perform compatibility check and matching verification on the configuration table according to the configuration information corresponding to the configuration table.
  • a configuration table rbs_invoice_report_config needs to be established according to the type of the data platform, where the data platform is a data receiving platform corresponding to the regulatory authority.
  • this embodiment provides a configuration table for example.
  • the table data structure of the configuration table rbs_invoice_report_config can be set as follows:
  • Data_type is 'data type 0 - non-monthly invoice invoice invoice 1- month invoice invoice';
  • Data_source is 'data source 0 - counter 1 - non-counter';
  • Busi_column_name is 'business field name'
  • Busi_column_desc is 'Business field Chinese description'
  • Busi_column_serial is 'business serial number'
  • Busi_column_type is 'business field type'
  • Busi_column_format is 'business field format'
  • Vms_column_name is 'document field name'
  • Vms_column_type is 'document field type'
  • Vms_column_format is 'document field format'
  • the configuration table is compared with the data platform according to the configuration information corresponding to the configuration table.
  • the compatibility and matching check of the configuration table with the data platform includes performing compatibility and matching check on the format and type of each field in the configuration table. For example, if the type of a field in the configuration table configuration table is date and the format of the field is "yyyy/mm/dd", after the compatibility and matching check, the data stored in the field will be "yyyy/mm/dd” format is stored, such as "2017/01/01" means January 01, 2017; similarly, if the format of the field indicating the date is “mm/dd/yyy”, the data stored in this field will be stored in “mm/dd/yyyy” format, such as “12/31/2016” means December 31, 2016.
  • the data stored in the field will be in the "0.00" format after the compatibility and matching check.
  • the amount of data is 200 yuan, it will be stored as "200.00".
  • the standard of the database mainly includes SQL (Structured Query Language, Structured Query Language), ODBC (Open Database Connectivity), JDBC (Java Data Base) Connectivity, java database connection) and so on.
  • SQL Structured Query Language
  • ODBC Open Database Connectivity
  • JDBC Java Data Base Connectivity
  • java database connection java database connection
  • the matching check is to prevent the non-compliant data from entering the database, and the DBMS is inserted, modified, deleted, etc. by the user.
  • database management system will automatically monitor the data according to certain constraints, so that non-compliant data can not enter the database to ensure that the data stored in the database is correct, effective and compatible.
  • step of performing compatibility and matching verification on the configuration table with the data platform in step S10 shown in FIG. 1 above includes:
  • the preset field includes one of a service field name, a service field type, a document field name, and a document field type. Item or multiple items.
  • busi_column_name service field name
  • busi_column_type service field type
  • vms_column_name document field name
  • vms_column_type document field type
  • step S20 the reported data is differentiated according to the source of the data to be reported.
  • the sources of the data to be reported mainly include two types: data reported on the counter and data reported on the counter.
  • the data reported on the counter refers to the data entered through the counter, and the data reported on the counter is in the counter.
  • Data entered by other input devices such as data entered by the customer on the official website and on the client.
  • the configuration is different.
  • the information can be directly configured according to the invoice printing information; for the non-counter data, the data to be reported needs to be cached first. In the temporary table, then the data to be reported in the temporary table is configured.
  • step S30 the configured data to be reported is pre-processed, and the pre-processed data to be reported is filtered.
  • the to-be-reported data of different sources after the configuration may be pre-processed by using a reload, wherein the convert, transfer function of the sys.anydata may be used to implement the character, value, date, and table record type in the data to be reported. Etc., return to the above custom table type character index array anydata_array_by_charIndex.
  • overloading refers to the case where the function or method has the same name, but the parameter list is different.
  • Such functions or methods with the same name but different parameters are called overloaded functions or methods.
  • the sources of the data to be reported include two types of data on the counter and the data on the counter, although the functions used by the two sources to report data are the same function, but the sources are different, and the corresponding data.
  • the parameters are also different. Therefore, the preprocessing of the above-mentioned data to be reported needs to be completed by overloading.
  • the convert conversion function is a function that converts numbers from one measurement system to another.
  • the convert conversion function converts dates into general functions of new data types, and can display date/time data in different formats.
  • the syntax is: CONVERT(number, from_unit, to_unit), where Number is the value that needs to be converted in units of from_units, From_unit is the unit of the number number, and To_unit is the unit of the conversion result.
  • the screening of the data to be reported after the pre-processing is performed by filtering the data to be reported from the data to be reported after the pre-processing, for example, there are 10 columns of different types of data in the data to be reported after the pre-processing, and Only 8 columns of data need to be recorded in the data platform. Therefore, it is necessary to filter the 8 columns of data that need to be reported to the data platform after the pre-processed data to be reported.
  • step S40 the filtered data to be reported is adapted by using a preset function, and the adapted data to be reported is uploaded to the data platform.
  • dynamic SQL can be used by using the sys.anydata access restore function.
  • the Query Language (Structured Query Language) format adapts the filtered data to be reported one by one, and then uploads the adapted data to be reported to the data platform.
  • the access function is a function applied in the Access database module.
  • the adapting the filtered data to be reported includes: according to the type of the data to be reported after the screening, the “checked-in” of the filtered data to be uploaded to the corresponding upload data array, and the data storage manner of the uploaded data array and The above data platforms are consistent.
  • the scalable data reporting method in this embodiment first establishes a configuration table according to the type of the data platform, and performs compatibility and matching check on the configuration table, and secondly, differentiates the reported data according to the source of the data to be reported. After the configuration, the configured data to be reported is pre-processed and filtered. Finally, the filtered data to be reported is adapted and uploaded to the data platform.
  • the present invention by performing a series of processes such as differential configuration, pre-processing, filtering, and adaptation on the reported data, the purpose of quickly performing data reporting according to the type of the data platform is realized, so that multiple regulatory agencies can share one.
  • the data reporting system for enterprises, only needs to develop and maintain a data reporting system, and can complete the task of reporting data to multiple regulatory agencies, thereby effectively reducing the manpower and material resources, improving work efficiency, and solving the present problem.
  • the same data reporting system is difficult to be compatible with multiple regulatory agencies, resulting in the development and maintenance of the data reporting system, which not only requires a lot of manpower and material resources, but also causes repeated labor and low technical efficiency.
  • the source of the data to be reported includes the data on the counter and the data on the counter, which is shown in step S20 of FIG.
  • the steps for differentiating the reported data according to the source of the data to be reported include:
  • the asynchronously configured processing is performed on the to-be-reported data.
  • step of performing real-time configuration processing on the to-be-reported data includes:
  • the type conversion of the to-be-reported data is implemented by brid_column_serial (service serial number) bridging the mapping relationship between the busi_column_name (service field name) and the vms_column_name (document field name).
  • the mapping between the service sequence number bridging service field name and the document field name, that is, the service sequence number can directly map the to-be-serviced field name or the document field name.
  • step of performing asynchronous configuration processing on the to-be-reported data includes:
  • the data to be reported is cached in a preset temporary table, and the dynamic mapping relationship is implemented through configuration.
  • the implementation of the busi_column_desc (service field description) field is associated with the corresponding busi_column_name (service field name) to ensure that the data corresponding to the column to be reported can be written to the column corresponding to the temporary table, and secondly, the data to be reported in the temporary table is performed.
  • the type conversion of the data to be reported is implemented by brid_column_serial (service sequence number) bridging the mapping relationship between busi_column_name (service field name) and vms_column_name (document field name).
  • the scalable data reporting method in this embodiment performs real-time configuration on the data to be reported from the counter surface, and asynchronously configures the data to be reported from the non-counter surface to implement data to be reported from different sources.
  • the purpose of the differentiated configuration is to be able to unify the format and type of the data to be reported from different sources, and report the data to be reported from different sources to the data platform at one time.
  • the pre-processed data to be reported is filtered in step S30 shown in FIG.
  • the steps include:
  • the pre-processed data to be reported is filtered according to the mapping relationship between the service field name and the service sequence number in the configuration table.
  • the method further includes:
  • the filtered data to be reported is fed back to the preset intermediate temporary array.
  • the pre-processed data to be reported is filtered by the mapping relationship between the service field name and the service sequence number in the information configuration table. Specifically, the pre-processed character index array is filtered into a custom table type character. An intermediate temporary array of indexed array formats.
  • the data to be reported to the data platform is filtered out from the pre-processed data to be reported. For example, there are 10 columns of different types of data in the to-be-reported data after the pre-processing, and only 8 columns of data need to be recorded in the data platform. Therefore, it is necessary to filter out the eight columns of data that need to be reported in the character index array as an intermediate temporary array.
  • the pre-processed data to be reported is pre-processed
  • the pre-processed data to be reported is filtered according to the type of the data platform, and the data platform to be reported is filtered out.
  • the data is cached in a preset intermediate temporary array, thereby enabling the purpose of data reporting at a time according to the type of the data platform, saving manpower and material resources.
  • FIG. 2 is a schematic flowchart of the refinement step of the step S40 shown in FIG. 1 according to the first, second, and third embodiments, and the fourth embodiment of the scalable data reporting method of the present invention.
  • the step of adapting the to-be-reported data to be filtered by using the preset reduction function in the step S40 shown in FIG. 1 and uploading the adapted data to be reported to the data platform includes:
  • Step S41 adapting the intermediate temporary array according to the mapping relationship between the service serial number and the document field name, and writing the adapted intermediate temporary array to the preset upload data array;
  • Step S42 Upload the upload data array to the data platform according to the document field name.
  • the sys.anydata access restore function can be used to adapt the intermediate temporary array one by one using the dynamic SQL form, and then the adapted intermediate temporary array is written according to the mapping relationship between the service serial number and the document field name. Upload the data array, and finally report the uploaded data array check number to the above data platform according to the document field name.
  • the method for reporting the data to be reported in the present embodiment is to filter the data to be reported after the pre-processing, and the data to be reported after the adaptation can be uploaded to the data at one time. platform.
  • the present invention also provides an expandable data reporting system, the scalable data reporting system comprising: a memory, a processor, and an expandable data reporting program stored on the memory and operable on the processor;
  • a configuration table is created according to the type of the data platform, and the compatibility and matching check are performed on the configuration table.
  • the reported data is differentiated according to the source of the data to be reported, and then the configured data to be reported is configured.
  • the pre-processing and screening are performed.
  • the filtered data to be reported is adapted and uploaded to the data platform, that is, the system implements a series of processes such as differential configuration, pre-processing, filtering, and adaptation to report the reported data.
  • the purpose of data reporting is fast, so that multiple regulators can share a data reporting system.
  • only one data reporting system can be developed and maintained, and multiple regulatory agencies can be reported.
  • the task of data so it can effectively reduce the manpower and material resources effectiveness.
  • the filtered data to be reported is adapted by using a preset restore function, and the adapted data to be reported is uploaded to the data platform.
  • FIG. 3 is a schematic diagram of a system structure of a software running environment involved in the scalable data reporting system of the present invention.
  • the scalable data reporting system may include: a processor 1001, For example, CPU, network interface 1004, user interface 1003, memory 1005, communication bus 1002.
  • the communication bus 1002 is configured to implement connection communication between the components;
  • the user interface 1003 may include a display, an input unit such as a keyboard, and the optional user interface 1003 may further include a standard wired interface and a wireless interface.
  • the network interface 1004 may optionally include a standard wired interface, a wireless interface (such as a WI-FI interface); the memory 1005 may be a high-speed RAM memory or a stable memory (non-volatile) Memory, such as a disk storage; the memory 1005 may alternatively be a storage device independent of the processor 1001 described above.
  • a wireless interface such as a WI-FI interface
  • the memory 1005 may be a high-speed RAM memory or a stable memory (non-volatile) Memory, such as a disk storage; the memory 1005 may alternatively be a storage device independent of the processor 1001 described above.
  • FIG. 3 does not constitute a limitation to the above described system, and may include more or fewer components than those illustrated, or some components may be combined, or different component arrangements.
  • a memory 1005 as a computer storage medium may include an operating system, a network communication module, a user interface module, and an expandable data reporting program.
  • the network interface 1004 is mainly used to connect to the background server and perform data communication with the background server.
  • the user interface 1003 is mainly used to connect the client (user end) to perform data communication with the client; and the processor 1001 can use
  • the scalable data reporting program stored in the memory 1005 is called and the corresponding operation is performed.
  • the present invention further provides a storage medium on which an extensible data reporting program is stored, the storage medium being capable of: first establishing a configuration table according to the type of the data platform, and performing compatibility and matching verification on the configuration table. Secondly, the reported data is differentiated according to the source of the data to be reported, and then the configured data to be reported is pre-processed and filtered. Finally, the filtered data to be reported is adapted and uploaded to the data platform, that is, The storage medium can perform a series of processing such as differential configuration, pre-processing, filtering, and adaptation on the data to be reported, so as to quickly perform data reporting according to the type of the data platform, so that multiple regulatory agencies can share one data report.
  • the system for the enterprise, only needs to develop and maintain a data reporting system, and can complete the task of reporting data to multiple regulatory agencies, thereby effectively reducing the manpower and material resources and improving work efficiency.
  • the filtered data to be reported is adapted by using a preset restore function, and the adapted data to be reported is uploaded to the data platform.
  • the embodiments corresponding to the storage medium are substantially the same as the embodiments corresponding to the foregoing scalable data reporting method, and therefore are not described herein again.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Economics (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • Finance (AREA)
  • Development Economics (AREA)
  • Accounting & Taxation (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

本发明公开了一种可扩展数据上报方法，该方法包括：根据数据平台的类型建立配置表，并根据所述配置表对应的配置信息，对所述配置表进行与数据平台的兼容性和匹配性校验；根据待上报数据的来源对待上报数据进行差异化配置；对配置后的待上报数据进行预处理，并对预处理后的待上报数据进行筛选；利用预设的还原函数对筛选后的待上报数据进行适配，并将适配后的待上报数据上传至所述数据平台。本发明还公开了一种可扩展数据上报系统，以及一种存储介质。本发明解决了现有技术中同一数据上报系统难以兼容多个监管机构，，导致在数据上报系统的开发与维护过程中，不但需耗费大量的人力物力，还会造成重复劳动，工作效率较低的技术问题。

Description

可扩展数据上报方法、系统、及存储介质
技术领域
本发明涉及数据库技术领域，尤其涉及一种可扩展数据上报方法、系统、及存储介质。
背景技术
按照我国监管部门(如银监会、国家外汇管理局、人民银行等)对金融机构监管的相关要求，金融机构的各种业务数据需要向各个监管机构进行主动申报。
随着金融机构业务开展逐渐广泛，为满足相关监管要求，需要由统一的数据上报系统对口各监管机构进行自动化申报。同时，自动化申报对时间点要求严格，需要在有限的时间内完成业务分析、相关业务系统数据筛选、报送接口配套等工作。
由于不同的监管机构之间往往存在差异，因此企业需要上报的客户数据内容也会不同，传统的数据上报方式都是企业根据监管机构量身定制，即各个监管机构都有其对应的专用数据上报系统，数据上报系统与监管机构为一一对应的关系，同一数据上报系统难以兼容多个监管机构，因此，对于企业而言，在数据上报系统的开发与维护过程中，不但会耗费大量的人力物力，还会造成重复劳动，工作效率较低。
发明内容
本发明的主要目的在于提出一种可扩展数据上报方法、系统、及存储介质，旨在解决现有技术中同一数据上报系统难以兼容多个监管机构，，导致在数据上报系统的开发与维护过程中，不但需耗费大量的人力物力，还会造成重复劳动，工作效率较低的技术问题。
为实现上述目的，本发明提供一种可扩展数据上报方法，所述可扩展数据上报方法包括：
根据数据平台的类型建立配置表，并根据所述配置表对应的配置信息，对所述配置表进行与数据平台的兼容性和匹配性校验；
根据待上报数据的来源对待上报数据进行差异化配置；
对配置后的待上报数据进行预处理，并对预处理后的待上报数据进行筛选；
利用预设的还原函数对筛选后的待上报数据进行适配，并将适配后的待上报数据上传至所述数据平台。
优选地，对所述配置表进行与数据平台的兼容性和匹配性校验的步骤包括：
对所述配置表中预设的字段进行与数据平台的兼容性和匹配性校验，所述预设的字段包括业务字段名、业务字段类型、单证字段名、单证字段类型中的一项或多项。
优选地，所述待上报数据的来源包括柜面上报数据和非柜面上报数据，所述根据待上报数据的来源对待上报数据进行差异化配置的步骤包括：
若所述待上报数据为柜面上报数据，则对所述待上报数据进行实时配置处理；
若所述待上报数据为非柜面上报数据，则对所述待上报数据进行异步配置处理。
优选地，对所述待上报数据进行实时配置处理的步骤包括：
根据所述待上报数据对应的发票信息，通过所述配置表中的业务序列号桥接所述业务字段名与单证字段名之间的映射关系，对所述待上报数据进行类型转换。
优选地，对所述待上报数据进行异步配置处理的步骤包括：
将所述待上报数据缓存至预设的临时表中；
通过所述配置表中的业务序列号桥接所述业务字段名与单证字段名之间的映射关系，对所述临时表中缓存的待上报数据进行类型转换。
优选地，所述对预处理后的待上报数据进行筛选的步骤包括：
根据所述配置表中的业务字段名和业务序列号之间的映射关系，对预处理后的待上报数据进行筛选。
优选地，所述对预处理后的待上报数据进行筛选的步骤之后还包括：
将筛选后的待上报数据反馈至预设的中间临时数组。
优选地，所述利用预设的还原函数对筛选后的待上报数据进行适配，并将适配后的待上报数据上传至所述数据平台的步骤包括：
根据所述业务序列号与单证字段名之间的映射关系，对所述中间临时数组进行适配，并将适配后的中间临时数组写入到预设的上传数据数组；
根据所述单证字段名，将所述上传数据数组上传至所述数据平台。
此外，为实现上述目的，本发明还提供一种可扩展数据上报系统，所述可扩展数据上报系统包括：存储器、处理器及存储在所述存储器上并可在所述处理器上运行的可扩展数据上报程序，所述可扩展数据上报程序被所述处理器执行时实现如上述可扩展数据上报方法所对应的各个步骤。
此外，为实现上述目的，本发明还提供一种存储介质，所述存储介质上存储有可扩展数据上报程序，所述可扩展数据上报程序被处理器执行时实现如上述可扩展数据上报方法所对应的各个步骤。
本发明所提供的可扩展数据上报方法、系统、及存储介质，可以实现：先根据数据平台的类型建立配置表，并对该配置表进行兼容性和匹配性校验，其次，根据待上报数据的来源对待上报数据进行差异化配置，然后对配置后的待上报数据进行预处理及筛选，最后将筛选后的待上报数据进行适配后上传至上述数据平台。即本发明中，通过对待上报数据进行差异化配置、预处理、筛选、适配等一系列处理，实现了根据数据平台的类型来快速进行数据上报的目的，从而使多个监管机构可以共用一个数据上报系统，对于企业而言，只需开发与维护一个数据上报系统，即可完成向多个监管机构上报数据的工作任务，因此可有效降低所耗费的人力物力，提升工作效率，解决了现有技术中同一数据上报系统难以兼容多个监管机构，，导致在数据上报系统的开发与维护过程中，不但需耗费大量的人力物力，还会造成重复劳动，工作效率较低的技术问题。
附图说明
图1为本发明可扩展数据上报方法第一实施例的流程示意图；
图2为本发明图1所示步骤S40的细化步骤流程示意图；
图3为本发明可扩展数据上报系统涉及的软件运行环境的系统结构示意图。
本发明目的的实现、功能特点及优点将结合实施例，参照附图做进一步说明。
具体实施方式
以下结合说明书附图对本发明的优选实施例进行说明，应当理解，此处所描述的优选实施例仅用于说明和解释本发明，并不用于限定本发明，并且在不冲突的情况下，本发明中的实施例及实施例中的特征可以相互组合。
本发明以下实施例提供一种可扩展数据上报方法，该方法中，先根据数据平台的类型建立配置表，并对该配置表进行兼容性和匹配性校验，其次，根据待上报数据的来源对待上报数据进行差异化配置，然后对配置后的待上报数据进行预处理及筛选，最后将筛选后的待上报数据进行适配后上传至上述数据平台。即本发明中，通过对待上报数据进行差异化配置、预处理、筛选、适配等一系列处理，从而使多个监管机构可以共用一个数据上报系统，对于企业而言，只需开发与维护一个数据上报系统，即可完成向多个监管机构上报数据的工作任务，因此可有效降低所耗费的人力物力，提升工作效率。
参照图1，图1为本发明可扩展数据上报方法第一实施例的流程示意图，本实施例中，所述可扩展数据上报方法包括：
步骤S10，根据数据平台的类型建立配置表，并根据所述配置表对应的配置信息，对所述配置表进行与数据平台的兼容性和匹配性校验。
本实施例中，不同的数据平台，其需要报送的上报数据也会有差异，故需要根据数据平台的类型建立配置表rbs_invoice_report_config，其中，该数据平台为监管机构对应的数据接收平台。
为了更好的理解本发明，本实施例提供一种配置表进行举例说明，例如，配置表rbs_invoice_report_config的表数据结构可设置为如下：
data_type is '数据类型0-非月交件发票 1-月交件发票' ;
data_source is '数据来源0-柜面 1-非柜面' ;
busi_column_name is '业务字段名' ;
busi_column_desc is '业务字段中文描述' ;
busi_column_serial is '业务序列号' ;
busi_column_type is '业务字段类型' ;
busi_column_format is '业务字段格式' ;
vms_column_name is '单证字段名' ;
vms_column_type is '单证字段类型' ;
vms_column_format is '单证字段格式' ;
其次，建立配置表之后，根据配置表对应的配置信息，对该配置表进行与数据平台的兼容性和匹配性校验。
其中，对所述配置表进行与数据平台的兼容性和匹配性校验包括对所述配置表中各个字段的格式以及类型进行兼容性和匹配性校验。例如，若配置表配置表中的某个字段的类型为日期，且该字段的格式为“yyyy/mm/dd”,则通过兼容性和匹配性校验之后，该字段内存储的数据都会以“yyyy/mm/dd”格式进行存储，如“2017/01/01”表示2017年01月01日；同理，若该表示日期的字段的格式为 “mm/dd/yyyy”，则该字段内存储的数据都会以“mm/dd/yyyy”格式进行存储，如“12/31/2016”表示2016年12月31日。另外，若配置表配置表中的某个字段的类型为金额，且该字段的格式为“0.00”，则通过兼容性和匹配性校验之后，该字段内存储的数据都会以“0.00”格式进行存储，如金额大小为200元的数据则存储为“200.00”。
其中，数据库的标准主要包括SQL（Structured Query Language，结构化查询语言)、ODBC（Open Database Connectivity，开放数据库连接）、JDBC（Java Data Base Connectivity，java数据库连接）等。由于各个数据库系统对数据库标准的支持程度不同，导致基于某一种数据库开发的应用系统在其他数据库上未必能够正常运行，例如如果数据库系统从SOL迁移到Oracle，则需要进行兼容性校验。其中，数据库兼容性校验一般需要解决的技术问题为：
（1）检查原数据库中的所有表能否全部移入新的数据库，并比较所有表中的数据是否正确；
（2）检查原数据库中的所有存储过程和触发器是否能够在新数据库中正确执行并加载；
（3）检查数据库中数据查询速度，判断是否存在较大影响。
其中，匹配性校验为了防止不符合规范的数据进入数据库，在用户对数据进行插入、修改、删除等操作时，DBMS (Database Management System，数据库管理系统)会自动按照一定的约束条件对数据进行监测，使不符合规范的数据不能进入数据库，以确保数据库中存储的数据正确、有效、相容。
进一步地，上述图1所示步骤S10中所述的对所述配置表进行与数据平台的兼容性和匹配性校验的步骤包括：
对所述配置表中预设的字段进行与数据平台的兼容性和匹配性校验，所述预设的字段包括业务字段名、业务字段类型、单证字段名、单证字段类型中的一项或多项。
具体的，对上述配置表rbs_invoice_report_config中的busi_column_name（业务字段名）、busi_column_type（业务字段类型）、vms_column_name（单证字段名）、vms_column_type（单证字段类型）中的一项或多项做兼容性和匹配性校验，然后返回自定义table类型字符索引数组string_array_by_charIndex，用于后续对待上报数据进行适配。
步骤S20，根据待上报数据的来源对待上报数据进行差异化配置。
本实施例中，待上报数据的来源主要包括两种：柜面上报数据和非柜面上报数据，其中，柜面上报数据是指通过柜台录入的数据，非柜面上报数据是指在除柜台之外的其他录入设备录入的数据，例如，由客户自行在官网网页、客户端录入的数据。
其中，对于不同来源的待上报数据，对其进行的配置也不同，对于柜面上报数据，可以直接根据发票打印信息来进行配置；对于非柜面上报数据，则需要先将待上报数据缓存到临时表中，然后对该临时表中的待上报数据进行配置。
步骤S30，对配置后的待上报数据进行预处理，并对预处理后的待上报数据进行筛选。
本实施例中，可以通过重载对配置后的不同来源的待上报数据进行预处理，其中，可以利用sys.anydata的convert转换函数实现将待上报数据中的字符、数值、日期、表记录类型等，返回至上述自定义的table类型字符索引数组anydata_array_by_charIndex。
其中，重载是指函数或者方法有相同的名称，但是参数列表不相同的情形，这样的同名但不同参数的函数或者方法之间，互相称之为重载函数或者方法。可以理解的是，上述待上报数据的来源包括柜面上报数据和非柜面上报数据两种，虽然这两种来源的待上报数据所采用的函数为同一个函数，但是来源不同，对应的数据参数也会不同，因次，需要通过重载的方式来完成对上述待上报数据的预处理。
其中，sys.anydata是Oracle数据库系统提供的一种新的数据类型，开发人员借助此类型可以声明包括任何类型数据的变量。convert转换函数是将数字从一个度量系统转换到另一个度量系统中的函数，例如，convert转换函数可以把日期转换为新数据类型的通用函数，并且可以用不同的格式显示日期/时间数据，常用语法为：CONVERT(number，from_unit，to_unit)，其中，Number是以from_units为单位的需要进行转换的数值，From_unit是数值number的单位，To_unit是转换结果的单位。
其中，对预处理后的待上报数据进行筛选是指从预处理后的待上报数据中筛选出需要上报数据平台的数据，如预处理后的待上报数据中存在10列不同类型的数据，而数据平台中只需要录入其中的8列数据，故需要在预处理后的待上报数据筛选出需要上报数据平台的8列数据。
步骤S40，利用预设的还原函数对筛选后的待上报数据进行适配，并将适配后的待上报数据上传至所述数据平台。
本实施例中，可以利用sys.anydata的access还原函数使用动态SQL（Structured Query Language，结构化查询语言）形式对筛选后的待上报数据逐一进行适配，然后将适配后的待上报数据上传至上述数据平台。
其中，access函数为应用在Access数据库模块中的函数。对筛选后的待上报数据进行适配包括：根据筛选后的待上报数据的类型，将筛选后的待上报数据的“对号入座”到相应的上传数据数组中，该上传数据数组的数据存放方式与上述数据平台一致。
本实施例所述的可扩展数据上报方法，先根据数据平台的类型建立配置表，并对该配置表进行兼容性和匹配性校验，其次，根据待上报数据的来源对待上报数据进行差异化配置，然后对配置后的待上报数据进行预处理及筛选，最后将筛选后的待上报数据进行适配后上传至上述数据平台。即本发明中，通过对待上报数据进行差异化配置、预处理、筛选、适配等一系列处理，实现了根据数据平台的类型来快速进行数据上报的目的，从而使多个监管机构可以共用一个数据上报系统，对于企业而言，只需开发与维护一个数据上报系统，即可完成向多个监管机构上报数据的工作任务，因此可有效降低所耗费的人力物力，提升工作效率，解决了现有技术中同一数据上报系统难以兼容多个监管机构，，导致在数据上报系统的开发与维护过程中，不但需耗费大量的人力物力，还会造成重复劳动，工作效率较低的技术问题。
进一步地，基于上述第一实施例，本发明可扩展数据上报方法第二实施例中，上述待上报数据的来源包括柜面上报数据和非柜面上报数据，上述图1所示步骤S20中所述的根据待上报数据的来源对待上报数据进行差异化配置的步骤包括：
若所述待上报数据为柜面上报数据，则对所述待上报数据进行实时配置处理；
若上述待上报数据为非柜面上报数据，则对所述待上报数据进行异步配置处理。
进一步地，对上述待上报数据进行实时配置处理的步骤包括：
根据所述待上报数据对应的发票信息，通过所述配置表中的业务序列号桥接所述业务字段名与单证字段名之间的映射关系，对所述待上报数据进行类型转换。
具体的，根据发票打印信息，通过busi_column_serial（业务序列号）桥接busi_column_name（业务字段名）与vms_column_name（单证字段名）之间的映射关系，来实现对上述待上报数据的类型转换。
其中，业务序列号桥接业务字段名与单证字段名之间的映射关系，即由业务序列号可以直接映射待业务字段名或者单证字段名。
进一步地，对上述待上报数据进行异步配置处理的步骤包括：
将所述待上报数据缓存至预设的临时表中；
通过所述配置表中的业务序列号桥接所述业务字段名与单证字段名之间的映射关系，对所述临时表中缓存的待上报数据进行类型转换。
具体的，先将上述待上报数据缓存至预设的临时表中，通过配置实现动态映射关系。实现，通过busi_column_desc（业务字段中文描述）字段关联对应busi_column_name（业务字段名）来确保待上报数据对应各列数据能够写入到临时表对应的列，其次，对临时表中的待上报数据进行逐单处理，通过busi_column_serial（业务序列号）桥接busi_column_name（业务字段名）与vms_column_name（单证字段名）之间的映射关系，来实现对上述待上报数据的类型转换。
本实施例所述的可扩展数据上报方法，对来源于柜面的待上报数据进行实时配置，对来源于非柜面的待上报数据进行异步配置，即可实现对不同来源的待上报数据进行差异化配置的目的，从而能够统一不同来源的待上报数据对应的格式以及类型，可一次性将不同来源的待上报数据上报至数据平台。
进一步地，基于上述第一实施例与第二实施例，本发明可扩展数据上报方法第三实施例中，上述图1所示步骤S30中所述的对预处理后的待上报数据进行筛选的步骤包括：
根据所述配置表中的业务字段名和业务序列号之间的映射关系，对预处理后的待上报数据进行筛选。
进一步地，上述图1所示步骤S30中所述的对预处理后的待上报数据进行筛选的步骤之后还包括：
将筛选后的待上报数据反馈至预设的中间临时数组。
其中，通过信息配置表中的业务字段名和业务序列号之间的映射关系，对预处理后的待上报数据进行筛选，具体的，对预处理后的字符索引数组筛选为自定义table类型的字符索引数组格式的中间临时数组。
其中，从预处理后的待上报数据中筛选出需要上报数据平台的数据，如预处理后的待上报数据中存在10列不同类型的数据，而数据平台中只需要录入其中的8列数据，故需要在字符索引数组中筛选出需要上报数据平台的8列数据，作为中间临时数组。
本实施例所述的可扩展数据上报方法，在对配置后的待上报数据进行预处理之后，需要根据数据平台的类型对预处理后的待上报数据进行筛选，筛选出需要上报数据平台的相关数据，并缓存在预设的中间临时数组，从而能够实现根据数据平台的类型，一次性快速进行数据上报的目的，节省人力物力。
进一步地，参照图2，图2为本发明图1所示步骤S40的细化步骤流程示意图，基于上述第一、第二、第三实施例，本发明可扩展数据上报方法第四实施例中，上述图1所示步骤S40中所述的利用预设的还原函数对筛选后的待上报数据进行适配，并将适配后的待上报数据上传至所述数据平台的步骤包括：
步骤S41，根据所述业务序列号与单证字段名之间的映射关系，对所述中间临时数组进行适配，并将适配后的中间临时数组写入到预设的上传数据数组；
步骤S42，根据所述单证字段名，将所述上传数据数组上传至所述数据平台。
其中，可以利用sys.anydata的access还原函数使用动态SQL形式对中间临时数组逐一进行适配，然后根据业务序列号与单证字段名之间的映射关系，将适配后的中间临时数组写入上传数据数组，最后根据单证字段名将该上传数据数组对号入座上报至上述数据平台。
本实施例所述的可扩展数据上报方法，在对预处理后的待上报数据进行筛选后，对筛选后的待上报数据进行适配，适配后的待上报数据即可一次性上传至数据平台。
本发明还提供一种可扩展数据上报系统，该可扩展数据上报系统包括：存储器、处理器及存储在所述存储器上并可在所述处理器上运行的可扩展数据上报程序；该系统能够实现：先根据数据平台的类型建立配置表，并对该配置表进行兼容性和匹配性校验，其次，根据待上报数据的来源对待上报数据进行差异化配置，然后对配置后的待上报数据进行预处理及筛选，最后将筛选后的待上报数据进行适配后上传至上述数据平台，即本系统通过对待上报数据进行差异化配置、预处理、筛选、适配等一系列处理，实现了根据数据平台的类型来快速进行数据上报的目的，从而使多个监管机构可以共用一个数据上报系统，对于企业而言，只需开发与维护一个数据上报系统，即可完成向多个监管机构上报数据的工作任务，因此可有效降低所耗费的人力物力，提升工作效率。
具体的，上述可扩展数据上报程序被所述处理器执行时实现下步骤：
根据数据平台的类型建立配置表，并根据所述配置表对应的配置信息，对所述配置表进行与数据平台的兼容性和匹配性校验；
根据待上报数据的来源对待上报数据进行差异化配置；
对配置后的待上报数据进行预处理，并对预处理后的待上报数据进行筛选；
利用预设的还原函数对筛选后的待上报数据进行适配，并将适配后的待上报数据上传至所述数据平台。
为了更好的理解本发明，参照图3，图3为本发明可扩展数据上报系统涉及的软件运行环境的系统结构示意图，本实施例中，上述可扩展数据上报系统可包括：处理器1001，例如CPU，网络接口1004，用户接口1003，存储器1005，通信总线1002。其中，通信总线1002用于实现这些组件之间的连接通信；用户接口1003可以包括显示屏（Display）、输入单元比如键盘（Keyboard），可选用户接口1003还可以包括标准的有线接口、无线接口；网络接口1004可选的可以包括标准的有线接口、无线接口（如WI-FI接口）；存储器1005可以是高速RAM存储器，也可以是稳定的存储器（non-volatile memory），例如磁盘存储器；存储器1005可选的还可以是独立于前述处理器1001的存储装置。
本领域技术人员可以理解，图3中示出的系统结构并不构成对上述系统的限定，可以包括比图示更多或更少的部件，或者组合某些部件，或者不同的部件布置。
如图3所示，作为一种计算机存储介质的存储器1005中，可以包括操作系统、网络通信模块、用户接口模块以及可扩展数据上报程序。
如图3所示，网络接口1004主要用于连接后台服务器，与后台服务器进行数据通信；用户接口1003主要用于连接客户端（用户端），与客户端进行数据通信；而处理器1001可以用于调用存储器1005中存储的可扩展数据上报程序，并执行相应的操作。
其中，该可扩展数据上报系统对应的实施例与上述可扩展数据上报方法对应的各个实施例基本相同，故在此不再赘述。
本发明还提供一种存储介质，该存储介质上存储有可扩展数据上报程序，该存储介质能够实现：先根据数据平台的类型建立配置表，并对该配置表进行兼容性和匹配性校验，其次，根据待上报数据的来源对待上报数据进行差异化配置，然后对配置后的待上报数据进行预处理及筛选，最后将筛选后的待上报数据进行适配后上传至上述数据平台，即该存储介质能够通过对待上报数据进行差异化配置、预处理、筛选、适配等一系列处理，实现根据数据平台的类型来快速进行数据上报的目的，从而使多个监管机构可以共用一个数据上报系统，对于企业而言，只需开发与维护一个数据上报系统，即可完成向多个监管机构上报数据的工作任务，因此可有效降低所耗费的人力物力，提升工作效率。
具体的，上述可扩展数据上报程序被处理器执行时实现如下步骤：
根据数据平台的类型建立配置表，并根据所述配置表对应的配置信息，对所述配置表进行与数据平台的兼容性和匹配性校验；
根据待上报数据的来源对待上报数据进行差异化配置；
对配置后的待上报数据进行预处理，并对预处理后的待上报数据进行筛选；
利用预设的还原函数对筛选后的待上报数据进行适配，并将适配后的待上报数据上传至所述数据平台。
其中，该存储介质对应的实施例与上述可扩展数据上报方法对应的各个实施例基本相同，故在此不再赘述。
需要说明的是，在本文中，术语“包括”、“包含”或者其任何其他变体意在涵盖非排他性的包含，从而使得包括一系列要素的过程、方法、物品或者装置不仅包括那些要素，而且还包括没有明确列出的其他要素，或者是还包括为这种过程、方法、物品或者装置所固有的要素。在没有更多限制的情况下，由语句“包括一个……”限定的要素，并不排除在包括该要素的过程、方法、物品或者装置中还存在另外的相同要素。
上述本发明实施例序号仅仅为了描述，不代表实施例的优劣。
通过以上的实施方式的描述，本领域的技术人员可以清楚地了解到上述实施例方法可借助软件加必需的通用硬件平台的方式来实现，当然也可以通过硬件，但很多情况下前者是更佳的实施方式。基于这样的理解，本发明的技术方案本质上或者说对现有技术做出贡献的部分可以以软件产品的形式体现出来，该计算机软件产品存储在如上所述的一个存储介质(如ROM/RAM、磁碟、光盘)中，包括若干指令用以使得一台终端设备执行本发明各个实施例所述的方法。
以上仅为本发明的优选实施例，并非因此限制本发明的专利范围，凡是利用本发明说明书及附图内容所作的等效结构或等效流程变换，或直接或间接运用在其他相关的技术领域，均同理包括在本发明的专利保护范围内。

Claims (10)

  1. 一种可扩展数据上报方法，其特征在于，所述可扩展数据上报方法包括：
    根据数据平台的类型建立配置表，并根据所述配置表对应的配置信息，对所述配置表进行与数据平台的兼容性和匹配性校验；
    根据待上报数据的来源对待上报数据进行差异化配置；
    对配置后的待上报数据进行预处理，并对预处理后的待上报数据进行筛选；
    利用预设的还原函数对筛选后的待上报数据进行适配，并将适配后的待上报数据上传至所述数据平台。
  2. 如权利要求1所述的可扩展数据上报方法，其特征在于，对所述配置表进行与数据平台的兼容性和匹配性校验的步骤包括：
    对所述配置表中预设的字段进行与数据平台的兼容性和匹配性校验，所述预设的字段包括业务字段名、业务字段类型、单证字段名、单证字段类型中的一项或多项。
  3. 如权利要求1或2所述的可扩展数据上报方法，其特征在于，所述待上报数据的来源包括柜面上报数据和非柜面上报数据，所述根据待上报数据的来源对待上报数据进行差异化配置的步骤包括：
    若所述待上报数据为柜面上报数据，则对所述待上报数据进行实时配置处理；
    若所述待上报数据为非柜面上报数据，则对所述待上报数据进行异步配置处理。
  4. 如权利要求3所述的可扩展数据上报方法，其特征在于，对所述待上报数据进行实时配置处理的步骤包括：
    根据所述待上报数据对应的发票信息，通过所述配置表中的业务序列号桥接所述业务字段名与单证字段名之间的映射关系，对所述待上报数据进行类型转换。
  5. 如权利要求3所述的可扩展数据上报方法，其特征在于，对所述待上报数据进行异步配置处理的步骤包括：
    将所述待上报数据缓存至预设的临时表中；
    通过所述配置表中的业务序列号桥接所述业务字段名与单证字段名之间的映射关系，对所述临时表中缓存的待上报数据进行类型转换。
  6. 如权利要求4或5所述的可扩展数据上报方法，其特征在于，所述对预处理后的待上报数据进行筛选的步骤包括：
    根据所述配置表中的业务字段名和业务序列号之间的映射关系，对预处理后的待上报数据进行筛选。
  7. 如权利要求6所述的可扩展数据上报方法，其特征在于，所述对预处理后的待上报数据进行筛选的步骤之后还包括：
    将筛选后的待上报数据反馈至预设的中间临时数组。
  8. 如权利要求7所述的可扩展数据上报方法，其特征在于，所述利用预设的还原函数对筛选后的待上报数据进行适配，并将适配后的待上报数据上传至所述数据平台的步骤包括：
    根据所述业务序列号与单证字段名之间的映射关系，对所述中间临时数组进行适配，并将适配后的中间临时数组写入到预设的上传数据数组；
    根据所述单证字段名，将所述上传数据数组上传至所述数据平台。
  9. 一种可扩展数据上报系统，其特征在于，所述可扩展数据上报系统包括：存储器、处理器及存储在所述存储器上并可在所述处理器上运行的可扩展数据上报程序，所述可扩展数据上报程序被所述处理器执行时实现如权利要求1至8中任意一项所述的可扩展数据上报方法的步骤。
  10. 一种存储介质，其特征在于，所述存储介质上存储有可扩展数据上报程序，所述可扩展数据上报程序被处理器执行时实现如权利要求1至8中任意一项所述的可扩展数据上报方法的步骤。
    说 明 书
PCT/CN2018/076469 2017-05-22 2018-02-12 可扩展数据上报方法、系统、及存储介质 Ceased WO2018214599A1 (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710365841.6 2017-05-22
CN201710365841.6A CN108959307A (zh) 2017-05-22 2017-05-22 可扩展数据上报方法、系统、及存储介质

Publications (1)

Publication Number Publication Date
WO2018214599A1 true WO2018214599A1 (zh) 2018-11-29

Family

ID=64395262

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/076469 Ceased WO2018214599A1 (zh) 2017-05-22 2018-02-12 可扩展数据上报方法、系统、及存储介质

Country Status (2)

Country Link
CN (1) CN108959307A (zh)
WO (1) WO2018214599A1 (zh)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2022143405A1 (zh) * 2020-12-30 2022-07-07 欧普照明股份有限公司 一种能耗数据处理方法，云服务器，以及能耗数据处理系统

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109842610B (zh) * 2018-12-13 2022-07-26 平安科技（深圳）有限公司 接口请求处理方法、装置、计算机设备及存储介质
CN109871407A (zh) * 2019-01-23 2019-06-11 深圳壹账通智能科技有限公司 备付金数据实时上报方法、装置、计算机设备和存储介质
CN110909060B (zh) * 2019-11-26 2023-10-03 中信银行股份有限公司 数据报送方法和系统
CN112036142A (zh) * 2020-09-02 2020-12-04 中国银行股份有限公司 一种基于数据配置的实时性报表生成方法及系统
CN112988867B (zh) * 2021-03-15 2025-09-12 中国建设银行股份有限公司 监管数据报送方法及装置
CN116257686A (zh) * 2023-02-16 2023-06-13 杭州当虹科技股份有限公司 基于ElasticSearch的可扩展的数据上报系统及方法

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102117454A (zh) * 2009-12-30 2011-07-06 中国银联股份有限公司 银行卡安全支付方法及系统
CN102236657A (zh) * 2010-04-28 2011-11-09 阿里巴巴集团控股有限公司 一种处理上报数据的方法和服务器
US20120310875A1 (en) * 2011-06-03 2012-12-06 Prashanth Prahlad Method and system of generating a data lineage repository with lineage visibility, snapshot comparison and version control in a cloud-computing platform
CN105512201A (zh) * 2015-11-26 2016-04-20 晶赞广告（上海）有限公司 数据收集和加工方法及装置

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103309945A (zh) * 2013-05-15 2013-09-18 上海证券交易所 一种将数据导入数据库的装置
CN103678591B (zh) * 2013-12-12 2017-07-11 用友网络科技股份有限公司 自动执行多业务单据统计处理的装置和方法
CN105608088B (zh) * 2014-11-19 2019-03-19 中国航空工业集团公司西安飞机设计研究所 一种基于配置文件的数据库自动创建与数据动态记录方法
CN104572122B (zh) * 2015-01-28 2018-04-27 中国工商银行股份有限公司 一种软件应用数据的生成装置及方法
CN106599221A (zh) * 2016-12-16 2017-04-26 北京用友审计软件有限公司 一种数据处理方法及装置

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102117454A (zh) * 2009-12-30 2011-07-06 中国银联股份有限公司 银行卡安全支付方法及系统
CN102236657A (zh) * 2010-04-28 2011-11-09 阿里巴巴集团控股有限公司 一种处理上报数据的方法和服务器
US20120310875A1 (en) * 2011-06-03 2012-12-06 Prashanth Prahlad Method and system of generating a data lineage repository with lineage visibility, snapshot comparison and version control in a cloud-computing platform
CN105512201A (zh) * 2015-11-26 2016-04-20 晶赞广告（上海）有限公司 数据收集和加工方法及装置

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2022143405A1 (zh) * 2020-12-30 2022-07-07 欧普照明股份有限公司 一种能耗数据处理方法，云服务器，以及能耗数据处理系统

Also Published As

Publication number Publication date
CN108959307A (zh) 2018-12-07

Similar Documents

Publication Publication Date Title
WO2018214599A1 (zh) 可扩展数据上报方法、系统、及存储介质
WO2019100638A1 (zh) 数据同步方法、装置、设备及存储介质
WO2018205545A1 (zh) 数据生成方法、装置、终端及计算机可读存储介质
WO2019165691A1 (zh) 自动生成测试案例的方法、装置、设备及可读存储介质
WO2018107610A1 (zh) 业务数据处理方法、系统、设备及计算机可读存储介质
WO2019169814A1 (zh) 自动生成中文注释的方法、装置、设备及存储介质
WO2019061613A1 (zh) 贷款资质筛选方法、装置及计算机可读存储介质
WO2019024219A1 (zh) 文档自动生成方法、装置、文档自动生成器及介质
WO2019174375A1 (zh) 接口测试方法、装置、设备及计算机可读存储介质
WO2019037396A1 (zh) 账户清结算方法、装置、设备及存储介质
WO2020224247A1 (zh) 基于区块链的数据溯源方法、装置、设备及可读存储介质
WO2018205376A1 (zh) 一种关联信息查询方法、终端、服务器管理系统及计算机可读存储介质
WO2019104876A1 (zh) 保险产品的推送方法、系统、终端、客户终端及存储介质
WO2019041832A1 (zh) 修改源数据库表结构的方法、服务器、系统及存储介质
WO2019192085A1 (zh) 银企直联通信方法、装置、设备及计算机可读存储介质
WO2019161615A1 (zh) 账单录入方法、系统、光学字符识别服务器和存储介质
WO2015144089A1 (en) Application recommending method and apparatus
WO2018205544A1 (zh) 软件项目管理方法、装置、终端及计算机存储介质
WO2018120430A1 (zh) 一种页面构建方法、终端、计算机可读存储介质及页面构建设备
WO2018227880A1 (zh) 数据比对方法、装置、设备及可读存储介质
WO2015131803A1 (en) Application recommending method and system
WO2019140804A1 (zh) 一种可疑交易监测方法、装置、设备及存储介质
WO2019100604A1 (zh) 账户查询方法、装置、设备及计算机可读存储介质
WO2018120681A1 (zh) 数据同步方法、装置、系统、数据处理服务器和存储介质
WO2018166314A1 (zh) 额度审批方法、装置、设备以及计算机可读存储介质

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 18805357

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 12.03.2020)

122 Ep: pct application non-entry in european phase

Ref document number: 18805357

Country of ref document: EP

Kind code of ref document: A1