Mix Master

January, 1998 - May, 1998
MS Windows 95/98/ME, MS Visual FoxPro 5.0, MS SQL, COM, OCX, ActiveX
Technologies: MS SQL (Transact SQL)
The main purpose of this system – is the calculation and scheduling radio station broadcasting time, as well as operating music database. The main elements and objects of the database are albums, performers and music compositions (songs). Besides these, there are a many other objects, used as additional characteristics for scheduling and statistical analysis. These additional objects include music style, performer’s language, rhythm, vocal type etc. Flexibly setting algorithm of scheduling and user-friendly mechanism of broadcast time subdivision into blocks allow to calculate music time length even in most difficult cases, while considering news, advertisement or any other program broadcasts. Scheduling is carried out in accordance with a specifically developed principle, which provides a user with a possibility to manage the process in detail. Schedule templates for each weekday were developed for this purpose. Every template is an hourly chart, where every hour is subdivided into arbitrary number of blocks. Every block, in its turn, is subdivided into a number of songs. Every song within the template receives a set of criteria, which help to select songs according to their priority characteristics. After the schedule is formed, a user can edit it manually, save it or print it out. The patterns, formed once, can be used for rather long periods of time, since the program monitors the broadcast frequency of songs and tries to distribute them evenly, while considering the song popularity level. To realize this, the system has a distribution function, which assists a user in determining broadcast frequency of a song depending on its popularity. Thanks to the intellectual selection algorithm there is practically no need to manually edit schedules produced. If the program cannot select a song (if selected criteria of the template are too strict), it gradually eliminates unnecessary criteria and finds the most appropriate song. Finally, the module of administration and statistical analysis allows to monitor plenitude and diversity of music database, and to replenish it when necessary.