제출문 국가기록원장귀하

제출문 국가기록원장귀하

연구결과보고서요약문

제 1 장총괄연구개발과제의최종연구개발목표

연구개발추진내용 모든전자기록물을포괄하는메타데이터프레임워크 개발 연구개발연차 차년 진척도 기존의페이스북 트위터아카이빙관련연구조사 페이스북 트위터기록물자동수집을위한수집도구연구개발 페이스북 트위터장기보존포맷및저장방안연구개발 페이스북 트위터기록물에대한분석 통계기능개발 페이스북 트위터장기보존포맷재현도구및브라우저 개발 페이스북 트위터수집 보존 재현도구테스트베드구현및시험적용평가

제 2 장총괄연구개발과제의최종연구개발내용및방법 번호 NAK 메타데이터 웹기록물메타데이터 행정정보시스템데이터세트메타데이터 1 생산행위자-> 기안자 Creator content_info->org->system->org_name content_info->org->system->orgcode 2 생산행위자-> 수신자 package->receiver 3 생산행위자-> 발신자 package->sender 4 기록식별자 Identifier package->id 5 기록물명 Title package->title 6 기술 Description package->description 7 주제 Keywords 8 유형 RecordType 9 저장매체 Format 10 날짜-> 생산일자 CreationDateTime package->production_date 11 날짜-> 종료일자 package->end_date 12 날짜-> 등록일자 package->registration_date 13 생산관리-> 생산근거 Laws content_info->org->system->law_type content_info->org->system->law_name content_info->org->system->law_pre 14 권한-> 접근 AccessLevel

15 이용이력 UsingHistory 16 보존이력-> 보존처리일시 ArchivingDateTime 17 보존이력-> 보존행위자 Archiver 18 관계 Relation 19 언어 Language

제 3 장총괄연구개발과제의최종연구개발결과 l l l

제 4 장총괄연구개발과제의연구결과고찰및결론

제 5 장총괄연구개발과제의연구성과

SNS 수집 보존 활용의프로세스정립 행정기관의 SNS 생성및수집체계화 전자기록물과함께활용통계등으로활용극대화 미래형디지털아카이브를위한기본토대로활용 수집 보존 활용의표준화과정을거쳐다른복합전자기록물관리체계에적용가능 행정기관의 SNS 장기보존사례를연구및교육자료로홍보 민간이운영하는 SNS 에대한영구보존에활용

제 6 장기타중요변경사항 제 7 장참고문헌

제 8 장첨부서류

제 9 장제 1 세부연구개발과제의최종연구개발목표

제 10 장제 1 세부연구개발과제의최종연구개발내용및방법

<?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/xmlschema elementformdefault="qualified targetnamespace="http://api.facebook.com/1.0/ xmlns:ns1="http://api.facebook.com/1.0/ xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"> <xs:import namespace="http://www.w3.org/2001/xmlschema-instance" schemalocation="xsi.xsd"/> <xs:element name="fql_query_response"> <xs:complextype> <xs:sequence> <xs:element maxoccurs="unbounded" ref="ns1:stream_post"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="stream_post"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:post_id"/> <xs:element ref="ns1:viewer_id"/> <xs:element ref="ns1:app_id"/> <xs:element ref="ns1:source_id"/> <xs:element ref="ns1:updated_time"/> <xs:element ref="ns1:created_time"/> <xs:element ref="ns1:filter_key"/> <xs:element ref="ns1:attribution"/> <xs:element ref="ns1:actor_id"/> <xs:element ref="ns1:target_id"/> <xs:element ref="ns1:message"/> <xs:element ref="ns1:app_data"/> <xs:element ref="ns1:action_links"/> <xs:element ref="ns1:attachment"/> <xs:element ref="ns1:impressions"/> <xs:element ref="ns1:comments"/> <xs:element ref="ns1:likes"/> <xs:element ref="ns1:place"/> <xs:element ref="ns1:privacy"/> <xs:element ref="ns1:permalink"/> <xs:element ref="ns1:xid"/> <xs:element ref="ns1:tagged_ids"/>

<xs:element ref="ns1:message_tags"/> <xs:element ref="ns1:description"/> <xs:element ref="ns1:description_tags"/> <xs:element ref="ns1:type"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="post_id" type="xs:nmtoken"/> <xs:element name="viewer_id" type="xs:integer"/> <xs:element name="app_id"> <xs:complextype mixed="true"> <xs:attribute ref="xsi:nil"/> </xs:complextype> </xs:element> <xs:element name="source_id" type="xs:integer"/> <xs:element name="updated_time" type="xs:integer"/> <xs:element name="created_time" type="xs:integer"/> <xs:element name="filter_key"> <xs:complextype/> </xs:element> <xs:element name="attribution"> <xs:complextype> <xs:attribute ref="xsi:nil" use="required"/> </xs:complextype> </xs:element> <xs:element name="actor_id" type="xs:integer"/> <xs:element name="target_id"> <xs:complextype mixed="true"> <xs:attribute ref="xsi:nil"/> </xs:complextype> </xs:element> <xs:element name="message" type="xs:string"/> <xs:element name="app_data"> <xs:complextype> <xs:sequence minoccurs="0"> <xs:element ref="ns1:attachment_data"/> <xs:element ref="ns1:images"/> <xs:element ref="ns1:photo_ids"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="attachment_data" type="xs:string"/> <xs:element name="photo_ids">

