CN101290670A - Uses of super large diamond database in diamond and jewellery network distribution platform - Google Patents
Uses of super large diamond database in diamond and jewellery network distribution platform Download PDFInfo
- Publication number
- CN101290670A CN101290670A CNA2008100287275A CN200810028727A CN101290670A CN 101290670 A CN101290670 A CN 101290670A CN A2008100287275 A CNA2008100287275 A CN A2008100287275A CN 200810028727 A CN200810028727 A CN 200810028727A CN 101290670 A CN101290670 A CN 101290670A
- Authority
- CN
- China
- Prior art keywords
- database
- diamond
- module
- super large
- format
- 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
Abstract
The invention discloses a method for applying a super-large scale diamond database in a diamond and jewelry electronic commerce network sales platform. The method comprises a diamond data integrated module, a database format conversion module, a large-scale database management module and an interface module between a database and a website. A plurality of the prior small-scale diamond databases with a nonstandard format are integrated into a standard-format super-large scale diamond database by the database integrated module. The database format conversion module converts database file in a comma separated format (csv format) and an SQL format. In the large-scale database management module, a system manger can conveniently and rapidly manage the super-large scale diamond database. The interface module between the database and the electronic commerce website realizes the retrieval to the super-large scale diamond database by a website user. A super-large scale diamond database system provided by the invention has the characteristics of convenient management and rapid retrieval. A flow chart of the invention is shown in an attached graph.
Description
Technical field
The present invention relates to use in a kind of electronic commerce network realm of sale the method for very-large database, specifically be applied to the super large diamond database in the diamond and jewellery network distribution platform.
Technical background
Along with the development of the online shopping of ecommerce, increasing people begin to accept these new ideas of shopping online.The sale of diamond gem is also progressively moved towards emerging online sales channel from traditional jewelry retail shop.In traditional jewelry retail shop, each jeweler's shop all adopts the method for stock's diamond, there is the cover stock diamond database system of oneself each jewelry commercial city, small-sized diamond database system format disunity like this, number of diamonds is few, data content is nonstandard, and the diamond database between the different jeweler's shops is difficult to compatible.This non-type small-sized diamond database has limited sharing of interior resource of diamond gem industry and information, in the electronic commerce times of diamond gem online spending, also is unfavorable for developing large-scale diamond gem online spending platform.It is compatible high that the Database Systems of ecommerce need have, standardization and be convenient to management, the characteristics of searching for fast.Electronic commerce times in the development of information of goods information data magnanimity, traditional small-sized diamond database can not satisfy the requirement of fast-developing e-commerce system, under such environment, we have developed the super large diamond database system in a kind of diamond and jewellery network distribution platform.It is complete that this system has data, data format standardization, and data content compatibility height can use the characteristics of fast database search method.Its superiority has been used and demonstrated to these Database Systems in our up-to-date diamond and jewellery network distribution platform.
Summary of the invention
Nonstandard in order to overcome existing traditional small-sized diamond database data layout, poor compatibility, the shortcoming that database volume is little and search is difficult, the invention provides a kind of super large diamond database system that is applied in the diamond and jewellery network distribution platform, it adopts the data layout of diamond sales industry internal standard, and data content is complete, and database volume is big, convenient management can use various database search methods to search for fast.
The technical solution adopted for the present invention to solve the technical problems is: the integrated original diamond database that uses the storage of comma-delimited file (csv) form that becomes of the diamond database of the different-format that each supplier is provided, this form has checks conveniently the characteristics that Compatibility of Operating System is good.Use script that the database file of CSV form is converted into the file of SQL database form automatically then, SQL easy to use inquires about and manages the diamond database system.Adopt the diamond database file of SQL form storage to have convenient management, search for characteristics fast, be suitable for superhuge database and retrieve fast.
This method comprises five modules:
1: diamond data integration module;
2: the database format modular converter;
3: the large data database management module;
4: database and e-commerce website interface module;
(1) diamond data integration module is the interface module of our ultra-large type standardization diamond database and traditional non-standard small-sized diamond database.This module will be integrated into uniform format from the non-type small-sized diamond database of form that different diamond supplier obtains there, the super large diamond database of data content standard, and adopt this database of stored in file format of CSV.
(2) in the database format modular converter, system uses script the diamond database file of CSV form to be converted into automatically the super large diamond database file of SQL database form.
(3) in the large data database management module, the system manager can use sql like language that database is managed, retrieval, operations such as ordering.
(4) in database and the e-commerce website interface module, the client of e-commerce website can set the search condition of diamond database by the graphic user interface of website, this module is converted into the standard SQL query language automatically with client's search condition, and super large diamond database retrieved, result for retrieval turns back to user-friendly Web site figure user interface.
Description of drawings
Fig. 1 is a modular structure process flow diagram of the present invention.
Fig. 2 is the diamond database file of CSV form.
Fig. 3 is the basic diamond search interface of diamond gem e-commerce website.
Fig. 4 is the result for retrieval of diamond database.
Fig. 5 is the interactive diamond search interface of diamond gem e-commerce website.
Embodiment
Below in conjunction with accompanying drawing, the invention will be further described.
By the modular structure process flow diagram of Fig. 1 as can be known, the present invention includes diamond data integration module, database format modular converter, large data database management module, database and e-commerce website interface module.These several modules are the organic component of super large diamond database system, finish the application of super large diamond database in diamond and jewellery network distribution platform jointly, wherein:
Diamond data integration module is the interface module of our ultra-large type standardization diamond database and traditional non-standard small-sized diamond database.This module will be integrated into uniform format from the non-type small-sized diamond database of form that different diamond supplier obtains there, the super large diamond database of data content standard, and adopt this database of stored in file format of CSV.The diamond document format data disunity that difference diamond supplier provides, data content is complete not to the utmost, and putting in order of data item is also inequality.The off-gauge small-sized diamond database that diamond data integration module provides different suppliers is converted into the super large diamond database of consolidation form, and in this database, the normal data of diamond is according to shape, weight, cut, color, cleanliness, polishing, symmetry, the degree of depth, table top, fluorescence, waist, the bottom surface, size, certificate, total price, every carat of price, stock's coding and the such series arrangement of remark information.We make the parameter of each diamond complete as far as possible, if lack a certain parameter in the diamond database that the supplier provides, we will ask the numerical value of this parameter to this supplier, if the parameter that the supplier can not provide, we leave a blank this.Diamond data integration module is at first carried out standardization to each small-sized diamond database, and the data ordering that also is about to each small-sized diamond database becomes standard format; Then each toy data base is integrated into a superhuge diamond database.This database uses the storage of CSV form.Such data file can be convenient to use text editor, and Microsoft Excel supervisor is opened.Can check data content easily for data base administrator or webmaster.
Diamond data integration module is the system of a robotization.After our system provided the diamond data of once upgrading, meeting every day of diamond data integration module was collected different diamond database information automatically and is integrated into the diamond data file of consolidation form at set intervals in diamond supplier.
In the database format modular converter, system uses script the diamond database file of CSV form to be converted into automatically the super large diamond database file of SQL database form.The database format modular converter also is the system of a robotization.When diamond data integration module generated new diamond data file, the just automatic Run Script of database format modular converter became the diamond database file conversion of CSV form the database file of SQL form.Such conversion also is to carry out every day, can guarantee that the diamond database system above the e-commerce website is always up-to-date.
In the large data database management module, the system manager can use sql like language that database is managed, retrieval, operations such as ordering.Using sql like language that database is managed has fast and characteristics easily.
Database and e-commerce website interface module are joined together super large diamond database and diamond gem e-commerce website.Client can set the search condition of diamond database by the graphic user interface of website, this module is converted into the standard SQL query language automatically with client's search condition, and according to these search conditions super large diamond database is retrieved, result for retrieval turns back to user-friendly Web site figure user interface.
Fig. 2 is the diamond database file of CSV form.The file of CSV form (csv form) can be opened with text editor or Microsoft excel application.We can see the various parameters of a diamond of each behavior to open the back, and each row is the corresponding same parameters of different diamonds.The parameter of diamond is according to shape (Shape), weight (Carat), cut (Cut), color (Color), cleanliness (Clarity), polishing (Polish), symmetry (Symmetry), the degree of depth (Depth), table top (Table), fluorescence (Fluorescence), waist (Girdle), bottom (Cutlet), size (Dimension), certificate (Lab), total price (Total), every carat of price (Per/Ct), diamond stock number (Stock#), the series arrangement of remark information (Remarks) (planting this form at Fig. 2 does not show fully).The diamond parameter that lacks is left a blank in form.We can see several basic parameter shapes of diamond, weight, and cut, color and cleanliness all are complete, because all comprise this several basic parameters in each diamond supplier's the database basically.Other have some parameters and imperfect, but for most of clients, those parameters do not influence client and select diamond.Our super large diamond database is exactly to safeguard a perfect database of parameter as far as possible, makes client can obtain comprehensive information when the diamond gem network is selected diamond.
Fig. 3 is the diamond search interface of diamond gem e-commerce website.This page uses figure, and modes such as tabulation are listed in several important parameters of diamond on the webpage, and client selects the diamond search condition by graphic user interface.By clicking " search diamond " button of below of screen, database and e-commerce website interface module just are converted into the standard SQL query statement automatically with client's selection, the SQL query statement is retrieved the super large diamond database of SQL form, and the result of retrieval turns back on the webpage with the mode of graphical list and browses for client.
Fig. 4 is the result for retrieval of diamond database.Database inquiry system is retrieved super large diamond database according to the condition that client sets, and the result of retrieval turns back on the e-commerce website, with the form of tabulation as shown in Figure 4.On the result for retrieval form, client can sort to result for retrieval, compares and check the operation of each diamond details.Client clicks the ordering arrow on the result for retrieval form each time, and system orders the data base management system (DBMS) on backstage to carry out the result for retrieval ordering with regard to sending a SQL ordering.The result of ordering is presented on the webpage with the form of form equally.
Fig. 5 is the interactive diamond search interface of diamond gem e-commerce website.Except using traditional basic search page, we have also developed the interactive diamond search system in the diamond gem ecommerce online trade platform.In interactive search, client can set the search condition of diamond by slider bar and check box.The same database and the interface module of website are converted to client's search condition the standard SQL query statement and retrieve super large diamond database, and result for retrieval is presented on the webpage, with the form of form as shown in Figure 5.In interactive search, client can change search condition at any time, and system is just retrieved automatically again, and retrieval table upgrades automatically, is unlike in the basic search, and customer need return back to the diamond search page and reselects search condition and carry out new retrieval once.
Claims (5)
- The application of 1 super large diamond database in diamond and jewellery network distribution platform, it can set up standardized format, the super large diamond database that data content is complete in the electronic commerce network sales platform of diamond gem.By the SQL system database is managed and searches for, and Search Results is turned back to e-commerce website by graphic user interface.It is big that the present invention has a data capacity, data format standard, and convenient management is searched for characteristics fast.The method of this super large diamond database comprises following module:(1) diamond data integration module, this module will be integrated into uniform format from the non-type small-sized diamond database of form that different diamond supplier obtains there, the super large diamond database of data content standard, and this database of stored in file format of employing CSV.(2) database format modular converter, this module use script the diamond database file of CSV form to be converted into automatically the super large diamond database file of SQL database form.(3) large data database management module, the system manager can use sql like language that database is managed in this module, retrieval, operations such as ordering.(4) database and e-commerce website interface module, the client of e-commerce website can set the search condition of diamond database by the graphic user interface of website in this module, this module is converted into the standard SQL query language automatically with client's search condition, and super large diamond database retrieved, result for retrieval turns back to user-friendly Web site figure user interface.
- Super large diamond database in 2 diamond and jewellery network distribution platforms according to claim 1 is characterized in that:In diamond data integration module:Diamond supplier regularly uploads the non-standard small-sized diamond database with different-format.The super large diamond database system obtains up-to-date diamond database file every day automatically, reads the content of each database file automatically, and it is standardized as the database file of consolidation form.Then each standardized small-sized diamond database is integrated and become a superhuge diamond database.This diamond database is with database file form (csv form) storage of CSV.The capacity of diamond database can reach several ten thousand even a hundreds of thousands diamond.
- Super large diamond database in 3 diamond and jewellery network distribution platforms according to claim 1 is characterized in that:In the database format modular converter:System adopts shell script every day automatically with the database file of csv form diamond database file conversion becoming SQL form.The conversion of database is regularly carried out every day, and the backstage, website keeps up-to-date diamond data file at any time.
- Super large diamond database in 4 diamond and jewellery network distribution platforms according to claim 1 is characterized in that:In the large data database management module:The system manager can use sql like language that database is managed, retrieval, and operations such as ordering have convenient management and inquire about characteristics fast.
- Super large diamond database in 5 diamond and jewellery network distribution platforms according to claim 1 is characterized in that:In database and e-commerce website interface module:The client of e-commerce website can set the search condition of diamond database by the graphic user interface of website, and client can use the method for basic diamond search or interactive diamond search to set the diamond search condition.This module is converted into the standard SQL query language automatically with client's search condition, and super large diamond database is retrieved.Result for retrieval turns back in the diamond and jewellery network distribution platform with the form of form.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008100287275A CN101290670A (en) | 2008-06-12 | 2008-06-12 | Uses of super large diamond database in diamond and jewellery network distribution platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008100287275A CN101290670A (en) | 2008-06-12 | 2008-06-12 | Uses of super large diamond database in diamond and jewellery network distribution platform |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101290670A true CN101290670A (en) | 2008-10-22 |
Family
ID=40034919
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2008100287275A Pending CN101290670A (en) | 2008-06-12 | 2008-06-12 | Uses of super large diamond database in diamond and jewellery network distribution platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101290670A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105868402A (en) * | 2016-04-20 | 2016-08-17 | 中国商用飞机有限责任公司 | Aircraft maintenance quality analysis oriented QAR (quick access recorder) data preprocessing method and device |
| CN107491987A (en) * | 2017-08-03 | 2017-12-19 | 深圳市云钻科技有限公司 | A kind of batch cost accounting system and method based on diamond product dynamic database |
| CN107609891A (en) * | 2017-08-03 | 2018-01-19 | 深圳市云钻科技有限公司 | A kind of batch transaction screening system and method based on diamond product dynamic database |
| CN107633418A (en) * | 2017-08-03 | 2018-01-26 | 深圳市云钻科技有限公司 | A kind of diamond product price information real-time show system and method |
| CN107657475A (en) * | 2017-08-03 | 2018-02-02 | 深圳市云钻科技有限公司 | A kind of price fixing based on diamond product dynamic database is merchandised system and method in advance |
| CN107679890A (en) * | 2017-09-15 | 2018-02-09 | 深圳市云钻科技有限公司 | A kind of buyer may filter that screening diamond transaction system and method |
-
2008
- 2008-06-12 CN CNA2008100287275A patent/CN101290670A/en active Pending
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105868402A (en) * | 2016-04-20 | 2016-08-17 | 中国商用飞机有限责任公司 | Aircraft maintenance quality analysis oriented QAR (quick access recorder) data preprocessing method and device |
| CN107491987A (en) * | 2017-08-03 | 2017-12-19 | 深圳市云钻科技有限公司 | A kind of batch cost accounting system and method based on diamond product dynamic database |
| CN107609891A (en) * | 2017-08-03 | 2018-01-19 | 深圳市云钻科技有限公司 | A kind of batch transaction screening system and method based on diamond product dynamic database |
| CN107633418A (en) * | 2017-08-03 | 2018-01-26 | 深圳市云钻科技有限公司 | A kind of diamond product price information real-time show system and method |
| CN107657475A (en) * | 2017-08-03 | 2018-02-02 | 深圳市云钻科技有限公司 | A kind of price fixing based on diamond product dynamic database is merchandised system and method in advance |
| CN107679890A (en) * | 2017-09-15 | 2018-02-09 | 深圳市云钻科技有限公司 | A kind of buyer may filter that screening diamond transaction system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102236663B (en) | Query method, query system and query device based on vertical search | |
| CN103942299B (en) | A kind of data linkage exhibiting device and methods of exhibiting | |
| CN107798026A (en) | Data query method and apparatus | |
| CN101290670A (en) | Uses of super large diamond database in diamond and jewellery network distribution platform | |
| WO2022156529A1 (en) | Commodity recommendation method and apparatus for enterprise user | |
| CN105488048A (en) | Data query method and device | |
| CN103886487A (en) | Individualized recommendation method and system based on distributed B2B platform | |
| CN104835014A (en) | Scientific research information service platform for enterprise | |
| CA2394514A1 (en) | Method and system for parameterized database drill-through | |
| CN101344949A (en) | Advanced interactive type search method of diamond and jewellery network sales system | |
| Girsang et al. | Business intelligence for construction company acknowledgement reporting system | |
| Yeung et al. | Data analytics architectures for e-commerce platforms in cloud | |
| US8832601B2 (en) | ETL tool utilizing dimension trees | |
| CN104182226A (en) | General mobile information system adaptation method and device | |
| CN104199648B (en) | A kind of General Mobile information system adaptation method and device | |
| CN109919728A (en) | A kind of Method of Commodity Recommendation in difference quotient city | |
| Warlina et al. | Designing web-based food ordering information system in restaurant | |
| Girsang et al. | Decision support system using data warehouse for hotel reservation system | |
| CN102033886A (en) | Fabric search method and system utilizing same | |
| Gupta et al. | A Review of Data Warehousing and Business Intelligence in different perspective | |
| Al Essa et al. | Data Mining and Warehousing | |
| CN107908756B (en) | Product information display method and system | |
| CN108510343A (en) | A movement tradition ERP e-commerce platform order processing methods | |
| Alfredo et al. | Data warehouse development for flight reservation system | |
| KR20170055379A (en) | Purchase price forecasting methods for new developments utilizing the ERP database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C57 | Notification of unclear or unknown address | ||
| DD01 | Delivery of document by public notice |
Addressee: Xiong Gang Document name: Notification of Passing Preliminary Examination of the Application for Invention |
|
| DD01 | Delivery of document by public notice |
Addressee: Xiong Gang Document name: Notification of before Expiration of Request of Examination as to Substance |
|
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20081022 |