• Publications of The Korean Astronomical Society
• /
• v.19 no.1
• /
• pp.121-128
• /
• 2004

We have constructed a database of Korean historical astronomical records. The database contains observational data recorded from BC 2183 to AD 1910. We have also built a webpage for searching through the database based on the following criteria: (1) dynasties (2) astronomical phenomena (3) reigning kings (4) references (5) keywords. Users may select two or more dynasties to search through the database for a certain phenomena, and compare data with those of other dynasties. The queried data can be primarily sorted by one critetion, and secondarily sorted by another, each in ascending or descending order. The search results give dates both in Solar and Lunisolar calendars, years and dates in Sexagenary cycle, dynasties, reigning kings, astronomical phenomena, and references. The database and webpage were constructed under the research project of the Korean Astronomical Data Center (KADC, http://kadc.kao.re.kr) in Korea Astronomy Observatory (KAO).

• The Bulletin of The Korean Astronomical Society
• /
• v.42 no.2
• /
• pp.88.3-89
• /
• 2017

We present our experiences with open-source NoSQL database systems in analyzing spatial and temporal astronomical data. We conduct experiments of using Redis in-memory NoSQL database system by modifying and exploiting its support of geohash for astronmical spatial data. Our experiment focuses on performance, cost, difficulty, and scalability of the database system. We also test OpenTSDB as a possible NoSQL database system to process astronomical time-series data. Our experiments include ingesting, indexing, and querying millions or billions of astronomical time-series measurements. We choose our KMTNet data and the public VVV (VISTA Variables in the Via Lactea) catalogs as test data. We discuss issues in using these NoSQL database systems in astronomy.

• Publications of The Korean Astronomical Society
• /
• v.21 no.1
• /
• pp.1-9
• /
• 2006

An archiving system designed to enable documenting database of astronomical images, with functions of search and download, is being developed by Korean Astronomical Data Center(KADC) of Korea Astronomy and Space Science Institute(KASI). The system consists of three PCs for web server, database server, and system management server. The search program for the web environment is operated in the web server. In the management server, several utility program we developed are installed: input program for the database, program for transfer from fits to jpg files, program for data recovery and management, and programs for statistics and connect management. The collected data would be sorted out by the system manager to input into the database. The online input is possible in an observatory where the data is produced. We applied the content management system(CMS) module for the database management. On the basic of CMS module, we set up a management system for the whole life cycle of metadata from creation and collection to storage and deletion of the data. For the search function, we employed a technique to extract indices from the metadata. In addition, MySQL is adopted for DBMS. We currently display about 2,700 and 25,000 photographs for astronomical phenomena and astronomical objects on the data, respectively.

• Publications of The Korean Astronomical Society
• /
• v.26 no.1
• /
• pp.1-24
• /
• 2011

Korea Astronomy and Space Science Institute (KASI) has constructed online database of the Korean Astronomical Almanac as a part of the 'Knowledge and Information Business Project 2009' supported by the Ministry of Knowledge Economy. Throughout this project, KASI provides both digitized images and extracted text from the almanac covering approximately 240 years. The primary purpose of this paper is to serve as a reference for users of the almanac database. Hence, we introduce the calendar history and kinds of the astronomical almanac used in Korea, and explain the contents of the almanacs according to its appearance time. We also briefly mention the steps employed in constructing the database system and Web site. Since ancient times, astronomical almanacs have been an essential part of daily life. We, therefore, believe that the astronomical almanac database constructed by KASI will prove its usefulness in various fields, and particularly in the study of historical astronomy.

• Publications of The Korean Astronomical Society
• /
• v.19 no.1
• /
• pp.109-119
• /
• 2004

As a core project of the Korean Astronomical Data Center (KADC) in Korea Astronomy Observatory (KAO), we have constructed a framework of astronomical database using MySQL and JSP. MySQL database server is a powerful open source database management system, and JSP technology provides a simplified, fast way to create dynamic web content. Combined together, MySQL and JSP enable us to develop server-independent web-based applications efficiently in a short amount of time. The MySQL tables and JSP programs embedded in our database are built/written in a way to benefit both users and managers. We plan to expand our database by supplementing additional data in the near future. Our newly constructed database is expected to be the prototype of the Korean Virtual Observatory (KVO).

• The Bulletin of The Korean Astronomical Society
• /
• v.41 no.2
• /
• pp.53.2-53.2
• /
• 2016

We present our experiences with open-source spatio-temporal database systems for managing and analyzing big astronomical data acquired by wide-field time-domain sky surveys. Considering performance, cost, difficulty, and scalability of the database systems, we conduct comparison studies of open-source spatio-temporal databases such as GeoMesa and PostGIS that are already being used for handling big geographical data. Our experiments include ingesting, indexing, and querying millions or billions of astronomical spatio-temporal data. We choose the public VVV (VISTA Variables in the Via Lactea) catalogs of billions measurements for hundreds of millions objects as the test data. We discuss issues of how these spatio-temporal database systems can be adopted in the astronomy community.

• Journal of The Korean Astronomical Society
• /
• v.47 no.3
• /
• pp.115-122
• /
• 2014

The New Vacuum Solar Telescope (NVST) is a 1-meter vacuum solar telescope that aims to observe the fine structures of active regions on the Sun. The main tasks of the NVST are high resolution imaging and spectral observations, including the measurements of the solar magnetic field. The NVST has been collecting more than 20 million FITS files since it began routine observations in 2012 and produces maximum observational records of 120 thousand files in a day. Given the large amount of files, the effective archiving and retrieval of files becomes a critical and urgent problem. In this study, we implement a new data archiving system for the NVST based on the Fastbit Not Only Structured Query Language (NoSQL) database. Comparing to the relational database (i.e., MySQL; My Structured Query Language), the Fastbit database manifests distinctive advantages on indexing and querying performance. In a large scale database of 40 million records, the multi-field combined query response time of Fastbit database is about 15 times faster and fully meets the requirements of the NVST. Our slestudy brings a new idea for massive astronomical data archiving and would contribute to the design of data management systems for other astronomical telescopes.

• The Bulletin of The Korean Astronomical Society
• /
• v.24 no.2
• /
• pp.32-32
• /
• 1999

• Publications of The Korean Astronomical Society
• /
• v.24 no.1
• /
• pp.83-91
• /
• 2009

We have designed data processing server system to include data archiving, photometric processing and light curve analysis for KMTNet (Korea Microlensing Telescope Network). Outputs of each process are reported to the main photometric database, which manages the whole processing steps and archives the photometric results. The database is developed using ORACLE 11g Release 2 engine. It allows to select objects applying any set of criteria such as RA/DEC coordinate and Star ID, etc. We tested the performance of the database using the OGLE photometric data. The searching time for querying 70,000,000 records was under 1 second. The database is fully accessed using query forms via web page.

• Publications of The Korean Astronomical Society
• /
• v.26 no.1
• /
• pp.37-44
• /
• 2011

We constructed a photometric database system which is optimally designed for microlensing events from KMTNet (Korea Microlensing Telescope Network) observation. We developed a framework software for the convenience of archiving, uploading, searching, and downloading of processed photometric data. From various tests for optimal data archiving engines, we found that the MyISAM storage engine shows the best performance. For the high performance of database system, data types of each field are carefully suggested from various combinations of tests especially to correct round-off errors. The developed framework provides the convenience of access to the database server using query forms via web pages, and displays the light curve of selected target for a quick view.