<xs:complextype> <xs:sequence> <xs:element minoccurs="0" ref="ns1:photo_id"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="photo_id" type="xs:integer"/> <xs:element name="action_links"> <xs:complextype> <xs:sequence> <xs:element minoccurs="0" ref="ns1:stream_action_link"/> </xs:sequence> <xs:attribute name="list" type="xs:boolean"/> <xs:attribute ref="xsi:nil"/> </xs:complextype> </xs:element> <xs:element name="stream_action_link"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:text"/> <xs:element ref="ns1:href"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="attachment"> <xs:complextype> <xs:sequence> <xs:sequence minoccurs="0"> <xs:element ref="ns1:media"/> <xs:element ref="ns1:name"/> </xs:sequence> <xs:element minoccurs="0" ref="ns1:href"/> <xs:element minoccurs="0" ref="ns1:caption"/> <xs:element ref="ns1:description"/> <xs:sequence minoccurs="0"> <xs:element ref="ns1:properties"/> <xs:element ref="ns1:icon"/> <xs:element ref="ns1:fb_object_type"/> </xs:sequence> <xs:element minoccurs="0" ref="ns1:fb_object_id"/> </xs:sequence> </xs:complextype>

</xs:element> <xs:element name="media"> <xs:complextype> <xs:sequence> <xs:element minoccurs="0" ref="ns1:stream_media"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="stream_media"> <xs:complextype> <xs:sequence> <xs:element minoccurs="0" ref="ns1:href"/> <xs:element ref="ns1:alt"/> <xs:element ref="ns1:type"/> <xs:element ref="ns1:src"/> <xs:element minoccurs="0" ref="ns1:photo"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="alt" type="xs:string"/> <xs:element name="photo"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:aid"/> <xs:element ref="ns1:pid"/> <xs:element ref="ns1:fbid"/> <xs:element ref="ns1:owner"/> <xs:element ref="ns1:index"/> <xs:element ref="ns1:width"/> <xs:element ref="ns1:height"/> <xs:element ref="ns1:images"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="aid" type="xs:nmtoken"/> <xs:element name="pid" type="xs:nmtoken"/> <xs:element name="fbid" type="xs:integer"/> <xs:element name="owner" type="xs:integer"/> <xs:element name="index" type="xs:integer"/> <xs:element name="caption"> <xs:complextype/> </xs:element>

<xs:element name="properties"> <xs:complextype> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="icon" type="xs:anyuri"/> <xs:element name="fb_object_type" type="xs:string"/> <xs:element name="fb_object_id" type="xs:nmtoken"/> <xs:element name="impressions"> <xs:complextype> <xs:attribute ref="xsi:nil" use="required"/> </xs:complextype> </xs:element> <xs:element name="comments"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:can_remove"/> <xs:element ref="ns1:can_post"/> <xs:element ref="ns1:count"/> <xs:element ref="ns1:comment_list"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="can_remove" type="xs:integer"/> <xs:element name="can_post" type="xs:integer"/> <xs:element name="comment_list"> <xs:complextype> <xs:sequence> <xs:element minoccurs="0" maxoccurs="unbounded" ref="ns1:comment"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="comment"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:fromid"/> <xs:element ref="ns1:time"/> <xs:element ref="ns1:text"/> <xs:element ref="ns1:text_tags"/> <xs:element ref="ns1:id"/> <xs:element ref="ns1:likes"/> <xs:element ref="ns1:user_likes"/>

<xs:element ref="ns1:post_fbid"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="fromid" type="xs:integer"/> <xs:element name="time" type="xs:integer"/> <xs:element name="text_tags"> <xs:complextype> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="post_fbid" type="xs:integer"/> <xs:element name="place"> <xs:complextype mixed="true"> <xs:attribute ref="xsi:nil"/> </xs:complextype> </xs:element> <xs:element name="privacy"> <xs:complextype> <xs:sequence> <xs:element minoccurs="0" ref="ns1:description"/> <xs:element ref="ns1:value"/> <xs:sequence minoccurs="0"> <xs:element ref="ns1:friends"/> <xs:element ref="ns1:networks"/> <xs:element ref="ns1:allow"/> <xs:element ref="ns1:deny"/> </xs:sequence> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="value" type="xs:string"/> <xs:element name="networks"> <xs:complextype/> </xs:element> <xs:element name="allow"> <xs:complextype/> </xs:element> <xs:element name="deny"> <xs:complextype/> </xs:element> <xs:element name="permalink" type="xs:anyuri"/> <xs:element name="xid">

<xs:complextype/> </xs:element> <xs:element name="tagged_ids"> <xs:complextype> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="message_tags"> <xs:complextype> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="description_tags"> <xs:complextype> <xs:sequence> <xs:element minoccurs="0" ref="ns1:tags"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="tags"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:tag"/> </xs:sequence> <xs:attribute name="key" use="required" type="xs:integer"/> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="tag"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:id"/> <xs:element ref="ns1:name"/> <xs:element ref="ns1:offset"/> <xs:element ref="ns1:length"/> <xs:element ref="ns1:type"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="offset" type="xs:integer"/> <xs:element name="length" type="xs:integer"/> <xs:element name="images">

