데이타베이스 관리시스템 특론 II (Advanced DBMS II )

2009 1st Semester by Prof. Hwan-Seung Yong

• 6월 9일
• Student Presentation of ConceptNet related project.
• ComicKit (김진옥), 박유리(Emotion Engine), 이미연(Lifenet), 이선숙
• int.ere.st: SCOT-based Tag Sharing Services
• Social Semantic Cloud of Tag http://scot-project.org/scot/index.html
• '독일 독점' 차량용SW '한국기술' 이 뚫었다
• SW-HW 통합시대 급물살
• 한국 개발자가 앱스토어 휩쓴다
• 바다 위에서 소프트웨어 개발을
• '과학과 문화예술을 융합한다'
• 6월 2일
• J.G. Breslin, S. Decker, U. Bojars, "The Future of Social Networks: The Need for Semantics", Tutorial at the Semantic Technologies Conference, San Jose, USA, 19th May 2008. [Slides]
• "GGG": http://en.wikipedia.org/wiki/Giant_Global_Graph
• SKOS http://www.w3.org/2004/02/skos/
• http://www.bing.com/ http://www.decisionengine.com/
• http://rdfa.info/wiki/RDFa_Wiki
• [PDF] Microsearch: An Interface for Semantic Search
• PTSW: http://pingthesemanticweb.com/ 
• Semantic Web Search Engine http://swoogle.umbc.edu/ http://swse.deri.org/
• Semantic Microblogging http://smob.sioc-project.org/
• FOAFGear http://apassant.net/home/2008/01/foafgear/
• phpBB http://www.phpbb.com/
• http://sindice.com/
• JSON: Another Data Format
• http://en.wikipedia.org/wiki/JSON
• This week: 12주차: 5월 26일
• '와이브로 넷북' 내달 출시
• 도시바, 512GB SSD 노트북 세계 첫 출시
• Concept Miner paper
• On Data Visualization
• HDR (High Dynamic Range) Photos
• Social Software
• Semantic Web and Linked Data
• SIOC(Semantically-Interlinked Online Communities) Presentation http://sioc-project.org/presentations
• 11주차(5/19)
• Embedded DBMS report presentation by 3 students(SQL Lite, Berkeley DB, itzam)
• http://www.coyotegulch.com/products/itzam/index.html
• ORACLE LITE embedded dbms
• ConceptNet Introduction
• [PDF] Teaching machines about everyday life -
• http://agents.media.mit.edu/projects/emotusponens/
• Bubble Lexicon [PDF] Unpacking Meaning from Words: A Context-Centered Approach to ...
• Barry, B. (2005). Mindful Documentary. Massachusetts Institute of Technology, Ph.D. thesis.  
• Barry, B. (2003) The Mindful Camera: Common Sense for Documentary Videography. In Proceedings of ACM Multimedia Conference. Berkeley, California, USA.
• Williams, R., Barry, B. and Singh, P. (2005) ComicKit: Acquiring Story Scripts Using Commonsense Feedback. Proceedings of the ACM International Conference on Intelligent User Interfaces (IUI 2005). San Diego, CA, USA.
• Goal of this Course
• Learn comprehensive coverage of concepts and technique for Web and Database Issues and study recent research results through paper working
• By doing term project, each student can do personal data mining research project. - 최근 데이터베이스 관련 핫 이슈들을 살펴보고, 실제 연구용 소프트웨어 들을 설치하여 성능을 평가한다.

• Open Database, Data Cloud, DBPEDIA
• Green IT
• Cloud Computing, Cloud Data Services,
• Reality Mining
• Embedded Database
• Grid Data Management in Grid Computing
• Virtualization and DBMS virtualization?
• New Data Mining Applications
• Smart Tagging for Semantic Web
• Semantic Wikipedia, WIKI-MAPIA
• Metadata Repository System, SPARQL, RDF
• Social Network Analysis Tools
• Data Governance, Enterprise Architecture, ITA
• Advanced Data Mining Issues
• Term Project Presentation

Term Project Items

• Select one open source software, evaluate and extend it.
• Develop Flash based DBMS
• Develop AppStore for Personal Information Management or Handphone Touch Screen Software

References

• ACM CIKM 2009 Call for Papers, ACM CIKM 2008 Papers
• ACM SIGMOD, ACM SIGKDD Site
• 빅 스위치 The Big Switch 플루토노미(Plutonomy)와 디지털 엘리트의 등장, 팬케이크 인간(Pancake people)
  

1st Week: Course Introduction

