| 商品销售系统Oracle数据库开发及优化 |
| |
| 引用本文： | 沈雅婷.商品销售系统Oracle数据库开发及优化[J].教育技术导刊,2019,18(9):176-182. |
| |
| 作者姓名： | 沈雅婷 |
| |
| 作者单位： | 南京理工大学紫金学院 计算机学院，江苏 南京 210046 |
| |
| 摘 要： | 线上商品销售应用越来越广泛，为充分发挥市场作用，并实现高效的商品及相关人员管理，在传统商品销售系统的基础上增添市场管理模块。系统管理员根据更新的市场信息及时提出商品调整方案；消费者通过查询市场信息选择正确的地点购买物美价廉的商品，实现双赢。同时为了提高系统存储和查找效率，节省系统资源开销，在以Oracle作为底层开发数据库、建立数据库关系模型实现数据交互的基础上，从数据库表结构、索引以及SQL语句等方面对数据库进行优化。实验显示，未对商品号建立索引的查询时耗是建立索引的200倍。因此，对数据库的优化可提升增删查改速度，更好地满足买卖双方的需求，具有市场管理模块的商品销售系统更利于企业发展。
|
| 关 键 词： | Oracle数据库 商品销售 市场管理 数据库优化 |
| 收稿时间： | 2019-02-22 |
Development and Optimization of Oracle Database in Commodity Sales System |
| |
| SHEN Ya-ting.Development and Optimization of Oracle Database in Commodity Sales System[J].Introduction of Educational Technology,2019,18(9):176-182. |
| |
| Authors: | SHEN Ya-ting |
| |
| Institution: | School of Computer Science，Nanjing University of Science and Technology， Zijin College， Nanjing 210046， China |
| |
| Abstract: | Online applications of commodity sales are more and more widely used. In order to give full play to the role of the market to realise efficient management of commodity and relevant staff， market management module is added on the basis of traditional commodity sales system. According to the updated market information， system administrators timely put forward adjustment plans for commodities， etc. Consumers choose the right place to buy high-quality and low-cost commodities by selecting market information， thus achieving a win-win situation. At the same time， in order to improve the efficiency of system storage， select and save system resources， the database is optimized from the aspects of database table structure， index and SQL statement， based on Oracle as the underlying database development and database relational model to realize data interaction. Experiments show that the query time without indexing commodity number is 200 times longer than that with indexing. Therefore the optimization of the database improves the speed of adding， deleting and modifying， and better meets the needs of buyers and sellers， and commodity sales system with market management module is more conducive to development. |
| |
| Keywords: | Oracle database commodity sales market management database optimization |
|
| 点击此处可从《教育技术导刊》浏览原始摘要信息 |
| 点击此处可从《教育技术导刊》下载免费的PDF全文 |