<xs:complextype mixed="true"> <xs:sequence> <xs:element minoccurs="0" maxoccurs="unbounded" ref="ns1:image"/> </xs:sequence> <xs:attribute name="list" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="image"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:src"/> <xs:element ref="ns1:width"/> <xs:element ref="ns1:height"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="text" type="xs:string"/> <xs:element name="href" type="xs:anyuri"/> <xs:element name="type"> <xs:complextype mixed="true"> <xs:attribute ref="xsi:nil"/> </xs:complextype> </xs:element> <xs:element name="src" type="xs:anyuri"/> <xs:element name="width" type="xs:integer"/> <xs:element name="height" type="xs:integer"/> <xs:element name="name" type="xs:string"/> <xs:element name="description"> <xs:complextype mixed="true"> <xs:attribute ref="xsi:nil"/> </xs:complextype> </xs:element> <xs:element name="count" type="xs:integer"/> <xs:element name="id" type="xs:nmtoken"/> <xs:element name="likes"> <xs:complextype mixed="true"> <xs:choice minoccurs="0" maxoccurs="unbounded"> <xs:element ref="ns1:count"/> <xs:element ref="ns1:friends"/> <xs:element ref="ns1:href"/> <xs:element ref="ns1:user_likes"/> <xs:element ref="ns1:can_like"/> <xs:element ref="ns1:sample"/>

</xs:choice> </xs:complextype> </xs:element> <xs:element name="can_like" type="xs:integer"/> <xs:element name="sample"> <xs:complextype> <xs:sequence> <xs:element minoccurs="0" maxoccurs="unbounded" ref="ns1:uid"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="uid" type="xs:integer"/> <xs:element name="user_likes" type="xs:integer"/> <xs:element name="friends"> <xs:complextype> <xs:attribute name="list" type="xs:boolean"/> </xs:complextype> </xs:element> </xs:schema> <?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/xmlschema elementformdefault="qualified targetnamespace="http://api.facebook.com/1.0/ xmlns:ns1="http://api.facebook.com/1.0/ xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"> <xs:import namespace="http://www.w3.org/2001/xmlschema-instance" schemalocation="xsi.xsd"/> <xs:element name="fql_query_response"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:event"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="event"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:eid"/> <xs:element ref="ns1:name"/> <xs:element ref="ns1:pic"/>

<xs:element ref="ns1:host"/> <xs:element ref="ns1:description"/> <xs:element ref="ns1:start_time"/> <xs:element ref="ns1:end_time"/> <xs:element ref="ns1:creator"/> <xs:element ref="ns1:location"/> <xs:element ref="ns1:venue"/> <xs:element ref="ns1:hide_guest_list"/> <xs:element ref="ns1:can_invite_friends"/> <xs:element ref="ns1:all_members_count"/> <xs:element ref="ns1:attending_count"/> <xs:element ref="ns1:unsure_count"/> <xs:element ref="ns1:declined_count"/> <xs:element ref="ns1:not_replied_count"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="eid" type="xs:integer"/> <xs:element name="pic" type="xs:anyuri"/> <xs:element name="host"> <xs:complextype> <xs:attribute ref="xsi:nil" use="required"/> </xs:complextype> </xs:element> <xs:element name="description" type="xs:string"/> <xs:element name="start_time" type="xs:integer"/> <xs:element name="end_time" type="xs:integer"/> <xs:element name="creator" type="xs:integer"/> <xs:element name="location" type="xs:string"/> <xs:element name="venue"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:name"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="hide_guest_list" type="xs:integer"/> <xs:element name="can_invite_friends" type="xs:integer"/> <xs:element name="all_members_count" type="xs:integer"/> <xs:element name="attending_count" type="xs:integer"/> <xs:element name="unsure_count" type="xs:integer"/> <xs:element name="declined_count" type="xs:integer"/> <xs:element name="not_replied_count" type="xs:integer"/>

<xs:element name="name" type="xs:string"/> </xs:schema> <?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/xmlschema elementformdefault="qualified targetnamespace="http://api.facebook.com/1.0/ xmlns:ns1="http://api.facebook.com/1.0/"> <xs:element name="fql_query_response"> <xs:complextype> <xs:sequence> <xs:element maxoccurs="unbounded" ref="ns1:album"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="album"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:aid"/> <xs:element ref="ns1:owner"/> <xs:element ref="ns1:name"/> <xs:element ref="ns1:object_id"/> <xs:element ref="ns1:cover_pid"/> <xs:element ref="ns1:cover_object_id"/> <xs:element ref="ns1:created"/> <xs:element ref="ns1:modified"/> <xs:element ref="ns1:description"/> <xs:element ref="ns1:location"/> <xs:element ref="ns1:size"/> <xs:element ref="ns1:link"/> <xs:element ref="ns1:visible"/> <xs:element ref="ns1:modified_major"/> <xs:element ref="ns1:edit_link"/> <xs:element ref="ns1:type"/> <xs:element ref="ns1:like_info"/> <xs:element ref="ns1:comment_info"/> <xs:element ref="ns1:can_upload"/> <xs:element ref="ns1:photo_count"/> <xs:element ref="ns1:video_count"/> </xs:sequence> </xs:complextype>

