The Storefront demo is a Java application showcasing key benefits of NuoDB v1.1:
Use the Simulated User Setup and Node Setup forms to increase the number of customer workloads and NuoDB nodes
Multiple Tenancy. Launch multiple stores with the same NuoDB nodes. Click Show DDL and you’ll have the scripts to populate and alter your additional databases.
Variable Workloads. Dynamically change the mix of OLTP and analytic transactions. Use the Simulated Users form to change the ratio of back office to shopper workloads.
You can access the Storefront demo from the Console Home tab.
More Information
Adding Addtional Storage Managers and Transactions Engines Adding Muti-Tenancy Databases
Using Storefront DDLs in Multi-tenancy Databases
To launch the Storefront Demo:
Open a browser to http://localhost:8080. The NuoDB Console opens.
Toward the bottom right of the page, click Storefront.
The Carousel scrolls to the Store Front Demo.
Click Open Storefront Demo to launch the demo.
Note
NuoDB v1.1 or later must be installed in order to access the Console.
1.
2.
To access the Storefront web app source files:
If the NuoDB Console is not already up, open a browser tab to http://localhost:8080. From the navigation bar, choose Demos, and then in the Storefront panel click GitHub.
NuoDB® Company Website
Copyright © 2013 NuoDB, Inc. All rights reserved
SPACERMulti-Tenancy
1.
2.
3.
4.
5.
6.
Adding Multi-Tenancy Databases
To add additional Storefront databases to the schema:
Navigate to the Console > Admin tab.
In the Domain Overview gadget, click Start Database.
The [Start Database] Naming screen appears.
Provide a name for your database and click Next.
The [Start Database] Configure Storage Managers screen appears.
A new database is created by naming it. In this example, we’ll name it Storefront2.
Choose an archive directory for the database from the list view of available hosts.
Provide a path for the archive directory in the Archive Directory textbox, and click Submit. The Storage Manager archive directory is configured.
Additional parameters are also configurable from this dialog. To access it again, deselect the Host and select it again. The Configure Storage Manager dialog re-opens.
6.
7.
8.
9.
Click Next.
The Configure Transaction Engines screen appears.
Select a host for the TE from the list of available hosts, and click Next. The DBA Credentials screen appears.
Provide DBA credentials for new database, select Confirm tat you want to create this database, and click Finish.
The database is created.
Repeat steps 1-8 to provision each additional database.
1.
2.
3.
4.
Adding Storage Managers and Transactions Engines To add Transaction Engines or Storage Manager:
Open a browser window to http://localhost:8080, then click the Admin tab, and in the Domain Overview gadget, click the Databases li nk.
If you are not logged in the Domain, you will land on at the Admin/Login dialog, and must login to the domain and then navigate to the Admin tab. Provide the domain credentials for the Storefront Demo (you most likely installed it to the quickstart domain):
Domain_Username: quickstart Domain Password: quickstart
The Admin > Databases screen opens.
In the Databases, click Storefront.
The Database: Storefront screen appears.
In the Database section, click Add Process The Add Process dialog appears.
4.
5.
6.
In the General tab, choose:
Database: Storefront [ or other multi-tenancy DB ] Host: Select a Host from the list
Type: Transaction Engine or Storage Manager Commit Mode: Local or Remote
Click Submit to add the process (TE or SM) to the database.
Repeat step 3-4 for each additional TE or SM you want to add.
NuoDB® Company Website
Copyright © 2013 NuoDB, Inc. All rights reserved
SPACER1.
2.
3.
4.
Using Storefront DDLs in Multi-Tenancy DBs
To use the Storefront DDLs in newly created (multi-tenancy) databases:
This procedure assumes additional databases have been created for the Storefront Demo. If they haven’t, follow the steps in To add additional , to do so.
databases to the Storefront schema
Open the Storefront Demo and NuoDB Console (http://localhost:8080/explorer.html) in separate browser windows.
In the Storefront Demo tab, click the Control Panel button to make sure you’re in the right place, and then click the DDL button.
The Storefront DDL textbox opens.
Select and copy a DDL statement you would like to use, then switch browser tabs to the NuoDB Console > Explorer window.
Move to the Console > Explorer browser tab, and in the Database Hierarchy, double-click the Storefront2 database—or whatever you named it—in this example, Storefront2 is new database), and click Login.
User: StorefrontUser2 Password: StorefrontUser2
Note
The Console opens to the Explorer tab.
4.
The Storefront2 Schemas and Security directories become visible in the Database Hierarchy tree.
5.
6.
7.
Click Execute to run the query.
If you are not already logged into the Domain, you will be prompted to do so before the query can run. In this example we have installed the Storefront Demo in the quickstart domain.
Domain_Username: quickstart Domain Password: quickstart
Repeat steps 3, 5 and 6 for each DDL statement.
NuoDB® Company Website
Copyright © 2013 NuoDB, Inc. All rights reserved
SPACER1.
2.
Simulated User Setup
Use the Simulated Users form to change the ratio of back office to shopper workloads.
Click the Load 900 Real Products (with pictures) button -or- Generate 5000 random products (no pictures) to load products into the database.
Product data is loaded into the database.
Add users in the #Users column and click Update Users.
Storefront Status Bar
Control Panel
The control panel is the home page of the demo where the Simulated User Setup
Shopping Site
Opens the Storefront shopping site. Items can be browsed, reviewed, added to the shopping cart, quantities adjusted, and cart checking out (credit card information is not collected or processed in this demo).
Service calls/sec.
Service Calls per Second
Graphical representation of the number of service methods being called per second.
Click the button to view a graphical breakdown by service method:+
addProduct
Service processing time is the amount of time it takes to execute the service method on the web server side. This includes database transaction time (with network latency) plus any business logic processing time on the web server side.
Store items in carts
Four graphical displays:
Total Items in Shopping Carts Items Purchased per Second
Active Customer Sessions (20 min. expiry) Reviews per Second
Simulator active users
Two simulations are presented:
Active Simulated Users Simulated Steps per Second
Click the +/- button to toggle the view between aggregate and segmented views.
Segmented Views
The segments displayed for each view are as follows:
Active Simulated Users
Back office: Analyst
Customer: Browsing & reviews
Customer: Fast purchaser [ needs definition ] Customer: Instant purchaser [ needs definition ] Customer: Slow purchaser
Simulated Steps per Second
ADMIN_RUN_REPORT BROWSE
BROWSE_CATEGORY BROWSE_NEXT_PAGE BROWSE_SORT CART_CHECKOUT CART_UPDATE CART_VIEW
PRODUCT_ADD_REVIEW PRODUCTPADD_TO_CART PRODUCT_VIEW_DETAILS
NuoDB® Company Website