CN117390030B - Multidimensional parameter mapping configuration method and device and electronic equipment - Google Patents
Multidimensional parameter mapping configuration method and device and electronic equipment Download PDFInfo
- Publication number
- CN117390030B CN117390030B CN202311698519.7A CN202311698519A CN117390030B CN 117390030 B CN117390030 B CN 117390030B CN 202311698519 A CN202311698519 A CN 202311698519A CN 117390030 B CN117390030 B CN 117390030B
- Authority
- CN
- China
- Prior art keywords
- parameter
- apikey
- sub
- multidimensional
- dimensional
- 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
Links
- 238000013507 mapping Methods 0.000 title claims abstract description 60
- 238000000034 method Methods 0.000 title claims abstract description 53
- 238000004590 computer program Methods 0.000 claims description 11
- 238000007619 statistical method Methods 0.000 claims description 8
- 230000008569 process Effects 0.000 claims description 7
- 238000012216 screening Methods 0.000 claims description 5
- 238000012545 processing Methods 0.000 abstract description 2
- BQCADISMDOOEFD-UHFFFAOYSA-N Silver Chemical compound [Ag] BQCADISMDOOEFD-UHFFFAOYSA-N 0.000 description 9
- 229910052709 silver Inorganic materials 0.000 description 9
- 239000004332 silver Substances 0.000 description 9
- 238000006243 chemical reaction Methods 0.000 description 8
- 238000013461 design Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 7
- 238000004891 communication Methods 0.000 description 6
- 238000013499 data model Methods 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000009466 transformation Effects 0.000 description 2
- 230000007547 defect Effects 0.000 description 1
- 238000002716 delivery method Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000002955 isolation Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000000844 transformation Methods 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/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/907—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Library & Information Science (AREA)
- Stored Programmes (AREA)
Abstract
The disclosure provides a multidimensional parameter mapping configuration method, a multidimensional parameter mapping configuration device and electronic equipment, which are applied to the technical field of data processing, wherein the method comprises the following steps: setting multidimensional parameters and corresponding multidimensional parameter options in a main object to form a main object-multidimensional parameter relation table and a main object-multidimensional parameter option relation table; acquiring a configuration relation between the multidimensional parameter and the apikey, and generating a multidimensional parameter-apikey configuration relation table; generating a plurality of sub-objects from the main object; determining an apikey of the attribute of the child object; based on the apikey of the attribute of the sub-object, obtaining a multidimensional parameter corresponding to the apikey of the attribute of the sub-object; and writing the multidimensional parameter corresponding to the apikey of the attribute of the sub-object into the sub-object. The invention establishes the mapping relation between the main object and the sub object through the multidimensional parameter, realizes the dynamic storage and accurate inquiry of the sub object and realizes the dynamic mapping storage of the multidimensional parameter.
Description
Technical Field
The disclosure relates to the technical field of data processing, and in particular relates to a multidimensional parameter mapping configuration method, a multidimensional parameter mapping configuration device and electronic equipment.
Background
In a multi-tenant system in a Software-as-a-Service (SAAS) mode, a system Service provider may provide a multi-dimensional parameter design in the system, but how to reflect dynamic multi-dimensional parameters on sub-objects and dynamically expand to support the searching, BI, etc. scenarios of enterprise-level clients becomes a difficult problem when N sub-object association data are generated after the multi-dimensional parameters are applied to the main object.
At present, the multi-dimensional parameter design under the SaaS mode is mostly realized from multi-dimensional design of a main object to multi-dimensional parameter storage of a sub-object through Json storage, and the sub-object tracks related information of the multi-dimensional parameter by checking a Json structure. However, due to the limitation of the storage length of the Json structure, when the multi-dimensional parameters are many, the storage is also gradually limited; when the downstream object selects a child object, the Json structure multidimensional parameter is inconvenient to search; when the sub-objects are subjected to statistical analysis, the Json structure classification statistics is inconvenient.
Therefore, dynamic storage and accurate query based on the SaaS mode are currently urgent problems to be solved.
Disclosure of Invention
The disclosure provides a multi-dimensional parameter mapping configuration method, a multi-dimensional parameter mapping configuration device and electronic equipment, which are used for solving the defects of poor multi-dimensional parameter storage expansibility and inconvenient searching and statistics in the prior art and realizing dynamic storage and accurate query of multi-dimensional parameters.
The invention provides a multidimensional parameter mapping configuration method, which comprises the following steps:
setting a multi-dimensional parameter and a corresponding multi-dimensional parameter option in a main object to form a main object-multi-dimensional parameter relation table and a main object-multi-dimensional parameter option relation table, wherein the multi-dimensional parameter is a dynamic parameter;
acquiring the configuration relation between the multidimensional parameter and the apikey, and generating a multidimensional parameter-apikey configuration relation table;
generating a plurality of sub-objects by the main object according to actual task requirements;
determining an apikey of the attribute of the child object;
searching the multi-dimensional parameter-apikey configuration relation table based on the apikey of the attribute of the sub-object to obtain the multi-dimensional parameter corresponding to the apikey of the attribute of the sub-object;
and writing the multidimensional parameters corresponding to the apikey of the attribute of the sub-object and the multidimensional parameter options corresponding to the apikey into the sub-object.
According to the multi-dimensional parameter mapping configuration method provided by the invention, the multi-dimensional parameters and corresponding multi-dimensional parameter options are set in the main object to form a main object-multi-dimensional parameter relation table and a main object-multi-dimensional parameter option relation table, which concretely comprises the following steps:
selecting corresponding multidimensional parameters according to the type of the main object, and filling the main object and the corresponding multidimensional parameters into a main object-multidimensional parameter relation table;
selecting multidimensional parameter options according to the content of the main object, and filling the content of the main object and the corresponding multidimensional parameter options into a main object-multidimensional parameter option relation table;
the multidimensional parameter is set as a dynamic parameter.
According to the method for mapping and configuring the multidimensional parameter provided by the invention, the configuration relation between the multidimensional parameter and the apikey is obtained, and a multidimensional parameter-apikey configuration relation table is generated, which comprises the following steps:
searching a multidimensional parameter corresponding to the apikey in the main object-multidimensional parameter relation table according to a preset rule to obtain a configuration relation between the apikey and the multidimensional parameter;
and storing the configuration relation in a data table to form a multidimensional parameter-apikey configuration relation table.
According to the multidimensional parameter mapping configuration method provided by the invention, the determining the apikey of the attribute of the sub-object comprises the following steps:
acquiring attribute metadata of the sub-object;
and obtaining the apikey corresponding to the attribute of the sub-object based on the attribute metadata.
According to the multi-dimensional parameter mapping configuration method provided by the invention, the writing of the multi-dimensional parameters corresponding to the apikey of the attribute of the sub-object and the corresponding multi-dimensional parameter options into the sub-object comprises the following steps:
according to the main object-multidimensional parameter relation selected by the user, combining the multidimensional parameter corresponding to the apikey of the attribute of the sub object and the multidimensional parameter option corresponding to the apikey to obtain combined set data;
and writing the combined set data into the sub-object.
According to the multi-dimensional parameter mapping configuration method provided by the invention, after the multi-dimensional parameters corresponding to the apikey of the attribute of the sub-object and the corresponding multi-dimensional parameter options are written into the sub-object, the method further comprises the searching process of the sub-object:
selecting multidimensional parameters for screening according to the multidimensional parameters in the primary object; or alternatively, the first and second heat exchangers may be,
and filtering according to the multidimensional parameters on the sub-objects, and finely searching the sub-object result set.
According to the multi-dimensional parameter mapping configuration method provided by the invention, after the multi-dimensional parameters corresponding to the apikey of the attribute of the sub-object and the corresponding multi-dimensional parameter options are written into the sub-object, the method further comprises a statistical analysis process of the sub-object:
sub-objects are grouped, classified and screened according to metadata parameters of platform services.
The invention also provides a multidimensional parameter mapping configuration device, which comprises:
the parameter setting module is used for setting multidimensional parameters and corresponding multidimensional parameter options in the main object to form a main object-multidimensional parameter relation table and a main object-multidimensional parameter option relation table, wherein the multidimensional parameters are dynamic parameters;
the configuration relation table acquisition module is used for acquiring the configuration relation between the multidimensional parameter and the apikey and generating a multidimensional parameter-apikey configuration relation table;
the sub-object generation module is used for generating a plurality of sub-objects according to the actual task requirements by the main object;
a determining module, configured to determine an apikey of the attribute of the child object;
the determining module is further configured to search the multidimensional parameter-apikey configuration relation table based on the apikey of the attribute of the sub-object, so as to obtain a multidimensional parameter corresponding to the apikey of the attribute of the sub-object;
and the writing module is used for writing the multidimensional parameter corresponding to the apikey of the attribute of the sub-object and the corresponding multidimensional parameter option into the sub-object.
The invention also provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of any of the multi-dimensional parameter mapping configuration methods described above when executing the program.
The present invention also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the multi-dimensional parameter mapping configuration method as described in any of the above.
The invention also provides a computer program product comprising a computer program which when executed by a processor implements the steps of the multi-dimensional parameter mapping configuration method as described in any one of the above.
According to the multi-dimensional parameter mapping configuration method, the multi-dimensional parameter mapping configuration device and the electronic equipment, the mapping relation between the main object and the sub-object is established through the multi-dimensional parameters, so that mapping conversion from the configuration of the main object to the sub-object of the dynamic multi-dimensional parameters is realized, and dynamic storage and accurate query of the sub-object are realized; the invention can increase columns according to the configuration of metadata and dynamically realize the mapping storage of multidimensional parameters.
Drawings
In order to more clearly illustrate the technical solutions of the present disclosure or the prior art, the following description will briefly introduce the drawings that are required to be used in the embodiments or the prior art descriptions, and it is obvious that the drawings in the following description are some embodiments of the present disclosure, and other drawings may be obtained according to these drawings without inventive effort for a person of ordinary skill in the art.
FIG. 1 is a flow chart of a multi-dimensional parameter mapping configuration method provided by the invention;
FIG. 2 is one of the schematic diagrams of the multidimensional parameter map provided by the embodiment of the present invention;
FIG. 3 is a second schematic diagram of a multi-dimensional parameter map provided by an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a multidimensional parameter mapping configuration device according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of an electronic device provided by the present invention.
Detailed Description
For the purposes of making the objects, technical solutions and advantages of the embodiments of the present disclosure more apparent, the technical solutions of the embodiments of the present disclosure will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present disclosure, and it is apparent that the described embodiments are some embodiments, but not all embodiments of the present disclosure. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the disclosed embodiments, are within the scope of the disclosed embodiments.
SaaS, software-as-a-Service, is a completely innovative Software application model that began to rise in the 21 st century as Internet technology developed and application Software matured. In the traditional mode, a manufacturer deploys a software product to a plurality of client terminals inside an enterprise through License to realize delivery. SaaS defines a new delivery method and also allows software to further return to the nature of the service. SaaS services typically provide services to hundreds or thousands of different customers (also known as tenants) based on a set of standard software systems. This requires that SaaS services can support isolation of data and configuration between different tenants, thereby guaranteeing security and privacy of each tenant's data, as well as personalized needs of users such as interfaces, business logic, data structures, etc. Since SaaS supports multiple tenants simultaneously, each tenant has many users, which presents significant challenges to the performance, stability, and extensibility of the infrastructure platform supporting the software. SaaS is used as a software delivery mode based on the Internet, and optimizing the performance and the operation cost of the software after large-scale application are core tasks of architects.
At present, the multi-dimensional parameter design under the SaaS mode is mostly realized from multi-dimensional design of a main object to multi-dimensional parameter storage of a sub-object through Json storage, and the sub-object tracks related information of the multi-dimensional parameter by checking a Json structure. In the multi-dimensional mapping design under the SaaS mode, the prior art only provides configuration capability of multi-dimensional parameters and multi-dimensional parameter options in the aspect of multi-dimensional parameter configuration, after the multi-dimensional parameter configuration is selected by the application of a main object in the aspect of multi-dimensional parameter mapping, the selected multi-dimensional parameters are stored on fixed fields of sub-objects by using Json, the storage length of the Json structure is limited, and when the multi-dimensional parameters are too many, the storage is gradually limited, so that the expansibility is lost; in the aspect of sub-object searching, when a downstream object selects a sub-object, the Json structure multidimensional parameter searching is inconvenient; in the sub-object statistical analysis scene, when the sub-object performs statistical analysis, the Json structure classification statistics is inconvenient.
Therefore, dynamic storage and accurate query in SaaS mode are currently a need to be addressed.
In order to solve the above problems, the present invention provides a multidimensional parameter mapping configuration method, as shown in fig. 1, including:
step 101, setting multidimensional parameters and corresponding multidimensional parameter options in a main object to form a main object-multidimensional parameter relation table and a main object-multidimensional parameter option relation table, wherein the multidimensional parameters are dynamic parameters;
step 102, acquiring the configuration relation between the multidimensional parameter and the apikey, and generating a multidimensional parameter-apikey configuration relation table;
step 103, generating a plurality of sub-objects by the main object according to actual task requirements;
step 104, determining an apikey of the attribute of the sub-object;
step 105, searching the multi-dimensional parameter-apikey configuration relation table based on the apikey of the attribute of the sub-object to obtain the multi-dimensional parameter corresponding to the apikey of the attribute of the sub-object;
and step 106, writing the multi-dimensional parameters corresponding to the apikey of the attribute of the sub-object and the corresponding multi-dimensional parameter options into the sub-object.
The above steps are described in detail with reference to specific examples.
Step 101, setting multidimensional parameters and corresponding multidimensional parameter options in a main object to form a main object-multidimensional parameter relation table and a main object-multidimensional parameter option relation table, wherein the multidimensional parameters are dynamic parameters;
in the step, the multidimensional parameters are set according to actual demands, specifically, corresponding multidimensional parameters are selected according to the type of a main object, and the main object and the corresponding multidimensional parameters are filled in a main object-multidimensional parameter relation table; selecting multidimensional parameter options according to the content of the main object, and filling the content of the main object and the corresponding multidimensional parameter options into a main object-multidimensional parameter option relation table; the multidimensional parameter is set as a dynamic parameter.
Illustratively, taking the design of multidimensional parameters in a sales-facilitating CRM system as an example, a plurality of specifications of products in the CRM system can be set as specification 1 to be a color, and specification value 1 is silver, white or black; the specification 2 is a size, and the specification value 2 is 5.7 inches, 6.1 inches, and 6.5 inches. In other scenarios, the specification 1 may also be set to a shape, with the corresponding specification value 1 being set to a sphere, cuboid, cylinder, etc.
Step 102, acquiring the configuration relation between the multidimensional parameter and the apikey, and generating a multidimensional parameter-apikey configuration relation table;
in this step, a data model needs to be built in advance, so that a user can realize a configuration relationship between the multidimensional parameter and the child object apikey.
Specifically, according to a preset rule, searching a multidimensional parameter corresponding to the apikey in the main object-multidimensional parameter relation table to obtain a configuration relation between the apikey and the multidimensional parameter; and storing the configuration relation in a data table to form a multidimensional parameter-apikey configuration relation table.
Further, after the user selects the multi-dimensional parameters of the main object by himself, the system searches the corresponding sub-object apikey according to the multi-dimensional parameter table and writes the sub-object apikey into a default value.
Step 103, generating a plurality of sub-objects by the main object according to actual task requirements;
in this step, according to different task demands, the main object generates corresponding sub-objects in batches.
Step 104, determining an apikey of the attribute of the sub-object;
in this step, the child objects generated in S103 determine the apikey of the attribute of each child object.
Specifically, acquiring attribute metadata of the child object; and obtaining the apikey of the attribute corresponding to the sub-object based on the attribute metadata.
Step 105, searching the multi-dimensional parameter-apikey configuration relation table based on the apikey of the attribute of the sub-object to obtain the multi-dimensional parameter corresponding to the apikey of the attribute of the sub-object;
in the step, after determining the apikey of the attribute of the sub-object, the multidimensional parameter corresponding to the apikey is searched according to a pre-established configuration relation table.
And step 106, writing the multi-dimensional parameters corresponding to the apikey of the attribute of the sub-object and the corresponding multi-dimensional parameter options into the sub-object.
In the step, mapping conversion is carried out on the multidimensional parameters, and when the sub-objects are generated in batches from the main object by utilizing the configuration of the dynamic parameters and the sub-object apikey, the dynamic parameters are converted and filled on the sub-objects according to the mapping relation, so that the description and inheritance of the sub-objects on the dynamic parameters are realized.
Specifically, according to a main object-multidimensional parameter relation selected by a user, combining multidimensional parameters corresponding to the apikey of the attribute of the sub object and corresponding multidimensional parameter options to obtain combined set data; and writing the combined set data into the sub-object.
Further, the user can set an apikey mapping relation of the attribute of the sub-object corresponding to the multidimensional parameter of the current main object, after selection, the system searches and searches the apikey corresponding column of the attribute of the sub-object according to the mapping relation and writes the apikey corresponding column of the attribute of the sub-object into the apikey column of the attribute of the sub-object according to the metadata, thereby realizing the function of dynamically searching and writing the apikey corresponding column of the sub-object.
Optionally, after writing the multi-dimensional parameter corresponding to the apikey of the attribute of the sub-object and the corresponding multi-dimensional parameter option into the sub-object, the method further includes a search process of the sub-object: selecting multidimensional parameters for screening according to the multidimensional parameters in the primary object; or filtering according to the multidimensional parameters on the sub-objects, and finely searching the sub-object result set.
Optionally, after writing the multi-dimensional parameters corresponding to the apikey of the attribute of the sub-object and the corresponding multi-dimensional parameter options into the sub-object, the method further includes a statistical analysis process of the sub-object: sub-objects are grouped, classified and screened according to metadata parameters of platform services such as Paas platform.
In a specific embodiment, as shown in fig. 2, fig. 2 is one of schematic diagrams of a multi-dimensional parameter map provided in an embodiment of the present invention, where the multi-dimensional parameter map includes two transformations:
first conversion: conversion from multi-dimensional parameters to primary object-to-dimensional parameter relationships is brought in;
second conversion: the write is looked up from the transformation of the main object-pair dimension parameter relationship to the sub-object metadata apikey.
Specifically, the implementation step of the multidimensional parameter mapping includes:
step one, multi-dimensional parameter mapping configuration: constructing a required data model, and enabling a user to realize configuration relation of the multi-dimensional parameters and the child objects apikey;
step two, a multidimensional parameter mapping conversion algorithm: after the user selects the multi-dimensional parameters of the main object by himself, the system searches the corresponding sub-object apikey according to the multi-dimensional parameter table and writes the sub-object apikey into a default value, at this time, the user can also set the apikey mapping relation of the attribute of the sub-object corresponding to the multi-dimensional parameters of the current main object, after the selection, the system searches the apikey corresponding column of the attribute of the sub-object according to the mapping relation and writes the apikey corresponding column of the attribute of the sub-object into the apikey column of the attribute corresponding to the sub-object, thereby realizing the function of dynamically searching and writing the apikey corresponding column of the sub-object.
Fig. 3 is a second schematic diagram of a multidimensional parameter map provided in an embodiment of the present invention, as shown in fig. 3, for example, in a specific embodiment, a product multi-specification implementation scheme in a system may be divided into a multi-specification, specification value configuration, commodity, product map storage and quotation, and product order selection process.
The multi-specification configuration includes the steps of:
step one, setting basic data: specification and specification value;
and step two, according to the main object-multi-dimensional parameter relation selected by the user and the main object-multi-dimensional parameter option relation, solving how many pieces of combined set data exist by using a Cartesian algorithm of the main object-multi-dimensional parameter relation and the multi-dimensional parameter option relation.
Illustratively, for example, the primary object is an a-handset: configuring the user to select a color; silver, white, size: 5.7 inches, 6.1 inches, 2 x 2 formed 4 combined sub-object data:
1) Silver 5.7 inches: color (apikey 1); silver, size (apikey 2): 5.7 inches;
2) Silver 6.1 inch: color (apikey 1); silver, size (apikey 2): 6.1 inch;
3) White 5.7 inches: color (apikey 1); white, size (apikey 2): 5.7 inches;
4) White 6.1 inch: color (apikey 1); white, size (apikey 2): 6.1 inch.
In another embodiment, the following may be provided:
1. specification 1: color:
specification value 1: silver, white, black;
2. specification 2: size:
specification value 2:5.7 inches, 6.1 inches, 6.5 inches;
the goods SPU and SKU are set as follows:
1. commodity SPU:
trade name: a13;
2. specification of: color/size: silver/5.7 inches;
3. product SKU: a13 Silver 5.7 inches, selling price: 5800 yuan.
As can be seen from the above embodiments, the multi-dimensional parameter mapping configuration method provided by the present invention is based on a multi-dimensional parameter configuration scene, and utilizes a mapping scheme to implement mapping conversion of dynamic multi-dimensional parameters from configuration of a main object to sub-objects, thereby implementing dynamic storage of sub-objects.
According to the multidimensional parameter mapping method provided by the invention, the method can be further applied to a scene of sub-object searching and statistical analysis.
Specifically, when searching, the sub-objects can select multidimensional parameters to filter according to the first main object. And screening according to multi-dimensional parameters on the sub-objects, and finely searching the sub-object result set.
In the statistical analysis scene, the sub-object mapping inherits the multidimensional parameters of the main object, so that grouping, classification screening and the like can be performed according to the metadata parameters of the Paas platform.
The multi-dimensional parameter mapping configuration mode provided by the invention realizes inheritance occupation inquiry of the multi-dimensional parameter on the sub-object through mapping configuration storage of the sub-object and the multi-dimensional parameter, a user can realize the multi-dimensional parameter of the sub-object and the configuration relation with the multi-dimensional parameter through configuration without expansion development, and as the multi-dimensional parameter is increased, the user can increase columns according to the configuration of metadata, map multiple columns on the sub-object, and realize dynamic mapping storage of the multi-dimensional parameter, thereby realizing dynamic expansion.
The following describes a multidimensional parameter mapping configuration apparatus provided by an embodiment of the present disclosure, and the multidimensional parameter mapping configuration apparatus described below and the multidimensional parameter mapping configuration method described above may be referred to correspondingly to each other.
The multidimensional parameter mapping configuration device provided by the invention, as shown in fig. 4, comprises:
a parameter setting module 41, configured to set a multidimensional parameter and a multidimensional parameter option corresponding to the multidimensional parameter in a main object, and form a main object-multidimensional parameter relation table and a main object-multidimensional parameter option relation table, where the multidimensional parameter is a dynamic parameter;
a configuration relation table obtaining module 42, configured to obtain a configuration relation between the multidimensional parameter and the apikey, and generate a multidimensional parameter-apikey configuration relation table;
a sub-object generating module 43, configured to generate a plurality of sub-objects according to actual task requirements from the main object;
a determining module 44, configured to determine an apikey of the attribute of the child object;
the determining module 44 is further configured to search the multidimensional parameter-apikey configuration relation table based on the apikey of the attribute of the sub-object, to obtain a multidimensional parameter corresponding to the apikey of the attribute of the sub-object;
the writing module 45 is configured to write the multi-dimensional parameter corresponding to the apikey of the attribute of the sub-object and the corresponding multi-dimensional parameter option into the sub-object.
In the embodiment of the disclosure, a main object-multi-dimensional parameter relation table and a main object-multi-dimensional parameter option relation table are formed by setting multi-dimensional parameters and corresponding multi-dimensional parameter options in a main object, wherein the multi-dimensional parameters are dynamic parameters; acquiring the configuration relation between the multidimensional parameter and the apikey, and generating a multidimensional parameter-apikey configuration relation table; generating a plurality of sub-objects by the main object according to actual task requirements; determining an apikey of the attribute of the child object; searching the multi-dimensional parameter-apikey configuration relation table based on the apikey of the attribute of the sub-object to obtain the multi-dimensional parameter corresponding to the apikey of the attribute of the sub-object; and writing the multidimensional parameters corresponding to the apikey of the attribute of the sub-object and the corresponding multidimensional parameter options into the sub-object, thereby establishing a mapping relation between the main object and the sub-object through the multidimensional parameters, realizing mapping conversion of the dynamic multidimensional parameters from the configuration of the main object to the sub-object, and further realizing dynamic storage and accurate query of the sub-object. The invention can also increase columns according to the configuration of metadata, and dynamically realize the mapping storage of multidimensional parameters.
Fig. 5 illustrates a physical schematic diagram of an electronic device, as shown in fig. 5, which may include: processor 510, communication interface (Communications Interface) 520, memory 530, and communication bus 540, wherein processor 510, communication interface 520, memory 530 complete communication with each other through communication bus 540. Processor 510 may invoke logic instructions in memory 530 to perform a multi-dimensional parameter map configuration method comprising: setting a multi-dimensional parameter and a corresponding multi-dimensional parameter option in a main object to form a main object-multi-dimensional parameter relation table and a main object-multi-dimensional parameter option relation table, wherein the multi-dimensional parameter is a dynamic parameter; acquiring the configuration relation between the multidimensional parameter and the apikey, and generating a multidimensional parameter-apikey configuration relation table; generating a plurality of sub-objects by the main object according to actual task requirements; determining an apikey of the attribute of the child object; searching the multi-dimensional parameter-apikey configuration relation table based on the apikey of the attribute of the sub-object to obtain the multi-dimensional parameter corresponding to the apikey of the attribute of the sub-object; and writing the multidimensional parameters corresponding to the apikey of the attribute of the sub-object and the multidimensional parameter options corresponding to the apikey into the sub-object.
Further, the logic instructions in the memory 530 described above may be implemented in the form of software functional units and may be stored in a computer-readable storage medium when sold or used as a stand-alone product. Based on such understanding, the technical solutions of the embodiments of the present disclosure may be essentially or, what contributes to the prior art, or part of the technical solutions, may be embodied in the form of a software product stored in a storage medium, including several instructions to cause a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in the embodiments of the present disclosure. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
In another aspect, the present disclosure also provides a computer program product comprising a computer program stored on a non-transitory computer readable storage medium, the computer program comprising program instructions which, when executed by a computer, are capable of performing the multi-dimensional parameter map configuration method provided by the methods described above, the method comprising: setting a multi-dimensional parameter and a corresponding multi-dimensional parameter option in a main object to form a main object-multi-dimensional parameter relation table and a main object-multi-dimensional parameter option relation table, wherein the multi-dimensional parameter is a dynamic parameter; acquiring the configuration relation between the multidimensional parameter and the apikey, and generating a multidimensional parameter-apikey configuration relation table; generating a plurality of sub-objects by the main object according to actual task requirements; determining an apikey of the attribute of the child object; searching the multi-dimensional parameter-apikey configuration relation table based on the apikey of the attribute of the sub-object to obtain the multi-dimensional parameter corresponding to the apikey of the attribute of the sub-object; and writing the multidimensional parameters corresponding to the apikey of the attribute of the sub-object and the multidimensional parameter options corresponding to the apikey into the sub-object.
In yet another aspect, the present disclosure also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, is implemented to perform the above-provided multidimensional parameter mapping configuration methods, the method comprising: setting a multi-dimensional parameter and a corresponding multi-dimensional parameter option in a main object to form a main object-multi-dimensional parameter relation table and a main object-multi-dimensional parameter option relation table, wherein the multi-dimensional parameter is a dynamic parameter; acquiring the configuration relation between the multidimensional parameter and the apikey, and generating a multidimensional parameter-apikey configuration relation table; generating a plurality of sub-objects by the main object according to actual task requirements; determining an apikey of the attribute of the child object; searching the multi-dimensional parameter-apikey configuration relation table based on the apikey of the attribute of the sub-object to obtain the multi-dimensional parameter corresponding to the apikey of the attribute of the sub-object; and writing the multidimensional parameters corresponding to the apikey of the attribute of the sub-object and the multidimensional parameter options corresponding to the apikey into the sub-object.
The apparatus embodiments described above are merely illustrative, wherein the elements illustrated as separate elements may or may not be physically separate, and the elements shown as elements may or may not be physical elements, may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art will understand and implement the present invention without undue burden.
From the above description of the embodiments, it will be apparent to those skilled in the art that the embodiments may be implemented by means of software plus necessary general hardware platforms, or of course may be implemented by means of hardware. Based on this understanding, the foregoing technical solution may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as ROM/RAM, a magnetic disk, an optical disk, etc., including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method described in the respective embodiments or some parts of the embodiments.
Finally, it should be noted that: the above embodiments are merely for illustrating the technical solution of the present disclosure, and are not limiting thereof; although the present disclosure has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present disclosure.
Claims (10)
1. A method for multidimensional parameter mapping configuration, comprising:
setting a multi-dimensional parameter and a corresponding multi-dimensional parameter option in a main object to form a main object-multi-dimensional parameter relation table and a main object-multi-dimensional parameter option relation table, wherein the multi-dimensional parameter is a dynamic parameter;
acquiring the configuration relation between the multidimensional parameter and the apikey, and generating a multidimensional parameter-apikey configuration relation table, wherein the apikey is a unique identifier of a specific attribute of each object obtained according to a service scene, and the multidimensional parameter-apikey configuration relation table is a dynamic configuration relation table;
generating a plurality of sub-objects by the main object according to actual task requirements;
determining the apikey of the attribute of the child object;
searching the multidimensional parameter-apikey configuration relation table based on the apikey of the attribute of the sub-object to obtain the multidimensional parameter corresponding to the apikey of the attribute of the sub-object;
and writing the multidimensional parameter corresponding to the apikey of the attribute of the sub-object into the sub-object.
2. The method for configuring multi-dimensional parameter mapping according to claim 1, wherein the steps of setting multi-dimensional parameters and corresponding multi-dimensional parameter options in the main object to form a main object-multi-dimensional parameter relation table and a main object-multi-dimensional parameter option relation table specifically include:
selecting corresponding multidimensional parameters according to the type of the main object, and filling the main object and the corresponding multidimensional parameters into a main object-multidimensional parameter relation table;
selecting multidimensional parameter options according to the content of the main object, and filling the content of the main object and the corresponding multidimensional parameter options into a main object-multidimensional parameter option relation table;
the multidimensional parameter is set as a dynamic parameter.
3. The method for mapping configuration of multidimensional parameters according to claim 2, wherein the obtaining the configuration relation between the multidimensional parameters and the apikey, generating a multidimensional parameter-apikey configuration relation table, comprises:
searching a multidimensional parameter corresponding to an apikey in the main object-multidimensional parameter relation table according to a preset rule to obtain a configuration relation between the apikey and the multidimensional parameter;
and storing the configuration relation in a data table to form a multidimensional parameter-apikey configuration relation table.
4. The multi-dimensional parameter map configuration method of claim 1, wherein said determining said apikey of said child object's attribute comprises:
acquiring attribute metadata of the sub-object;
and obtaining the apikey of the attribute corresponding to the sub-object based on the attribute metadata.
5. The method of claim 2, wherein writing the multi-dimensional parameters corresponding to the apikey of the attribute of the sub-object and the corresponding multi-dimensional parameter options into the sub-object comprises:
according to the main object-multidimensional parameter relation selected by the user, combining the multidimensional parameter corresponding to the apikey of the attribute of the sub object and the multidimensional parameter option corresponding to the apikey to obtain combined set data;
and writing the combined set data into the sub-object.
6. The multi-dimensional parameter map configuration method according to claim 1 or 5, wherein after writing the multi-dimensional parameter corresponding to the apikey and the corresponding multi-dimensional parameter option of the attribute of the sub-object into the sub-object, the method further comprises a search process of the sub-object:
screening the multi-dimensional parameters in the main object, and then searching corresponding parameters in the multi-dimensional parameters of the sub-object according to the multi-dimensional parameters of the main object; or, directly carrying out refined search according to the multidimensional parameters on the sub-object to obtain a sub-object result set.
7. The multi-dimensional parameter map configuration method according to claim 1 or 5, wherein after writing the multi-dimensional parameters corresponding to the apikey and the corresponding multi-dimensional parameter options of the attributes of the sub-objects into the sub-objects, the method further comprises a statistical analysis process of the sub-objects:
sub-objects are grouped, classified and screened according to metadata parameters of platform services.
8. A multi-dimensional parameter map configuration apparatus, comprising:
the parameter setting module is used for setting multidimensional parameters and corresponding multidimensional parameter options in the main object to form a main object-multidimensional parameter relation table and a main object-multidimensional parameter option relation table, wherein the multidimensional parameters are dynamic parameters;
the configuration relation table acquisition module is used for acquiring the configuration relation between the multidimensional parameter and the apikey and generating a multidimensional parameter-apikey configuration relation table, wherein the apikey is a unique identifier of a specific attribute of each object obtained according to a service scene, and the multidimensional parameter-apikey configuration relation table is a dynamic configuration relation table;
the sub-object generation module is used for generating a plurality of sub-objects according to the actual task requirements by the main object;
a determining module, configured to determine the apikey of the attribute of the child object;
the determining module is further configured to search the multidimensional parameter-apikey configuration relation table based on the apikey of the attribute of the sub-object, to obtain a multidimensional parameter corresponding to the apikey of the attribute of the sub-object;
and the writing module is used for writing the multidimensional parameter corresponding to the apikey of the attribute of the sub-object and the multidimensional parameter options corresponding to the apikey into the sub-object.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the multi-dimensional parameter mapping configuration method according to any one of claims 1 to 7 when the program is executed by the processor.
10. A non-transitory computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the multi-dimensional parameter map configuration method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311698519.7A CN117390030B (en) | 2023-12-12 | 2023-12-12 | Multidimensional parameter mapping configuration method and device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311698519.7A CN117390030B (en) | 2023-12-12 | 2023-12-12 | Multidimensional parameter mapping configuration method and device and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117390030A CN117390030A (en) | 2024-01-12 |
| CN117390030B true CN117390030B (en) | 2024-03-08 |
Family
ID=89437794
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311698519.7A Active CN117390030B (en) | 2023-12-12 | 2023-12-12 | Multidimensional parameter mapping configuration method and device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117390030B (en) |
Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107423037A (en) * | 2016-03-09 | 2017-12-01 | 阿里巴巴集团控股有限公司 | Application programming interfaces localization method and equipment |
| US10015167B1 (en) * | 2017-03-17 | 2018-07-03 | Accenture Global Solutions Limited | Extensible key management system for application program interfaces |
| CN109669993A (en) * | 2018-12-20 | 2019-04-23 | 北京树根互联科技有限公司 | Data processing method, data processing equipment and electronic equipment |
| CN110222060A (en) * | 2019-06-12 | 2019-09-10 | 山东浪潮通软信息科技有限公司 | A kind of method of Dynamic Matching multiattribute data |
| CN110618983A (en) * | 2019-08-15 | 2019-12-27 | 复旦大学 | JSON document structure-based industrial big data multidimensional analysis and visualization method |
| CN112860948A (en) * | 2021-04-26 | 2021-05-28 | 北京仁科互动网络技术有限公司 | Metadata management method and system based on multi-tenant SaaS architecture and electronic equipment |
| CN113225379A (en) * | 2021-03-31 | 2021-08-06 | 北京三快在线科技有限公司 | Method and device for sending HTTP request message |
| US11334543B1 (en) * | 2018-04-30 | 2022-05-17 | Splunk Inc. | Scalable bucket merging for a data intake and query system |
| CN115374102A (en) * | 2021-07-30 | 2022-11-22 | 北京大杏科技有限责任公司 | Data processing method and system |
| CN115757393A (en) * | 2022-10-19 | 2023-03-07 | 燕山大学 | Tenant extension attribute merging method in multi-tenant mode and multi-tenant system thereof |
| CN115827646A (en) * | 2023-02-22 | 2023-03-21 | 北京仁科互动网络技术有限公司 | Index configuration method and device and electronic equipment |
| US11620541B1 (en) * | 2019-10-17 | 2023-04-04 | Splunk Inc. | Custom use case framework in computer analytics system |
| CN116466935A (en) * | 2023-04-07 | 2023-07-21 | 金蝶软件（中国）有限公司 | Template processing method, device, computer equipment and storage medium |
| CN116521091A (en) * | 2023-06-28 | 2023-08-01 | 苏州浪潮智能科技有限公司 | Data reading method, device, equipment, data transmission system and storage medium |
-
2023
- 2023-12-12 CN CN202311698519.7A patent/CN117390030B/en active Active
Patent Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107423037A (en) * | 2016-03-09 | 2017-12-01 | 阿里巴巴集团控股有限公司 | Application programming interfaces localization method and equipment |
| US10015167B1 (en) * | 2017-03-17 | 2018-07-03 | Accenture Global Solutions Limited | Extensible key management system for application program interfaces |
| US11334543B1 (en) * | 2018-04-30 | 2022-05-17 | Splunk Inc. | Scalable bucket merging for a data intake and query system |
| CN109669993A (en) * | 2018-12-20 | 2019-04-23 | 北京树根互联科技有限公司 | Data processing method, data processing equipment and electronic equipment |
| CN110222060A (en) * | 2019-06-12 | 2019-09-10 | 山东浪潮通软信息科技有限公司 | A kind of method of Dynamic Matching multiattribute data |
| CN110618983A (en) * | 2019-08-15 | 2019-12-27 | 复旦大学 | JSON document structure-based industrial big data multidimensional analysis and visualization method |
| US11620541B1 (en) * | 2019-10-17 | 2023-04-04 | Splunk Inc. | Custom use case framework in computer analytics system |
| CN113225379A (en) * | 2021-03-31 | 2021-08-06 | 北京三快在线科技有限公司 | Method and device for sending HTTP request message |
| CN112860948A (en) * | 2021-04-26 | 2021-05-28 | 北京仁科互动网络技术有限公司 | Metadata management method and system based on multi-tenant SaaS architecture and electronic equipment |
| CN115374102A (en) * | 2021-07-30 | 2022-11-22 | 北京大杏科技有限责任公司 | Data processing method and system |
| CN115757393A (en) * | 2022-10-19 | 2023-03-07 | 燕山大学 | Tenant extension attribute merging method in multi-tenant mode and multi-tenant system thereof |
| CN115827646A (en) * | 2023-02-22 | 2023-03-21 | 北京仁科互动网络技术有限公司 | Index configuration method and device and electronic equipment |
| CN116466935A (en) * | 2023-04-07 | 2023-07-21 | 金蝶软件（中国）有限公司 | Template processing method, device, computer equipment and storage medium |
| CN116521091A (en) * | 2023-06-28 | 2023-08-01 | 苏州浪潮智能科技有限公司 | Data reading method, device, equipment, data transmission system and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| 孔兰菊 ; 李庆忠 ; 史玉良 ; 王学 ; .面向SaaS应用基于键值对模式的多租户索引研究.计算机学报.2010,(第12期),2239-2247. * |
| 面向SaaS应用基于键值对模式的多租户索引研究;孔兰菊;李庆忠;史玉良;王学;;计算机学报(第12期);2239-2247 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117390030A (en) | 2024-01-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108153670B (en) | Interface testing method and device and electronic equipment | |
| CN107370786B (en) | General information management system based on micro-service architecture | |
| CN107545046B (en) | Fusion method and device for multi-source heterogeneous data | |
| CN112396462B (en) | Crowd circling method and device based on click house | |
| CN107102995B (en) | Method and device for determining SQL execution plan | |
| CN110888672B (en) | Expression engine implementation method and system based on metadata architecture | |
| CN103729171A (en) | Generating method and device of service workflow codes | |
| CN112559606A (en) | Conversion method and conversion device for JSON format data | |
| CN116992092A (en) | Method and device for establishing flow model, storage medium and terminal equipment | |
| CN117390030B (en) | Multidimensional parameter mapping configuration method and device and electronic equipment | |
| CN108241620B (en) | Query script generation method and device | |
| US11531706B2 (en) | Graph search using index vertices | |
| CN112035156A (en) | E-commerce platform docking device, method, equipment and medium | |
| CN115982177A (en) | Data collection method, device, equipment and medium based on tree dimensionality | |
| US9230022B1 (en) | Customizable result sets for application program interfaces | |
| CN116303657A (en) | Group image generation method, group image generation device, computer device, and storage medium | |
| CN115268863A (en) | Low-code platform data description method, equipment and medium | |
| CN106970780A (en) | A kind of data interactive method and device | |
| CN115017185A (en) | Data processing method, device and storage medium | |
| CN109165049A (en) | Module data processing method and processing device | |
| CN107851165B (en) | Key system, key client and key management method | |
| CN114676675B (en) | Data processing method, device, computer equipment and storage medium | |
| CN112506944B (en) | Data standard conversion access method, device, equipment and medium between service systems | |
| CN118689924A (en) | Service processing method, device, equipment and storage medium | |
| CN116414440A (en) | Software modification method and device and electronic equipment |
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 |