</xs:element> <xs:element name="aid" type="xs:nmtoken"/> <xs:element name="owner" type="xs:integer"/> <xs:element name="name" type="xs:string"/> <xs:element name="object_id" type="xs:integer"/> <xs:element name="cover_pid" type="xs:nmtoken"/> <xs:element name="cover_object_id" type="xs:integer"/> <xs:element name="created" type="xs:integer"/> <xs:element name="modified" type="xs:integer"/> <xs:element name="description" type="xs:string"/> <xs:element name="location" type="xs:string"/> <xs:element name="size" type="xs:integer"/> <xs:element name="link" type="xs:anyuri"/> <xs:element name="visible" type="xs:ncname"/> <xs:element name="modified_major" type="xs:integer"/> <xs:element name="edit_link" type="xs:anyuri"/> <xs:element name="type" type="xs:ncname"/> <xs:element name="like_info"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:can_like"/> <xs:element ref="ns1:like_count"/> <xs:element ref="ns1:user_likes"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="can_like" type="xs:integer"/> <xs:element name="like_count" type="xs:integer"/> <xs:element name="user_likes" type="xs:integer"/> <xs:element name="comment_info"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:can_comment"/> <xs:element ref="ns1:comment_count"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="can_comment" type="xs:integer"/> <xs:element name="comment_count" type="xs:integer"/> <xs:element name="can_upload" type="xs:integer"/> <xs:element name="photo_count" type="xs:integer"/> <xs:element name="video_count" type="xs:integer"/> </xs:schema>

<?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/xmlschema elementformdefault="qualified targetnamespace="http://api.facebook.com/1.0/ xmlns:ns1="http://api.facebook.com/1.0/"> <xs:element name="fql_query_response"> <xs:complextype> <xs:sequence> <xs:element maxoccurs="unbounded" ref="ns1:photo_tag"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="photo_tag"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:pid"/> <xs:element ref="ns1:object_id"/> <xs:element ref="ns1:subject"/> <xs:element ref="ns1:text"/> <xs:element ref="ns1:xcoord"/> <xs:element ref="ns1:ycoord"/> <xs:element ref="ns1:created"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="pid" type="xs:nmtoken"/> <xs:element name="object_id" type="xs:integer"/> <xs:element name="subject" type="xs:string"/> <xs:element name="text" type="xs:string"/> <xs:element name="xcoord" type="xs:decimal"/> <xs:element name="ycoord" type="xs:decimal"/> <xs:element name="created" type="xs:integer"/> </xs:schema> <?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/xmlschema elementformdefault="qualified targetnamespace="http://api.facebook.com/1.0/ xmlns:ns1="http://api.facebook.com/1.0/"> <xs:element name="fql_query_response">

<xs:complextype> <xs:sequence> <xs:element ref="ns1:page"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="page"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:page_id"/> <xs:element ref="ns1:name"/> <xs:element ref="ns1:username"/> <xs:element ref="ns1:pic"/> <xs:element ref="ns1:pic_cover"/> <xs:element ref="ns1:page_url"/> <xs:element ref="ns1:fan_count"/> <xs:element ref="ns1:categories"/> <xs:element ref="ns1:type"/> <xs:element ref="ns1:website"/> <xs:element ref="ns1:general_info"/> <xs:element ref="ns1:founded"/> <xs:element ref="ns1:description"/> <xs:element ref="ns1:company_overview"/> <xs:element ref="ns1:location"/> <xs:element ref="ns1:mission"/> <xs:element ref="ns1:products"/> <xs:element ref="ns1:phone"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="page_id" type="xs:integer"/> <xs:element name="name" type="xs:string"/> <xs:element name="username" type="xs:ncname"/> <xs:element name="pic" type="xs:anyuri"/> <xs:element name="pic_cover"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:cover_id"/> <xs:element ref="ns1:source"/> <xs:element ref="ns1:offset_y"/> </xs:sequence> </xs:complextype>

</xs:element> <xs:element name="cover_id" type="xs:integer"/> <xs:element name="source" type="xs:anyuri"/> <xs:element name="offset_y" type="xs:integer"/> <xs:element name="page_url" type="xs:anyuri"/> <xs:element name="fan_count" type="xs:integer"/> <xs:element name="categories"> <xs:complextype> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="type" type="xs:string"/> <xs:element name="website" type="xs:string"/> <xs:element name="general_info" type="xs:string"/> <xs:element name="founded"> <xs:complextype/> </xs:element> <xs:element name="description"> <xs:complextype/> </xs:element> <xs:element name="company_overview"> <xs:complextype/> </xs:element> <xs:element name="location"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:street"/> <xs:element ref="ns1:city"/> <xs:element ref="ns1:state"/> <xs:element ref="ns1:country"/> <xs:element ref="ns1:zip"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="street" type="xs:string"/> <xs:element name="city" type="xs:ncname"/> <xs:element name="state"> <xs:complextype/> </xs:element> <xs:element name="country" type="xs:string"/> <xs:element name="zip" type="xs:nmtoken"/> <xs:element name="mission"> <xs:complextype/>

