Auction Web site and database design needs ranking Manual

Posted on 2009-06-29 filed under: Development (RSS) 214 views   

【Objective】
In the "interactive network" on the production of a module showing the top auction site. Baidu to achieve the effect of keyword bidding and ranking of similar shows in the "interactive network" location of the gold. Auction Web site ranking process, the use of the goods TaoBao auction mechanism.

【Requirements】

1, Introduction

1.1 The purpose of the preparation

The auction site to auction the feasibility of functional modules, integrity, and in accordance with the idea of the expected realization of the function modules, especially the demand for the preparation of the prospectus. At the same time, the note also played with the planning and design staff to better communicate the role.

1.2 Background
a. "Interactive Network" function modules auction auction site;

b. The function module is "interactive network" part.

1.3 Definitions

"Interactive Network" in the auction Web site, through the auction to determine the content of the final show. Content portal is the buyers.

Site-bit: "interactive network" in the auction Web site to display links to the entrance of each site on a web site known as the place.

Auction: the auction, including two ways, auction and Buy It Now.

Auction: the auction site by the seller to set a starting price place, interested buyers bid in the specified time, after the end of the auction, the highest bidder places on the Web site can be.

A price: a price for the site by the seller to set a final price-bit, the first buyers of the price to be website-bit.

Starting price: site-bit starting price, the seller can accept the lowest bid price.

The rate of increase: the buyers bid in order to go beyond a person's pre-bid to increase the current bid amount. Fare increases by the seller in the release position when the auction site custom.

Auction cycle: place the auction site, that is, a period of time. The use of unit: days. Such as: from at 0:00 on the July 1 the entire July 7 to 24 points throughout the cycle for 7 days.

Site-bit effective cycle: film website portal-bit effective time buyers, but also a time period with the same auction cycle is 7 days.
Note: Site-bit effective cycle is always the auction cycle, the previous cycle, that is, the current auction cycle is the auction site the next bit effective cycle, shows the entrance to the auction Web site content.

2, the task outlined in

2.1 objectives

"Interactive Network" in the auction site to auction and sold in the form. Auction site get buyers through "interactive networks" buyers to raise the visibility of websites and bring more revenue to the buyer. Benefits to the buyer at the same time, "interactive network" will make a profit. This is the intention of developing the module.

The function module is "interactive network" an integral part of, "an interactive network of" non-log home page (index.aspx) and the log home (my.aspx) show that the auction site's content is the buyer through the function module The film. That is, a buyer won the bid auction site, and then the portal will be the location of the site point to the buyer.

2.2 end-user features

Companies or individuals to pass through the auction of the functional module. Taken place as long as the Web site, the location link on the site point to the winner. "Interactive network" can be a total of 16 auction sites, and auction site places cycle (the time the auction) and the manner in which the use of auctions, sellers are issued through the auction site in the background when the set bit.

The auction site the auction cycles bit of a release once the auction site is a bit non-stop 24 hours a day.

2.3 auction site the auction rules

"I'm proud of," the auction site, and through an auction and the auction price in two ways. Auction Web site by the seller to set a starting price place, interested buyers bid in the specified time, after the end of the auction, the highest bidder places on the Web site can be; a price for the site by the seller-bit set a final price, the first buyers of the price to be website-bit.

Bid auction site places Time:

Starting time
Seven days a week in the auction for a period of time, known as the auction of the week week. The first day of week (Mon) 0:00 all of the site is starting places.

Take the time node
The last day of the auction week (Sun) 0:00 is the end of the auction.

Auction details:

Starting price
Is the seller's minimum acceptable price.

For example: If the seller intends to auction an auction site, and starting price of 1 yuan, to the end of the auction, buyers bid, only one, the baby will contract to 1 yuan.

The rate of increase
In order to offer the buyer is overtaking a person's bid to increase the current bid amount. Fare increases by the seller in the release position when the auction site custom.

Deputy bid (not to use the Interactive Network) - The following are the proxy bidding mechanism TaoBao

As a buyer, Taobao will be entered when you bid the highest price, in any other buyers bid, you automatically increase the minimum bid amount up to the highest bidder to maintain your position until your maximum bid by other So far more than the buyer. You enter the maximum price for the other members are confidential. Agents bid function is only applicable to a single auction. Just enter your bid the highest price acceptable to you; the end of the auction, if no one bid more than you, you are the winner, you will be the amount of the current bid to buy the treasure you want. For example: If the seller intends to auction a cup process, starting price is set to 1 million, the rate of increase of 1 million, the first time you bid, as when the buyer entered 50, offer records show only one dollar. The end of the auction, buyers bid for another 2 yuan, the system will help you proxy bid, the last of the baby to 3 yuan will be traded, you are the winner.

Digital auction site
First of all, the seller's Web site set up to participate in the auction starting price place, the rate of increase. Buyers can be the actual situation according to their own, enter the system needs a minimum price. The end of the auction, the highest bidder was the site bit. If the same bid, the bidder first place was the site.

Price of a rule:

Buy It Now
A price for the site by the seller to set a final price-bit, the first bid to be the buyers place Site.

"Interactive network" in a total of 16 sites, and the number of buyers is unpredictable, that is, unpredictable system load, the design optimization of the need to consider. At the same time, the need for strict synchronization mechanism to prevent buyers抢拍places with a Web site, the occurrence of the problem of reading dirty data.

Needs of the provisions of 3

The provisions of 3.1 pairs of functions

