Apache Stonehenge : StockTrader Database
This page last changed on May 06, 2010 by nickh.
DescriptionThe Stonehenge StockTrader Sample Application relies on a database for storage of user information, stock information, and application configuration data. In the M1 release of the Stonehenge StockTrader Sample Application, Microsoft SQL Server was the only database supported, however support has now been added for using MySQL as the data store.
Tables Contained in the DatabaseTables that have been marked with a ACCOUNT TableThe ACCOUNT table is used to store account details about users (as opposed to identifying information). It keeps track of events such as account creation and logins/logouts, as well as the current balance for the account. The PROFILE_USERID column is used to correlate information in this table with information in the ACCOUNTPROFILE table.
ACCOUNTPROFILE TableThe ACCOUNTPROFILE table is used to store personal information about registered users of the StockTrader application. It contains contact information, payment information, and authentication information (stored as plain text).
BSTOOPS Table
The BSTOOPS table is used as a lookup table by the Configuration Service to determine the Order Processor Service instance that a given Business Service instance is configured to call.
CLIENTTOBS Table
The CLIENTTOBS table is used as a lookup table by the Configuration Service to determine the Business Service instance that a given StockTrader Client instance is configured to call.
DBCONFIG Table
The DBCONFIG table is used to store information about known instances of the StockTrader Database that can be used. This table is used primarily by the StockTrader Configuration Service.
HOLDING TableThe HOLDING table is used to store information about the various stock holdings that users of the StockTrader application currently have.
ORDERS TableThe ORDERS table is used to store information about all stock orders that users of the StockTrader application have ever placed.
QUOTE TableThe QUOTE table is used to store the current state of the market.
SERVICE Table
The SERVICE table is used as a lookup table by the StockTrader Configuration Service to resolve service endpoints and security requirements.
|
![]() |
Document generated by Confluence on Jun 22, 2010 14:31 |