CN109002512A - A kind of e-commerce system - Google Patents

A kind of e-commerce system Download PDF

Info

Publication number
CN109002512A
CN109002512A CN201810718651.2A CN201810718651A CN109002512A CN 109002512 A CN109002512 A CN 109002512A CN 201810718651 A CN201810718651 A CN 201810718651A CN 109002512 A CN109002512 A CN 109002512A
Authority
CN
China
Prior art keywords
olap
data
user
information
web
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
Application number
CN201810718651.2A
Other languages
Chinese (zh)
Inventor
李燕
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Jiaxing Jiuxuan Electronic Commerce Co Ltd
Original Assignee
Jiaxing Jiuxuan Electronic Commerce Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Jiaxing Jiuxuan Electronic Commerce Co Ltd filed Critical Jiaxing Jiuxuan Electronic Commerce Co Ltd
Priority to CN201810718651.2A priority Critical patent/CN109002512A/en
Publication of CN109002512A publication Critical patent/CN109002512A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]

Landscapes

  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

A kind of e-commerce system, include web site subsystem, OLAP subsystem and individual character sub-systems, it is described in web site subsystem, Internet user passes through the access site information of web browser interactivity, website accesses to web service database according to different Internet user's operations, using individuation data library, different user can access the website according to the characteristics of personality of oneself;The interest that user is obtained in the way of answering a question can be adequately utilized using the system, but also the information of user's browsing pages is combined the variation for updating user interest with to the feedback information for recommending the page, it can fast and accurately find the interest of user, and it is cross-platform, convenient for promoting, change conducive to enterprise from the environment of centralization to Distributed Open Environments.

Description

