Schema-and Data-driven Discovery of SQL Keys

Van Bao Tran Le,Sebastian Link,Mozhgan Memari 한국정보과학회 2012 Journal of Computing Science and Engineering Vol.6 No.3

Keys play a fundamental role in all data models. They allow database systems to uniquely identify data items, and therefore, promote efficient data processing in many applications. Due to this, support is required to discover keys. These include keys that are semantically meaningful for the application domain, or are satisfied by a given database. We study the discovery of keys from SQL tables. We investigate the structural and computational properties of Armstrong tables for sets of SQL keys. Inspections of Armstrong tables enable data engineers to consolidate their understanding of semantically meaningful keys, and to communicate this understanding to other stake-holders. The stake-holders may want to make changes to the tables or provide entirely different tables to communicate their views to the data engineers. For such a purpose, we propose data mining algorithms that discover keys from a given SQL table. We combine the key mining algorithms with Armstrong table computations to generate informative Armstrong tables, that is, key-preserving semantic samples of existing SQL tables. Finally, we define formal measures to assess the distance between sets of SQL keys. The measures can be applied to validate the usefulness of Armstrong tables, and to automate the marking and feedback of non-multiple choice questions in database courses.

Tobacco Control Policies in Vietnam: Review on MPOWER Implementation Progress and Challenges

Hoang, Van Minh,Tran, Thu Ngan,Vu, Quynh Mai,Nguyen, Thi Tuyet My,Le, Hong Chung,Vu, Duy Kien,Tran, Tuan Anh,Nguyen, Bao Ngoc,Vu, Van Giap,Nguyen, Manh Cuong,Pham, Duc Manh,Kim, Bao Giang Asian Pacific Journal of Cancer Prevention 2016 Asian Pacific journal of cancer prevention Vol.17 No.no.sup1

In Vietnam, the WHO Framework Convention on Tobacco Control (WHO FCTC) took effect in March 2005 while MPOWER has been implemented since 2008. This paper describes the progress and challenges of implementation of the MPOWER package in Vietnam. We can report that, in term of monitoring, Vietnam is very active in the Global Tobacco Surveillance System, completing two rounds of the Global Adult Tobacco Survey (GATS) and three rounds of the Global Youth Tobacco Survey (GYTS). To protect people from tobacco smoke, Vietnam has issued and enforced a law requiring comprehensive smoking bans at workplaces and public places since 2013. Tobacco advertising and promotion are also prohibited with the exception of points of sale displays of tobacco products. Violations come in the form of promotion girls, corporate social responsibility activities from tobacco manufacturers and packages displayed by retail vendors. Vietnam is one of the 77 countries that require pictorial health warnings to be printed on cigarette packages to warn about the danger of tobacco and the warnings have been implemented effectively. Cigarette tax is 70% of factory price which is equal to less than 45% of retail price and much lower than the recommendation of WHO. However, Vietnam is one of the very few countries that require manufacturers and importers to make "compulsory contributions" at 1-2% of the factory price of cigarettes sold in Vietnam for the establishment of a Tobacco Control Fund (TCF). The TCF is being operated well. In 2015, 67 units of 63 provinces/cities, 22 ministries and political-social organizations and 6 hospitals received funding from TCF to implement a wide range of tobacco control activities. Cessation services have been starting with a a toll-free quit-line but need to be further strengthened. In conclusion, Vietnam has constantly put efforts into the tobacco control field with high commitment from the government, scientists and activists. Though several remarkable achievements have been gained, many challenges remain. To overcome those challenges, implementation strategies that take into account the contextual factors and social determinants of tobacco use in Vietnam are needed.

Eco-friendly Aqueous Binder-Based LiNi 0.4 Mn 1.6 O 4 Cathode Enabling Stable Cycling Performance of High Voltage Lithium-Ion Batteries with Biomass-Derived Silica

