期刊名称：International Journal of Computer Applications and Information Technology
印刷版ISSN：2278-7720
出版年度：2014
卷号：7
期号：2
页码：149-151
出版社：Mahadev Educational Society
摘要：Queries are the important part of database. All the operations of a data can be done in database with the help of query. In this paper, we have tried to mention the different types of database queries. Queries are categorized as functional, OLTP and DSS queries. DSS queries are complex in nature and take more time as compare to other queries. Functional queries are further categorized as create, manage and control queries. Data management queries are used to manipulate the data by using insert, delete and update operations. Data control queries are used commit and grant operations. In online transaction processing system (OLTP); real updates are performed but decision support system (DSS) queries perform batch which is totally different from OLTP.