A kind of e-commerce system
Technical field
The present invention relates to e-commerce field, especially a kind of e-commerce system.
Background technique
E-commerce is the commercial activity using information network technique as means, centered on the exchange of commodities;It also is understood as On internet (Internet), intranet (Intranet) and value-added network (VAN, Value Added Network) with Electronic transaction mode carries out the activity of transaction and related service, be the electronization of each link of traditional commerce activity, networking, Informationization is based on browser/server application mode under the open network environment in internet, both parties do not meet into The various commercial activities of row realize online transaction between the shopping online of consumer, trade company and online e-payment and various The novel commercial operation pattern of the movable one kind of commercial activity, transaction, finance activities and relevant integrated service;
However current business information website needs to browse many pages when user opens the information checked and oneself is looked for need Face can just be found, and to the bad of personalized designs, the personalized of these business infomation systems is realized using active push Mode, the information in systematic search WWW, then selection is best suitable for N number of page of user interest to user, secondly from user there The evaluation about each push page is obtained, the algorithm of intelligent selection is finally updated according to the feedback information of page evaluation, from And information can be quickly obtained, but have the following deficiencies: (1) user provides the interest of oneself in a manner of keyword, Some users can not accurately often express the interest of oneself, so that system cannot comprehensively find the interest of user;(2) user Dull compared with the exchange way between system, possible user is when browsing a certain business information website, many useless information User will be recommended, exchanging between user and system is caused and obstacle occurs;
In the new focus that e-commerce field data warehouse is information technology framework, it provides and integrates diverse application System comes tissue and storing data from the angle of development and history, so that the processing of information-based and analysisization is used;OLAP is to establish C/S model software systems on the basis of data warehouse, belong to data warehouse applications, common OLAP will using logic, GUI and DBMS are strictly distinguished, and complicated application logic is distributed in client computer, and data need to be transferred at Analysis server Reason, since the storage capacity of client computer is not as good as server, thus efficiency substantially reduces;It thus needs to redesign a kind of new electricity Sub- business system.
The present invention be exactly in order to solve problem above and carry out improvement.
Summary of the invention
The object of the present invention is to provide a kind of interest that can fast and accurately find user, realize personalized access, efficiently Data access and analysis pretreatment, save the expense of exploitation, it is cross-platform, convenient for promote, conducive to enterprise from centralization ring The e-commerce system that border changes to Distributed Open Environments.
The present invention is that technical solution used by solving its technical problem is:
A kind of e-commerce system, it is described in web comprising web site subsystem, OLAP subsystem and individual character sub-systems In website subsystem, Internet user passes through the access site information of web browser interactivity, and website is according to different Internet user's operation accesses to web service database, and using individuation data library, different user can be according to oneself Characteristics of personality access the website;
It is described to provide useful knowledge and decision in OLAP subsystem to policymaker by olap analysis and help, utilization Olap analysis to business datum warehouse and the olap analysis to web daily record data warehouse obtain information system producer each Data information needed for kind;
It is described in individual character sub-systems, by regularly analyzing business datum warehouse and web journal file, to each page Access behavior and the feedback information of questionnaire survey calculate the key training of customer, allow the manager of information system according to The decision information of policymaker is adjusted the content and structure of website, so that information system be reconstructed;
Further, reconstruct step of the manager to information system are as follows:
(1) active push is utilized, some interested contents of customer that may allow are provided daily;
(2) commodity that customer less buys are given with certain discount;
(3) order that user access is reorganized according to the needs of every user, hobby, provides different to different customers Page order, user start access when its most desirable information page is just placed on foremost, different types of information page The decrease of their key training is successively discharged backward by user in face;
Further, the OLAP subsystem includes enterprise servers, olap server and client computer, enterprise's clothes Business device, olap server and client computer constitute the three-decker of OLAP system, also include base layer data in the OLAP system Library and data warehouse, enterprise servers, olap server and client computer are attached with data warehouse;
The enterprise servers are the first layer of OLAP system, are attached with base layer data library system, for storing number According to the detail data in warehouse;
The olap server is the second layer of OLAP system, is used for analysis integrated data, which comes from data Warehouse or base layer data library;
The client computer is the third layer of OLAP system, and the client computer is sequence of user application program, this layer of energy is logical It crosses olap server and unified access interface is provided;
Specifically, client's function directly obtains data by data access interface ODBC from data warehouse;
Wherein, the user submits analysis request to give WEB Server by the WEB Browser in client computer, described The analysis request of user is submitted to olap server by WEB Server.
The OLAP system also includes multi-dimensional data cube tool, display analysis result tool and data conversion tools DTS;
The third party application of the client computer is by data access interface OLE DB operation data, in data conversion work Have under DTS and data warehouse carries out data exchange, timely update data warehouse;
Olap server reads data from data warehouse and is transferred to display analysis result tool;
It is checked finally by third party WEB Browser.
The beneficial effects of the present invention are: it can be adequately by obtaining user in the way of answering a question using the system Interest, but also the information of user's browsing pages with to recommend the page feedback information combine it is emerging for updating user The variation of interest, can fast and accurately find the interest of user;It reorganizes the user according to the needs of every user, hobby and visits The order asked provides different page orders to different customers, when user starts access just by its most desirable information page It is placed on foremost, different types of information page successively discharges the decrease of their key training by user backward, thus Realize personalized access;OLAP three-decker in system will strictly be distinguished using logic, GUI and DBMS, complicated It is not distributed across in client computer, but is left concentratedly on Analysis server using logic, provide efficient data by server Access and analysis pretreatment;WEB and OLAP combination can save the expense of exploitation, directly adopt WEB Browser and be not required to out It sends out software special, and cross-platform, convenient for promoting, changes conducive to enterprise from the environment of centralization to Distributed Open Environments.
Detailed description of the invention
Fig. 1 is a kind of structural relation figure of e-commerce system proposed by the present invention.
Fig. 2 is a kind of development phase block diagram of e-commerce system proposed by the present invention.
Fig. 3 is a kind of three-decker block diagram of the OLAP subsystem of e-commerce system proposed by the present invention.
Fig. 4 is the logic diagram of OLAP system.
Specific embodiment
In order to be easy to understand the technical means, the creative features, the aims and the efficiencies achieved by the present invention, tie below Diagram and specific embodiment are closed, the present invention is further explained.
Referring to Fig.1, shown in Fig. 2, Fig. 3, Fig. 4, which includes web site subsystem, OLAP subsystem and individual character Sub-systems;
Further, described in web site subsystem, Internet user passes through web browser interactivity Site information is accessed, website accesses to web service database according to different Internet user's operations, utilizes personalization Database, different user can access the website according to the characteristics of personality of oneself;
Specifically, it is described in OLAP subsystem, useful knowledge and decision, which are provided, to policymaker by olap analysis helps It helps, using the olap analysis to business datum warehouse and to the olap analysis in web daily record data warehouse, makes information system producer Obtain various required data informations;
Wherein, described in individual character sub-systems, it is right by regularly analyzing business datum warehouse and web journal file The feedback information of access behavior and the questionnaire survey of each page calculates the key training of customer, allows the management of information system Person is adjusted the content and structure of website according to the decision information of policymaker, so that information system be reconstructed;
Reconstruct step of the manager to information system are as follows:
(1) active push is utilized, some interested contents of customer that may allow are provided daily;
(2) commodity that customer less buys are given with certain discount;
(3) order that user access is reorganized according to the needs of every user, hobby, provides different to different customers Page order, user start access when its most desirable information page is just placed on foremost, different types of information page The decrease of their key training is successively discharged by user in face backward, to realize personalized access.
The olap analysis in the business datum warehouse " cuts the progress of OLAP multi-dimension data cube using Multidimensional Data Model The operation such as piece " or " drilling through ", so that the sales volume of customer's commodity one day is obtained, the whole of a certain product in certain a period of time Sales volume etc., OLAP system further include the tool of storage and management multi-dimension data cube, and display is analyzed the tool of result and needed When change data tool etc.;
The OLAP subsystem includes enterprise servers, olap server and client computer, the enterprise servers, OLAP clothes Business device and client computer constitute the three-decker of OLAP system, also include base layer data library and data bins in the OLAP system Library, enterprise servers, olap server and client computer are attached with data warehouse,;
The enterprise servers are the first layer of OLAP system, are attached with base layer data library system, for storing number According to the detail data in warehouse;
The olap server is the second layer of OLAP system, is used for analysis integrated data, which comes from data Warehouse or base layer data library;
The client computer is the third layer of OLAP system, and the client computer is sequence of user application program, this layer of energy is logical It crosses olap server and unified access interface is provided;
Further, client's function directly obtains data by data access interface ODBC from data warehouse;
Further, the user submits analysis request to give WEB Server by the WEB Browser in client computer, The analysis request of user is submitted to olap server by the WEB Server, and html language is converted into multidimensional during this Data query, application server complete analysis and operate and result is given to WEB Server, and then WEB Server returns result Back to user;
Specifically, the OLAP system also includes multi-dimensional data cube tool, display analysis result tool and data Crossover tool DTS;
The third party application of the client computer is by data access interface OLE DB operation data, in data conversion work Have under DTS and data warehouse carries out data exchange, timely update data warehouse;
Olap server reads data from data warehouse and is transferred to display analysis result tool;
It is checked finally by third party WEB Browser;
The third party application is user's access modules, and operation data is the product and Gu saved in Web database The information data of visitor's access;
The OLAP Server is created using SQL Server database for managing OLAP multi-dimensional data cube;
It can be but also user is clear adequately by the interest for obtaining user in the way of answering a question using the system Look at the page information with to recommending the feedback information of the page to combine variation for updating user interest, can quickly, it is accurate Discovery user interest;The order that user access is reorganized according to the needs of every user, hobby, mentions to different customers For different page orders, its most desirable information page is just placed on foremost when user starts access, it is different types of Information page successively discharges the decrease of their key training by user backward, to realize personalized access;System In OLAP three-decker will strictly distinguish using logic, GUI and DBMS, complicated application logic is not distributed across client It on machine, but leaves concentratedly on Analysis server, provides efficient data access by server and analysis pre-processes;WEB The expense that exploitation can be saved with OLAP combination directlys adopt WEB Browser and is not required to develop special software, and across flat Platform changes conducive to enterprise from the environment of centralization to Distributed Open Environments convenient for promoting.
The basic principles, main features and advantages of the present invention have been shown and described above.The technology of the industry Personnel are it should be appreciated that the present invention is not limited to the above embodiments, and the above embodiments and description only describe this The principle of invention, various changes and improvements may be made to the invention without departing from the spirit and scope of the present invention, these changes Change and improvement all fall within the protetion scope of the claimed invention.The claimed scope of the invention by appended claims and its Equivalent defines.