</xs:element> <xs:element name="products"> <xs:complextype/> </xs:element> <xs:element name="phone"> <xs:complextype/> </xs:element> </xs:schema> <?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/xmlschema elementformdefault="qualified targetnamespace="http://api.facebook.com/1.0/" xmlns:ns1="http://api.facebook.com/1.0/"> <xs:element name="fql_query_response"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:event_member"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="event_member"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:eid"/> <xs:element ref="ns1:uid"/> <xs:element ref="ns1:rsvp_status"/> <xs:element ref="ns1:start_time"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="eid" type="xs:integer"/> <xs:element name="uid" type="xs:integer"/> <xs:element name="rsvp_status" type="xs:ncname"/> <xs:element name="start_time" type="xs:integer"/> </xs:schema> <?xml version="1.0" encoding="utf-8"?>

<xs:schema xmlns:xs="http://www.w3.org/2001/xmlschema elementformdefault="qualified" targetnamespace="http://api.facebook.com/1.0/ xmlns:ns1="http://api.facebook.com/1.0/"> <xs:element name="fql_query_response"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:video_tag"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="video_tag"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:vid"/> <xs:element ref="ns1:subject"/> <xs:element ref="ns1:updated_time"/> <xs:element ref="ns1:created_time"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="vid" type="xs:integer"/> <xs:element name="subject" type="xs:integer"/> <xs:element name="updated_time" type="xs:integer"/> <xs:element name="created_time" type="xs:integer"/> </xs:schema> <?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/xmlschema elementformdefault="qualified" targetnamespace="http://api.facebook.com/1.0/ xmlns:ns1="http://api.facebook.com/1.0/"> <xs:element name="fql_query_response"> <xs:complextype> <xs:sequence> <xs:element maxoccurs="unbounded" ref="ns1:question_option"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="question_option"> <xs:complextype> <xs:sequence>

<xs:element ref="ns1:id"/> <xs:element ref="ns1:name"/> <xs:element ref="ns1:object_id"/> <xs:element ref="ns1:votes"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="id" type="xs:integer"/> <xs:element name="name" type="xs:string"/> <xs:element name="object_id" type="xs:integer"/> <xs:element name="votes" type="xs:integer"/> </xs:schema> <?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/xmlschema elementformdefault="qualified" targetnamespace="http://api.facebook.com/1.0/ xmlns:ns1="http://api.facebook.com/1.0/"> <xs:element name="fql_query_response"> <xs:complextype> <xs:sequence> <xs:element maxoccurs="unbounded" ref="ns1:question_option_votes"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="question_option_votes"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:voter_id"/> <xs:element ref="ns1:option_id"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="voter_id" type="xs:integer"/> <xs:element name="option_id" type="xs:integer"/> </xs:schema> <?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/xmlschema

elementformdefault="qualified" targetnamespace="http://api.facebook.com/1.0/ xmlns:ns1="http://api.facebook.com/1.0/"> <xs:element name="fql_query_response"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:place"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="place"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:name"/> <xs:element ref="ns1:description"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="name" type="xs:ncname"/> <xs:element name="description"> <xs:complextype/> </xs:element> </xs:schema> <?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/xmlschema elementformdefault="qualified" targetnamespace="http://api.facebook.com/1.0/ xmlns:ns1="http://api.facebook.com/1.0/"> <xs:element name="fql_query_response"> <xs:complextype> <xs:sequence> <xs:element maxoccurs="unbounded" ref="ns1:like"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="like"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:user_id"/> </xs:sequence>

</xs:complextype> </xs:element> <xs:element name="user_id" type="xs:integer"/> </xs:schema> <?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/xmlschema elementformdefault="qualified" targetnamespace="http://api.facebook.com/1.0/ xmlns:ns1="http://api.facebook.com/1.0/" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"> <xs:import namespace="http://www.w3.org/2001/xmlschema-instance" schemalocation="xsi.xsd"/> <xs:element name="fql_query_response"> <xs:complextype> <xs:sequence> <xs:element maxoccurs="unbounded" ref="ns1:comment"/> </xs:sequence> <xs:attribute name="list" use="required" type="xs:boolean"/> </xs:complextype> </xs:element> <xs:element name="comment"> <xs:complextype> <xs:sequence> <xs:element ref="ns1:xid"/> <xs:element ref="ns1:object_id"/> <xs:element ref="ns1:post_id"/> <xs:element ref="ns1:fromid"/> <xs:element ref="ns1:time"/> <xs:element ref="ns1:id"/> <xs:element ref="ns1:post_fbid"/> <xs:element ref="ns1:app_id"/> <xs:element ref="ns1:likes"/> <xs:element ref="ns1:comments"/> <xs:element ref="ns1:text"/> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="xid"> <xs:complextype/> </xs:element> <xs:element name="object_id"> <xs:complextype> <xs:attribute ref="xsi:nil" use="required"/>

