CN110990392A - Method for foreign trade service supply chain - Google Patents
Method for foreign trade service supply chain Download PDFInfo
- Publication number
- CN110990392A CN110990392A CN201911283360.6A CN201911283360A CN110990392A CN 110990392 A CN110990392 A CN 110990392A CN 201911283360 A CN201911283360 A CN 201911283360A CN 110990392 A CN110990392 A CN 110990392A
- Authority
- CN
- China
- Prior art keywords
- data
- management data
- management
- center unit
- database
- 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
- 238000000034 method Methods 0.000 title claims abstract description 18
- 238000004458 analytical method Methods 0.000 claims abstract description 15
- 238000013499 data model Methods 0.000 claims abstract description 11
- 238000007619 statistical method Methods 0.000 claims abstract description 10
- 238000007418 data mining Methods 0.000 claims abstract description 4
- 238000012545 processing Methods 0.000 claims abstract description 4
- 238000007726 management method Methods 0.000 claims description 105
- 239000000284 extract Substances 0.000 claims description 6
- 238000012550 audit Methods 0.000 claims description 3
- 238000004422 calculation algorithm Methods 0.000 claims description 3
- 238000007689 inspection Methods 0.000 claims description 3
- 238000012546 transfer Methods 0.000 claims description 3
- 238000004140 cleaning Methods 0.000 description 7
- 230000008676 import Effects 0.000 description 3
- 238000007405 data analysis Methods 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 230000006399 behavior Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000004083 survival effect Effects 0.000 description 1
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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/2465—Query processing support for facilitating data mining operations in structured databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- 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/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0609—Buyer or seller confidence or verification
-
- 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/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
- G06Q30/0635—Processing of requisition or of purchase orders
Abstract
The invention provides a method for a foreign trade service supply chain, which comprises the following steps: s1, establishing a transaction database which comprises a customer center unit, an order center unit, a settlement center unit, a wind control center unit, a personnel center unit and a statistical analysis unit; s2, establishing an HBase database, and transferring data in the transaction type database to the HBase database; s3, carrying out data mining analysis query on the data in the HBase database and generating an analysis query result; s4, extracting data to be displayed from the analysis query result according to a preset semantic model to generate a data model; s5, displaying the data model according to a preset report form format; the method has the advantages of high efficiency, high quality and the like in processing the service data.
Description
Technical Field
The invention belongs to the technical field of foreign trade services, and particularly relates to a method for a foreign trade service supply chain.
Background
With the further release of foreign trade import and export rights, the number of production enterprises and circulation enterprises directly engaged in foreign trade export is increased sharply, and small and medium-sized foreign trade export enterprises lose the advantages of the original import and export rights, international trade experience and the like, and face serious survival crises.
The problems of difficult financing, expensive financing and the like of medium and small enterprises exist for many years, the financial service aiming at the enterprises is far from meeting the requirements at present, and many of the financial services are met by core enterprises in a supply chain. The reason is mainly two ways: the mainstream financial institution is not familiar with the business scene of the small and micro enterprise and is difficult to reach the small and micro enterprise; the data dimensionality of the enterprise is small, and the enterprise also stays in the personal credit of the enterprise owner and the basic operation information of the enterprise, so that the risk is difficult to control; in order to address the above problems, a method for a foreign trade service supply chain is needed.
Disclosure of Invention
The invention aims to provide a method for a foreign trade service supply chain, which aims to solve the problems that small and medium-sized enterprises lack financial services of a supply chain system, so that the development of the foreign trade enterprises is restricted due to unclear business scenes and few data dimensions.
The invention provides the following technical scheme:
a method for a foreign trade service supply chain comprising the steps of: s1, establishing a transaction database which comprises a customer center unit, an order center unit, a settlement center unit, a wind control center unit, a personnel center unit and a statistical analysis unit; s2, establishing an HBase database, and transferring data in the transaction type database to the HBase database; s3, carrying out data mining analysis query on the data in the HBase database and generating an analysis query result; s4, extracting data to be displayed from the analysis query result according to a preset semantic model to generate a data model; and S5, displaying the data model according to a preset report form format.
Further, in S1, the customer center unit includes a customer management module, configured to collect workbench data, e-commerce customer data, market management data, private pool management data, customer management data, buyer management data, and handover management data; the order center unit comprises an order management module which is used for collecting client management data, contract management data, order management data, credit card management data, income payment management data, payment application data, customs clearance management data, logistics expense data, reconciliation management data and invoice management data; the settlement center unit comprises a settlement management module used for collecting collection management data, payment management data, tax refund management data, commission management data, invoice management data, posting management data and standing book management data; the wind control center unit comprises a wind control management module for acquiring policy management data, double-audit management data, factory inspection management data, supervision management data, letter and dispatching management data, comprehensive service filing data, ticket collection early warning data, customs clearance admission data, fund management data and risk country management data; the personnel center unit comprises a personnel management module which is used for collecting official document management data, notice management data and sales performance management data; the statistical analysis unit comprises a statistical analysis module which is used for collecting sales report data, operation report data, financial report data, risk report data, analysis report data and assessment report data.
Further, in S2, the data warehouse tool extracts data from the transactional database, performs a data cleaning algorithm according to the data cleaning parameters, extracts an HQL statement for converting data from the MaP function of the MapReduce computing framework, obtains a target data result, and writes the data after data cleaning and filtering into the HBase database according to the target data.
Further, in S3, the method includes the following steps: s11, setting a starting line for scanning the HBase database; s12, calculating and scanning an ending line of the HBase database according to the starting line; and scanning the HBase database within a range represented by the start row to the end row.
Further, in S4, the semantic model is a new data model that adds a completely new data constructor and data processing primitive on the basis of the relationship model and is used for expressing complex structures and rich semantics.
The invention has the beneficial effects that:
the present invention is a method for a foreign trade service supply chain,
1) an HBase Database (Hadoop Database, a distributed and nematic open source Database) is constructed based on a Hadoop platform, so that the whole system can transfer the characteristics of high efficiency and high expansibility of the Hadoop platform and can better support mass data;
2) the data management system is developed based on a Hadoop ecosystem, wherein a data warehouse building tool, a data analysis tool and a free report tool are built based on an HBase database, are connected with the HBase and operate aiming at data in the HBase; the data analysis tool is constructed based on the data warehouse tool Hive, and the Hive module is called according to specific service requirements.
3) The data warehouse building tool fully utilizes a MapReduce distributed parallel computing framework provided by Hadoop, and realizes the parallelization of the data extraction process. Meanwhile, the data warehouse building tool adopts a data cleaning technology when loading data from the business system database to the data warehouse, thereby greatly improving the quality of business data.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention and not to limit the invention. In the drawings:
FIG. 1 is a schematic flow diagram of the present invention.
Detailed Description
As shown in fig. 1, a method for a foreign trade service supply chain comprises the steps of:
s1, establishing a transaction database which comprises a customer center unit, an order center unit, a settlement center unit, a wind control center unit, a personnel center unit and a statistical analysis unit;
the client center unit comprises a client management module used for collecting workbench data, E-commerce client data, market management data, private pool management data, client management data, buyer management data and transfer management data;
the order center unit comprises an order management module which is used for collecting client management data, contract management data, order management data, credit card management data, income payment management data, payment application data, customs clearance management data, logistics expense data, reconciliation management data and invoice management data;
the settlement center unit comprises a settlement management module used for collecting collection management data, payment management data, tax refund management data, commission management data, invoice management data, posting management data and standing book management data;
the wind control center unit comprises a wind control management module for acquiring policy management data, double-audit management data, factory inspection management data, supervision management data, letter and dispatching management data, comprehensive service filing data, ticket collection early warning data, clearance entry data, fund management data and risk country management data;
the personnel center unit comprises a personnel management module which is used for collecting official document management data, notice management data and sales performance management data;
the statistical analysis unit comprises a statistical analysis module which is used for collecting sales report data, operation report data, financial report data, risk report data, analysis report data and assessment report data.
S2, establishing an HBase database, and transferring data in the transaction type database to the HBase database;
s2, the data warehouse tool extracts data from the affair database, executes data cleaning algorithm according to data cleaning parameters, extracts HQL statements used for converting the data from the MaP function of the MapReduce calculation framework, obtains target data results, and writes the data after data cleaning and filtering into the HBase database according to the target data.
S3, carrying out data mining analysis query on the data in the HBase database and generating an analysis query result;
in S3, the method includes the steps of:
s11, setting a starting line for scanning the HBase database;
s12, calculating and scanning an ending line of the HBase database according to the starting line; and scanning the HBase database within the range represented by the start row to the end row.
S4, extracting data to be displayed from the analysis query result according to a preset semantic model to generate a data model;
in S4, the semantic model is a new data model that adds a completely new data constructor and data processing primitive on the basis of the relationship model and is used to express complex structures and rich semantics.
And S5, displaying the data model according to a preset report form format.
An example of this embodiment is as follows:
is used for an import and export platform of an electronic product,
(1) collecting basic information of a customer by using a mobile terminal (customer center unit); basic information of a customer is admitted to an electronic commodity platform (in a transactional database);
transferring data (in the transactional database) to the HBase database;
(2) the order center unit matches basic information of a client with admission information (in an HBase database) through factors such as brands, types and the like, if a target commodity is found, pre-evaluation information aiming at the commodity is generated based on sales information (a semantic model) of the target commodity, and behaviors such as false reporting, tax cheating and the like can be effectively avoided;
(3) after the commodity is admitted, the customer can place an order by self or can place an order by the customer service in stead of order execution (customs declaration, payment collection, ticket collection, tax return application and tax return payment);
(4) sending pre-rating information (report format) to the mobile terminal by the clearing house unit;
(5) and the settlement center unit receives and releases the money and closes the order finally.
Although the present invention has been described in detail with reference to the foregoing embodiments, it will be apparent to those skilled in the art that changes may be made in the embodiments and/or equivalents thereof without departing from the spirit and scope of the invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (5)
1. A method for a foreign trade service supply chain comprising the steps of:
s1, establishing a transaction database which comprises a customer center unit, an order center unit, a settlement center unit, a wind control center unit, a personnel center unit and a statistical analysis unit;
s2, establishing an HBase database, and transferring data in the transaction type database to the HBase database;
s3, carrying out data mining analysis query on the data in the HBase database and generating an analysis query result;
s4, extracting data to be displayed from the analysis query result according to a preset semantic model to generate a data model;
and S5, displaying the data model according to a preset report form format.
2. The method for a foreign trade service supply chain according to claim 1, wherein in S1,
the customer center unit comprises a customer management module used for collecting workbench data, e-commerce customer data, market management data, private pool management data, customer management data, buyer management data and transfer management data;
the order center unit comprises an order management module which is used for collecting client management data, contract management data, order management data, credit card management data, income payment management data, payment application data, customs clearance management data, logistics expense data, reconciliation management data and invoice management data;
the settlement center unit comprises a settlement management module used for collecting collection management data, payment management data, tax refund management data, commission management data, invoice management data, posting management data and standing book management data;
the wind control center unit comprises a wind control management module for acquiring policy management data, double-audit management data, factory inspection management data, supervision management data, letter and dispatching management data, comprehensive service filing data, ticket collection early warning data, customs clearance admission data, fund management data and risk country management data;
the personnel center unit comprises a personnel management module which is used for collecting official document management data, notice management data and sales performance management data;
the statistical analysis unit comprises a statistical analysis module which is used for collecting sales report data, operation report data, financial report data, risk report data, analysis report data and assessment report data.
3. The method of claim 1, wherein S2 comprises a data binning tool, the data binning tool extracts data from transactional database, performs data cleansing algorithm according to data cleansing parameters, extracts HQL statements for converting data from the MaP function of MapReduce computing framework, obtains target data result, and writes the data cleansed and filtered data into HBase database according to the target data.
4. The method for a foreign trade service supply chain according to claim 1, wherein in said S3, the steps of:
s11, setting a starting line for scanning the HBase database;
s12, calculating and scanning an ending line of the HBase database according to the starting line; and scanning the HBase database within a range represented by the start row to the end row.
5. The method of claim 1, wherein in said S4, said semantic model is a new type of data model that adds a completely new data constructor and data processing primitives to said relational model for expressing complex structures and rich semantics.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911283360.6A CN110990392A (en) | 2019-12-13 | 2019-12-13 | Method for foreign trade service supply chain |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911283360.6A CN110990392A (en) | 2019-12-13 | 2019-12-13 | Method for foreign trade service supply chain |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110990392A true CN110990392A (en) | 2020-04-10 |
Family
ID=70093430
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911283360.6A Pending CN110990392A (en) | 2019-12-13 | 2019-12-13 | Method for foreign trade service supply chain |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110990392A (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102880709A (en) * | 2012-09-28 | 2013-01-16 | 用友软件股份有限公司 | Data warehouse management system and data warehouse management method |
| CN109087043A (en) * | 2018-07-24 | 2018-12-25 | 路迪斯达（深圳）投资发展有限公司 | A kind of cargoes imported and exported trade management platform |
-
2019
- 2019-12-13 CN CN201911283360.6A patent/CN110990392A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102880709A (en) * | 2012-09-28 | 2013-01-16 | 用友软件股份有限公司 | Data warehouse management system and data warehouse management method |
| CN109087043A (en) * | 2018-07-24 | 2018-12-25 | 路迪斯达（深圳）投资发展有限公司 | A kind of cargoes imported and exported trade management platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105321046A (en) | Corporate financial management system | |
| CN111191921A (en) | Small and micro enterprise operation condition wind control analysis system | |
| CN104700275A (en) | Electronic commerce platform financial accounting method and system | |
| US20150046307A1 (en) | Item level personal finance management (pfm) for discretionary and non-discretionary spending | |
| CN105373958A (en) | Accounting method based on bank bills | |
| US20090327036A1 (en) | Decision support systems using multi-scale customer and transaction clustering and visualization | |
| CN111784388A (en) | Financial product recommendation method and device | |
| CN113205402A (en) | Account checking method and device, electronic equipment and computer readable medium | |
| CN107545480A (en) | A four big point-of-sale terminal rural area electric business processing system | |
| CN101308564A (en) | Mortgage loan information monitoring method and system | |
| CN111325540B (en) | POS system based on block chain | |
| CN112365352A (en) | Anti-cash-out method and device based on graph neural network | |
| CN110990392A (en) | Method for foreign trade service supply chain | |
| Semenyuta et al. | Digital technologies in lending small and medium-size enterprises in Russia | |
| CN117033431A (en) | Work order processing method, device, electronic equipment and medium | |
| CN104102965A (en) | Method for informatization of enterprise operation and management | |
| US20230100685A1 (en) | Financial product information collecting platform system, financial product information collecting method, and computer program for the same | |
| CN114187045A (en) | Digital intelligent operation system | |
| CN113554509B (en) | Processing method, device, medium and electronic equipment for online payment service | |
| CN112214536B (en) | Enterprise account data real-time import management system | |
| CN102609876A (en) | System and method for processing consumption credit investigation information | |
| KR20150097837A (en) | Pattern generating system for statement data generation and account recommendation and providing method thereof | |
| KR20150058578A (en) | Big data construction system using electronic contract or e-bills | |
| CN108876573B (en) | Tax check and management method | |
| Singh et al. | Two-tiered clustering classification experiments for market segmentation of EFTPOS retailers |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200410 |