CN112102028B - Unified configuration and verification method and system for service data - Google Patents

Unified configuration and verification method and system for service data Download PDF

Info

Publication number
CN112102028B
CN112102028B CN202010801672.8A CN202010801672A CN112102028B CN 112102028 B CN112102028 B CN 112102028B CN 202010801672 A CN202010801672 A CN 202010801672A CN 112102028 B CN112102028 B CN 112102028B
Authority
CN
China
Prior art keywords
rule
configuration
commodity
preset
parameter
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.)
Active
Application number
CN202010801672.8A
Other languages
Chinese (zh)
Other versions
CN112102028A (en
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.)
Beijing Si Tech Information Technology Co Ltd
Original Assignee
Beijing Si Tech Information Technology 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 Beijing Si Tech Information Technology Co Ltd filed Critical Beijing Si Tech Information Technology Co Ltd
Priority to CN202010801672.8A priority Critical patent/CN112102028B/en
Publication of CN112102028A publication Critical patent/CN112102028A/en
Application granted granted Critical
Publication of CN112102028B publication Critical patent/CN112102028B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]
    • G06Q30/0621Item configuration or customization
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • G06F16/288Entity relationship models

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • General Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Computational Linguistics (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • Development Economics (AREA)
  • Debugging And Monitoring (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a method and a system for uniformly configuring and checking service data, wherein the method comprises the following steps: inquiring a preset commodity and rule relation example table according to the business commodity to be configured to obtain a corresponding configuration rule code; inquiring according to a preset limiting rule instance table to obtain a rule corresponding to the configuration rule code; inquiring a limit condition corresponding to a rule according to a preset core limit condition instance table; inquiring specific parameters of the obtained limiting conditions according to a preset parameter instance table; and replacing the rule parameters of the business commodity according to the specific parameters. According to the technical scheme, database operation is not needed manually, the development cost of service developers is reduced, and the development efficiency is improved.

Description

Unified configuration and verification method and system for service data
Technical Field
The invention relates to the technical field of service support systems, in particular to a service data unified configuration and verification method and a service data unified configuration and verification system.
Background
At present, a BOSS service support system is increasingly complex, the service volume of bearing acceptance is huge, and especially, service commodity acceptance types (product tariffs and marketing activities are transacted). And various business restrictions exist to meet different market demands during commodity acceptance. The restrictions of the service developer on the product charge and the marketing activities are independent configuration and cannot be reused, so that the service development workload and the maintenance difficulty are increased.
Disclosure of Invention
Aiming at the problems, the invention provides a method and a system for uniformly configuring and checking service data, wherein the front-end and back-end limiting condition configuration of service commodities is carried out through a uniform configuration platform, the back-end checking capability is combined, database operation is not needed to be carried out manually, the development cost of service developers is reduced, and the development efficiency is improved.
In order to achieve the above object, the present invention provides a method for uniformly configuring and checking service data, including: inquiring a preset commodity and rule relation example table according to the business commodity to be configured to obtain a corresponding configuration rule code; inquiring according to a preset limiting rule instance table to obtain a rule corresponding to the configuration rule code; inquiring a limiting condition corresponding to the rule according to a preset core limiting condition instance table; inquiring according to a preset parameter instance table to obtain specific parameters of the limiting conditions; and replacing the rule parameters of the business commodity according to the specific parameters.
In the above technical solution, preferably, the service data unified configuration and verification method further includes: if the corresponding configuration rule code is not queried when the corresponding configuration rule code is queried through the preset commodity and rule relation example table, stopping the rule parameter configuration of the business commodity.
In the above technical solution, preferably, the service data unified configuration and verification method further includes: and if the corresponding rule is not queried when the rule corresponding to the configuration rule code is queried through a preset limit rule instance table, sending error reporting information of configuration data deletion.
In the above technical solution, preferably, the constraint condition corresponding to the rule queried according to the preset core constraint condition instance table specifically includes three query implementation modes of SQL statement, JAVA rule component and storage process; in the SQL statement mode, the SQL statement in the rule factor value field in the core constraint condition example table is analyzed through the SQL statement, and in the JAVA rule assembly mode, the entity in the rule factor value field is called by utilizing the JAVA statement.
In the above technical solution, preferably, when a specific parameter of the constraint condition is obtained by querying according to a preset parameter instance table, if the specific parameter is queried, configuring the queried parameter as a rule parameter of the service commodity according to a corresponding sequence and a parameter type in a parameter template, and checking through configuration; if the specific parameters are not inquired, stopping the rule parameter configuration of the business commodity or sending error reporting information with unmatched parameter types according to the returned value judgment result of the inquiring implementation mode.
In the above technical solution, preferably, the query implementation mode to be adopted is determined to be an SQL statement, a JAVA rule component or a stored procedure according to the rule factor type field value of the core constraint condition instance table.
In the above technical solution, preferably, the service commodity to be configured is determined according to the service commodity and the corresponding parameter value input by the front end configuration module.
The invention also provides a service data unified configuration and verification system, which applies the service data unified configuration and verification method according to any one of the technical schemes, and comprises the following steps: the configuration rule code inquiring module is used for inquiring the corresponding configuration rule code through a preset commodity and rule relation example table according to the business commodity to be configured; the rule query module is used for querying and obtaining rules corresponding to the configuration rule codes according to a preset limit rule instance table; the constraint condition query module is used for querying the constraint condition corresponding to the rule according to a preset core constraint condition instance table; the parameter query module is used for querying and obtaining specific parameters of the limiting conditions according to a preset parameter instance table; and the parameter configuration module is used for replacing the rule parameters of the business commodity according to the specific parameters.
In the above technical solution, preferably, if the configuration rule code query module does not query the corresponding configuration rule code when querying the corresponding configuration rule code through the preset commodity and rule relation example table, the rule parameter configuration of the service commodity is stopped, and if the rule query module does not query the corresponding rule when querying the corresponding rule of the configuration rule code through the preset constraint rule example table, the error reporting information of the configuration data deletion is sent.
In the above technical solution, preferably, the service data unified configuration and verification system further includes a front end configuration module, and the service commodity to be configured is determined according to the service commodity and the corresponding parameter value input by the front end configuration module.
Compared with the prior art, the invention has the beneficial effects that: and the front-end and back-end limiting condition configuration of the business commodity is carried out through the unified configuration platform, the back-end verification capability is combined, database operation is not needed to be carried out manually, the development cost of business developers is reduced, and the development efficiency is improved.
Drawings
Fig. 1 is a schematic flow chart of a service data unified configuration and verification method disclosed in an embodiment of the invention;
fig. 2 is a schematic block diagram of a service data unified configuration and verification system disclosed in an embodiment of the present invention.
In the figure, the correspondence between each component and the reference numeral is:
11. The system comprises a configuration rule coding query module, a rule query module, a constraint condition query module, a parameter configuration module and a front-end configuration module.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The invention is described in further detail below with reference to the attached drawing figures:
As shown in fig. 1, the method for uniformly configuring and checking service data provided by the invention comprises the following steps: inquiring a preset commodity and rule relation example table according to the business commodity to be configured to obtain a corresponding configuration rule code; inquiring according to a preset limiting rule instance table to obtain a rule corresponding to the configuration rule code; inquiring a limit condition corresponding to a rule according to a preset core limit condition instance table; inquiring specific parameters of the obtained limiting conditions according to a preset parameter instance table; and replacing the rule parameters of the business commodity according to the specific parameters.
In the embodiment, the front-end and back-end limiting condition configuration of the business commodity is carried out through the unified configuration platform, the back-end verification capability is combined, database operation is not needed to be carried out manually, the development cost of business developers is reduced, and the development efficiency is improved.
Specifically, taking the service commodity of the telecom operator as an example, the unified configuration and verification method of the service data is specifically described by the configuration and verification of the restriction conditions and parameters of the tariffs and marketing activities.
Firstly, according to the business commodity to be configured at the front end, a preset commodity and rule relation example table (PD_ GOODSRULE _ DICT), a constraint rule example table (PD_ GOODSRULEDETAIL _ DICT), a core constraint CONDITION example table (PD_condition_ DICT) and a parameter example table (PD_ CONDITIONPARAMS _ DICT) are sequentially queried according to the configuration flow.
The limiting rule instance table is used for recording information such as condition details, prompt information, grouping and the like corresponding to the rules, the core limiting condition instance table is used for recording information such as condition content, data sources and the like, and the parameter instance table is used for recording information such as types and value taking modes of parameters and the like.
And secondly, implementing execution and result output of the corresponding configuration rule content through a unified back-end rule checking interface.
And then, the limit conditions and parameters of the tariffs and marketing activities in the existing system are combined, basic core limit conditions are abstracted, and the basic core limit conditions are configured into a newly added core limit condition table and a newly added parameter table.
The core limiting conditions comprise cost and brand limiting, marketing activity relation, online time limiting, family cheering limiting class, target user group limiting, broadband class limiting and the like.
Specifically, the commodity and rule relationship instance table, the constraint rule instance table, the core constraint condition instance table and the parameter instance table are shown in the following tables, respectively.
Table 1 commodity and rule relationship example table
Table 2 restriction rule instance table
Table 3 core constraint instance table
Table 4 parameter example table
In the foregoing embodiment, preferably, the service data unified configuration and verification method further includes: if the corresponding configuration rule code is not queried when the corresponding configuration rule code is queried through the preset commodity and rule relation example table, stopping the rule parameter configuration of the business commodity.
In the foregoing embodiment, preferably, the service data unified configuration and verification method further includes: if the corresponding rule is not queried when the corresponding rule of the configuration rule code is queried through the preset limit rule instance table, sending error reporting information of configuration data deletion.
In the above embodiment, preferably, the constraint conditions corresponding to the query rule according to the preset core constraint condition instance table specifically include three query implementation manners of SQL statements, JAVA rule components and stored procedures; in the SQL statement mode, the SQL statement in the rule factor value field in the core constraint condition example table is analyzed through the SQL statement, and in the JAVA rule component mode, the entity in the rule factor value field is called by utilizing the JAVA statement.
In the above embodiment, preferably, when a specific parameter of a constraint condition is queried according to a preset parameter instance table, if the specific parameter is queried, configuring the queried parameter as a rule parameter of a service commodity according to a corresponding sequence and a parameter type in a parameter template, and checking through configuration; if the specific parameters are not inquired, stopping the rule parameter configuration of the business commodity or sending error reporting information with unmatched parameter types according to the returned value judgment result of the inquiring implementation mode.
In the above embodiment, it is preferable that the query implementation to be employed is determined as an SQL statement, JAVA rule component, or stored procedure according to the rule factor type field value of the core constraint instance table.
In the above embodiment, preferably, the service commodity to be configured is determined according to the service commodity and the corresponding parameter value input by the front-end configuration module.
As shown in fig. 2, the present invention further provides a service data unified configuration and verification system, and the service data unified configuration and verification method applied to any one of the above embodiments includes: the configuration rule code inquiring module 11 is used for inquiring through a preset commodity and rule relation example table according to the business commodity to be configured to obtain a corresponding configuration rule code; the rule query module 12 is configured to query a preset constraint rule instance table to obtain a rule corresponding to the configuration rule code; the constraint condition query module 13 is configured to query a constraint condition corresponding to a rule according to a preset core constraint condition instance table; the parameter query module 14 is configured to query specific parameters of the obtained constraint conditions according to a preset parameter instance table; and the parameter configuration module 15 is used for replacing the rule parameters of the business commodity according to the specific parameters.
In the above embodiment, preferably, if the configuration rule code query module 11 does not query the corresponding configuration rule code when querying the corresponding configuration rule code through the preset commodity and rule relation example table, the rule parameter configuration of the service commodity is stopped, and if the rule query module 12 does not query the corresponding rule when querying the corresponding rule of the configuration rule code through the preset constraint rule example table, the error reporting information of the configuration data missing is sent.
In the above embodiment, preferably, the service data unified configuration and verification system further includes a front-end configuration module 16, and determines the service commodity to be configured according to the service commodity and the corresponding parameter value input by the front-end configuration module 16.
The above is only a preferred embodiment of the present invention, and is not intended to limit the present invention, but various modifications and variations can be made to the present invention by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims (9)

1. The unified configuration and verification method for the service data is characterized by comprising the following steps:
Inquiring a preset commodity and rule relation example table according to the business commodity to be configured to obtain a corresponding configuration rule code;
inquiring according to a preset limiting rule instance table to obtain a rule corresponding to the configuration rule code;
Inquiring a limiting condition corresponding to the rule according to a preset core limiting condition instance table;
Inquiring specific parameters of the limiting conditions according to a preset parameter instance table, if the specific parameters are inquired, configuring the inquired parameters into rule parameters of the business commodity according to the corresponding sequence and the parameter types in a parameter template, and checking through configuration; if the specific parameters are not inquired, stopping the rule parameter configuration of the business commodity or sending error reporting information with unmatched parameter types according to the returned value judgment result of the inquiring implementation mode;
and replacing the rule parameters of the business commodity according to the specific parameters.
2. The method for unified configuration and verification of service data according to claim 1, further comprising:
if the corresponding configuration rule code is not queried when the corresponding configuration rule code is queried through the preset commodity and rule relation example table, stopping the rule parameter configuration of the business commodity.
3. The method for unified configuration and verification of service data according to claim 1, further comprising:
And if the corresponding rule is not queried when the rule corresponding to the configuration rule code is queried through a preset limit rule instance table, sending error reporting information of configuration data deletion.
4. The unified configuration and verification method of service data according to claim 1, wherein the query of the constraint condition corresponding to the rule according to the preset core constraint condition instance table specifically includes three query implementation modes of SQL statement, JAVA rule component and storage process;
in the SQL statement mode, the SQL statement in the rule factor value field in the core constraint condition example table is analyzed through the SQL statement, and in the JAVA rule assembly mode, the entity in the rule factor value field is called by utilizing the JAVA statement.
5. The unified configuration and verification method of business data according to claim 4, wherein the query implementation to be adopted is determined to be an SQL statement, a JAVA rule component or a stored procedure according to the rule factor type field value of the core constraint instance table.
6. The method for uniformly configuring and verifying service data according to claim 1, wherein the service commodity to be configured is determined according to the service commodity and the corresponding parameter value input by the front-end configuration module.
7. A service data unified configuration and verification system, applying the service data unified configuration and verification method according to any one of claims 1 to 6, characterized by comprising:
the configuration rule code inquiring module is used for inquiring the corresponding configuration rule code through a preset commodity and rule relation example table according to the business commodity to be configured;
The rule query module is used for querying and obtaining rules corresponding to the configuration rule codes according to a preset limit rule instance table;
The constraint condition query module is used for querying the constraint condition corresponding to the rule according to a preset core constraint condition instance table;
The parameter query module is used for querying and obtaining specific parameters of the limiting conditions according to a preset parameter instance table;
and the parameter configuration module is used for replacing the rule parameters of the business commodity according to the specific parameters.
8. The unified business data configuration and verification system according to claim 7, wherein if the configuration rule code query module does not query the corresponding configuration rule code when querying the corresponding configuration rule code through the preset commodity and rule relation example table, stopping the rule parameter configuration of the business commodity, and if the rule query module does not query the corresponding rule when querying the corresponding rule of the configuration rule code through the preset constraint rule example table, sending error reporting information of configuration data deletion.
9. The unified service data configuration and verification system according to claim 7, further comprising a front-end configuration module, wherein the service commodity to be configured is determined according to the service commodity and the corresponding parameter value input by the front-end configuration module.
CN202010801672.8A 2020-08-11 2020-08-11 Unified configuration and verification method and system for service data Active CN112102028B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010801672.8A CN112102028B (en) 2020-08-11 2020-08-11 Unified configuration and verification method and system for service data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010801672.8A CN112102028B (en) 2020-08-11 2020-08-11 Unified configuration and verification method and system for service data

Publications (2)

Publication Number Publication Date
CN112102028A CN112102028A (en) 2020-12-18
CN112102028B true CN112102028B (en) 2024-04-23

Family

ID=73753455

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010801672.8A Active CN112102028B (en) 2020-08-11 2020-08-11 Unified configuration and verification method and system for service data

Country Status (1)

Country Link
CN (1) CN112102028B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115797021A (en) * 2023-02-07 2023-03-14 卓望数码技术(深圳)有限公司 Commodity template configuration system and method based on components

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1773992A (en) * 2004-11-12 2006-05-17 阿尔卡特公司 Communication traffic control rule generation methods and systems
CN101719237A (en) * 2009-12-09 2010-06-02 南京联创科技集团股份有限公司 Data quality monitoring method based on full service indicator rule allocation
CN103544074A (en) * 2012-07-09 2014-01-29 阿里巴巴集团控股有限公司 Method and device for verifying service
CN105913316A (en) * 2016-04-15 2016-08-31 中国银行股份有限公司 Rule configuration method and apparatus
CN106651572A (en) * 2016-12-29 2017-05-10 中国建设银行股份有限公司 Business rule assembly method and apparatus
CN107133233A (en) * 2016-02-29 2017-09-05 阿里巴巴集团控股有限公司 A kind of processing method and processing device of configuration data inquiry
CN109033206A (en) * 2018-06-29 2018-12-18 北京奇虎科技有限公司 A kind of rule matching method, Cloud Server and rule match system
CN110362531A (en) * 2019-06-17 2019-10-22 众安在线财产保险股份有限公司 A kind of automatic archiving method and device

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1773992A (en) * 2004-11-12 2006-05-17 阿尔卡特公司 Communication traffic control rule generation methods and systems
CN101719237A (en) * 2009-12-09 2010-06-02 南京联创科技集团股份有限公司 Data quality monitoring method based on full service indicator rule allocation
CN103544074A (en) * 2012-07-09 2014-01-29 阿里巴巴集团控股有限公司 Method and device for verifying service
CN107133233A (en) * 2016-02-29 2017-09-05 阿里巴巴集团控股有限公司 A kind of processing method and processing device of configuration data inquiry
CN105913316A (en) * 2016-04-15 2016-08-31 中国银行股份有限公司 Rule configuration method and apparatus
CN106651572A (en) * 2016-12-29 2017-05-10 中国建设银行股份有限公司 Business rule assembly method and apparatus
CN109033206A (en) * 2018-06-29 2018-12-18 北京奇虎科技有限公司 A kind of rule matching method, Cloud Server and rule match system
CN110362531A (en) * 2019-06-17 2019-10-22 众安在线财产保险股份有限公司 A kind of automatic archiving method and device

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
工作流门户中业务过程数据的配置;杨萍等;《信息技术》(第8期);27-31 *

Also Published As

Publication number Publication date
CN112102028A (en) 2020-12-18

Similar Documents

Publication Publication Date Title
CN102073640B (en) Method, system and server for testing structured query language (SQL) statements
CN102117306B (en) Method and system for monitoring ETL (extract-transform-load) data processing process
US20140100910A1 (en) System and Method for Audits with Automated Data Analysis
CN102236672A (en) Method and device for importing data
CN109299074B (en) Data verification method and system based on templated database view
CN112102028B (en) Unified configuration and verification method and system for service data
CN116719799A (en) Environment-friendly data management method, device, computer equipment and storage medium
CN110781235A (en) Big data based purchase data processing method and device, terminal and storage medium
CN111190814A (en) Software test case generation method and device, storage medium and terminal
CN112347120B (en) Automatic optimization method and device based on complex SQL
CN112884175A (en) Configuration baseline checking method based on custom rule
CN112416904A (en) Electric power data standardization processing method and device
CN114356454B (en) Reconciliation data processing method, device, storage medium and program product
CN112395343B (en) DSG-based field change data acquisition and extraction method
CN113220726A (en) Data quality detection method and system
CN114416852A (en) Data processing method, device, equipment and medium
CN113065935A (en) Data processing method, device, equipment and storage medium
CN115063217B (en) Budget management method, device, equipment and medium
KR102503717B1 (en) Managing system for recycling engine of vehicle and methd for operating the same
CN101883004A (en) Method, device and system for synthesizing service data
CN113283557B (en) Information verification method, device, electronic equipment and storage medium
CN112364058B (en) Auditing method and device for commodity price configuration
CN110349068B (en) Public service system
CN114331654A (en) Hive-based page configuration reconciliation system and method
CN115619512A (en) Account checking processing method, account checking processing device, computer readable medium and computer program product

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
GR01 Patent grant
GR01 Patent grant