</xs:complextype> </xs:element> <xs:element name="post_id" type="xs:nmtoken"/> <xs:element name="fromid" type="xs:integer"/> <xs:element name="time" type="xs:integer"/> <xs:element name="id" type="xs:string"/> <xs:element name="post_fbid" type="xs:integer"/> <xs:element name="app_id" type="xs:integer"/> <xs:element name="likes" type="xs:integer"/> <xs:element name="comments"> <xs:complextype/> </xs:element> <xs:element name="text" type="xs:string"/> </xs:schema>

<?xml version="1.0" encoding="utf-8"?> <fql_query_response xmlns="http://api.facebook.com/1.0/" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" list="true"> <stream_post> <post_id>160757343979418_389955327726284</post_id> <viewer_id>100002239261598</viewer_id> <app_id xsi:nil="true"/> <source_id>160757343979418</source_id> <updated_time>1343369235</updated_time> <created_time>1343369235</created_time> <filter_key/> <attribution xsi:nil="true"/> <actor_id>160757343979418</actor_id> <target_id xsi:nil="true"/> <message>.,,.,,... :)</message> <app_data> <attachment_data>[]</attachment_data> <images>[389955317726285]</images> <photo_ids list="true"> <photo_id>389955317726285</photo_id> </photo_ids> </app_data> <action_links xsi:nil="true"/> <attachment> <media list="true"> <stream_media> <href>http://www.facebook.com/photo.php?fbid=389955317726285&set=a.164972220224597.60798.160757343979 418&type=1&relevant_count=1</href> <alt>.,,.,,... :)</alt>

<type>photo</type> <src>http://photos-g.ak.fbcdn.net/hphotos-ak-snc6/268351_389955317726285_1272853963_s.jpg</src> <photo> <aid>160757343979418_60798</aid> <pid>160757343979418_1044868</pid> <fbid>389955317726285</fbid> <owner>160757343979418</owner> <index>703</index> <width>800</width> <height>403</height> <images list="true"> <image> <src>http://photos-g.ak.fbcdn.net/hphotos-ak-snc6/268351_389955317726285_1272853963_s.jpg</src> <width>130</width> <height>65</height> </image> <image>... <?xml version="1.0" encoding="utf-8"?> <fql_query_response xmlns="http://api.facebook.com/1.0/" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" list="true"> <stream_post> <post_id>164375563576415_370461309690767</post_id> <viewer_id>100002239261598</viewer_id> <app_id xsi:nil="true"/> <source_id>164375563576415</source_id> <updated_time>1343377689</updated_time> <created_time>1343377689</created_time> <filter_key/> <attribution xsi:nil="true"/> <actor_id>164375563576415</actor_id> <target_id xsi:nil="true"/> <message>[ ],! ~!</message> <app_data/> <action_links xsi:nil="true"/> <attachment> <media list="true"> <stream_media>

<href>http://youtu.be/nvu00mkriqe</href> <alt>[ ] </alt> <type>video</type> <src>http://external.ak.fbcdn.net/safe_image.php?d=aqdyulcdzyseeong&w=130& amp;h=130&url=http%3a%2f%2fi3.ytimg.com%2fvi%2fnvu00mkriqe%2fmqdefault.jpg</src> <video> <display_url>http://www.youtube.com/watch?v=nvu00mkriqe</display_url> <source_url>http://www.youtube.com/v/nvu00mkriqe?version=3&autohide=1&autoplay=1</source_url> <source_type>html</source_type> </video> </stream_media> </media> <name>[ ] </name> <href>http://youtu.be/nvu00mkriqe</href> <caption/> <description>[ ],! ~!</description> <properties list="true"/> <icon>http://static.ak.fbcdn.net/rsrc.php/v2/yj/r/v2onatytqze.gif</icon> </attachment> <impressions xsi:nil="true"/> <comments> <can_remove>0</can_remove> <can_post>1</can_post> <count>0</count> <comment_list list="true"/> </comments> <likes> <href>http://www.facebook.com/browse/likes/?id=370461309690767</href> <count>0</count> <sample list="true"/> <friends list="true"/> <user_likes>0</user_likes> <can_like>1</can_like> </likes> <place xsi:nil="true"/>... <?xml version="1.0" encoding="utf-8"?> <fql_query_response xmlns="http://api.facebook.com/1.0/" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" list="true">

<stream_post> <post_id>144425452253459_484233481605986</post_id> <viewer_id>100002239261598</viewer_id> <app_id xsi:nil="true"/> <source_id>144425452253459</source_id> <updated_time>1343375514</updated_time> <created_time>1343375372</created_time> <filter_key/> <attribution xsi:nil="true"/> <actor_id>144425452253459</actor_id> <target_id xsi:nil="true"/> <message>,...!</message> <app_data/> <action_links xsi:nil="true"/> <attachment> <description/> </attachment> <impressions xsi:nil="true"/> <comments> <can_remove>0</can_remove> <can_post>1</can_post> <count>1</count> <comment_list list="true"> <comment> <fromid>100001058771258</fromid> <time>1343375514</time> <text>. <text_tags list="true"/> <id>144425452253459_484233481605986_109592886</id> <likes>0</likes> <user_likes>0user_likes> <post_fbid>484233981605936</post_fbid> </comment> </comment_list> </comments> <likes>?</text> <href>http://www.facebook.com/browse/likes/?id=484233481605986</href> <count>15</count> <sample list="true"> <uid>100003413476479</uid>