Claims (6)

1. a kind of e-commerce system includes web site subsystem, OLAP subsystem and individual character sub-systems, it is characterised in that:
It is described in web site subsystem, Internet user passes through the access site information of web browser interactivity, net It stands and is accessed according to different Internet user's operations to web service database, utilize individuation data library, different user The website can be accessed according to the characteristics of personality of oneself;
It is described in OLAP subsystem, provide useful knowledge to policymaker by olap analysis and decision help, using to industry Be engaged in data warehouse olap analysis and olap analysis to web daily record data warehouse, so that information system producer is obtained various institutes Need data information;
The visit in individual character sub-systems, by regularly analyzing business datum warehouse and web journal file, to each page It asks that the feedback information of behavior and questionnaire survey calculates the key training of customer, allows the manager of information system according to decision The decision information of person is adjusted the content and structure of website, so that information system be reconstructed.
2. a kind of e-commerce system as described in claim 1, which is characterized in that reconstruct of the manager to information system Step are as follows:
(1) active push is utilized, some interested contents of customer that may allow are provided daily;
(2) commodity that customer less buys are given with certain discount;
(3) order that user access is reorganized according to the needs of every user, hobby, different pages is provided to different customers Its most desirable information page is just placed on foremost when user starts access by face order, and different types of information page is pressed User successively discharges the decrease of their key training backward.
3. a kind of e-commerce system as described in claim 1, which is characterized in that the OLAP subsystem includes enterprises service Device, olap server and client computer, the enterprise servers, olap server and client computer constitute the three-layered node of OLAP system Structure, also includes base layer data library and data warehouse in the OLAP system, enterprise servers, olap server and client computer with Data warehouse is attached;
The enterprise servers are the first layer of OLAP system, are attached with base layer data library system, for storing data storehouse Detail data in library;
The olap server is the second layer of OLAP system, is used for analysis integrated data, which comes from data warehouse Or base layer data library;
The client computer is the third layer of OLAP system, and the client computer is sequence of user application program, this layer can pass through Olap server provides unified access interface.
4. a kind of e-commerce system as claimed in claim 3, which is characterized in that client's function is connect by data access Mouth ODBC directly obtains data from data warehouse.
5. a kind of e-commerce system as claimed in claim 4, which is characterized in that the user passes through the WEB in client computer Browser submits analysis request to give WEB Server, the WEB Server that the analysis request of user is submitted to OLAP and is serviced Device.
6. a kind of e-commerce system as claimed in claim 4, which is characterized in that the OLAP system also includes multidimensional number According to cube tool, display analysis result tool and data conversion tools DTS;
The third party application of the client computer is by data access interface OLE DB operation data, in data conversion tools Under DTS and data warehouse carries out data exchange, and timely update data warehouse;
Olap server reads data from data warehouse and is transferred to display analysis result tool;
It is checked finally by third party WEB Browser.
CN201810718651.2A 2018-07-03 2018-07-03 A kind of e-commerce system Pending CN109002512A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810718651.2A CN109002512A (en) 2018-07-03 2018-07-03 A kind of e-commerce system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810718651.2A CN109002512A (en) 2018-07-03 2018-07-03 A kind of e-commerce system