Ngoc Thi Bao Nguyen,Hoang Van Nguyen,Nhan Thanh Tran,Phat Tan Vu,Phung My Loan Le,Man Van Tran 대한금속·재료학회 2023 ELECTRONIC MATERIALS LETTERS Vol.19 No.3

High voltage cathode materials LiNi x Mn 2−x O 4 (x = 0.4; 0.5) have been attracting greater attention in developing high energydensity Li-ion battery technology for electrical vehicles and large-scale applications. The main challenge of high voltagecathodes is severe electrolyte decomposition leading to short cell cycle life. In addition, LiNi 0.4 Mn 1.6 O 4 cathode materialprocessed with polyvinylidene fl uoride (PVdF) binder generally suff ers an oxidation decomposition as well as cathodedelamination from current collectors during cycling. Herein, we suggest using sodium carboxymethyl cellulose (CMC),lithium polyacrylic acid (LiPAA) as water-soluble binders for replacing conventional PVdF in cathode processing to demonstratethe eff ectiveness on long-cycling of half-cell Li || LiNi 0.4 Mn 1.6 O 4 , full-cell SiO 2 -graphite || LiNi 0.4 Mn 1.6 O 4 and SiO 2|| LiNi 0.4 Mn 1.6 O 4 . In half-cell, the cells with water-soluble binders-based cathode exhibited a higher discharge capacity thanthe one using PVdF binder (CMC—126.0 mAh/g; LiPAA—125.7 mAh/g; PVdF—117 mAh/g at C/5, respectively). CMCand LiPAA also improve retention capacity up to 90% after 500 cycles at C/3. Interestingly, LiPAA based electrode exhibitsan excellent rate-capability with discharge capacity of 80 mAh/g at 8C. The stability of electrodes was also investigated byelectrode chemical impedance spectroscopy (EIS) and Scanning electron microscope (SEM). In full-cell, CMC and LiPAAbased cells showed eff ectiveness in decreasing transition metal dissolution and preventing the cathode degradation duringlong-cycling through its excellent capacity retention in 200 cycles at C/3.

Determinants Influencing Housing-Option Decision of Gen Y: The Case of Vietnam

Ha Thu LUONG(Ha Thu LUONG ),Dung Manh TRAN(Dung Manh TRAN ),Dan Linh Ngoc NGUYEN(Dan Linh Ngoc NGUYEN ),Van Bao NGUYEN(Van Bao NGUYEN ),Anh Thuc LE(Anh Thuc LE ),Hieu Van PHAM(Hieu Van PHAM ) 한국유통과학회 2023 유통과학연구 Vol.21 No.7

Study Design for the 2016 Baseline Survey of a Health System Strengthening Project in Quoc Oai District, Hanoi, Vietnam

Van Minh Hoang,오주환,Bao Ngoc Nguyen,Le Minh Dat,이종구,Thi Giang Huong Tran,Van Huy Nguyen,이승표,방경숙,조영태,김선영,이화영,Quang Cuong Le,Narshil Choi,Thai Son Dinh,Ngoc Hoat Luu 대한의학회 2019 Journal of Korean medical science Vol.34 No.5

Background: In order to provide essential scientific evidence on the population's health status and social health determinants as well as the current capacity of the health care system in Vietnam to health policy makers and managers, Vietnam Ministry of Health, Hanoi University of Public Health, Hanoi Medical University, and Ho Chi Minh University of Medicine and Pharmacy collaborated with Seoul National University (Korea) and conducted a health system survey in the Quoc Oai district (of Hanoi capital) that represented northern rural Vietnam. Methods: The study design was a cross-sectional study. The survey covered different topics (more than 200 questions) and was administered in three separate questionnaires: 1) Basic information of all household members; 2) Household characteristics; and 3) Individual characteristics. Socio-demographic characteristics among the households and individuals were collected from 2,400 households sampled by multi-stage cluster sampling method: more than 200 questions. Results: The household size of Quoc Oai was larger than the national average and there was no significant difference in gender composition. In addition, the proportions of pre-elderly, age 55–64, and elderly group (65 years old and over) were higher than the national population statistics. In this context, demographic transition has begun in Quoc Oai. Conclusion: This study design description provides the basic information about a baseline survey of a future prospective cohort (as a part of a collaborative project on strengthening the health system in Vietnam) to the prospective data user of this survey.