<uid>100003174834918</uid> <uid>100001804939379</uid> <uid>100002853352827</uid> </sample> <friends list="true"/> <user_likes>0</user_likes> <can_like>1</can_like>...

제 11 장제 1 세부연구개발과제의최종연구개발결과 l l l

제 12 장제 1 세부연구개발과제의연구결과고찰및결론

제 13 장세부연구개발과제의연구성과

기타관련정책에활용예를구체적으로기술함. 타연구및차기연구에활용된예를구체적으로기술함. 언론홍보및대국민교육내용, 일자등을간략히기술함. 임상시험, 관련 DB 구축, 워크샾또는심포지움개최등의경우구체적으로기술함.

제 14 장기타중요변경사항

제 15 장참고문헌

제 16 장첨부서류

제 17 장제 2 세부연구개발과제의최종연구개발목표

제 18 장제 2 세부연구개발과제의연구대상및방법

<select id="selecttoken" resultclass="hashmap"> select * from tweet_oauth where 1 = 1 <isnotempty property="screen_name"> and screen_name = #screen_name# </isnotempty> and ROWNUM = 1 </select> <insert id="insertstatus_information" parameterclass="map"> INSERT INTO STATUS_INFORMATION ( CREATED_AT, STATUS_ID, TEXT, SOURCE, TRUNCATED, IN_REPLY_TO_STATUS_ID, IN_REPLY_TO_USER_ID, IN_REPLYTO_SCREEN_NAME, RETWEET_COUNT, IS_RETWEET, FAVORITED, GEO, PLACE, CONTRIBUTORS, USER_ID, SCREEN_NAME, NAME, IMAGE_URL, IMAGE_URL_HTTPS, RETWEETED_CREATED_AT, RETWEETED_STATUS_ID, RETWEETED_TEXT, RETWEETED_SOURCE, RETWEETED_TRUNCATED, RETWEETED_IN_REPLYTO_STATUS_ID, RETWEETED_IN_REPLY_TO_USER_ID

, RETWEETED_INREPLYTO_SCREENNAME, RETWEETED_FAVORITED, RETWEETED_GEO, RETWEETED_PLACE, RETWEETED_CONTRIBUTORS, RETWEETED_USER_ID, RETWEETED_SCREEN_NAME, RETWEETED_NAME, RETWEETED_DESCRIPTION, RETWEETED_IMAGE_URL, RETWEETED_IMAGE_URL_HTTPS ) <iterate property="list" open="" close="from dual" conjunction="from dual union all" > SELECT #list[].created_at#,#list[].status_id#,#list[].text#,#list[].source#,#list[].truncated#,#list[].in_reply_to_status_id#,#list[].in_reply_to_user_id#,#list[].in_replyto_screen_name#,#list[].retweet_count#,#list[].is_retweet#,#list[].favorited#,#list[].geo#,#list[].place#,#list[].contributors#,#list[].user_id#,#list[].screen_name#,#list[].name#,#list[].image_url#,#list[].image_url_https#,#list[].retweeted_created_at#,#list[].retweeted_status_id#,#list[].retweeted_text#,#list[].retweeted_source#,#list[].retweeted_truncated#,#list[].retweeted_in_replyto_status_id#,#list[].retweeted_in_reply_to_user_id#

,#list[].retweeted_inreplyto_screenname#,#list[].retweeted_favorited#,#list[].retweeted_geo#,#list[].retweeted_place#,#list[].retweeted_contributors#,#list[].retweeted_user_id#,#list[].retweeted_screen_name#,#list[].retweeted_name#,#list[].retweeted_description# </insert> </iterate>,#list[].retweeted_image_url#,#list[].retweeted_image_url_https# <insert id="insertuser_information" parameterclass="map"> MERGE INTO USER_INFORMATION A USING( SELECT #USER_ID# AS USER_ID, #NAME# AS NAME, #SCREEN_NAME# AS SCREEN_NAME, #CREATED_AT# AS CREATED_AT, #LOCATION# AS LOCATION, #DESCRIPTION# AS DESCRIPTION, #URL# AS URL, #PROTECTED# AS PROTECTED, #FOLLOWERS_COUNT# AS FOLLOWERS_COUNT, #FRIENDS_COUNT# AS FRIENDS_COUNT, #FAVOURITES_COUNT# AS FAVOURITES_COUNT, #STATUSES_COUNT# AS STATUSES_COUNT, #LISTED_COUNT# AS LISTED_COUNT, #PROFILE_IMAGE_URL# AS PROFILE_IMAGE_URL, #PROFILE_IMAGE_URL_HTTPS# AS PROFILE_IMAGE_URL_HTTPS, #UTC_OFFSET# AS UTC_OFFSET, #TIME_ZONE# AS TIME_ZONE, #LANG# AS LANG, #GEO_ENABLED# AS GEO_ENABLED, #VERIFIED# AS VERIFIED