Publications (1)

Publication Number Publication Date
CN109002512A true CN109002512A (en) 2018-12-14

Family

ID=64598935

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810718651.2A Pending CN109002512A (en) 2018-07-03 2018-07-03 A kind of e-commerce system

Country Status (1)

Country Link
CN (1) CN109002512A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111026905A (en) * 2019-12-02 2020-04-17 上海麦克风文化传媒有限公司 Efficient user interest category prediction method

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1674011A (en) * 2004-03-26 2005-09-28 赖明勇 Electronic business decision-making support system
CN1790397A (en) * 2005-12-28 2006-06-21 浙江工业大学 Third party logistics data processing method based on online analysis
CN102360386A (en) * 2011-10-12 2012-02-22 朱一超 Intelligent shopping guide system and method of electronic commerce website
CN102693307A (en) * 2012-05-24 2012-09-26 上海克而瑞信息技术有限公司 Website user access behavior recording and analyzing system
US20130018840A1 (en) * 2011-07-12 2013-01-17 Panorama Software Inc. Enhanced usage of business intelligence systems
CN106708821A (en) * 2015-07-21 2017-05-24 广州市本真网络科技有限公司 User personalized shopping behavior-based commodity recommendation method

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1674011A (en) * 2004-03-26 2005-09-28 赖明勇 Electronic business decision-making support system
CN1790397A (en) * 2005-12-28 2006-06-21 浙江工业大学 Third party logistics data processing method based on online analysis
US20130018840A1 (en) * 2011-07-12 2013-01-17 Panorama Software Inc. Enhanced usage of business intelligence systems
CN102360386A (en) * 2011-10-12 2012-02-22 朱一超 Intelligent shopping guide system and method of electronic commerce website
CN102693307A (en) * 2012-05-24 2012-09-26 上海克而瑞信息技术有限公司 Website user access behavior recording and analyzing system
CN106708821A (en) * 2015-07-21 2017-05-24 广州市本真网络科技有限公司 User personalized shopping behavior-based commodity recommendation method

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111026905A (en) * 2019-12-02 2020-04-17 上海麦克风文化传媒有限公司 Efficient user interest category prediction method
CN111026905B (en) * 2019-12-02 2024-04-12 上海麦克风文化传媒有限公司 Efficient user interest category prediction method