• [Weekly BIZ] "진정한 IT 혁명은 지금부터… 클라우드 컴퓨팅 시대 온다" 니컬러스 카
• PC의 시대는 끝?
• World Wide Computing 의 시대 WWC
• 10대 파급기술(Disruptive Technology): 가트너 선정
• 정의: 기존 시장을 붕괴시키고 새로운 시장을 창출하는 기술, 반대: Sustainable Technology
• 가트너, 10대 혁신 기술 (Disruptive Technology) 제시
• 와해적 기술(disruptive technology): 디지털 카메라 기술이 필름 카메라 기술을 대체한 것처럼 지금까지 핵심역량의 가치창출 능력을 크게 떨어뜨리는 기술
• 디젤/가솔린 엔진 => 전기자동차
• 아날로그 TV => 디지털 LCD TV
• Overview of this course. Topics, Papers, Term Projects
• CIKM 2008 overview and CIKM 2009 CFP.
• The Claremont Report on Database Research 2008.
• Google Street view vs 다음 로드뷰  한국스트리트뷰
• 스트리트뷰 촬영 전용장비, 다음 로드뷰 ‘대박’…개발업체는 ‘울상’
• 대한민국을 통째로 스캔한 '로드뷰'의 무한도전

2nd Week: 아래 사이트들을 모두 방문해서 충분히 읽어보고 사용해 볼 것.

• Linked Open Data: the LOD cloud, 2008. 9.
• http://www.freebase.com/ Commercial Company vs DBPEDIA
• http://www.bikepedia.com/
• Open Knowledge and Common Sense reasoning engine  http://www.opencyc.org/
• IEEE P1600.1 Standard Upper Ontology Working Group
• RIESE RDFing EuroStat

3주차:

• Open Database Project: WikiDB?
• Freebase http://www.freebase.com/ (Graph Database, not relational model)
• Google Base http://base.google.com/base/ http://en.wikipedia.org/wiki/Google_Base
• http://wiki.dbpedia.org/
• Public Data Set: http://www.geonames.org/
• Linked Data Project:  http://en.wikipedia.org/wiki/Linked_Data
• Linked Data Tutorial by http://www.semantic-web.at/ Semantic Web Company
• The Linking Open Data W3C SWEO Community Project Presentation
• DBPEDIA Slide
• Semantic Web Search Engine http://swse.org/
• Generic RDF Data Browser 'tabulator: http://www.w3.org/2005/ajar/tab
• Project Gutenberg, http://www.freedb.org/
• RDF Storage and Benchmarking
• Microsoft PowerPoint - Lilly-BSBM-Talk.ppt Berlin SPARQLE Benchmarking
• http://esw.w3.org/topic/SparqlEndpoints
• http://en.wikipedia.org/wiki/Turtle_(syntax)
• http://en.wikipedia.org/wiki/Notation_3
• LSDIS_Lab's BRAHMS main-memory RDF/S storage
• http://jena.sourceforge.net/ http://www.openlinksw.com/weblog/oerling/index.vspx?page=&id=1409
• http://darq.sourceforge.net/ DARQ
• Semantic Discovery System
• Sesame http://www.openrdf.org/
• AMAZON Web Service for Public data http://aws.amazon.com/publicdatasets/#1
• 과제물1: 다음에 대해서 조사하여 발표한다.
• BRAHMS(김진옥), JENA(박유리), DARQ(이선숙), Sesame(이미연)
• 조사발표에는 구체적인 정보와 소프트웨어의 설치 및 DEMO 데이터 결과 시연을 포함한다.
• 각자 15분-20분이내 발표, 발표자료는 수업시간전까지 사이버 강의실에 올림.
• 5주차에 발표한다.
• 과제물2: 2008년에 발표된 주요 DB 관련 논문을 선택하여 다음 주 까지 메일로 보고.
• 6주차부터 1명씩 발표. (6주-9주)
• 4주: Cloud Computing
• http://en.wikipedia.org/wiki/Cloud_computing

