CAJ | 학술논문

在采集、处理、解释一体化软件平台中，不可避免地有大量的 SQL 语句执行，而在这些 SQL 语句执行中，不需要返回的SQL语句又占主要比例。通过设计SQL语句缓存区，并把不需要返回的SQL语句实时放入此缓存区，最后通过设计高效的执行线程，对此缓存区内的SQL语句进行实时的处理。这种方法既分离了业务与数据库操作，也提高了业务对数据库操作请求的效率。
재채집、처리、해석일체화연건평태중，불가피면지유대량적 SQL 어구집행，이재저사 SQL 어구집행중，불수요반회적SQL어구우점주요비례。통과설계SQL어구완존구，병파불수요반회적SQL어구실시방입차완존구，최후통과설계고효적집행선정，대차완존구내적SQL어구진행실시적처리。저충방법기분리료업무여수거고조작，야제고료업무대수거고조작청구적효솔。
During the acquisition, processing and interpretation integrated software platform, there are a large number of SQL statements inevitably executed, while running these SQL statements, SQL statements that do not need to return occupy to a major proportion. This paper designs the SQL statements cache and SQL statements that do not need to return real-time put into this cache, and finally by designing the thread of executing SQL statements, SQL statements in the cache real-time process. This method does not only the separation of business and database operations, but also improves the business efficiency of requests for database operations.