CN107301211B - Online data processing method - Google Patents
Online data processing method Download PDFInfo
- Publication number
- CN107301211B CN107301211B CN201710422162.8A CN201710422162A CN107301211B CN 107301211 B CN107301211 B CN 107301211B CN 201710422162 A CN201710422162 A CN 201710422162A CN 107301211 B CN107301211 B CN 107301211B
- Authority
- CN
- China
- Prior art keywords
- label
- product
- tag
- rule set
- product label
- 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
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/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- 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
- G06F16/2291—User-Defined Types; Storage management thereof
-
- 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
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0637—Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/083—Shipping
- G06Q10/0831—Overseas transactions
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0201—Market modelling; Market analysis; Collecting market data
- G06Q30/0206—Price or cost determination based on market factors
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Development Economics (AREA)
- Finance (AREA)
- Databases & Information Systems (AREA)
- Accounting & Taxation (AREA)
- Data Mining & Analysis (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Tourism & Hospitality (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Game Theory and Decision Science (AREA)
- Educational Administration (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an online data processing method, which comprises the following steps: (1) defining the attribute of the product label and the rule set of the product label; (2) a step of sharing and downloading product labels; (3) and screening data by using the product label. The method avoids the complexity of repeated data rule sets in the traditional trade data screening, and meanwhile, the trade analyst who is not familiar with the specific product can also screen the data by downloading the product labels of other users.
Description
Technical Field
The present invention relates to data processing, and more particularly, to an online data processing method.
Background
With the continuous development of import and export trade in China, import and export enterprises need to accurately know the development dynamic of the current industry, grasp the positions of import and export commodities of the enterprises in the whole industry in the aspects of quality, price, import and export destinations and the like, adjust enterprise strategies in time, and improve the competitiveness of the enterprises.
Import and export trade analysis is mainly to screen out commodity data related to the enterprise by using original import and export data obtained from customs, ports, statistical bureaus and the like, and further to perform trend analysis in various aspects such as specification, quantity, price, production enterprises, export enterprises, import and export destinations and the like of commodities, so that competitive price strategies, purchasing strategies, import and export strategies and the like are made for import and export commodities of the enterprise.
The traditional trade data screening method is to utilize Excel, Word and other tool software to process and sort the original data, judge from many aspects such as specification, price and the like, and continuously screen out the data meeting the requirements of the user. However, the traditional trade data screening method is mostly carried out by a single person due to the limitation of using tools, and for the analysis of the same commodity in different time periods, conditions such as price and specification need to be repeatedly input for screening, so that the repeated utilization of a rule set cannot be realized, and the method cannot be shared with other people; meanwhile, due to the characteristics of the traditional trade data screening method, an analyst is more concentrated on screening familiar products, and for unfamiliar products, the analyst who is familiar with the product needs to give screening because the analyst does not know the price, the market demand and the like, or the analyst needs to look up data and know the market to be familiar with the product and then perform data screening, so that a large amount of labor and time cost are consumed.
Disclosure of Invention
Aiming at the defects of the prior art, the invention aims to provide an online data processing method, which solves the limitations of the traditional trade data screening method, realizes the reusability of a screening rule set and can be shared by multiple persons.
In order to achieve the purpose, the technical scheme of the invention is as follows: an online data processing method, comprising: (1) defining the attribute of the product label and the rule set of the product label; (2) a step of sharing and downloading product labels; (3) and screening data by using the product label.
As an improvement of the invention, the attribute of the product label is the self-owned feature of a specific product label, including the name of the label, the import and export type, the bill carrying or closing type, the product name to which the label can be applied, the source country of the label query data, the label description, and whether to share.
As an improvement of the present invention, the rule set of the product label is a specific query condition, which includes a customs code, a product name, an import-export merchant, an import source country or an export destination country, an import-export city, a transportation mode, a customs name, a price range, and a time range.
As an improvement of the invention, the step of sharing the product label comprises setting a sharing identifier on the product label and storing the sharing identifier in the product label database.
As an improvement of the invention, said step of downloading a product label comprises downloading a product label from said product label database.
As an improvement of the present invention, when defining a product tag, setting a shared tag attribute in product tag attributes to set whether the product tag to be defined is a shared tag or a common tag, when a user clicks a save button after filling in tag attributes and tag rule set information, the attribute information of the product tag is saved in a product tag definition table of a database, and the rule set information of the product is saved in a product tag rule set table of the database, and one product tag may include a plurality of rule set information.
As an improvement of the present invention, the step of downloading the product label comprises:
g. firstly, copying basic attribute information and rule set information of downloaded product tags into a cache for processing.
h. And replacing the tag ID of the basic attribute information of the downloaded product tag in the cache by using a new ID value, and simultaneously replacing the corresponding original tag ID value in the rule set information of the downloaded product tag by using the new ID value.
i. And replacing the original ID value in the rule set information of the downloaded product label in the cache with the newly generated ID value.
j. And modifying the ID of the main account, the ID of the creating user and the ID of the modifying user in the basic attributes of the downloaded product tags in the cache into the ID of the user A, changing the creating date into the current system time, and clearing the modifying date, the deleting person and the deleting date.
k. And setting the ID of the source user of the label in the basic attribute of the downloaded product label in the cache as the ID of the user B.
And setting whether the tag attribute is shared or not to be in a non-shared state, and resetting the downloading times to be 0 so as to record the downloading amount of the tag when the user modifies the tag to be the shared tag next time.
Compared with the prior art, the method avoids the complexity of repeated data rule sets in the traditional trade data screening, and meanwhile, the method can also be used for screening data by downloading product labels of other users for trade analysts who are not familiar with specific products.
Drawings
The structure and advantageous effects of the present invention will be described in detail with reference to the accompanying drawings and the detailed description.
FIG. 1 is a flow chart diagram of an online data processing method of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantageous technical effects of the present invention clearer, the present invention is described in further detail below with reference to the accompanying drawings and the detailed description. It should be understood that the detailed description and specific examples, while indicating the preferred embodiment of the invention, are intended for purposes of illustration only and are not intended to limit the scope of the invention.
The product label of the online data processing method comprises several modules of label attribute, label rule set, label downloading, function and result set display and the like; the tag attribute specifies the self-characteristics of a specific product tag, including the name of the tag, the import and export type, the bill drawing or closing type, the product name applicable to the tag, the source country of the tag query data, the tag description, whether to share the tag, and the like; the label rule set defines specific query conditions of the label, including customs code (customs clearance), product name (bill of lading), import and export merchants, import source country or export destination country, import and export cities, transportation mode, customs name, price range, time range and the like; the label downloading means that after the product label is shared, other users can download and use the product label, after the product label is downloaded, the original author information of the product label is still kept, and the user can further modify the label according to the understanding of the user on the label; the functional module manages and uses the label, including the storage, deletion, inquiry and the like of the label; the result set is displayed in a mode of graph after the user clicks the query button, and the result set comprises information of data such as country, city, import and export modes, product name, time, import and export merchants, quantity, price, transportation mode and the like. The product label divides the screening process of original trade data into different stages, namely three stages of rule set definition, sharing and downloading and data screening, and separates the rule definition from the data screening, thereby realizing one-time definition, multi-person sharing and multiple screening. All users are connected to a background database through a network by using a Web browser, and definition information of all labels is recorded in the database. After an experienced data analyst defines a product tag, a shared identifier can be added to the tag and stored in a background database, other users can download and use the tag after logging in a system, and after the tag is downloaded, the user can further edit the tag according to needs to meet the data screening requirements of the user.
When defining the product label, whether the product label to be defined currently is a shared label or a common label can be set by setting a shared label attribute in the product label attribute, and the default is the common label. When the user clicks the save button after completing the filling of the label attribute and the label rule set information, the attribute information of the product label is saved in the product label definition table of the database, the rule set information of the product is saved in the product label rule set table of the database, and one product label can contain a plurality of rule set information. The product label created by the user and the downloaded shared label can modify the label according to the specific situation of the user, including modifying the basic attribute information of the label (including whether to share), adjusting the rule set information of the label, and the like, so that the user can use the label to filter data. When the user switches to the shared label column, a product label list (default sorting according to the descending order of the downloading amount of the product labels, and multiple modes of selection for the user, such as sharing time ascending and descending order, keyword search and the like, can be provided) can be seen, the list contains all the shared product labels defined by the user and the system, and the information of the name, the author, the downloading button and the like of each product label can be directly seen. If the user needs to know more information of the product label, the user can directly click the product name to check the label attribute and the detailed information of the rule set of the product label, and meanwhile, the user can also directly use the current product label to perform data screening.
Referring to fig. 1, the online data processing method of the present invention includes the steps of: (1) a user A (an experienced analyst) logs in the trade analysis system through a Web browser and enters a product label definition page; (2) defining a product label: inputting attribute information and rule set information of a product label; (3) the user A can utilize a defined product label to screen trade data, and can add a shared identifier to the label; (4) clicking a storage button to store the defined product label into a background database for downloading by other users; (5) a user B logs in the trade analysis system through a Web browser and enters a product label page; (6) the user B can see the information of the product label name, the author and the like shared by the user A on the product label page, the label can be downloaded and used by clicking the download button of the label, all attribute information and the definition of the rule set of the label can be seen after downloading, and the label can be further modified according to the own needs; (7) and clicking a query button to apply the label to screen the trade data, and displaying the screened result in a data list.
When the user A clicks and downloads the product label shared by the user B, the system distributes the shared product label information of the user B to the user A after certain processing, so that the user A has a product label which is the same as that of the user B, and the downloading process is as follows:
firstly, copying basic attribute information and rule set information of a downloaded product label (a product label shared by a user B) into a cache for processing.
And m, replacing the tag ID of the basic attribute information of the downloaded product tag in the cache with a new ID value, and simultaneously replacing the corresponding original tag ID value in the rule set information of the downloaded product tag with the new ID value.
n. replacing the original ID value in the rule set information of the downloaded product label in the cache with the newly generated ID value.
And o, modifying the ID of the main account, the ID of the creating user and the ID of the modifying user in the basic attributes of the downloaded product tags in the cache into the ID of the user A, changing the creating date into the current system time, and clearing the modifying date, the deleting person and the deleting date.
And p, setting the ID of the source user of the label in the basic attribute of the downloaded product label in the cache as the ID of the user B.
And q, setting whether the tag attribute is shared or not to be in a non-shared state, and resetting the downloading times to be 0 so as to record the downloading amount of the tag when the user modifies the tag to be the shared tag next time.
And r, inserting the modified label attribute information into a corresponding product label definition table in the database, and inserting the modified label rule set information into a corresponding product label rule set table in the database.
Appropriate changes and modifications to the embodiments described above will become apparent to those skilled in the art from the disclosure and teachings of the foregoing description. Therefore, the present invention is not limited to the specific embodiments disclosed and described above, and some modifications and variations of the present invention should fall within the scope of the claims of the present invention. Furthermore, although specific terms are employed herein, they are used in a generic and descriptive sense only and not for purposes of limitation.
Claims (6)
1. An online data processing method, comprising:
(1) defining the attribute of the product label and the rule set of the product label;
(2) a step of sharing and downloading product labels;
(3) screening data by using the product label;
the step of downloading the product label comprises:
a. firstly, copying basic attribute information and rule set information of downloaded product tags into a cache for processing;
b. replacing the tag ID of the basic attribute information of the downloaded product tag in the cache with a new ID value, wherein the new ID value is also used for replacing the corresponding original tag ID value in the rule set information of the downloaded product tag;
c. replacing the original ID value in the rule set information of the downloaded product label in the cache with the newly generated ID value;
d. modifying the ID of the main account, the ID of the creation user and the ID of the modification user in the basic attribute of the downloaded product label in the cache into the ID of the user A, changing the creation date into the current system time, and clearing the modification date, the deletion person and the deletion date;
e. setting the ID of a tag source user in the basic attribute of the downloaded product tag in the cache as the ID of a user B;
f. whether the tag attribute is shared or not is set to be in a non-shared state, and the downloading frequency is reset to be 0, so that the downloading amount of the tag can be recorded when a user modifies the tag to be a shared tag next time;
and inserting the modified label attribute information into a corresponding product label definition table in the database, and inserting the modified label rule set information into a corresponding product label rule set table in the database.
2. The on-line data processing method as claimed in claim 1, wherein the attribute of the product label is an inherent feature of a specific product label, including a name of the label, a import/export type, a bill raising or closing type, a product name to which the label is applicable, a source country of the label query data, a label description, and whether to share.
3. The online data processing method of claim 1, wherein the rule set of the product label is a specific query condition, and comprises a customs code, a product name, an import/export firm, an import/export country, an import/export city, a transportation mode, a customs name, a price range, and a time range.
4. The online data processing method of claim 1, wherein the step of sharing the product tag comprises setting a sharing identifier on the product tag and storing the sharing identifier in a product tag database.
5. The online data processing method of claim 4, wherein the step of downloading a product label comprises downloading a product label from the product label database.
6. The on-line data processing method as claimed in claim 1, wherein when defining the product label, setting whether the product label to be defined is a shared label or a common label by setting a shared label attribute in the product label attributes, when a user clicks a save button after completing filling in the label attributes and the label rule set information, the attribute information of the product label is saved in a product label definition table of the database, and the rule set information of the product is saved in a product label rule set table of the database, and one product label may contain a plurality of rule set information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710422162.8A CN107301211B (en) | 2017-06-07 | 2017-06-07 | Online data processing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710422162.8A CN107301211B (en) | 2017-06-07 | 2017-06-07 | Online data processing method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107301211A CN107301211A (en) | 2017-10-27 |
| CN107301211B true CN107301211B (en) | 2020-01-21 |
Family
ID=60134643
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710422162.8A Active CN107301211B (en) | 2017-06-07 | 2017-06-07 | Online data processing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107301211B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108388665B (en) * | 2018-03-14 | 2021-06-22 | 四川长虹电器股份有限公司 | Method for inquiring and acquiring new data insertion position in data |
| CN111984619A (en) * | 2019-05-21 | 2020-11-24 | 振锋企业股份有限公司 | Authorization method for data editing authority of product item |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1442811A (en) * | 2002-03-06 | 2003-09-17 | 鸿富锦精密工业（深圳）有限公司 | Enterprise import and export commodity interconnected network monitoring system and method |
| CN101918961A (en) * | 2007-11-14 | 2010-12-15 | 潘吉瓦公司 | Evaluating public records of supply transactions |
| CN104737187A (en) * | 2012-08-31 | 2015-06-24 | 邓白氏公司 | System and process of associating import and/or export data with a corporate identifier |
| CN105809482A (en) * | 2016-03-11 | 2016-07-27 | 郑州师范学院 | Big data analysis system and method for cross-border trade |
-
2017
- 2017-06-07 CN CN201710422162.8A patent/CN107301211B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1442811A (en) * | 2002-03-06 | 2003-09-17 | 鸿富锦精密工业（深圳）有限公司 | Enterprise import and export commodity interconnected network monitoring system and method |
| CN101918961A (en) * | 2007-11-14 | 2010-12-15 | 潘吉瓦公司 | Evaluating public records of supply transactions |
| CN104737187A (en) * | 2012-08-31 | 2015-06-24 | 邓白氏公司 | System and process of associating import and/or export data with a corporate identifier |
| CN105809482A (en) * | 2016-03-11 | 2016-07-27 | 郑州师范学院 | Big data analysis system and method for cross-border trade |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107301211A (en) | 2017-10-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20230350883A1 (en) | Dynamic Dashboard with Guided Discovery | |
| US7505983B2 (en) | Extending data flows | |
| US8340995B2 (en) | Method and system of using artifacts to identify elements of a component business model | |
| US6785689B1 (en) | Consolidation of multiple source content schemas into a single target content schema | |
| Heer et al. | Interactive analysis of big data | |
| US7613688B2 (en) | Generating business warehouse reports | |
| US7840896B2 (en) | Definition and instantiation of metric based business logic reports | |
| US20050165829A1 (en) | Systems, Methods and Computer Program Products for Developing Enterprise Software Applications | |
| CA2795628C (en) | Method and system for providing business intelligence data | |
| US20130166563A1 (en) | Integration of Text Analysis and Search Functionality | |
| US20060064428A1 (en) | Methods and apparatus for mapping a hierarchical data structure to a flat data structure for use in generating a report | |
| US20110173529A1 (en) | Template processing engine for business systems | |
| Tannock et al. | Data-driven simulation of the supply-chain—Insights from the aerospace sector | |
| CN104838377A (en) | Integrating event processing with map-reduce | |
| CN106599153A (en) | Multi-data-source-based waste industry search system and method | |
| US20120089636A1 (en) | Dimensional data explorer | |
| CN107301211B (en) | Online data processing method | |
| CN107729575A (en) | Towards the information intelligent matching process and system of real estate supply and demand | |
| CN101464871A (en) | Report query collocation system and method | |
| Worwa et al. | Quality of Web-based information systems | |
| US8270612B2 (en) | Mapping compound keys | |
| US20140149186A1 (en) | Method and system of using artifacts to identify elements of a component business model | |
| Lee et al. | An Asynchronous-Driven Node. js Based Intermediary-free Direct Deal Distribution Platform Converged with Cloud Service | |
| CN107908756B (en) | Product information display method and system | |
| CN105320667A (en) | Industrial automation think tank system |
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 | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20220510 Address after: 510000 North District fghi area, 17th floor, No. 80 Xianlie Middle Road, Yuexiu District, Guangzhou City, Guangdong Province Patentee after: Younongfu technology development (Guangdong) Co.,Ltd. Address before: 614000 No. 258, Jiazhou Avenue, Shizhong District, Leshan City, Sichuan Province Patentee before: SICHUAN KCOMBER TECHNOLOGY CO.,LTD. |
|
| TR01 | Transfer of patent right |