CN106227784A - A kind of self-service peek system based on complete self-defined SQL scene - Google Patents
A kind of self-service peek system based on complete self-defined SQL scene Download PDFInfo
- Publication number
- CN106227784A CN106227784A CN201610567677.2A CN201610567677A CN106227784A CN 106227784 A CN106227784 A CN 106227784A CN 201610567677 A CN201610567677 A CN 201610567677A CN 106227784 A CN106227784 A CN 106227784A
- Authority
- CN
- China
- Prior art keywords
- configuration
- script
- access
- scene
- list
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000013515 script Methods 0.000 claims abstract description 63
- 230000000737 periodic effect Effects 0.000 claims abstract description 32
- 238000000034 method Methods 0.000 claims abstract description 17
- 238000012795 verification Methods 0.000 claims abstract description 10
- 238000012216 screening Methods 0.000 claims description 8
- 230000000007 visual effect Effects 0.000 claims description 4
- 230000005540 biological transmission Effects 0.000 claims description 2
- 238000011161 development Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 239000002699 waste material Substances 0.000 description 2
- 230000007547 defect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Mathematical Physics (AREA)
- Entrepreneurship & Innovation (AREA)
- Computational Linguistics (AREA)
- Economics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Computer Security & Cryptography (AREA)
- Marketing (AREA)
Abstract
The present invention relates to the application in carrier data fairground, particularly relate to flexibly customizing scene and the method and system of peek the most automatically.Open a kind of the parsing by self-defined scene configuration offer business scenario of the present invention is represented and periodicity automatic scheduling method, including: marketing scene is newly-increased and script configures；Script resolves and rule verification；Essential condition, optional condition configure；Output field configures；Periodic task configures；Peek inventory management.According to technical scheme, it is possible to resolve the problem that business department carries out the most personalized peek and the two kinds of conflicting requirements being repeated cyclically peek simultaneously.
Description
Technical Field
The invention relates to the application field of operator business/application marketing recommendation, in particular to a self-service access method and a self-service access system for a user-defined SQL scene.
Background
In the data fetching process of an IT support business department, operators often meet the data fetching requirements which are more and more different, and have periodic data fetching requirements according to days and months, and the conventional manual data fetching by IT personnel does not meet the intensive requirements in timeliness and reusability, so that unnecessary resource waste is caused, and the risk that the customer requirements cannot be responded in time exists;
in the prior art, because the IT platform access function is limited, the following defects exist in the self-service access process:
the access platform often provides a self-service access function by developing a page query mode, and the development period is long;
after the access page is ready, the modification difficulty is high, and the addition and deletion of configuration conditions require secondary development of developers;
the same page can only realize a self-service fetching requirement, and the waste of one-time fetching is large;
the periodic fetching is often specified by developers during development and cannot be modified in time according to business requirements;
in a word, the existing access function is single, service personnel are difficult to participate in the rule configuration process, and the reusability is not high.
Disclosure of Invention
In view of the above, the main objective of the present invention is to provide a self-service access system based on a completely customized SQL scene, which can support customized SQL configuration, and access personnel can flexibly configure the screening conditions and access cycles;
in order to achieve the purpose, the technical scheme of the invention is realized as follows:
the invention provides a self-service access system based on a completely self-defined SQL scene, which comprises the following components: newly adding a marketing scene, configuring scripts, analyzing the scripts, checking rules, configuring required conditions/optional conditions, configuring output fields, configuring periodic tasks and managing access lists; wherein,
marketing scene newly-added and script configuration is used for configuring marketing scene information and scripts, providing scene adding, deleting, modifying and checking functions, providing scene template examples and custom script configuration;
the script analysis and rule verification is used for configuring automatic script analysis and script grammar verification and providing necessary grammar error prompt;
the method comprises the steps of configuring required conditions/optional conditions, after a scene script is analyzed into popular and easily understood rule options, providing functions of configuring the required conditions and the optional conditions of the scene, and configuring the analyzed rule options into the required/optional options;
the output field configuration is used for configuring the access content, configuring export list content after configuring necessary screening conditions, analyzing the export list content into a graphical check option according to a scene, selecting the output content, and providing a configuration option to configure the output content code into a corresponding Chinese interpretation function;
the method comprises the steps of configuring periodic tasks, wherein after scene configuration is completed, a background is required to be submitted to execute and generate an access list, two modes of immediate generation and offline periodic generation are provided, and the periodic tasks can automatically generate the list periodically according to days, weeks and months;
the access list management is used for providing a list downloading function after data generation, generating a corresponding access example according to access configuration, providing a list downloading button, and downloading the periodic tasks in the same access example according to the generation time;
in the system, the marketing scenario newly-added and script configuration is as follows:
newly adding an SQL scene, configuring SQL script information, supporting a custom SQL grammar and providing script template reference;
the custom SQL script supports the transmission of dynamic date parameters, can dynamically acquire the date parameters according to the day and the month, and supports the periodic automatic data acquisition;
in the above system, the script analysis and rule verification are as follows:
after the SQL script configuration is completed, SQL rule analysis is carried out, and information such as basic SQL scripts, rule description information, dynamic parameters, rule data types and the like is identified;
the parsed script needs to be subjected to grammar rule verification, error prompt is carried out on script configuration with grammar errors, and a user is reminded to modify the script configuration in time;
in the above system, the optional condition is configured to:
after the user-defined SQL script is configured and analyzed into visual configuration options, configuration of a necessary/optional condition is required, the necessary condition is used for forcibly requiring the options configured by a fetching person and is suitable for configuration options such as permission types, standard requirement types and the like; the selectable condition is applicable to general configuration options, and the options which are not mandatory to the configuration condition can be configured into the selectable condition;
in the above system, the output field is configured to:
after the configuration of the screening condition is finished, self-service access output content configuration is carried out, SQL script configuration is analyzed into graphical options, output field options are added for configuration, and meanwhile, coding interpretation configuration is supported for coding field options, so that data taken out by service personnel can be understood more easily;
in the above system, the periodic task is configured to:
providing two modes of immediate generation of a self-service access list and periodic generation of a background, wherein an immediately generated task immediately runs to generate list information after the access instance configuration is completed, a periodic task is submitted and then stored in a task queue, and the periodic task automatically runs to generate the self-service access list after a specified period of time;
in the above system, the access list management is:
after the task is finished, the access personnel enters an access list management page to download a self-service access list and provide a CSV format for export;
the list is distinguished according to the name of the access example, and the periodic access task is downloaded in the same access example according to the generation time.
Drawings
FIG. 1 is a schematic structural diagram of a self-service data fetching system based on a completely customized SQL scene according to the present invention;
FIG. 2 is a flow diagram of a self-service access system based on a completely customized SQL scenario.
Detailed Description
The basic idea of the invention is: the IT personnel newly build a self-service access scene, configure SQL script information according to self-service access requirements, and integrate with a plurality of current access requirements to realize that a single scene supports a plurality of access requirements; after the SQL script information configuration is completed, the system checks syntax rules, carries out error prompt on syntax error configuration, and submits the syntax error configuration after IT personnel modify; after the successful submission, the system analyzes the rules and displays the rules into visual graphic options, IT personnel configure the necessary conditions according to the management and control requirements, and configure the optional conditions according to the service requirements, so as to provide the information of configuration and screening conditions for the service personnel; after the configuration of the necessary/optional conditions is finished, configuring output field information, and configuring the output field information by combining with a specific access requirement to finish scene information configuration; service personnel create an access instance based on a self-service access scene, configure a necessary/optional condition, check out an output field required by the access, configure access task information, and support one-time immediate access and background periodic access configuration; after the operation of the access task is finished, a self-service access list is generated, and service personnel can download the list on a list management page;
the present invention will be further described in detail with reference to the following specific examples;
the invention provides a self-service access system based on a completely self-defined SQL scene, which is used for supporting the self-service access requirement of a business department, and comprises the following components: newly adding a marketing scene, configuring scripts, analyzing the scripts, checking rules, configuring required conditions/optional conditions, configuring output fields, configuring periodic tasks and managing access lists; wherein,
marketing scene newly-added and script configuration is used for configuring marketing scene information and scripts, providing scene adding, deleting, modifying and checking functions, providing scene template examples and custom script configuration;
the script analysis and rule verification is used for configuring automatic script analysis and script grammar verification and providing necessary grammar error prompt;
the method comprises the steps of configuring required conditions/optional conditions, after a scene script is analyzed into popular and easily understood rule options, providing functions of configuring the required conditions and the optional conditions of the scene, and configuring the analyzed rule options into the required/optional options;
the output field configuration is used for configuring the access content, configuring export list content after configuring necessary screening conditions, analyzing the export list content into a graphical check option according to a scene, selecting the output content, and providing a configuration option to configure the output content code into a corresponding Chinese interpretation function;
the method comprises the steps of configuring periodic tasks, wherein after scene configuration is completed, a background is required to be submitted to execute and generate an access list, two modes of immediate generation and offline periodic generation are provided, and the periodic tasks can automatically generate the list periodically according to days, weeks and months;
the access list management is used for providing a list downloading function after data generation, generating a corresponding access example according to access configuration, providing a list downloading button, and downloading the periodic tasks in the same access example according to the generation time;
the marketing scene adding and script configuration process comprises the following steps: newly building a marketing scene, configuring SQL script information, and supporting SQL template configuration and user-defined SQL script configuration;
the script analysis and rule verification process comprises the following steps: after the SQL script is configured, analyzing the script content to generate information such as access field description, data type and the like, checking the grammar rule of the SQL script, and prompting grammar errors;
the configuration process of the necessary condition/optional condition is as follows: after the SQL configuration information is submitted, the system carries out rule analysis, the obscure SQL script information is analyzed into a visual configuration rule display, and IT personnel add scene optional condition options and optional condition options according to the management and control requirements;
the configuration process of the output field comprises the following steps: after the configuration of the necessary condition/optional condition is completed, IT personnel need to add output field information according to the service requirement, configure the output content which can be selected by the service personnel, and save the completed scene configuration;
the periodic task configuration process comprises the following steps: the service personnel creates an access example based on a self-service access scene, selects the necessary/optional conditions for access screening and the output field required by the requirement, and configures a one-time generation list or a self-service access list periodically generated every day, every week and every month according to the access frequency;
the access list management process comprises the following steps: after the service personnel receive the short message prompt of the completion of the access list, the login system checks the information of the number of access records and the like, and exports the list;
the above description is only exemplary of the present invention and should not be taken as limiting the scope of the present invention, and any modifications, equivalents, improvements, etc. that are within the spirit and principle of the present invention should be included in the present invention.
Claims (7)
1. A self-service access system based on completely self-defined SQL scene is characterized in that the system comprises: newly adding a marketing scene, configuring scripts, analyzing the scripts, checking rules, configuring necessary conditions/optional conditions, configuring output fields, configuring periodic tasks and managing access lists, wherein:
marketing scene is newly added and script configuration is carried out: the system is used for configuring marketing scene information and scripts, providing functions of adding, deleting, modifying and checking scenes, providing scene template examples and custom script configuration;
script analysis and rule verification: the system is used for automatically analyzing the configuration script and checking the grammar of the script, and providing necessary grammar error prompt;
mandatory/optional configuration of conditions: after the scene script is analyzed into popular and easily understood rule options, the functions of configuring the necessary scene conditions and the optional conditions are provided, and the analyzed rule options are configured into the necessary/optional options;
and (3) output field configuration: the system is used for configuring access content, configuring export list content after configuring necessary screening conditions, analyzing the export list content into graphical hook options according to scenes, selecting output content, and providing configuration options to configure output content codes into corresponding Chinese interpretation functions;
and (3) periodic task configuration: after the scene configuration is finished, a background is required to be submitted to execute and generate an access list, two modes of immediate generation and offline periodic generation are provided, and periodic tasks can automatically generate the list periodically according to days, weeks and months;
and (3) management of a data acquisition list: the method is used for providing a list downloading function after data generation, generating a corresponding access example according to access configuration, providing a list downloading button, and downloading the periodic tasks in the same access example according to the generation time.
2. The system of claim 1, wherein the marketing scenario add-on script is configured to:
newly adding an SQL scene, configuring SQL script information, supporting a custom SQL grammar and providing script template reference;
the custom SQL script supports the transmission of dynamic date parameters, can dynamically acquire the date parameters according to the day and the month, and supports the periodic automatic data acquisition.
3. The system of claim 1, wherein the script parsing and rule checking is:
after the SQL script configuration is completed, SQL rule analysis is carried out, and information such as basic SQL scripts, rule description information, dynamic parameters, rule data types and the like is identified;
the parsed script needs to be subjected to grammar rule verification, error prompt is carried out on script configuration with grammar errors, and a user is reminded to modify the script in time.
4. The system of claim 1, wherein the mandatory/optional conditions are configured to:
after the user-defined SQL script is configured and analyzed into visual configuration options, configuration of a necessary/optional condition is required, the necessary condition is used for forcibly requiring the options configured by a fetching person and is suitable for configuration options such as permission types, standard requirement types and the like; the selectable condition is applicable to general configuration options, and an option having no mandatory requirement for the configuration condition may be configured as a selectable condition.
5. The system of claim 1, wherein the output field is configured to:
and after the configuration of the screening condition is finished, self-service access output content configuration is carried out, the SQL script configuration is analyzed into a graphical option, an output field option is added for configuration, and meanwhile, the coding field option supports coding interpretation configuration, so that data taken out by service personnel can be understood more easily.
6. The system of claim 1, wherein the periodic task is configured to:
and providing two modes of immediate generation and background periodic generation of the self-service access list, wherein the immediately generated task immediately runs to generate list information after the access instance configuration is completed, the periodic task is submitted and then stored in a task queue, and the periodic task automatically runs to generate the self-service access list after the specified period time.
7. The system of claim 1, wherein the access list is managed as:
after the task is finished, the access personnel enters an access list management page to download a self-service access list and provide a CSV format for export; the list is distinguished according to the name of the access example, and the periodic access task is downloaded in the same access example according to the generation time.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610567677.2A CN106227784A (en) | 2016-07-19 | 2016-07-19 | A kind of self-service peek system based on complete self-defined SQL scene |
| CN201710591739.8A CN107357587A (en) | 2016-07-19 | 2017-07-19 | A kind of self-service access system and method based on complete self-defined SQL scenes |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610567677.2A CN106227784A (en) | 2016-07-19 | 2016-07-19 | A kind of self-service peek system based on complete self-defined SQL scene |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106227784A true CN106227784A (en) | 2016-12-14 |
Family
ID=57531732
Family Applications (2)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610567677.2A Pending CN106227784A (en) | 2016-07-19 | 2016-07-19 | A kind of self-service peek system based on complete self-defined SQL scene |
| CN201710591739.8A Pending CN107357587A (en) | 2016-07-19 | 2017-07-19 | A kind of self-service access system and method based on complete self-defined SQL scenes |
Family Applications After (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710591739.8A Pending CN107357587A (en) | 2016-07-19 | 2017-07-19 | A kind of self-service access system and method based on complete self-defined SQL scenes |
Country Status (1)
| Country | Link |
|---|---|
| CN (2) | CN106227784A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107357587A (en) * | 2016-07-19 | 2017-11-17 | 南京坦道信息科技有限公司 | A kind of self-service access system and method based on complete self-defined SQL scenes |
| CN109376161A (en) * | 2018-08-22 | 2019-02-22 | 中国平安人寿保险股份有限公司 | Label data update method, device, medium and electronic equipment based on big data |
| CN110502508A (en) * | 2019-08-23 | 2019-11-26 | 行吟信息科技（上海）有限公司 | A kind of method of calibration and system based on dynamic state of parameters |
| CN111552702A (en) * | 2020-05-08 | 2020-08-18 | 北京思特奇信息技术股份有限公司 | Method and device for automatically configuring business rules, electronic equipment and storage medium |
| CN114025027A (en) * | 2021-11-02 | 2022-02-08 | 浙江三维万易联科技有限公司 | Data transmission script running method and device, storage medium and electronic device |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117193722A (en) * | 2021-01-28 | 2023-12-08 | 广州衣科明夷信息技术有限公司 | Hierarchical serial marketing center system based on MQ distributed transaction |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104216888B (en) * | 2013-05-30 | 2017-10-17 | 中国电信股份有限公司 | Data processing task relation method to set up and system |
| US9710262B2 (en) * | 2015-11-23 | 2017-07-18 | Sap Se | User-configurable database artifacts |
| CN105511891A (en) * | 2016-02-26 | 2016-04-20 | 广州品唯软件有限公司 | Self-service access platform front-end frame establishing method and self-service access platform front-end frame establishing device |
| CN106227784A (en) * | 2016-07-19 | 2016-12-14 | 南京坦道信息科技有限公司 | A kind of self-service peek system based on complete self-defined SQL scene |
| CN106776834A (en) * | 2016-11-28 | 2017-05-31 | 中通服公众信息产业股份有限公司 | A kind of data analysis based on index is from access method and system |
-
2016
- 2016-07-19 CN CN201610567677.2A patent/CN106227784A/en active Pending
-
2017
- 2017-07-19 CN CN201710591739.8A patent/CN107357587A/en active Pending
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107357587A (en) * | 2016-07-19 | 2017-11-17 | 南京坦道信息科技有限公司 | A kind of self-service access system and method based on complete self-defined SQL scenes |
| CN109376161A (en) * | 2018-08-22 | 2019-02-22 | 中国平安人寿保险股份有限公司 | Label data update method, device, medium and electronic equipment based on big data |
| CN109376161B (en) * | 2018-08-22 | 2023-07-18 | 中国平安人寿保险股份有限公司 | Tag data updating method and device based on big data, medium and electronic equipment |
| CN110502508A (en) * | 2019-08-23 | 2019-11-26 | 行吟信息科技（上海）有限公司 | A kind of method of calibration and system based on dynamic state of parameters |
| CN111552702A (en) * | 2020-05-08 | 2020-08-18 | 北京思特奇信息技术股份有限公司 | Method and device for automatically configuring business rules, electronic equipment and storage medium |
| CN114025027A (en) * | 2021-11-02 | 2022-02-08 | 浙江三维万易联科技有限公司 | Data transmission script running method and device, storage medium and electronic device |
| CN114025027B (en) * | 2021-11-02 | 2023-10-03 | 三维通信股份有限公司 | Method and device for running data transmission script, storage medium and electronic device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107357587A (en) | 2017-11-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106227784A (en) | A kind of self-service peek system based on complete self-defined SQL scene | |
| US11087249B2 (en) | Method and apparatus for triggering execution of a workflow over a network | |
| US11321669B2 (en) | Creating a customized email that includes an action link generated based on form data | |
| US10402308B2 (en) | Sandboxing for custom logic | |
| US11714689B2 (en) | System and method for managing user interaction flows within third party applications | |
| CN108804089B (en) | Application service capability plug-in method and system of assembly module | |
| CN106462409B (en) | Method and system for customized ready-to-componentized application definition | |
| Gürcan et al. | Using Microsoft PowerApps, Mendix and OutSystems in two development scenarios: an experience report | |
| CN113987541A (en) | Data access control method and device and electronic equipment | |
| EP2702485A1 (en) | Web-based app builder for mobile devices with automatic updates | |
| US10929279B2 (en) | Systems and method for automated testing framework for service portal catalog | |
| CN115268861B (en) | Introduction method, system, equipment and storage medium of custom component | |
| CN114564194A (en) | Form self-defining development method and system based on VUE framework | |
| KR101950397B1 (en) | Method for providing business management system by sharing business information between users | |
| CN110096304A (en) | Task construction method, device, equipment and storage medium based on Jenkins | |
| CN113032004B (en) | Method, apparatus and program product for managing development jobs in a development environment | |
| US11893383B2 (en) | Configuration properties management for software | |
| CN116233077A (en) | Data processing method and device | |
| US11789712B2 (en) | Data configuration deployment framework | |
| Gaylord et al. | Professional Asp. net 4.5 in C# and VB | |
| Bangera | DevOps for Serverless Applications: Design, deploy, and monitor your serverless applications using DevOps practices | |
| Biehl | GraphQL API Design | |
| CN110019136A (en) | Report generating system and report form generation method | |
| US11132374B2 (en) | Property painter | |
| KR20150108151A (en) | System and method for developing application |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20161214 |
|
| WD01 | Invention patent application deemed withdrawn after publication |