Sample datamine demos

These are a couple of demonstrations of the dataminer. These demos are from the tutorial that comes with the dataminer, in the sample folder.

The demos are in the form of animated gifs - these should work in most browsers. Once the demo has finished, use your 'back' key to return to this page.

In these demos, a yellow highlightling shows where you'd click if you were doing it yourself.

The demos:

• Produce a breakdown of the data, showing revenue vs. date. animated gif
• Breakdown of revenue by account group. animated gif

The following are some more complex examples, not animated, just screen shots of the results.

• Number of calls per day, excluding users in the 'Clowns' group. Screenshots: table, graph
• Total revenue, per account, since the 29th May. Screenshot: table
• A table showing the date and account that and user used more than 30 minutes of calls. Screen shot: table
• A graph showing minutes and revenue totals for each day, since 29th May. Screen shot: table

The example database

This is the example database schema. It consists of three tables. The sample application stores user accounts, the group that the account is in, and phone calls that are made by each account.

ex_accounts holds the accounts - in our case, very simple data. A more realistic database might store other information about the account, such as real name, password, or whatever

ex_groups holds the account group names. Each account is in one and only one group. Again, a more realistic database would also store other group specific data.

ex_billing holds billing records for the database. Each billing record is attached to an account, and has a date, a quantity (duration), a rate per minute, and the total cost of the call (amount).

Comments about this sample database will probably be ignored. :) It's deliberately very stupid, and doesn't use any particular database specific features.

back to top document

create table ex_groups (
    group_id int PRIMARY KEY,
    group_name char(10)
) 

create table ex_accounts (
    account_id  int PRIMARY KEY,
    account     char(10),               -- account id
    group_id    int                     -- ref into ex_groups
)

create table ex_billing (
    billing_id  int PRIMARY KEY,
    account_id  int,
    edate       char(10),               -- event date as yyyy-mm-dd
    quantity    int,                    -- number of minutes
    rate        float,                  -- rate per minute
    amount      float                   -- total value of call
)