Greetings

I'm a 4th-year Ph.D. candidate in Computer Science at the University of Toronto, working under the supervision of Prof. Khai Truong.

My research centers human-AI interaction, with an emphasis on accessibility and creativity support, particularly in enhancing "music accessibility" for d/Deaf and hard-of-hearing individuals. One of my main projects involves song signing to support culturally responsive content creation and encourage collaboration between d/Deaf and non-d/Deaf artists. Another aspect of my work focuses on enhancing people's well-being. I am engaged in projects that support individuals with dementia in their out-of-home experiences and encourage mindful eating behaviours among children.

I completed my B.Sci in Computer Science and Engineering at Ewha Womans University, where I was advised by Prof. Uran Oh (Human-Computer Interaction Lab) and Prof. Hyokyung Bahn (Distributed Computing and Operating System Lab). Additionally, I worked as a research intern at the Samsung AI Centre Toronto under the guidance of Dr. Iqbal Mohomed, and at NAVER AI (HCI group) with Dr. Young-Ho Kim.
Labels

4장 관계대수와 SQL

 <필수 연산자>

Selection

Projection

Union

Difference

Cartesian Product: (j*n)x(m*i) = 차수 n + m, 카디널리티: i*j


<유도 연산자>

Intersection

Theta join

Equi join

Natual join

Division (u*(n_m)) / (u*m) = (u*n)


<집합 연산자>

합집합/ 차집합/ 교집합

** 합집합 호환: 개수가 같고 도메인이 닽다. Attribute Domain 일치


<집단 함수> : SELECT와 HAVING에만 가능

AVG

SUM

MIN/ MAX

COUNT


<SQL>

1) SELECT: 정보 검색

SELECT FROM WHERE GROUP BY HAVING ORDER BY

- AS: 별칭

- 조인 = 

2) INSERT

INSERT INTO VALUE

3) DELETE

DELETE FROM WHERE

4) UPDATE

UPDATE SET WHERE


<트리거>

이벤트 발생시 자동 수행하는 정의문, ECA 규칙

CREATE TRIGER WHEN BEGIN

제약조건 위반 시 수행 동작


<주장>

제약조건을 위반하는 연산 방지

CREATE ASSERTION CHECK


라벨:

Comments

Post a Comment