Hallux Productions (HP) is a small music publishing and management company focusing on local and regional artists in the Mid-South. The Hallux database is comprised on 25 tables with over one million rows. It contains sales data from 1990 to 2006 from 5000 customers and 400 bands.
Accessing the Hallux Dataset
The Hallux dataset is contained within the Walton College of Business's Enterprise Systems.
The dataset can be accessed with SQL queries within the University of Arkansas's Remote Desktop environment. The best way to access the dataset would be within the University's Teradata SQL Assistant software or Microsoft SQL Management Studio (Systems).
Once an account is obtained, the Hallux database can be queried as fit by the user.
Access To This Dataset
Access to this dataset is for educational use and Systems Access must be requested and approved prior to use. Once access has been approved, the Data Dictionary and Entity Relationship Diagram is available by logging into the requested system and selecting the Instructions tab.
Note: By legal agreement, It is forbidden to download the data from the University of Arkansas systems. This will be strictly enforced.Request Systems Access
Behind the Data
Hallux Productions (HP) is a small music publishing and management company focusing on local and regional artists in the Mid-South. HP aims to be a "one-stop shop" for bands and individual music artists by offering recording contracts, live booking services, marketing, and album sales and distribution. Income is generated through two primary sources: album sales and booking services. To assist in this process, HP employs agents who search for talent, execute and manage recording contracts, and schedule live appearances. HP also maintains relationships with venues in the areas it serves to provide a steady source of talent for the locations and a stream of events for the artists. In return, HP earns a percentage of ticket sales or cover charges for each performance.
The Hallux database contains information that provides a snapshot of the company over all of the ideas discussed above. The Contract table specifies the terms of the contract, which may be one of many possibilities: duration, a certain number of albums, a certain number of live performances, or perpetual. It also specifies the percentage to be earned by the client on album sales and live performances. An agent's contact information, hire date, and status is stored in the Agent table. Album information is recorded in the Album table and live bookings are tracked in the Performance table. The tables containing the most amount of data are the Order tables: Order_Detail, Order_Header, and Order_Source. These tables, in aggregate, detail orders that HP has managed and contain the source, date, total, and the contents of the order. Finally, HP keeps a record of the clients in the Band table. A contact person, status, members, members' contact information, and instruments are all stored.
|Table Name||Time Frame||Rows||Attributes||Size (GB)|
|Agent||1/1/1990 to 12/1/1999||42||5||0.408|
|Album||1/1/1990 to 12/27/2006||2,641||5||1.295|
|Band||1/1/1990 to 12/27/2006||400||6||0.626|
|Band_Member||1/1/1990 to 12/30/2006||1,415||4||0.728|
|Customer_Profile||1/1/1937 to 12/31/1977||4,496||6||0.915|
|Order_Header||1/6/1990 to 1/9/2007||184,126||8||24.189|
|Performance||1/1/1990 to 9/10/2007||65,440||6||6.097|
|Platform data is currently available: Yes|