1 / 15

Web based approach to managing audio and video archive for unique Bulgarian bells

Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 . Web based approach to managing audio and video archive for unique Bulgarian bells. Tihomir Trifonov, Tsvetanka Georgieva Department of Mathematics and Informatics,

lamont
Download Presentation

Web based approach to managing audio and video archive for unique Bulgarian bells

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 Web based approach to managing audio and video archive for unique Bulgarian bells Tihomir Trifonov, Tsvetanka Georgieva Department of Mathematics and Informatics, University of Veliko Tarnovo “St. St. Cyril and Methodius”, Bulgaria The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  2. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 • The aim of the presented paper is to propose a Web based approach to managing audio and video archive for unique Bulgarian bells. • In the present time, we work on a project “Research and Identification of Valuable Bells of the Historic and Culture Heritage of Bulgaria and Development of Audio and Video Archive with Advanced Technologies”, whose purpose is to study and identify several dozens of the most valuable bells in our churches, monasteries and museums. 2 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  3. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 An audio and video archive is developed by using advanced technologies for analysis, reservation and data protection, and it contains: • the main bells' characteristics: design, form, type, geometric size, decorative and artistic scheme, weight, material, state, characteristics of chime, data about the producer and owner of the bell, estimation of its historical value; • digital photos and video recordings of the bells while being tolled; • the frequency spectrum of the bells during a stroke; • the bells' frequency spectrum in main tone; • charts representing the sound fade by time, sound stream, sound pressure and other acoustic characteristics, etc. 3 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  4. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 • The developed client/server system provides users the possibility of accessing information about different characteristics of the bells according to their specific interests. • We describe the architecture of the Web based system and the services, included in its realization. • We also represent the structure of the created database that stores the necessary information. 4 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  5. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 The architecture of the system 5 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  6. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 • The layer for data processing is realized by using the database management system. For the present system we use Microsoft SQL Server, which allows efficient storage of large databases and provides functionality for accessing the data. • The application level is realized by using Web server. It provides the possibility for dynamic generation of the information. Apache is chosen as a Web server and PHP (Hypertext Preprocessor) for program modules development from the server side. • The client part of the system presents the data for users by using convenient browser (such as Internet Explorer,Mozilla Firefox, etc.). The possibility of changing the language of the interface (Bulgarian, English) is done. 6 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  7. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 Page from the application 7 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  8. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 Monastery “St. Transfiguration” near the town of Veliko Tarnovo 8 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  9. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 Church “St. Nikolay” in Veliko Tarnovo, View close to the bell 9 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  10. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 The connection between BellDB and MatLab provides possibility for analyzing the sounds of the bells and to search a concrete bell by a sample of its sound. Real sound of the given bell and its 3D spectrogram, computed in MatLab 10 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  11. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 Data acquisition of the experimental data (PULSE 11, B&K) 11 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  12. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 • The model of the BellDB database in keeping with the entity-relationship model (ER model). • The objects of the ER model are depicted as rectangles, their attributes as ellipsis, and the relations as rhombuses. 12 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  13. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 ER diagram of BellDB database Relational model of BellDB database 13 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  14. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 References • P. Chen, The Entity-Relationship Model: Toward a Unified View of Data, ACM Transactions on Database Systems, Vol.1, No.1, 1976, pages 9-36. • H. Garcia-Molina, J. D. Ullman, J. Widom, Database Systems: The Complete Book, Williams, 2002. • Martin Gruber, Mastering SQL, SoftPress, Sofia, 2001. • Microsoft Corporation, MCSE Training: Microsoft SQL Server 2000 – Design and Implementing Databases, SoftPress, Sofia, 2001. • SoftPress Publisher, Programming with JavaScript, SoftPress, Sofia, 2001. • http://javascript.internet.com • http://www.microsoft.com/sql • http://www.php.net 14 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

  15. Tenth International Conference on System Analysis and Information Technologies, Kyiv, Ukraine, 2008 Thank youfor your attention! Спасибо за внимание! 15 The work was supported partially by the Bulgarian National Science Fund under Grant KIN-1009/2006

More Related