陶 磁 器 デ ー タ ベ ー ス ソ リ ュ ー シ ョ ン 図1 中世 陶 磁 器 デ ー タベ ー ス 109
A Database Solution for Ceramic Data OGINO Shigeharu Abstract This paper describes various aspects of the development of a database for handling ceramic data. In preparing aca demic papers and in sorting and processing archaeological materials, the ability to handle large amounts of data in quick and easy fashion is desirable. In the case of research on ceramics in particular, as it is necessary to process large amounts of data, it is no longer sufficient merely to apply traditional methods of research. In light of this the author has devised a new method for rapidly processing ceramic data with a computer. For the past ten years the author has been compiling the Medieval Ceramics Database is conducted mainly with 17 of its 54 fields. The field used to define a site is of great importance, sites varies based on the way a site is defined. Table 1 shows the approximate (MCD). Data processing as the number of minimum number of vessels estimated from sherd counts for various archaeological contexts; a large difference in the number of sites represented based on which criteria are selected, those of field "Iseki" versus "Iseki 1." emerges What kinds of output tables are called for in research on medieval ceramics? In most cases, these consist of the numbers of sites or items recovered for various production centers or vessel forms. Accordingly, a total of 70 differ ent output forms have been envisioned, and ways were considered for producing them with a computer. As a means centered on the Macintosh, which can also be used with Windows, the automated processing of data using AppleScript and Microsoft Visual Basic for Applications (VBA) was envisioned. After several methods were considered, data processing which links AppleScript and VBA was taken as the basis. In other words, an AppleScript program is used to convert a FileMaker Pro database into Excel format, after which the data can be processed and an output of the results made with VBA programming. An explanation is given of a VBA program "PC (Sanshutsu)," which outputs the amounts of recovered ceramic ma terials per production center. With AppleScript or VBA programming it is possible to control the orders to be executed and thereby obtain a high level of data processing, and moreover to utilize other applications, and to devise and employ user interfaces. The author has developed two GUI (Graphical User Interfaces), one for AppleScript programming and the other for VBA. By utilizing these GUI, it is possible for the user obtain output results in dialog fashion by simply clicking buttons. This application makes it possible to obtain output tables as desired in simple and easy fashion for large amounts of ceramic data. Keywords: Database, Macintosh; Windows; FileMaker Pro; Excel; AppleScript; VBA; programming, ceramics; Medieval period; western Japan 122