, #CONTRIBUTORS_ENABLED# AS CONTRIBUTORS_ENABLED FROM DUAL) B ON (A.USER_ID = B.USER_ID) WHEN MATCHED THEN UPDATE SET A.NAME = B.NAME, A.SCREEN_NAME = B.SCREEN_NAME, A.CREATED_AT = B.CREATED_AT, A.LOCATION = B.LOCATION, A.DESCRIPTION = B.DESCRIPTION, A.URL = B.URL, A.PROTECTED = B.PROTECTED, A.FOLLOWERS_COUNT = B.FOLLOWERS_COUNT, A.FRIENDS_COUNT = B.FRIENDS_COUNT, A.FAVOURITES_COUNT = B.FAVOURITES_COUNT, A.STATUSES_COUNT = B.STATUSES_COUNT, A.LISTED_COUNT = B.LISTED_COUNT, A.PROFILE_IMAGE_URL = B.PROFILE_IMAGE_URL, A.PROFILE_IMAGE_URL_HTTPS = B.PROFILE_IMAGE_URL_HTTPS, A.UTC_OFFSET = B.UTC_OFFSET, A.TIME_ZONE = B.TIME_ZONE, A.LANG = B.LANG, A.GEO_ENABLED = B.GEO_ENABLED, A.VERIFIED = B.VERIFIED, A.CONTRIBUTORS_ENABLED = B.CONTRIBUTORS_ENABLED WHEN NOT MATCHED THEN INSERT( A.USER_ID, A.NAME, A.SCREEN_NAME, A.CREATED_AT, A.LOCATION, A.DESCRIPTION, A.URL, A.PROTECTED, A.FOLLOWERS_COUNT, A.FRIENDS_COUNT, A.FAVOURITES_COUNT, A.STATUSES_COUNT, A.LISTED_COUNT, A.PROFILE_IMAGE_URL

, A.PROFILE_IMAGE_URL_HTTPS, A.UTC_OFFSET, A.TIME_ZONE, A.LANG, A.GEO_ENABLED, A.VERIFIED, A.CONTRIBUTORS_ENABLED ) VALUES( B.USER_ID, B.NAME, B.SCREEN_NAME, B.CREATED_AT, B.LOCATION, B.DESCRIPTION, B.URL, B.PROTECTED, B.FOLLOWERS_COUNT, B.FRIENDS_COUNT, B.FAVOURITES_COUNT, B.STATUSES_COUNT, B.LISTED_COUNT, B.PROFILE_IMAGE_URL, B.PROFILE_IMAGE_URL_HTTPS, B.UTC_OFFSET, B.TIME_ZONE, B.LANG, B.GEO_ENABLED, B.VERIFIED, B.CONTRIBUTORS_ENABLED ) </insert>

<%@page import="common.utility"%> <%@ page contenttype="text/html;charset=utf-8"%> <%@ page import="java.io.*"%> <%@ page import="java.io.file"%> <%@ page import="javax.xml.parsers.documentbuilderfactory"%> <%@ page import="javax.xml.parsers.documentbuilder"%> <%@ page import="org.w3c.dom.document"%> <%@ page import="org.w3c.dom.nodelist"%> <%@ page import="org.w3c.dom.node"%> <%@ page import="org.w3c.dom.element"%> <%@ page import="xml.xmlgetvalue"%> <%@ page import="java.text.numberformat" %> String xmlurl_top = url + File.separator+ "xml" + File.separator + tweets.xml"; File fxmlfile_top = new File(xmlurl_top); DocumentBuilderFactory dbfactory_top = DocumentBuilderFactory.newInstance(); DocumentBuilder dbuilder_top = dbfactory_top.newdocumentbuilder(); Document doc_top = dbuilder_top.parse(xmlurl_top); doc_top.getdocumentelement().normalize(); Node tweetnode = nlist_tweet.item(temp); Node tweetmnode = nlist_tweetmeta.item(temp); Element tweetelement = (Element)tweetNode Element tweetmelement = (Element)tweetMNode String text = Utility.ChangeTextinUrl(xmlGetValue.getTagValue("text", tweetelement)); String profile_image_url = xmlgetvalue.gettagvalue("profile_image_url", tweetelement); String favorited = xmlgetvalue.gettagvalue("favorited", tweetelement); String retweet_count = xmlgetvalue.gettagvalue("retweet_count", tweetelement); String screen_name = xmlgetvalue.gettagvalue("screen_name", tweetmelement); String created_at = xmlgetvalue.gettagvalue("created_at", tweetmelement);

<div id="twitter"> <div id="profile_logo"><img src="<%=profile_image_url %>" width="60" height="55" /></div> <div id="text"> <div id="day"><%=created_at %></div> <span class="title_font03"><a href="https://twitter.com/<%=screen_name%>"><%=name %></a></span> <span class="title_font02">@<%=screen_name %></span><br /> <%=text %><br /><br/> <%=photo %> </div><div id="clear"></div></div>

l l l

제 20 장제 2 세부연구개발과제의연구결과고찰및결론

제 21 장제 2 세부연구개발과제의연구성과

제 22 장기타중요변경사항

제 23 장참고문헌

제 24 장첨부서류

l l l l

l l l l

l l l l