Exposure to Tobacco Advertising and Promotion among School Children Aged 13-15 in Vietnam - an Overview from GYTS 2014

Tran, Khanh Long,Phung, Xuan Son,Kim, Bao Giang,Phan, Thi Hai,Doan, Thi Thu Huyen,Luong, Ngoc Khue,Pham, Thi Quynh Nga,Nguyen, Tuan Lam,Hoang, Van Minh,Le, Thi Thanh Huong Asian Pacific Journal of Cancer Prevention 2016 Asian Pacific journal of cancer prevention Vol.17 No.no.sup1

Evidence shows that tobacco advertising and promotion activities may increase tobacco consumption and usage, especially in youth. Despite the regulation on prohibiting advertisement of any tobacco product, tobacco advertisement and promotion activities are still common in Vietnam. This article presents current exposure to tobacco advertising and promotion (TAP) among school children aged 13 to 15 years in Vietnam in 2014 and potential influencing factors. Data from the Global Youth Tobacco Survey 2014 in Vietnam covering 3,430 school aged children were used. Both descriptive and analytical statistics were carried out with Stata 13 statistical software. Binary logistic regression was applied to explain the exposure to TAP among youth and examine relationships with individual factors. A significance level of p<0.05 and sampling weights were used in all of the computations. In the past 30 days, 48.6% of the students experienced exposure to at least 1 type of tobacco advertising or promotion. Wearing or otherwise using products related to tobacco was the most exposure TAP type reported by students (22.3%). The internet (22.1), points of sales (19.2) and social events (11.5) were three places that students aged 13-15 frequently were exposed to TAP. Binary logistic results showed that gender (female vs male) (OR = 0.61, 95%CI: 0.52 - 0.71), susceptibility to smoking (OR = 2.12, 95%CI: 1.53 - 2.92), closest friends' smoked (OR = 1.43, 95%CI: 1.2 - 1.7) and parents smoking status (OR = 2.83, 95%CI: 1.6 - 5.01) were significantly associated with TAP exposure among school-aged children. The research findings should contribute to effective implementation of measures for preventing and controlling tobacco use among students aged 13-15 in Viet Nam.

Factors Affecting Parents' Intention to Choose English Centers: The Role of STEM Education

Tran, Do-Van-Anh,Nguyen, Ngoc-Duyen,Tang, Thai-Ngoc,Le, Dinh-Bao-Nhi,Vo, Huyen-Yen-Nhi,Le, Hoanh-Su Korea Multimedia Society 2020 The journal of multimedia information system Vol.7 No.1

Parents' desire for daily English practice for students and the urge for a etter English education has led to a demand for a highly qualified educational curriculum. In addition to getting deep-dive insights into parents' decision-making process, the increasingly important role of STEM education method has been proved in accordance with plenty of evidenced-based many of previous research. This study was conducted to examine the five independent factors affecting parents' intentions when designating English centers for their children, respectively named: Facility, Teachers, Brands, Social factors and Tuition. Through a preliminary approach, 235 samples were analyzed. Analysis of the sample responses reveals the importance level of five independent factors affecting Parents' intention to choose English centers in descending order: Facilities, Teachers, Brands, Tuition and Social factors. Furthermore, a positive correlation was found between STEM and Intention to choose English centers, indicating that whether the center applies STEM-related curriculum in English courses or not, in fact, has a significant impact on parents' decision. In terms of attitude towards STEM, further statistical tests revealed an interesting finding, which is the fact that how STEM affects Intention of parents is directly proportional to the Attitude towards STEM. With the help of SPSS 20 and AMOS 20, the SEM analysis was processed in order to draw conclusions about factors impacting Intentions to choose English centers. Combining with Multi-group analysis, the major role of STEM education has been assessed in relation to plenty of correlations. In light of recent major and massive growth of English teaching market in Vietnam, several suggestions and recommendations in terms of sustainable developments have been displayed in this research.