IPO plans, said the use of sub-function modules for each input, processing, output, one quantitative and qualitative description of the function modules to the functional requirements. Namely, that the importation of any volume, by what kind of deal with what output. Auction a number of modules that must be met at the same time auction buyers demand a web site, at the same time the number of buyers in the auction is uncertain.

IPO chart:

The performance of the provisions of 3.2 pairs of

3.2.1 Accuracy

When more than one buyer at time of auction site, if there is the same as buyers bid, then the first bid for the eventual winner of the buyer. Bid sooner or later, the use of second-class distinction. (Bid sooner or later in time how to define, it should be accurate to what level, how to achieve?)

3.2.2 Flexibility

Need to give full consideration to the design of the expansion of functions, functional modules are highly flexible.

Flexibility factors:

a. Change mode of operation;

b. Changes in operating environment;

c. Interface with other software or other software on the module integration;

Group site is the main means to integrate the functional modules.

d. Accuracy and effective changes in the time limit;

Mainly refers to the auction site and efficient cycle and cycle.

e. Plans to change or improve.

Refers to the future expansion of the main features.

3.3 input output request

Explain the input and output data types, and each of the format, value range, to make an accurate definition of precision. The software and the data output control must be marked with the interpretation of output and, for example, including a hard copy of the report (the normal output, status output and abnormal output), as well as graphics or display a description of the report.

3.4 Data Management competency requirements

That need to manage volumes of text and records the number of table sizes and the Sultan of volume, according to a predictable increase in the weight of the data and estimate the storage requirements.

3.4.1 database concurrency control consistency

A moment more than the same auction site buyers complicated bit of consistency, how to control?

3.4.2 Database table structure

1, WL_SitePosition (site, it has also said the auction objects)

Field Name
Data Type
Description
Remarks

spID
int
Location code
PK (primary key)

spName
Nvarchar (8)
Location name

spIniPrice
int
Start Price

spIncExtent
int
The rate of increase

spNowPrice
int
Current prices

spBidNum
int
Bids

spAucType
tinyint
Auction Type
0 - auction; 1 - 1 price

spBAucDT
datetime
Starting Date Time
Precise to the second

spEAucDT
datetime
Date Time node shoot

spStat
tinyint
State
0 - not allowed to auction; 1 - to allow the auction

buyerID
int
Buyer Code
FK

siteName
Nvarchar (8)
Site name
The name of the buyer's Web site

siteUrl
Nvarchar (64)
Site Address

2, WL_AuctionRecord (auction record sheet)

Field Name
Data Type
Description
Remarks

arID
int
Record ID
Since the field by

spID
Int
Location code
FK

buyerID
int
Buyer Code
FK

bidPrice
int
Bid price

bidDT
Datetime
Bid Date Time

siteName
Nvarchar (8)
Site name
The name of the buyer's Web site

siteUrl
Nvarchar (64)
Site Address

3, WL_ Buyers (buyers table)

Field Name
Data Type
Description
Remarks

buyerID
Int
Buyer Code
PK (primary key) from WL_User Table

buyerName
Nvarchar (16)
Buyer Name

buyerPoint
int
Points

buyerPrePoint
int
Pre-paid points
Buyers bid more than one site at the same time places, the need to advance the sum of points

buyerIntegral
Int
Buyer Points
Set aside and clearing points

buyerTel
Nvarchar (16)
Phone

buyerMobile
Nvarchar (16)
Mobile phone

buyerEmail
Nvarchar (64)
E-mail

buyerMSN
Nvarchar (64)

buyerQQ
Nvarchar (64)

4, WL_ComSite (auction Web site - taken of the site)

Field Name
Data Type
Description
Remarks

cSiteID
int
Auction Web site, code-named
Since the field by

cSiteName
Nvarchar (8)
Site name

cSiteUrl
Nvarchar (64)
Site Address

cSiteVDT
datetime
Effective Date Time

spID
Int
Location code

buyerID
Int
Buyer Code

3.5 Failure to address the requirements

List of possible software, hardware failures, as well as the performance in terms of the consequences and deal with the requirements of the fault.

3.6 Other special requirements

Units such as user security and confidentiality requirements, the requirements on the use of maintainability, can be complementary, accessibility, reliability, operating environment of convertible special requirements.

4 operating environment requirements

4.1 Equipment

Listed in the software needed to run the hardware equipment.

Describe a new type of equipment and its specialized functions, including:

a. Processor type and memory capacity;

b. Core capacity, online or offline, of the type and quantity of equipment;

c. Input and output devices of the type and number of online or offline;

d. Data communications equipment and the number of models;

e. Function keys and other special hardware

4.2 Support Software

Supporting software modules, including when an auction cycle, the data sorted out winners in a timely manner in order to "interactive networks" buyers to add a portal software (windows service application programs or windows), and testing of supporting software and so on.

4.3 Interface

Windows service program modules or the need for windows applications (combination of scheduled tasks), when the end of an auction cycle, sorting out the winners of the data in a timely manner in order to "interactive networks" buyers add portal.

Tags: two ways (RSS), database design (RSS), introduction 1 (RSS), period of time (RSS), functional modules (RSS), definitions (RSS), realization (RSS), auction auction (RSS), gold auction (RSS), auction web (RSS), interactive network (RSS), auction site (RSS), content portal (RSS), fare increases (RSS), interested buyers (RSS), design staff (RSS), bid price (RSS), highest bidder (RSS), prospectus (RSS), feasibility (RSS)

Permalink: http://www.codeweblog.com/auction-web-site-and-database-design-needs-ranking-manual/