<그림 1> 아카이브 기술을 위한 규범 및 개념 모델의 진화 과정
<그림 2> 주요 개체와 각 개체의 속성을 정의한 모델 예시
<그림 3> Record(RiC-E01)와 Activity(RiC-E11)간의 관계 표현 다이어그램 예시
<그림 4> ANSI/SPARC DBMS 3단계 데이터 독립성 스키마 구조
<그림 5> RiC 개념모델을 데이터베이스 개념 스키마 단계에 대응
<그림 6> PIAAF 프로젝트 데모 프로그램 화면1:AN-BnF-SIAF 간 Person(RiC-E05)의 관계 표현과 검색 도구
<그림 7> PIAAF 프로젝트 데모 프로그램 화면2:Person(RiC-E05)의 개별 항목별 관련 데이터 검색 페이지
<그림 8> 관계형 모델을 사용해 링크드인 프로필을 표현
<그림 9> 링크드인 프로필 정보를 MySQL Workbench를 활용해 설계한 관계형 데이터 모델
<그림 10> 동일한 Organizational Domain을 간략하게 관계형 모델과 그래프형 모델로 표현한 예시
<그림 11> Neo4j를 통해 본 간략한 속성 그래프 모델 표현
<그림 12> RiC-CM 주요 개체 도식화
<그림 13> RiC-CM 보조 개체 도식화
<그림 14> RiC의 개체, 속성, 관계의 개괄적인 구조
<그림 15> RiC의 주요 개체와 보조 개체 구성
<그림 16> Gregorius Painting(원본)을 사진촬영 한 사본 “Photo of painting of Lucas Hirscher”
<그림 17> Photo of painting of LucasHirscher(item)정보의 RiC 기반 맥락
<그림 18> RiC 관계형 데이터 모델링의 개념적 모델 예시
<그림 19> RiC 그래프형 데이터 모델링의 개념적 모델 예시
<그림 20> RiC 관계형 데이터 모델링의 논리적 모델 예시
<그림 21> RiC 그래프형 데이터 모델링의 논리적 모델 예시
<그림 22> 그래프형 데이터 논리 모델에 샘플데이터를 적용해 Neo4j로 구현한 결과
<표 1> RiC-CM 주요 개체
<표 2> RiC-CM 보조 개체
<표 3> Record(RiC-E01)의 관계: Record-Record, Record-Record Set, Record-Record Part, Record-Agent
<표 4> Record(RiC-E01)의 관계: Record-Activity, Record-Position, Record-Occupation, Record-Function, Record-Function(Abstract)
<표 5> Record(RiC-E01)의 관계: Record-Mandate, Record-Documentary Form, Record-Date, Record-Place, Record-Concept/Thing
<표 6> RiC-CM 주요 개체간 관계
<표 7> 그래프형 데이터 모델로서의 속성 그래프와 트리플 저장소의 대응
<표 8> Noe4j 그래프형 데이터모델(Neo4j Browser에서 “:play movie-graph” 실행)
<표 9> RiC 데이터 모델링을 위한 샘플데이터
<표 10> RiC 데이터 모델링을 위한 샘플데이터 기록정보 정리
<표 11> 샘플데이터 기록정보에서 RiC Agent와 Person 개체에 해당하는 정보
<표 12> 샘플데이터 기록정보에서 RiC Position 개체에 해당하는 정보
<표 13> RiC 데이터 모델링을 위한 개체와 속성 매핑
<표 14> RiC 관계형 데이터 모델링을 위한 ‘관계’ 분석(1)
<표 15> RiC 관계형 데이터 모델링을 위한 ‘관계’ 분석(2)
<표 16> RiC 그래프형 데이터 모델링을 위한 ‘관계’ 분석
<표 17> RiC 관계형 데이터 모델링의 2차원 테이블 구조 저장을 위한 ID 설정
<표 18> RiC 그래프형 데이터 모델링을 위한 샘플데이터 시작 정점-끝 정점 설정
References
- Kim, Sang Rae (2015). Data Modeling Stories Determining Project Success or Failure. Seoul: Hanbit Media, Inc.
- Kim, Ik-han (2004). Evaluating Records and Their Descriptive Elements in the Records Management of Korea on the Basis of the Characteristics of a Record and Recordkeeping Metadata Standards. The Korean Journal of Archival Studies, 10, 3-26.
- Kim, Chi Soo (2015). Easy-to-learn Software engineering. Seoul: Hanbit Media, Inc..
- Silverston, Len (2008). The Data Model Resource Book, Vol. 1: A Library of Universal Data Models for All Enterprises(Revised Edition). Sebastopol, California: O'Reilly Media.
- Hernandez, M. J. (2013). Database Design for Mere Mortals (3rd): A Hands-on Guide to Relational Database Design. Boston: Addison-Wesley Professional.
- Kleppmann, Martin (2016). Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems, The Big Ideas Behind Reliable, Scalable, and Maintainable Systems. Sebastopol, California: O'Reilly Media.
- Fowler, Martin (2002). Patterns of Enterprise Application Architecture. Boston: Addison-Wesley Professional.
- Institute of Digital Archiving Myongji University (2017a). A Study on Conceptual Redesign of the next generation record management: Part 1. http://www.archives.go.kr/next/news/viewPublicationList.do?bg_no=428.
- Institute of Digital Archiving Myongji University (2017b). A Study on Conceptual Redesign of the next generation record management: Part 2. http://www.archives.go.kr/next/news/viewPublicationList.do?bg_no=429.
- Park, Zi-Young (2008). A Study on the Application of a CRM-based FRBR Ontology for Cultural Heritage Information: Based on the FRBRoo(object-oriented FRBR). Journal of the Korean Biblia Society for Library and Information Science, 19(2), 45-62.
- Park, Zi-Young (2016). Analyzing the Next-generation Archival Description Standard: "Record in Context" of ICA EGAD. Journal of Korean Society of Archives and Records Management, 16(1), 223-245. http://dx.doi.org/10.14404/JKSARM.2016.16.1.223
- Park, Zi-Young (2017a). Transition of Archival Description from ISAD(G) to Record in Context Conceptual Model. Journal of Korean Society of Archives and Records Management, 17(1), 93-115. https://doi.org/10.14404/JKSARM.2017.17.1.093
- Park, Zi-Young (2017b). Improving Archival Descriptive Standard Based on the Analysis of the Reviews by Archival Communities on RiC-CM Draft. The Korean Journal of Archival Studies, 54, 81-109.
- Park, Zi-Young (2017c). Expanding and Improving FRBR Conceptual Model through FRBRoo. Journal of the Korea Society for Information Management, 34(4), 201-225. https://doi.org/10.3743/KOSIM.2017.34.4.201
- Baek, Wook-in (2013). Digital data.information.knowledge. Seoul: CommunicationBooks, Inc.
- Newman, Sam (2015). Building Microservices: Designing Fine-Grained Systems. Sebastopol, California: O'Reilly Media.
- Oh, Jin-Kwan & Yim, Jin-Hee (2018). A Study on Designing a Next-Generation Records Management System. Journal of Korean Society of Archives and Records Management, 18(2), 163-188. https://doi.org/10.14404/JKSARM.2018.18.2.163
- Okuno, Mikiya (2015). Introduction to relational database practice(理論から學ぶデ一タベ一ス實踐入門). Japan: Gijutsuhyoronsha.
- Won, Jong-Kwan (2008). A Study on Reconciliation of Evidence and Memory Based on the Characteristics of the Records Continuum. Master's Thesis, Department of Information and Records Management, The Graduate School of Hankook University of Foreign Studies.
- Lee, Yu-Been & Rieh, Hae-young (2017). A suggestion of interface for ontology-based record retrieval system. Journal of Korean Society of Archives and Records Management, 17(1), 217-244. https://doi.org/10.14404/JKSARM.2017.17.1.217
- Lee, Chun Sik (2005). Database design and implementation (data modeling with performance considerations). Seoul: Hanbit Media, Inc.
- Lee, Chun Sik (2008). Design and build a database that seems to know. Seoul: Hanbit Media, Inc.
- Rieh, Hae-young (2013). Record Organization. Seoul: SuninBook.
- Lee, Hyun Sil & Han, Sung Kuk (2006). Conceptual Modeling of Record Management Metadata. Journal of the Korea Society for Information Management, 23(3), 23-48. https://doi.org/10.3743/KOSIM.2006.23.3.023
- Yim, Jin-Hee, Lee, Dae-Wook, Kim, Eun-Sil, & Kim, Ik-Han (2012). Directions for Developing Database Schema of Records in Archives Management Systems. The Korean Journal of Archival Studies, 34, 57-105.
- Korean Society of Archival Studies (2014). Dictionary of Records and Archival Terminology.
- Hyun, Moon Soo (2014). A Study on the Conceptualization of Information Resources for Localities Based on the FRBRoo/CIDOC CRM. Journal of the Korean Biblia Society for Library and Information Science, 25(4), 265-290. https://doi.org/10.14699/kbiblia.2014.25.4.265
- Hyun, Moon Soo & Seol, Moon-won (2018). An Exploration of the Direction of Development of the Next Generation Conceptual Model for Organizing Public Digital Records. The Korean Journal of Archival Studies, 56, 183-212.
- Hwang, Jin-hyun & Yim, Jin-Hee (2012). A study on Multiple Entity Data Model Design for Visual-Arts Archives and Information Management in the case of the KS X ISO 23081 Multiple Entity Model. The Korean Journal of Archival Studies, 33, 155-206.
- ANAI & ICAR (2016). Records In Contexts: A conceptual model for archival description(draft v0.1, september 2016): Il contributo italiano. http://www.ilmondodegliarchivi.org/images/Quaderni/MdA_Quaderni_n2.pdf
- Belinda Battley, Elizabeth Daniels & Gregory Rolan (2014). Archives as multifaceted narratives: linking the 'touchstones' of community memory. Archives and Manuscripts, 42(2), 155-157. https://doi.org/10.1080/01576895.2014.911675
- DB-Engines Ranking of Graph DBMS, 31 systems in ranking, December 2018 Available at: https://db-engines.com/en/ranking/graph+dbms (last visited 2018-12-31).
- DOREMUS: DOing REusable MUSical Data = Donnees en REutilisation pour la Musique en fonction des Usage. Web site. Available at: www.doremus.org/ (last visited 2018-12-31).
- EGAD (2016). International Council on Archives. Expert Group on Archival Description. 2016. Record In Contexts: A Conceptual Model For Archival Description. Consultation Draft v.0.1.
- EGAD (2017). Presentation of the standard "Records in Context." ICA Expert Group on Archival Description (EGAD): The ALA-ICA annual Conference 2017 Mexico, 27 to 29 November 2017.
- EGAD (2018). Presentation of the standard "Records in Context" Records in Contexts (RiC): a standard for archival description developed by the ICA Experts Group on Archival Description. International Council on Archives, Paris. Retrieved 12 January 2018.
- Fredric. M. Miller (2002). 아카이브와 매튜스크립트의 정리와 기술. (한국국가기록연구원 감수/조경구 역). 서울: 진리탐구.
- Gretchen Gueguen, Vitor Manoel Marques da Fonseca, Daniel V. Pitti, and Claire Sibille-de Grimouard (2013). Toward an International Conceptual Model for Archival Description: A Preliminary Report from the International Council on Archives' Experts Group on Archival Description. American Archivist 76, no. 2 (Fall/Winter 2013): 567-584. https://doi.org/10.17723/aarc.76.2.p071x02401282qx2
- Ian, Robinson, Jim, Webber, & Emil, Eifrem (2015). Graph Databases(2nd Edition): New Opportunities for Connected Data. O'Reilly Media.
- ICA EGAD (2018). Semantizing and visualising archival metadata: the PIAAF French prototype online, Florence Clavaud (Archives nationales de France EGAD) 4 May 2018. ICA Experts Group on Archival Description 2017 Annual Meeting - Rome, Italy 23-25 October 2017.
- ICA Experts Group on Archival Description, Records in Context: A Conceptual Model for Archival Description, Consultation Draft v0.1 September 2016, International Council on Archives, Paris, September 2016, pp. 116.
- Ketelaar, E. (2011). Cultivating Archives, Archival Science 12 (2012) 19-33. https://doi.org/10.1007/s10502-011-9142-5
- KROENKE (2009). Database Processing 11/E: Fundamentals, Design, and Implementation (Paperback). Pearson Education.
- Llanes-Padron, D., Pastor-Sanchez, J.A. (2017). Records in contexts: the road of archives to semantic interoperability. Program, Vol. 51 Issue: 4, 387-405. https://doi.org/10.1108/PROG-03-2017-0021
- M. Achichi, R. Bailly, C. Cecconi, M. Destandau, K. Todorov, & R. Troncy. DOREMUS: Doing Reusable Musical Data. In 14th International Semantic Web Conference (ISWC), 2015.
- McKemmish, S. (2017). Recordkeeping in the continuum: An Australian tradition. In A. J. Gilliand, S. McKemmish, & A. J. Lau (Eds.), Research in the Archival Multiverse (pp. 122-160). Clayton, Victoria: Monash University Publishing.
- Pearson Education (2009). Database Processing 11/E: Fundamentals, Design, and Implementation.
- Reed, Barbara (2017). New conceptual model for recordkeeping description, Records in Contexts. (2017. 2. 1).
- neo4j 블로그(rdbms vs graph datamodeling). 검색일자: 2018.12.31. https://neo4j.com/blog/rdbms-vs-graph-data-modeling/
- neo4j 홈페이지. 검색일자: 2018.12.31. https://neo4j.com/developer/guide-data-modeling/
- PIAAF 프로젝트 홈페이지. 검색일자: 2018.12.31. http://piaaf.demo.logilab.fr/
- Records in Contexts - Compendium 홈페이지. 검색일자: 2018.12.31. https://web.esrc.unimelb.edu.au/ICAD/biogs/E000166b.htm: 'RiC Primary Entities: What are they?
- Records in Contexts - Compendium 홈페이지. 검색일자: 2018.12.31. https://web.esrc.unimelb.edu.au/ICAD/biogs/E000396b.htm: 'RiC Supporting Entities: What are they?
- RiC-IM HOME: ICA Records in Context - Compendium. 검색일자: 2018.12.31. https://web.esrc.unimelb.edu.au/ICAD/index.html
- 국가기록원 영구기록물 기술규칙 [NAK 13:2011(v2.0)]. (행정안전부 고시 제2011-42호).