CN110837508A - Method, device and equipment for establishing aperture system and computer storage medium - Google Patents
Method, device and equipment for establishing aperture system and computer storage medium Download PDFInfo
- Publication number
- CN110837508A CN110837508A CN201911089780.0A CN201911089780A CN110837508A CN 110837508 A CN110837508 A CN 110837508A CN 201911089780 A CN201911089780 A CN 201911089780A CN 110837508 A CN110837508 A CN 110837508A
- Authority
- CN
- China
- Prior art keywords
- keyword
- dimension
- index
- source data
- data table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
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/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
Abstract
The invention provides a method, a device, equipment and a computer storage medium for establishing an aperture system, wherein the method specifically comprises the following steps: the embodiment of the invention establishes a keyword table; selecting at least one keyword as a dimension keyword according to a preset rule based on the keywords of the keyword table; selecting at least one keyword as an index keyword according to a preset rule based on the keywords of the keyword table; and automatically generating a query instruction corresponding to the dimension-index combination according to the dimension key words and the index key words, and establishing an aperture system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination. By the method, the dimension-index does not need to be set as a deem, so that the caliber of the query instruction corresponding to the dimension-index combination can be automatically generated, a caliber system is established, the workload of a user is reduced, and the processing efficiency of the large data is improved.
Description
Technical Field
The invention relates to the field of big data, in particular to a method, a device, equipment and a computer storage medium for establishing a caliber system.
Background
With the rapid development of the internet, the big data era is met, the exploration phase and the market starting phase are passed, and the big data is in the key turning period from concept to practical application. Big data tends to mature in all aspects of acceptance, technology, application and the like, and starts to step into the rapid development stage of the industry. The huge application value of big data drives the huge development of big data industry.
At present, in the age of big data, the quantity of data warehouses is getting bigger and bigger, when data information stored in the data warehouses is queried or modified, in the prior art, a modeling method is generally utilized to query or modify the data confidence stored in the data warehouses, but at present, for each query or modification operation, a corresponding script needs to be rewritten to realize the query or modification operation, and the mode causes huge workload and is not beneficial to the development of the big data industry.
Disclosure of Invention
The embodiment of the invention provides a method, a device, equipment and a computer storage medium for establishing a caliber system, and mainly aims to solve the problems that in the prior art, corresponding scripts are required to be rewritten for each query or modification operation, so that the workload is huge and the development of the big data industry is not facilitated.
In a first aspect, an embodiment of the present invention provides a method for establishing an aperture system, where the method specifically includes:
establishing a keyword table;
selecting at least one keyword as a dimension keyword according to a preset rule based on the keywords of the keyword table;
selecting at least one keyword as an index keyword according to a preset rule based on the keywords of the keyword table;
and automatically generating a query instruction corresponding to the dimension-index combination according to the dimension key words and the index key words, and establishing an aperture system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination.
Preferably, the establishing a keyword table specifically includes:
checking the data warehouse at intervals of preset time, and counting a source data table generated in the preset time, wherein the source data table comprises description fields;
and replacing the description information in the description field by using a keyword to establish a keyword table.
Preferably, the selecting, based on the keywords of the keyword table, at least one keyword as a dimension keyword according to a preset rule specifically includes:
acquiring a first source data table in the source data table, and determining at least one primary key in the first source data table;
calculating the times that at least one primary key in each first source data table is used as a foreign key of a second source data table;
selecting the primary key, which is used as the foreign key of the second source data table, from at least one primary key in the first source data table, wherein the number of times of the primary key is greater than or equal to a preset number threshold value as a dimension key of the first source data table, and the first source data table and the second source data table are any one of the source data tables;
alternatively, the first and second electrodes may be,
calculating the proportion of at least one primary key in each first source data table as a foreign key of a second source data table;
selecting the primary key with the proportion larger than or equal to a preset proportion threshold value as the external key of the second source data table from at least one primary key in the first source data table as the dimension key of the first source data table, wherein the first source data table and the second source data table are any one of the source data tables.
Preferably, the selecting, based on the keywords of the keyword table, at least one keyword as an index keyword according to a preset rule specifically includes:
acquiring a second source data table in the source data tables, and determining at least one keyword except for an exception key in the second source data table, wherein the second source data table is any one source data table except for the first source data table in the source data tables;
calculating the use number of each keyword except the foreign key in the second source data table;
selecting at least one keyword from at least one keyword in the second source data table except the foreign key as an index keyword, wherein the index keyword is a keyword of which the use number is greater than or equal to a preset use number threshold;
alternatively, the first and second electrodes may be,
calculating the utilization rate of each keyword except the foreign key in the second source data table;
selecting at least one keyword from at least one keyword in the second source data table except the foreign key as an index keyword, wherein the index keyword is a keyword of which the utilization rate is greater than or equal to a preset utilization rate threshold value;
alternatively, the first and second electrodes may be,
calculating the use frequency of each keyword in the second source data table except the foreign key;
and selecting at least one keyword from at least one keyword in the second source data table except the foreign key as an index keyword, wherein the index keyword is a keyword of which the use number is greater than or equal to a preset use frequency threshold value.
Preferably, on the basis of any of the above embodiments, the automatically generating, according to the dimension keyword and the index keyword, a query instruction corresponding to a dimension-index combination, and establishing a caliber system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination specifically include:
dimension splitting is carried out according to the dimension keywords and different theme categories, the split dimension keywords are stored into a plurality of dimension tables, and the dimension tables correspond to the theme categories;
index splitting is carried out according to the index keywords and different dimensions, the split index keywords are stored into a plurality of index tables, and the index tables correspond to the dimensions;
and automatically generating a dimension-index combination table according to the external keys of the index tables and the dimension tables, wherein the dimension-index combination table comprises the dimension-index combination and the query instruction corresponding to the dimension-index combination, and establishing a caliber system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination.
In a second aspect, an embodiment of the present invention further provides an apparatus for establishing an aperture system, where the apparatus includes: :
the first establishing module is used for establishing a keyword table;
the dimension selection module is used for selecting at least one keyword as a dimension keyword according to a preset rule based on the keywords of the keyword table;
the index selection module is used for selecting at least one keyword as an index keyword according to a preset rule based on the keywords of the keyword table;
and the second establishing module is used for automatically generating a query instruction corresponding to the dimension-index combination according to the dimension key words and the index key words and establishing an aperture system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination.
In a third aspect, the present invention provides an aperture system establishment apparatus, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement part or all of the steps of any one of the aperture system establishment methods described in the above embodiments.
In a fourth aspect, the present invention further provides a computer storage medium, where the computer storage medium may store a program, and when the program is executed, the program implements part or all of the steps of any one of the aperture system establishment methods described in the above embodiments.
Has the advantages that: the embodiment of the invention establishes a keyword table; selecting at least one keyword as a dimension keyword according to a preset rule based on the keywords of the keyword table; selecting at least one keyword as an index keyword according to a preset rule based on the keywords of the keyword table; and automatically generating a query instruction corresponding to the dimension-index combination according to the dimension key words and the index key words, and establishing an aperture system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination. By the method, dimension-index setting is not needed manually, so that the caliber of the query instruction corresponding to the dimension-index combination can be automatically generated, a caliber system is established, the workload of a user is reduced, and the processing efficiency of the large data is improved.
These and other aspects of the invention are apparent from and will be elucidated with reference to the embodiments described hereinafter.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a schematic flow chart of a method for establishing an aperture system according to an embodiment of the present invention;
fig. 2 is a schematic flow chart of another aperture system establishing method according to a second embodiment of the present invention;
fig. 3 is a schematic flow chart of another aperture system establishing method according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of an aperture system establishing apparatus according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of an aperture system establishing apparatus according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The following are detailed below.
The terms "first," "second," "third," and "fourth," etc. in the description and claims of the invention and in the accompanying drawings are used for distinguishing between different objects and not for describing a particular order. Furthermore, the terms "include" and "have," as well as any variations thereof, are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those steps or elements listed, but may alternatively include other steps or elements not listed, or inherent to such process, method, article, or apparatus. The term "and/or" is used to describe an associative relationship of associated objects, meaning that three relationships may exist, e.g., a and/or B, may mean: a exists alone, A and B exist simultaneously, and B exists alone. The character "/" generally indicates that the former and latter associated objects are in an "or" relationship.
Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the invention. The appearances of the phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. It is explicitly and implicitly understood by one skilled in the art that the embodiments described herein can be combined with other embodiments.
Embodiments of the present application are described below with reference to the drawings.
Example one
According to an aspect of the present invention, there is provided a method for establishing an aperture system, specifically including the following steps, as shown in fig. 1:
s1, establishing a keyword table;
it should be noted that the execution subject of the embodiment of the present invention is a data management server, the data management server is composed of one or more computers running in a local area network and data management system software, and the data management server provides a management service for user data.
Specifically, a source data table when data in a data warehouse is checked every day can be counted, wherein the source data table comprises table names, description fields and description information corresponding to the description fields, keywords are extracted from the description information in each row of source data in the counted source data table, the extracted keywords are generated into a keyword table, and the keywords in the keyword table correspond to the description information in each row of source data one to one.
S2, based on the keywords of the keyword table, selecting at least one keyword as a dimension keyword according to a preset rule;
and selecting at least one keyword from each generated keyword table according to a preset rule as a dimension keyword of the keyword table, and setting the dimension keyword as the dimension of the aperture system.
S3, based on the keywords of the keyword table, selecting at least one keyword as an index keyword according to a preset rule;
and selecting at least one keyword from each generated keyword table according to a preset rule as an index keyword of the keyword table, and setting the dimension keyword as an index of the caliber system. The index is the attribute value of the dimension set above, for example, the dimension is a city, the corresponding index is Shenzhen, and Shenzhen is the attribute value of the dimension of the city.
And S4, automatically generating a query instruction corresponding to the dimension-index combination according to the dimension key words and the index key words, and establishing an aperture system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination.
The selected dimension key words and the selected index key words are automatically generated into dimension-index combinations, such as city-Shanghai, source data of which the login city is Shanghai are inquired from a data warehouse if necessary, the corresponding data query instructions are automatically generated according to the generated flow web page access daily table-city-Shanghai, wherein the flow web page access daily table is a table name required in the data query instructions, the field name can be determined as city according to the flow web page access daily table and the dimension, the corresponding query instructions are generated according to the determined table name, the field name and the dimension-index combinations, and further, the query instructions corresponding to all the dimension-index combinations can be generated through a traversal principle. And establishing an aperture system by using the dimension-index combination and the corresponding query instruction. The caliber system comprises a table name, a table field, dimension keywords, index keywords and query instructions corresponding to all dimension-index combinations. And the corresponding query instruction is automatically generated according to the dimension-index combination, and the corresponding query instruction is executed when the query is needed, so that the required source data can be queried from the data warehouse, the workload of a user is reduced, and the data processing efficiency is improved.
Has the advantages that: the embodiment of the invention establishes a keyword table; selecting at least one keyword as a dimension keyword according to a preset rule based on the keywords of the keyword table; selecting at least one keyword as an index keyword according to a preset rule based on the keywords of the keyword table; and automatically generating a query instruction corresponding to the dimension-index combination according to the dimension key words and the index key words, and establishing an aperture system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination. By the method, dimension-index setting is not needed manually, so that the caliber of the query instruction corresponding to the dimension-index combination can be automatically generated, a caliber system is established, the workload of a user is reduced, and the processing efficiency of the large data is improved.
Example two
The embodiment of the present invention further provides another method for establishing an aperture system, and specifically, as shown in fig. 2, a keyword table may be established through the following steps:
s1, establishing a keyword table;
the specific implementation of step S1 has been described in detail in the foregoing embodiments, and is not described herein again, and further, step S1 may also implement the following steps to establish the keyword table, specifically as follows:
s11, checking the data warehouse at intervals of preset time, and counting a source data table generated in the preset time, wherein the source data table comprises description fields;
and checking the data warehouse at preset time intervals, such as every day, verifying whether the original data in the data warehouse and the final data after daily updating are balanced or not, so that a user can extract and clean data with value for enterprises from the source data, and the source data in the data warehouse, which is unbalanced with the original data after daily updating, is cleaned and finally stored in the data warehouse. The data in the data warehouse will typically be retained for long periods of time for the enterprise to perform query operations for enterprise decision-making. Therefore, the data warehouse is checked every day, and the data base for the enterprise to perform query operation is provided.
And S12, replacing the description information in the description field by using keywords to establish a keyword table.
And counting a source data table generated in the preset time, wherein the source data table comprises at least one description field, the description field comprises corresponding description information, and the corresponding description information in the description field is replaced by keywords to establish a keyword table.
It should be noted that the keywords in the keyword table uniquely correspond to the description information corresponding to each line of source data. For example as shown in table 1 below:
TABLE 1
Table 1 is a keyword table 1 created after the description information in the traffic Web page access history table is replaced with keywords according to the definitions of the source data table.
As shown in table 2 below:
TABLE 2
Table 2 is a keyword table 2 created after the description information in the traffic Web page access calendar is replaced with keywords according to the definitions of the source data table.
S2, based on the keywords of the keyword table, selecting at least one keyword as a dimension keyword according to a preset rule;
preferably, on the basis of the above embodiment, in step S2, based on the keywords in the keyword table, at least one of the keywords is selected as a dimension keyword according to a preset rule, and the operation may be specifically performed in the following manner:
in a first mode
S21, acquiring a first source data table in the source data tables, and determining at least one primary key in the first source data table;
randomly acquiring a first source data table from a source data table generated in the process of checking the data warehouse within the preset time, determining at least one primary key in the first source data table, wherein the primary key is also called a primary key (primary key) and is a unique key in the table, the value of the primary key is used for uniquely identifying a certain record in the table, and a certain row of data in the table or a certain entity can be uniquely determined.
S22, calculating the times of taking at least one primary key in each first source data table as a foreign key;
and respectively calculating the times of taking each primary key as a foreign key by using at least one primary key determined in the first source data table. It should be noted that the foreign key is also called a foreign key, and if the public key is a primary key in one relationship, the public key is called a foreign key of another relationship, and the foreign key represents a relevant relationship between the two relationships. A table having a foreign key in another relationship as a primary key is referred to as a primary table, and a table having such a foreign key is referred to as a secondary table of the primary table. That is, the first source data table is a master table, the source data tables other than the first source data table are slave tables, and the number of times each of the master keys in the first source data table is used as a foreign key of the source data tables other than the first source data table is calculated.
S23, selecting the primary key with the frequency of being used as the foreign key being greater than or equal to a preset frequency threshold value from at least one primary key in the first source data table as the dimension key word of the first source data table, wherein the first source data table is any one of the source data tables;
the number of times that a certain primary key in the first source data table is used as a foreign key may be understood as the number of source data tables in a master-slave relationship with other source data tables in the data warehouse, and if the number of times that a certain primary key in the first source data table is used as a foreign key is greater than or equal to a preset number threshold, the primary key is used as a dimension key of the first source data table, and the dimension key is set as the dimension of the aperture system.
By selecting the keywords with the foreign key times larger than or equal to the preset time threshold as the dimension keywords, the accuracy of dimension selection is improved, the method can meet the requirement of big data processing, and meanwhile, the dimension keywords are selected by using foreign key statistics, so that the processing efficiency of later-stage data is improved, and the consistency of the data is kept.
Mode two
Step 1, acquiring a first source data table in the source data table, and determining at least one primary key in the first source data table;
randomly acquiring a first source data table from a source data table generated in the process of checking the data warehouse within the preset time, determining at least one primary key in the first source data table, wherein the primary key is also called a primary key (primary key) and is a unique key in the table, the value of the primary key is used for uniquely identifying a certain record in the table, and a certain row of data in the table or a certain entity can be uniquely determined.
Step 2, calculating the proportion of at least one primary key in each first source data table as a foreign key;
and respectively calculating the proportion of each primary key as a foreign key by using at least one primary key determined in the first source data table. It should be noted that the foreign key is also called a foreign key, and if the public key is a primary key in one relationship, the public key is called a foreign key of another relationship, and the foreign key represents a relevant relationship between the two relationships. A table having a foreign key in another relationship as a primary key is referred to as a primary table, and a table having such a foreign key is referred to as a secondary table of the primary table. That is, the first source data table is a master table, and the source data tables other than the first source data table are assumed to be slave tables, and the number of times each of the master keys in the first source data is used as the foreign key of the source data tables other than the first source data table is calculated.
And 3, selecting the primary key which is used as the foreign key and has the proportion larger than or equal to a preset proportion threshold value from at least one primary key in the first source data table as a dimension key word of the first source data table, wherein the first source data table is any one of the source data tables.
The ratio of a certain primary key in the first source data table as a foreign key may be understood as a ratio of the number of source data tables in a master-slave relationship between the first source data table and other source data tables in the data warehouse to the number of source data tables other than the first source data table, and if the ratio of the number of source data tables in a master-slave relationship between the first source data table and other source data tables in the data warehouse to the number of source data tables other than the first source data table is greater than or equal to a preset ratio threshold, the primary key is used as a dimension key of the first source data table, and the dimension key is set as a dimension of the aperture system.
The keywords with the foreign key number proportion larger than or equal to the preset proportion threshold are selected as the dimension keywords, accuracy of dimension selection is improved, the dimension selection can meet the requirement of big data processing, meanwhile, the dimension keywords are selected by foreign key statistics, processing efficiency of later-stage data is improved, and consistency of the data is kept.
S3, based on the keywords of the keyword table, selecting at least one keyword as an index keyword according to a preset rule;
preferably, on the basis of the above embodiment, in step S3, based on the keywords in the keyword table, at least one of the keywords is selected as an index keyword according to a preset rule, and the operation may be specifically performed in the following manner:
in a first mode
S31, acquiring a second source data table in the source data table, and determining at least one keyword except an exception key in the second source data table;
s32, calculating the use number of each keyword except the foreign key in the second source data table;
s33, selecting at least one keyword from at least one keyword in the second source data table except the foreign key as an index keyword, wherein the index keyword is a keyword of which the usage number is greater than or equal to a preset usage number threshold;
the second source data table is a data table of a subordinate relationship in the principal-subordinate relationship of the first source data table, and at least one keyword is determined except for a foreign key from the second source data table, wherein the at least one keyword does not include a primary keyword which is used as the foreign key and is used as a foreign key, and the frequency or the proportion of the foreign key is greater than or equal to a preset frequency threshold or a preset proportion threshold.
And respectively calculating the use number of at least one keyword except for the foreign key in each second source data table, selecting the keywords of which the use number is greater than or equal to a preset use number threshold value as index keywords, and setting the index keywords as indexes of the caliber system. By the method, the frequently-used keywords or inconsistent keywords can be screened, so that data cleaning of a data warehouse is facilitated, the data utilization efficiency is improved, and the data consistency is kept.
Mode two
Step 1, acquiring a second source data table in the source data table, and determining at least one keyword except an exclusive key in the second source data table;
step 2, calculating the utilization rate of each keyword except the foreign key in the second source data table;
step 3, selecting at least one keyword from at least one keyword except the foreign key in the second source data table as an index keyword, wherein the index keyword is a keyword of which the utilization rate is greater than or equal to a preset utilization rate threshold value;
the second source data table is a data table of a subordinate relationship in the principal-subordinate relationship of the first source data table, and at least one keyword is determined except for a foreign key from the second source data table, wherein the at least one keyword does not include a primary keyword which is used as the foreign key and is used as a foreign key, and the frequency or the proportion of the foreign key is greater than or equal to a preset frequency threshold or a preset proportion threshold.
And respectively calculating the utilization rate of at least one keyword except the foreign key in each second source data table, selecting the keyword of which the utilization rate is greater than or equal to a preset utilization rate threshold value as an index keyword, and setting the index keyword as an index of the aperture system. By the method, keywords with low utilization rate or inconsistent keywords can be screened, data cleaning of a data warehouse is facilitated, data utilization efficiency is improved, and data consistency is kept.
Mode III
Step 1, acquiring a second source data table in the source data table, and determining at least one keyword except an exclusive key in the second source data table;
step 2, calculating the use frequency of each keyword except the foreign key in the second source data table;
and 3, selecting at least one keyword from at least one keyword except the foreign key in the second source data table as an index keyword, wherein the index keyword is a keyword of which the use number is greater than or equal to a preset use frequency threshold value.
The second source data table is a data table of a subordinate relationship in the principal-subordinate relationship of the first source data table, and at least one keyword is determined except for a foreign key from the second source data table, wherein the at least one keyword does not include a primary keyword which is used as the foreign key and is used as a foreign key, and the frequency or the proportion of the foreign key is greater than or equal to a preset frequency threshold or a preset proportion threshold.
And respectively calculating the use frequency of at least one keyword except for the foreign key in each second source data table, selecting the keyword of which the use frequency is greater than or equal to a preset use frequency threshold value as an index keyword, and setting the index keyword as an index of the aperture system. By the method, keywords with low utilization rate or inconsistent keywords can be screened, data cleaning of a data warehouse is facilitated, data utilization efficiency is improved, and data consistency is kept.
And S4, automatically generating a query instruction corresponding to the dimension-index combination according to the dimension key words and the index key words, and establishing an aperture system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination.
Has the advantages that: according to the embodiment of the invention, the source data table for performing data warehouse number checking statistics at regular intervals is used for replacing the description information corresponding to the description field in the source data table by using the keywords, so that the keyword table is established, whether the source data in the data warehouse and the updated final data are balanced or not is periodically verified, the data consistency is favorably improved, so that a user can extract and clear the data with useful value for an enterprise from the source data, and the data are finally stored in the data warehouse, and a data basis for the enterprise to perform query operation is provided; automatically generating a dimension-index caliber combination according to the keyword table, and establishing a caliber system, so that the generated dimension-index combination can be adapted to the data change of the data warehouse, and the data change of the data warehouse can be better reflected; based on the keywords of the keyword table, selecting the keywords with the times or the proportion larger than or equal to a preset time threshold or a preset proportion threshold as the dimension keywords, so that the accuracy of dimension selection is improved, the dimension selection can be more suitable for the requirement of big data processing, and meanwhile, the dimension keywords are selected by utilizing foreign key statistics, so that the processing efficiency of later data is improved and the consistency of the data is kept; based on the keywords of the keyword table, the keywords of which the use number, the use rate and the use frequency reach threshold values are selected from the keywords except the foreign keys to serve as index keywords, so that the keywords with low use rate or inconsistent keywords can be screened, data cleaning of a data warehouse is facilitated, the data utilization efficiency is improved, and the data consistency is kept; and automatically generating a query instruction corresponding to the dimension-index combination according to the dimension key words and the index key words, and establishing an aperture system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination. By the method, dimension-index setting is not needed manually, so that the caliber of the query instruction corresponding to the dimension-index combination can be automatically generated, a caliber system is established, the workload of a user is reduced, and the processing efficiency of the large data is improved.
EXAMPLE III
On the basis of the above embodiment, the present invention further provides another caliber system establishing method, which specifically includes the following steps, as shown in fig. 3:
s1, establishing a keyword table;
s2, based on the keywords of the keyword table, selecting at least one keyword as a dimension keyword according to a preset rule;
s3, based on the keywords of the keyword table, selecting at least one keyword as an index keyword according to a preset rule;
the specific implementation of steps S1-S3 has been described in detail in the above embodiments, and will not be described herein.
And S4, automatically generating a query instruction corresponding to the dimension-index combination according to the dimension key words and the index key words, and establishing an aperture system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination.
Preferably, on the basis of the above embodiment, the step S4 automatically generates a query instruction corresponding to the dimension-index combination according to the dimension keyword and the index keyword, and establishes the caliber system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination, which may specifically include the following steps:
s41, performing dimension splitting according to the dimension keywords and different theme categories, and storing the split dimension keywords into a plurality of dimension tables, wherein the dimension tables correspond to the theme categories;
and dimension splitting is carried out on the dimension keywords according to different topic categories, wherein the topic categories can be preset, dimension splitting is carried out on all the dimension keywords, the dimension keywords after splitting are stored in a plurality of different dimension tables, and each dimension table corresponds to one topic category. For example, the theme categories of the dimension keyword login ID, the page ID, the browser cookie and the dimension keyword login ID, the page ID, the browser cookie, the IP, the city and the channel identifier in table 1 and table 2 are Web, the theme categories can be preset as App, user behavior and the like, and the dimension keywords are split according to the theme categories, so that the management of the mass data in different dimensions and layers is realized, the collection and storage of the mass data and the fast and accurate data query are realized, the data processing efficiency is improved, and a timely and accurate data basis is provided for the decision of enterprises.
S42, according to the index keywords, index splitting is carried out according to different dimensionalities, and the split index keywords are stored into a plurality of index tables, wherein the index tables correspond to the multiple dimensionalities;
it should be noted that, in the step S41, the index keywords are subjected to dimension splitting according to different topic categories, where the topic categories may be preset, all the index keywords are subjected to dimension splitting, and the split index keywords are stored in a plurality of different index tables, where each index table corresponds to one topic category. For example, the first access date, the last access date, the insertion time, the user insertion date and the partition date of the index keyword in table 1, and the subject category of the access times, the landing page times, the page exit times, the insertion time, the user insertion date and the partition date of the index keyword in table 2 are Web, it can be seen that the index keyword whose subject category is Web is the attribute value of the dimension keyword in step S41, the subject category can also be preset to App, the user behavior and the like, the index keyword is split according to the subject category, and the management of the mass data in the dimension and hierarchy is realized, so that the collection, the storage and the rapid and accurate data query of the mass data are realized, the data processing efficiency is improved, and a timely and accurate data basis is provided for the decision of an enterprise.
And S43, automatically generating a dimension-index combination table according to the index tables and the dimension tables, wherein the dimension-index combination table comprises the dimension-index combination and the query instruction corresponding to the dimension-index combination, and establishing a caliber system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination.
Automatically generating a dimension-index combination table from the plurality of index tables and the plurality of dimension tables, for example, as shown in table 3 below:
TABLE 3
Table 3 is a dimension-index combination table, which includes subject categories, dimensions and indexes, and is only for illustration and not intended to limit the scope of the present invention.
According to the dimension-index combination in table 3, a corresponding query instruction is automatically generated, for example, the city-visit number, that is, the query subject category in the data warehouse is Web, the website visit number of the current day of the city is specified, the query instruction with the query subject type being Web and the website visit number of the current day of the city is automatically generated, in the query instruction, the parameter related to the specific specified city or visit number may be a variable, according to the specific required parameter input by the user, by executing the assigned query instruction, the corresponding source data meeting the user input parameter can be obtained by querying from the data warehouse, and the source data query efficiency is improved.
Each dimension-index combination in table 3 corresponds to a query instruction, and a caliber system is established by using the dimension-index combination and the query instruction corresponding to the dimension-index combination, as shown in table 4:
TABLE 4
If a user needs to inquire the source data corresponding to the dimension-index combination, the corresponding inquiry instruction is determined according to the dimension-index combination, the specific inquiry parameter is input, the inquiry instruction after assignment is automatically executed, and the inquiry of the source data corresponding to the dimension-index combination from the data warehouse is completed.
Has the advantages that: the embodiment of the invention establishes a keyword table; selecting at least one keyword as a dimension keyword according to a preset rule based on the keywords of the keyword table; selecting at least one keyword as an index keyword according to a preset rule based on the keywords of the keyword table; performing dimensionality splitting according to the dimensionality key words and different theme categories, storing the split dimensionality key words into a plurality of dimensionality tables, wherein the dimension tables correspond to the theme categories, splitting the dimensionality key words according to the theme categories, and realizing management of the dimensionality and the hierarchy of mass data, so that the collection, storage and rapid and accurate data query of the mass data are realized, the data processing efficiency is improved, and a timely and accurate data basis is provided for enterprise decisions; index splitting is carried out according to the index keywords and different dimensions, the split index keywords are stored into a plurality of index tables, and the index tables correspond to the dimensions; and automatically generating a dimension-index combination table according to the index tables and the dimension tables, wherein the dimension-index combination table comprises the dimension-index combination and the query instruction corresponding to the dimension-index combination, and establishing a caliber system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination. By the method, the dimension-index does not need to be manually set, so that the caliber of the query instruction corresponding to the dimension-index combination can be automatically generated, and a caliber system is established.
Example four
An embodiment of the present invention provides an apparatus 400 for establishing an aperture system, as shown in fig. 4, the apparatus includes:
a first establishing module 410, configured to establish a keyword table;
a dimension selecting module 420, configured to select at least one keyword as a dimension keyword according to a preset rule based on the keyword of the keyword table;
an index selecting module 430, configured to select at least one keyword as an index keyword according to a preset rule based on the keyword of the keyword table;
a second establishing module 440, configured to automatically generate a query instruction corresponding to the dimension-index combination according to the dimension keyword and the index keyword, and establish an aperture system using the dimension-index combination and the query instruction corresponding to the dimension-index combination
The apparatus 400 provided in the embodiment of the present invention is a method corresponding to the above-mentioned embodiment, and the apparatus 400 further includes several units, which are used for implementing corresponding functions corresponding to corresponding steps of the above-mentioned method. Since the steps of the method have been described in detail in the above embodiments, they are not repeated in this apparatus 400.
Preferably, the first establishing module 410 specifically includes:
the statistical unit is used for checking the data warehouse at intervals of preset time and counting a source data table generated in the preset time, wherein the source data table comprises a description field;
and the first establishing unit is used for replacing the description information in the description field by using a keyword to establish a keyword table.
Preferably, the second establishing module 440 specifically includes:
the dimension splitting unit is used for performing dimension splitting according to the dimension keywords and different theme categories, and storing the split dimension keywords into a plurality of dimension tables, wherein the dimension tables correspond to the theme categories;
the index splitting unit is used for splitting indexes according to the index keywords and different dimensions, and storing the split index keywords into a plurality of index tables, wherein the index tables correspond to the dimensions;
and the second establishing unit is used for automatically generating a dimension-index combination table according to the external keys of the index tables and the dimension tables, wherein the dimension-index combination table comprises the dimension-index combination and the query instruction corresponding to the dimension-index combination, and the dimension-index combination and the query instruction corresponding to the dimension-index combination are utilized to establish the caliber system.
Has the advantages that: the embodiment of the invention establishes a keyword table through a first establishing module; the dimension selection module selects at least one keyword as a dimension keyword according to a preset rule based on the keywords of the keyword table; the index selection module selects at least one keyword as an index keyword according to a preset rule based on the keywords of the keyword table, the dimension splitting unit of the second establishment module splits the dimension according to the dimension keywords and different subject categories and stores the split dimension keywords into a plurality of dimension tables, the dimension tables correspond to the plurality of subject categories, and the index splitting unit of the second establishment module splits the dimension keywords according to the subject categories to realize management of the dimension hierarchy of the mass data, so that the collection, storage and rapid and accurate data query of the mass data are realized, the data processing efficiency is improved, and a timely and accurate data basis is provided for enterprise decision making; index splitting is carried out according to the index keywords and different dimensions, the split index keywords are stored into a plurality of index tables, and the index tables correspond to the dimensions; and automatically generating a dimension-index combination table according to the index tables and the dimension tables, wherein the dimension-index combination table comprises the dimension-index combination and the query instruction corresponding to the dimension-index combination, and establishing a caliber system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination. By the method, the query efficiency of the data warehouse source data can be effectively improved, the workload of a user is reduced, and the processing efficiency of the big data is improved.
EXAMPLE five
An embodiment of the present invention further provides an aperture system creating apparatus 500, where the apparatus includes a memory 510, a processor 520, and a computer program 530 stored in the memory 510 and executable on the processor 520, where the processor 520 executes the computer program 530 to implement any of the steps of the aperture system creating method described in the above embodiments.
The embodiment of the present invention further provides a computer storage medium, where the computer storage medium may store a program, and when the program is executed, the program includes some or all of the steps of any one of the aperture system establishment methods described in the above method embodiments.
It should be noted that, for simplicity of description, the above-mentioned method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present invention is not limited by the order of acts, as some steps may occur in other orders or concurrently in accordance with the invention. Further, those skilled in the art should also appreciate that the embodiments described in the specification are preferred embodiments and that the acts and modules referred to are not necessarily required by the invention.
In the foregoing embodiments, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus may be implemented in other manners. For example, the above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one type of division of logical functions, and there may be other divisions when actually implementing, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not implemented. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of some interfaces, devices or units, and may be an electric or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable memory. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a memory and includes several instructions for causing a computer device (which may be a personal computer, a server, a network device, or the like) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned memory comprises: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.
Those skilled in the art will appreciate that all or part of the steps in the methods of the above embodiments may be implemented by associated hardware instructed by a program, which may be stored in a computer-readable memory, which may include: flash Memory disks, Read-Only memories (ROMs), Random Access Memories (RAMs), magnetic or optical disks, and the like.
The above embodiments of the present invention are described in detail, and the principle and the implementation of the present invention are explained by applying specific embodiments, and the above description of the embodiments is only used to help understanding the method of the present invention and the core idea thereof; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
Claims (10)
1. A method for establishing an aperture system, the method comprising:
establishing a keyword table;
selecting at least one keyword as a dimension keyword according to a preset rule based on the keywords of the keyword table;
selecting at least one keyword as an index keyword according to a preset rule based on the keywords of the keyword table;
and automatically generating a query instruction corresponding to the dimension-index combination according to the dimension key words and the index key words, and establishing an aperture system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination.
2. The caliber system establishing method of claim 1, wherein the establishing a keyword table specifically comprises:
checking the data warehouse at intervals of preset time, and counting a source data table generated in the preset time, wherein the source data table comprises description fields;
and replacing the description information in the description field by using a keyword to establish a keyword table.
3. The caliber system establishing method of claim 2, wherein the selecting of at least one keyword as the dimension keyword according to a preset rule based on the keyword of the keyword table specifically comprises:
acquiring a first source data table in the source data table, and determining at least one primary key in the first source data table;
calculating the times of taking at least one primary key in each first source data table as a foreign key;
selecting the primary key which is used as the foreign key and has the frequency larger than or equal to a preset frequency threshold value from at least one primary key in the first source data table as a dimension key word of the first source data table, wherein the first source data table is any one of the source data tables;
alternatively, the first and second electrodes may be,
calculating the proportion of at least one primary key in each first source data table as a foreign key;
and selecting the primary key which is used as the foreign key and has the proportion larger than or equal to a preset proportion threshold value from at least one primary key in the first source data table as a dimension key word of the first source data table, wherein the first source data table is any one of the source data tables.
4. The caliber system establishing method of claim 3, wherein the selecting of at least one keyword as an index keyword according to a preset rule based on the keyword of the keyword table specifically comprises:
acquiring a second source data table in the source data tables, and determining at least one keyword except for an exception key in the second source data table, wherein the second source data table is any one source data table except for the first source data table in the source data tables;
calculating the use number of each keyword except the foreign key in the second source data table;
selecting at least one keyword from at least one keyword in the second source data table except the foreign key as an index keyword, wherein the index keyword is a keyword of which the use number is greater than or equal to a preset use number threshold;
alternatively, the first and second electrodes may be,
calculating the utilization rate of each keyword except the foreign key in the second source data table;
selecting at least one keyword from at least one keyword in the second source data table except the foreign key as an index keyword, wherein the index keyword is a keyword of which the utilization rate is greater than or equal to a preset utilization rate threshold value;
alternatively, the first and second electrodes may be,
calculating the use frequency of each keyword in the second source data table except the foreign key;
and selecting at least one keyword from at least one keyword in the second source data table except the foreign key as an index keyword, wherein the index keyword is a keyword of which the use number is greater than or equal to a preset use frequency threshold value.
5. The method for establishing an aperture system according to any one of claims 1 to 4, wherein the automatically generating a query instruction corresponding to a dimension-index combination according to the dimension keyword and the index keyword, and establishing the aperture system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination specifically comprises:
dimension splitting is carried out according to the dimension keywords and different theme categories, the split dimension keywords are stored into a plurality of dimension tables, and the dimension tables correspond to the theme categories;
index splitting is carried out according to the index keywords and different dimensions, the split index keywords are stored into a plurality of index tables, and the index tables correspond to the dimensions;
and automatically generating a dimension-index combination table according to the external keys of the index tables and the dimension tables, wherein the dimension-index combination table comprises the dimension-index combination and the query instruction corresponding to the dimension-index combination, and establishing a caliber system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination.
6. An aperture system establishing device, characterized in that the device specifically comprises:
the first establishing module is used for establishing a keyword table;
the dimension selection module is used for selecting at least one keyword as a dimension keyword according to a preset rule based on the keywords of the keyword table;
the index selection module is used for selecting at least one keyword as an index keyword according to a preset rule based on the keywords of the keyword table;
and the second establishing module is used for automatically generating a query instruction corresponding to the dimension-index combination according to the dimension key words and the index key words and establishing an aperture system by using the dimension-index combination and the query instruction corresponding to the dimension-index combination.
7. The aperture system creating device according to claim 6, wherein the first creating module specifically includes:
the statistical unit is used for checking the data warehouse at intervals of preset time and counting a source data table generated in the preset time, wherein the source data table comprises a description field;
and the first establishing unit is used for replacing the description information in the description field by using a keyword to establish a keyword table.
8. The aperture system creating device according to claim 7, wherein the second creating module specifically includes:
the dimension splitting unit is used for performing dimension splitting according to the dimension keywords and different theme categories, and storing the split dimension keywords into a plurality of dimension tables, wherein the dimension tables correspond to the theme categories;
the index splitting unit is used for splitting indexes according to the index keywords and different dimensions, and storing the split index keywords into a plurality of index tables, wherein the index tables correspond to the dimensions;
and the second establishing unit is used for automatically generating a dimension-index combination table according to the external keys of the index tables and the dimension tables, wherein the dimension-index combination table comprises the dimension-index combination and the query instruction corresponding to the dimension-index combination, and the dimension-index combination and the query instruction corresponding to the dimension-index combination are utilized to establish the caliber system.
9. An aperture system apparatus comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of an aperture system establishment method according to any of claims 1 to 5 when executing the computer program.
10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of a method for the creation of an aperture system as claimed in any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911089780.0A CN110837508A (en) | 2019-11-08 | 2019-11-08 | Method, device and equipment for establishing aperture system and computer storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911089780.0A CN110837508A (en) | 2019-11-08 | 2019-11-08 | Method, device and equipment for establishing aperture system and computer storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110837508A true CN110837508A (en) | 2020-02-25 |
Family
ID=69574981
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911089780.0A Pending CN110837508A (en) | 2019-11-08 | 2019-11-08 | Method, device and equipment for establishing aperture system and computer storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110837508A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111552679A (en) * | 2020-04-09 | 2020-08-18 | 苏宁金融科技(南京)有限公司 | Rapid modeling method and device based on simple requirements |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103577590A (en) * | 2013-11-12 | 2014-02-12 | 北京润乾信息系统技术有限公司 | Data query method and system |
| CN109062946A (en) * | 2018-06-21 | 2018-12-21 | 深圳市彬讯科技有限公司 | It is a kind of to highlight method and device based on multiple web pages |
| CN109144997A (en) * | 2018-06-11 | 2019-01-04 | 玖富金科控股集团有限责任公司 | Data correlation method, device and storage medium |
| CN109388654A (en) * | 2017-08-04 | 2019-02-26 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus for inquiring tables of data |
| CN110321344A (en) * | 2019-05-20 | 2019-10-11 | 平安普惠企业管理有限公司 | Information query method, device, computer equipment and the storage medium of associated data |
| CN110716950A (en) * | 2019-09-20 | 2020-01-21 | 黄沙沙 | Method, device and equipment for establishing aperture system and computer storage medium |
-
2019
- 2019-11-08 CN CN201911089780.0A patent/CN110837508A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103577590A (en) * | 2013-11-12 | 2014-02-12 | 北京润乾信息系统技术有限公司 | Data query method and system |
| CN109388654A (en) * | 2017-08-04 | 2019-02-26 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus for inquiring tables of data |
| CN109144997A (en) * | 2018-06-11 | 2019-01-04 | 玖富金科控股集团有限责任公司 | Data correlation method, device and storage medium |
| CN109062946A (en) * | 2018-06-21 | 2018-12-21 | 深圳市彬讯科技有限公司 | It is a kind of to highlight method and device based on multiple web pages |
| CN110321344A (en) * | 2019-05-20 | 2019-10-11 | 平安普惠企业管理有限公司 | Information query method, device, computer equipment and the storage medium of associated data |
| CN110716950A (en) * | 2019-09-20 | 2020-01-21 | 黄沙沙 | Method, device and equipment for establishing aperture system and computer storage medium |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111552679A (en) * | 2020-04-09 | 2020-08-18 | 苏宁金融科技(南京)有限公司 | Rapid modeling method and device based on simple requirements |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11119834B2 (en) | Artificial creation of dominant sequences that are representative of logged events | |
| CN105247507B (en) | Method, system and storage medium for the influence power score for determining brand | |
| CN102667761B (en) | Scalable cluster database | |
| JP5538510B2 (en) | Extensive user clustering based on set similarity | |
| JP5801291B2 (en) | Merging search results | |
| US9519862B2 (en) | Domains for knowledge-based data quality solution | |
| US10162892B2 (en) | Identifying information assets within an enterprise using a semantic graph created using feedback re-enforced search and navigation | |
| US20130117202A1 (en) | Knowledge-based data quality solution | |
| US20120166438A1 (en) | System and method for recommending queries related to trending topics based on a received query | |
| US20130117219A1 (en) | Architecture for knowledge-based data quality solution | |
| CN108027818A (en) | Inquiry based on figure | |
| CN110716950A (en) | Method, device and equipment for establishing aperture system and computer storage medium | |
| CN111008521A (en) | Method and device for generating wide table and computer storage medium | |
| US20140289268A1 (en) | Systems and methods of rationing data assembly resources | |
| CN110737432B (en) | Script aided design method and device based on root list | |
| CN103917970B (en) | Keyword search of customer interest in an enterprise | |
| US20140114982A1 (en) | Automatic taxonomy merge | |
| CN114969528A (en) | User portrait and learning path recommendation method, device and equipment based on capability evaluation | |
| US9594756B2 (en) | Automated ranking of contributors to a knowledge base | |
| CN110837508A (en) | Method, device and equipment for establishing aperture system and computer storage medium | |
| CN110837365A (en) | Script aided design method and device based on root table | |
| CN115203435A (en) | Entity relation generation method and data query method based on knowledge graph | |
| CN114860759A (en) | Data processing method, device and equipment and readable storage medium | |
| Aydin et al. | Data modelling for large-scale social media analytics: design challenges and lessons learned | |
| US11410098B1 (en) | Method for computational modelling and analysis of the skills and competencies of individuals |
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 | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 518000 R & D building 3501, block a, building 7, Vanke Cloud City Phase I, Xingke 1st Street, Xili community, Xili street, Nanshan, Shenzhen, Guangdong Applicant after: Tubatu Group Co.,Ltd. Address before: 1001-a, 10th floor, bike technology building, No.9, Keke Road, high tech Zone, Nanshan District, Shenzhen, Guangdong 518000 Applicant before: SHENZHEN BINCENT TECHNOLOGY Co.,Ltd. |
|
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200225 |