CAJ | 학술논문

密文索引方法最基本的思想是将数据库中的字符数据映射并调整为索引值，并将 SQL 语句转换为可以作用于索引属性列的形式。这种方法可以提高空管数据库系统中对加密字符数据内容的检索效率，并确保空管数据库系统的安全性。提出一种索引生成算法，并应用空管数据库系统的一个案例分析实现这种方法。最后完成两个实验，实验一设计了冲突检测算法，通过分析冲突概率，可以得出应用密文索引方法进行 SQL 查询时的效率提高方式；实验二验证了密文索引方法对 SQL 查询效率的提升效果。
밀문색인방법최기본적사상시장수거고중적자부수거영사병조정위색인치，병장 SQL 어구전환위가이작용우색인속성렬적형식。저충방법가이제고공관수거고계통중대가밀자부수거내용적검색효솔，병학보공관수거고계통적안전성。제출일충색인생성산법，병응용공관수거고계통적일개안례분석실현저충방법。최후완성량개실험，실험일설계료충돌검측산법，통과분석충돌개솔，가이득출응용밀문색인방법진행 SQL 사순시적효솔제고방식；실험이험증료밀문색인방법대 SQL 사순효솔적제승효과。
The basic idea of ciphertext index method in this paper is to map and adjust the character data in database into index value,and to convert the SQL statements to the form capable of applying to the index attribute column,this method can improve the retrieval efficiency on encrypted character data content in ATC database system,and ensures the security of ATC database system.We propose an index generation algorithm,and implement it by applying a case analysis in ATC database system.Finally we complete two experiments,in experiment one we design the conflict detection algorithm,by analysing the conflict probability we can obtain the way to improve the efficiency of applying cipher-text index method in SQL query,experiment two verifies the improvement effect of ciphertext index method on SQL query efficiency.