A Wetpaint Site
Sign in to Wetpaint
Home
Discussion Forum
What's New
Photos
Droplets
Members
To-Dos
Invite
Join This Site
Already a member?
Sign in
DVD Store Schema
Page Versions
To-Dos
Key:
additions
deletions
Please select two page versions to compare - check the checkbox to the right of each version.
Showing 7 pages
Date/Time
Made By
Edit Note
Type
Scope
Compare
Mar 29 2007, 6:39 PM EDT
dave_jaffe
edit
43 words added
48 words deleted
Change:
Orderlines ORDERLINEID 600 million
ORDERID
PROD_ID
QUANTITY
ORDERDATE
Cust_Hist CUSTOMERID 600 million
ORDERID
PROD_ID
Products PROD_ID 1 million
CATEGORY
TITLE
ACTOR
PRICE
SPECIAL
COMMON_PROD_ID
Inventory PROD_ID 1 million
QUAN_IN_STOCK
SALES
Reorder PROD_ID variable
DATE_LOW
QUAN_LOW
DATE_REORDERED
QUAN_REORDERED
DATE_EXPECTED
Categories CATEGORY
16
CATEGORYNAME
Stored Procedures
-----------------
The DVD Store
View changes from previous version.
(Word count: 624)
Mar 29 2007, 6:13 PM EDT
dave_jaffe
edit
5 words added
9 words deleted
Change:
----- ------- -------------------------------
Customers
CUSTOMERID
200 million
FIRSTNAME
LASTNAME
ADDRESS1
ADDRESS2
CITY
STATE
ZIP
COUNTRY
REGION
EMAIL
PHONE
CREDITCARDTYPE
CREDITCARD
CREDITCARDEXPIRATION
USERNAME
PASSWORD
AGE
INCOME
GENDER
200 Million
Orders
ORDERID
120 million
ORDERDATE
CUSTOMERID
NETAMOUNT
TAX
TOTALAMOUNT
120 Million
TOTALAMOUNT
Orderlines
ORDERLINEID
600 million
ORDERID
PROD_ID
QUANTITY
ORDERDATECust_Hist
CUSTOMERID
View changes from previous version.
(Word count: 624)
Mar 29 2007, 1:57 PM EDT
dave_jaffe
edit
1 word added
1 word deleted
Change:
Table
Table
Columns
Number of Rows (Large database) -----
-------
-------------------------------Customers
CUSTOMERID
200 million
FIRSTNAME
LASTNAME
ADDRESS1
ADDRESS2
CITY
STATE
ZIP
COUNTRY
REGION
EMAIL
PHONE
CREDITCARDTYPE
CREDITCARD
CREDITCARDEXPIRATION
USERNAME
PASSWORD
AGE
INCOME
GENDEROrders
ORDERID
120 million
ORDERDATE
CUSTOMERID
NETAMOUNT
TAX
TOTALAMOUNTOrderlines
ORDERLINEID
600 million
ORDERID
PROD_ID
QUANTITY
View changes from previous version.
(Word count: 624)
Mar 29 2007, 1:54 PM EDT
dave_jaffe
edit
1 word added
15 words deleted
Change:
realistic simulation of database activity is achieved without needing to model thousands of users. <dave_jaffe@dell.com> and <todd_muirhead@dell.com> 12/16/05
Back
Return
to DVD Store main page
Back to Architecture and Technology main page
Back to the Dell TechCenter home page
View changes from previous version.
(Word count: 624)
Jan 29 2007, 12:19 PM EST
Kitjer
edit
20 words added
Change:
a realistic simulation of database activity is achieved without needing to model thousands of users.
<dave_jaffe@dell.com> and <todd_muirhead@dell.com>
12/16/05
Back to DVD Store main page
Back to Architecture and Technology main page
Back to the Dell TechCenter home page
View changes from previous version.
(Word count: 638)
Jan 28 2007, 10:10 PM EST
Kitjer
DJ
edit
616 words added
Change:
the CUSTOMERID. If the customer is a new customer, New_customer is used to create a new row in the Customers
table with the user's data. Following the login phase the customer might search for a DVD by category,
actor or title. These are implemented by Browse_by_category, Browse_by_actor and Browse_by_title, respectively.
View changes from previous version.
(Word count: 618)
Jan 28 2007, 10:09 PM EST
Kitjer
create
No content added or deleted.
Change:
Created by
Kitjer
Jan 28 2007, 10:09 PM EST for: no reason given
JavaScript must be enabled in order for you to contribute to this site.
To start contributing, enable JavaScript by changing your browser options, then
try again
.
Site pages
Home
Blogs Chats and RSS
Whitepapers
Virtualization
OpenManage Systems Management
Demonstrations
HPCC
Blades
EqualLogic
Storage
Microsoft
Oracle
Linux
DataCenter Power and Cooling
Future of Computing - Systems Management
Desktop to Data Center
DVD Store
DVD Store Forum Page
DVD Store Frequently Asked Questions
DVD Store Readme
DVD Store Related Links
DVD Store Schema
DVD Store - December 2007 Version
LAMP Stack
SAP
TechCenter Extras
Solaris
new page
(Uncategorized)
Top Contributors
Loading...
Browse by Keywords
Loading...