Title page for etd-0831109-135136


[Back to Results | New Search]

URN etd-0831109-135136
Author Yu-lin Liou
Author's Email Address No Public.
Statistics This thesis had been viewed 5578 times. Download 1099 times.
Department IAMPUT
Year 2008
Semester 2
Degree Master
Type of Document
Language zh-TW.Big5 Chinese
Title Development of Sound Database for Fishes in Taiwan by Relational Model
Date of Defense 2009-07-29
Page Count 73
Keyword
  • Relational Model
  • 3-Tier System
  • Database
  • Frequency Endpoint Detection
  • Time Endpoint Detection
  • Fish Sounds
  • Entity-Relationship Diagram
  • Normalization
  • Abstract The goal of development of sound database for marine fishes in Taiwan not only preserves data, but also wants to provide a common ground of data sharing to increase the efficiency for the study of fish behavior, automatic recognition, localization, and tracking. In order to provide the sound quality in terms of signal-to-noise ratio to users, the fish sound recording will be analyzed before uploading. Because most available data were recorded either in the field or in fish tank, the fish sounds were extracted by using two different automatic detection methods. If fish sound recordings were from the field, the Time Endpoint Detection was applied by the processing a 0.5-s time frame with 50 % overlapping. Then the energy of the time frame was obtained by the sum of square of amplitude and the median of the energy plus a standard deviation was established as the threshold to extract fish sounds. If the recording was made in the fish tank, the Frequency Endpoint Detection was applied by 0.5-s time frame with 50 % overlapping. Then each time frame will be transformed into spectrum and the energy ratio of each frequency will be calculated from the spectrum. Finally the information entropy was obtained from the energy ratio and the detection threshold was set on standard deviation above the median of the information entropy. From two different automatic detection methods, the sound quality was presented in the signal-to-noise ratio, which was the average power of signal divided by average power of the background noise. The fish sound database was a 3-Tier system and developed by PHP and MySQL. In order to reduce the storage size and maintain the integrity of data, the Relational Model was applied. Firstly, the recording data were conceptually represented as Entity-Relationship Diagram(ERD). Secondly, the ERD was transformed to relational schemas. Thirdly, the schemas was normalized by first, second, and third forms. To improve the users’ efficiency the sound database provides three interfaces. One was data uploading, another was data searching according to the keyword of creature name, recording area, and recording time, the other was data comparing by recording number.
    Advisory Committee
  • Michael Hin-Kiu Mok - chair
  • Shih-Chieh Jack Hsu - co-chair
  • Ruey-Chang Wei - advisor
  • Files
  • etd-0831109-135136.pdf
  • indicate access worldwide
    Date of Submission 2009-08-31

    [Back to Results | New Search]


    Browse | Search All Available ETDs

    If you have more questions or technical problems, please contact eThesys