摘要：随着社会的发展，我们跨入了21世纪，21世纪是互联网的时代。在计算机技术快速发展的今天，互联网已经融入了我们生涯，在我们生涯中：电视、电脑、平板、手机等都已成为我们生活的必须品。各种设备也都相继出现在我们的面前中，以前有相同功能的，或者新发明创造的。伴随着云存储技术越来越成熟，大数据无声无息的进入懂啊了我们的生活中。大数据的查询效率也成了我们目前急需处理的问题。随着网络技术的不断革新，大数据已经成为我们家喻户晓的词语了。大数据是用来形容一家企业在对数据管理过程中，生成了许多的无具体结构和具有半结构化的数据，当我们想要处理或者对这些数据进行分析时，就不得不话费大量的时间和金钱来进行处理。我们平常使用的app或者网络程序中，在对数据库的各种操作中，将数据查询出结果然后进行分析的操作是最多的。如果我们能够在查询操作中使用高效的查询方法和策略，通常能够减少查询所花费的时间和减少消耗，从而达到提高查询效率的目的。设备监控记录的大数据量查询系统基于SQL语言和对数据库的查询性能进行分析和研究，探究数据库SQL查询处理的内容和过程可在哪些方面解决当一般查询遇上大数据量查询时的问题，详细探究查询优化的过程和方法。这些方法中主要包括了索引查询、SQL语句优化和表创建时的分区等提高查询效率的优化方法。69490

毕业论文关键词： 大数据；数据库；查询优化；索引；SQL语句

Development of large data query system for monitoring and recording equipment

Abstract: With the development of society, we entered twenty-first Century, twenty-first Century is the era of the Internet. The rapid development in computer technology today, the Internet has been integrated into our lives, in our lives: TV, computer, tablet, mobile phone has become necessary in our life. All kinds of equipment have also appeared in front of us. Before, have the same function, or a new invention. With the cloud storage technology becomes more mature, big data to understand ah soundless and stirless our life. Big data query efficiency has become our current urgent need to address the problem. As the network technology innovation, big data has become As we known to every family words. Big data is used to describe an enterprise in the management of data in the process of generating a lot of concrete structure and has a semi structured data, or when we want to analyze these data, you have to spend a lot of time and money to deal with. We usually use the app or web applications, in a variety of operations on the database, the data query results and analysis of the operation is the most. If we can use the query methods and strategies for efficient query operation, can usually reduce the amount of query time and reduce consumption, so as to improve. Inquiry efficiency. Big data equipment monitoring and recording volume query system to analyze and Research on the SQL language and database query performance based on the research content and process of database SQL query processing can be solved when the general query in a large amount of data query problem on the other hand, detailed study of query process and optimization method these methods include the index query, SQL optimization and partition table to create the optimization methods for improving query efficiency.

Keywords: Big data; database; query optimization; index; SQL statement

目录

1 绪论 1

1.1 课题开发背景 1

1.2 课题开发意义及目的 1

1.3 国内的相关研究