Similar Documents

Publication Publication Date Title
Büchner et al. Discovering internet marketing intelligence through online analytical web usage mining
US6408292B1 (en) Method of and system for managing multi-dimensional databases using modular-arithmetic based address data mapping processes on integer-encoded business dimensions
Pedersen et al. Multidimensional database technology
Martinez et al. Integrating data warehouses with web data: A survey
JP5242875B2 (en) Multidimensional database and integrated aggregation server
Haas et al. Data integration through database federation
Chaudhuri et al. Database technology for decision support systems
Stonebraker et al. Content integration for e-business
US9075859B2 (en) Parameterized database drill-through
CN103136335A (en) Data control method based on data platforms
CN105405047A (en) Community O2O-based data analysis system and implementation method thereof
CN116089495A (en) Self-service analysis platform based on big data
Buchner et al. An internet-enabled knowledge discovery process
Han et al. Study on web mining algorithm based on usage mining
Cecelja Manufacturing Information and Data Systems: Analysis, Design and Practice
CN110377668A (en) Data analysing method and system
Kocakoç et al. Business intelligence applications in retail business: OLAP, data mining & reporting services
CN109002512A (en) A kind of e-commerce system
Chen et al. A distributed OLAP infrastructure for e-commerce
Hua et al. Architectural support for business intelligence: a push‐pull mechanism
Cheng Product recommendation system design
CN109062547A (en) A kind of implementation method of electronic commerce information system
Ragulan et al. Designing a data warehouse system for sales and distribution company
KR100424144B1 (en) Web-based multi-dimensional information analyzing method and system
Du et al. Constructing federated databases in coordinated supply chains

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

Application publication date: 20181214

RJ01 Rejection of invention patent application after publication