Determinant factors impact on participation intention in Smart Classroom environment

Do-Van-Anh Tran,Dinh-Bao-Nhi Le,Huyen-Yen-Nhi Vo,Hoanh-Su Le 한국경영정보학회 2022 한국경영정보학회 학술대회논문집 Vol.2022 No.6

Memristor Binarized Neural Networks

Khoa Van Pham,Tien Van Nguyen,Son Bao Tran,HyunKyung Nam,Mi Jung Lee,Byung Joon Choi,Son Ngoc Truong,Kyeong-Sik Min 대한전자공학회 2018 Journal of semiconductor technology and science Vol.18 No.5

Binarized Neural Networks (BNNs) use only binary synapses of +1 and -1, not allowing any intermediate weights between -1 and +1. Though the recognition rate of BNNs is lower than the conventional Deep Neural Networks (DNNs), BNNs have attracted many interests nowadays, because BNNs do not need the complicated multiplication such as DNNs. Binary memristor crossbars can be very suitable to realize BNN hardware. This is because, in memristor BNNs, simple binary operation can be performed in bitwise manner for all the columns in memristor crossbars, simultaneously. In this paper, single-column and double-column memristor BNNs are presented, respectively. In addition, ReLU and sigmoid activation function circuits are also proposed with CMOS circuits. The designed Memristor-CMOS hybrid circuits of BNNs have been tested for MNIST vectors. The memristor BNNs could recognize almost 90% MNIST digits when the memristance variation is as large as 25%. For variation tolerance, the memristor BNNs are compared with the multi-valued memristor neural networks such as 4-bit, 6-bit, etc, in this paper. As a result, it has been confirmed the memristor BNNs become more variation-tolerant than the multi-valued memristor NNs when the variation becomes larger than 22%. Comparing the single-column and doublecolumn BNNs in this paper indicates that the singlecolumn BNN can save power consumption and array area almost by half than the double-column. This is because the single-column has just half memristors than the double-column. And, we measured the single-column and double-column BNNs using the fabricated memristor array. In this measurement, both the double-column and single-column BNNs were observed to work well.

The Belt and Road Initiative (BRI): Opportunities and Risks from Vietnamese Perspective

Long Duc Bao NGUYEN,Tracy Trang LY,Doan Cong TRAN,Ai Van TRAN,An Quoc LE,Alan HUDSON 한국유통과학회 2022 The Journal of Asian Finance, Economics and Busine Vol.9 No.4

The goal of this research is to look at the Belt and Road Initiative’s (BRI) goals, principles, and priorities, as well as criticisms and concerns. Another goal is to determine the Vietnamese government’s best response to the BRI. Finally, the study looks at the Vietnamese viewpoint. Document review is used in conjunction with PESTELED analysis and EIU country risk model technique in this study. The study is focused on in-depth interviews with 38 top government leaders, researchers, and scholars by adopting the Delphi technique to determine major factors of risks and opportunities as well as obtain a clearer view on the Vietnamese perspective of the BRI. The main conclusion is that Vietnam’s participation in the BRI could result in a variety of benefits and risks, including economic development, connectivity and integration, development finance, cooperation, coordination, trade facilitation, and people-to-people communication, as well as diplomatic and political risks, financial risks, environmental challenges, and job creation. Another conclusion is suggested that careful and case-by-case negotiation with China is needed for Vietnam to exploit the future benefits of BRI. There is a need to set up the strategy to mitigate the risk impacts, reduce the risk level, avoid risk, at last turn the risk into opportunities.