• 클라우드 컴퓨팅(Cloud Computing, CC)
• HADOOP: http://en.wikipedia.org/wiki/Hadoop
• 구글 Hadoop 소개 PPT
• Google App Engine 소개자료
• Introduction to Map/Reduce, Map-reduce 소개자료2
• 발표주제:
• Hadoop Distributed File System: Implementation of Map/Reduce Model
• Hypertable - C++ implementation,
• Google's BigTable http://www.slideshare.net/george.james/googles-bigtable
• http://hadoop.apache.org/hbase/
• Google MapReduce
• Google Apps Engine and GQL Google Query Language
• 5주차: Web Platform: FaceBook
• 3주차 과제 발표 (각 20-25분)
• Open Mind Common Sense
• 추천논문: 아래 논문중 택일.
• Open Mind Common Sense Papers
• 과제물3:
• 기업들의 그린 IT 제품 출시 및 연구 동향을 조사하여 다음 주에 발표한다. 각자 5분씩.
• 6주차(4월 7일) 그린 IT (1)
• 녹색 마인드 갖춘 녹색인재 양성해야
• 일본 IT업계, 재택근무 도입 '확대일로'
• 논문 발표
• 이선숙 (Google) Interpreting the Data: Parallel Analysis with Sawzall, Rob Pike, Sean Dorward, Robert Griesemer, Sean Quinlan
• 7주차(4월 14일) 그린 IT (2). Open & Sharing in Web.
• 미래의 과학자들, 자전거에 푹 빠지다 - 1등 인터넷뉴스 조선닷컴
• [심층기획] 탄소 줄이고 배출권얻는다
• 포스코, 남미법인 세워 탄소배출권 확보 나서
• 맵티즌 시대… 이젠 지도로 소통한다 , http://abyss.jaram.org/oil/ (주유소 가격비교), Yahoo's 라이프맵, GPS 측정산행기
• http://en.wikipedia.org/wiki/Microformats
• 다음 오픈 ID http://openid.daum.net/
• 주과제: Mashup Editor를 소개하고 사용해서 sample mashup application 생성 예제 demo
• MS Popfly(박유리), Yahoo Pipes(김진옥), Google GME(이미연), Mozilla Ubiquity(firefox, 이선숙) 선택.
• 논문 발표
• 이미연, (Yahoo) Pig Latin: A Not-So-Foreign Language for Data Processing
  C. Olston, B. Reed, U. Srivastava, R. Kumar and A. Tomkins. ACM SIGMOD 2008 International Conference on Management of Data, Vancouver, Canada, June 2008. View Paper
• 8주차  Data and Intelligence
• Mashup Application 발표
• 김진옥, Robert Speer (2007), Open Mind Commons: An Inquisitive Approach to Learning Common Sense, Workshop on Common Sense and Intelligent User Interfaces, January 28, 2007, Honolulu, Hawaii
• 9주차: 논문 발표, Semantic Web and Concept Net, Mobile Computing & DB
• 박유리,Improving End-User Programming with Situational Mashups in Web 2.0 Environment
미코노미 왜 미코노미인가?
[벤처스토리⑮] 디자인도 두 잇 유어셀프(Do It Yourself)  www.vaimi.com
Embedded DBMS
http://en.wikipedia.org/wiki/Berkeley_DB
• Centrality of network
• http://en.wikipedia.org/wiki/Tag_spam
• Collaborative Web Tagging workshop in WWW 2006
• http://en.wikipedia.org/wiki/Folksonomy Folksontology?
• FolksOntology: An Integrated Approach for Turning Folksonomies into Ontologies
• http://alipr.com/ Story Picturing Engine - SPE
• [PDF] Improved Annotation of the Blogopshere via Autotagging and ...
• 토마스 말론이 보는 노동의 미래는?
• 과제물4: Embedded DBMS를 1개씩 택해서 설치, 사용, 평가 발표한다.
• 10주차(5/12): ConceptNet [PDF] ConceptNet — a practical commonsense reasoning tool-kit
• Introduction [PPT] ConceptNet - a pratical commonsense reasoning tool-kit
• Student Presentation: Embedded DBMS install and testing
• Lecture Notes for Henry's Introductory Lecture (PDF 3.2 MB)
• Lecture Notes for Henry's Lecture on Common Sense Inference (PDF 1.9 MB)
• http://web.media.mit.edu/~hugo/montylingua/
• http://en.wikipedia.org/wiki/Gestalt_psychology
• http://en.wikipedia.org/wiki/K-line_(artificial_intelligence)
• MIT Open Course: MAS-964Common-Sense-Reasoning-for-Interactive-Applications
• http://en.wikipedia.org/wiki/Thought Treasure
• Web Technology Trend: Web 3.0
• Term Project Items
• Apache Pig Open Source Student Projects
• Open Source Software and Database.

참고자료

• 일본, 경제 성장을 위한 '디지털 일본 창조 프로젝트'
• Open Source Database Software Comparison
• Google Code University http://code.google.com/edu/
• Social Platform
• http://www.web2hub.com/blog/
• YAGO: http://www.mpi-inf.mpg.de/~suchanek/downloads/yago/ (WordNet + Wikipedia)
• UMBEL http://umbel.org/lod_constellation.html
• DOAP: Open Source Project Metadata Site.
• Semantic Web Central  http://www.semwebcentral.org/
• Semantic Web related tools http://www.mkbergman.com/?p=385
• http://www.openstreetmap.org/
• http://wikimapia.org/
• IBM SocialTools
• MIT 선정, 2009년을 빛낼 첨단기술 10선
• 워싱턴 정가(政街) 새 유행은 ''트위터'' Social Networking using microblogging
• 모바일 SMS와 결합 한국 미투데이 me2day
• [PDF] Video Representation and Processing for Multimedia Data Mining  
• [PPT] Content-based Video Indexing, Classification & Retrieval  
• Lecture: Semantic analysis of text and speech (SGN-9206 Signal processing ...
• [PDF] introduction to ConceptNet