本文選題：數(shù)據(jù)庫連接池 + 數(shù)據(jù)庫優(yōu)化��； 參考：《北京交通大學(xué)》2015年碩士論文

【摘要】：隨著企業(yè)經(jīng)營管理理念的不斷提升,互聯(lián)網(wǎng)公司之間的競爭和合作日益密切,想要取得令人滿意的業(yè)績和實現(xiàn)公司的高速發(fā)展,取決于領(lǐng)導(dǎo)層的決策和基層工作人員對當前狀況的認知。如今是數(shù)字信息化時代,傳統(tǒng)意義上的管理分析和決策手段正在發(fā)生轉(zhuǎn)變,變?yōu)椤坝脭?shù)據(jù)說話”。一個公司若想更快更好的發(fā)展,那么數(shù)據(jù)分析這塊必須得到重視,這關(guān)系到公司領(lǐng)導(dǎo)層的決策是否正確以及企業(yè)的發(fā)展方向是否切實可行。如此,基于大數(shù)據(jù)量的數(shù)據(jù)提取,整理,分析就成為了所有互聯(lián)網(wǎng)公司以及大部分軟件公司必須要做的事情。 本項目同時滿足公司不同職能人員的基于數(shù)據(jù)統(tǒng)計的不同需求和運營操作。向公司領(lǐng)導(dǎo)層以及運營人員提供多項基礎(chǔ)運營數(shù)據(jù),不同時間節(jié)點間的數(shù)據(jù)增量等。向公司銷售人員提供營帳系統(tǒng),進行訂單處理和收入查詢。向公司運營人員提供用戶開通,續(xù)費,擴容,計費等實際功能。向市場人員提供私有云開通,查詢等功能。同時,本項目含有很多常用的統(tǒng)計接口。本人自進入公司后,交接同步盤后臺管理系統(tǒng),獨立負責同步盤后臺管理系統(tǒng)的需求獲取,設(shè)計,開發(fā)以及維護。其中本人從運營人員手中獲取需求,進行需求分析。獨立完成詳細設(shè)計后,向上級匯報講解設(shè)計思路,確認無誤后開始正式開發(fā)。本人開發(fā)完成了所有的模塊,包括前臺頁面和后臺邏輯以及數(shù)據(jù)庫開發(fā)。項目的難點在于在數(shù)據(jù)量十分龐大時,如何在確保數(shù)據(jù)統(tǒng)計準確的前提下,提高效率。其中有的功能需要聯(lián)查三張以上的千萬級MySQL數(shù)據(jù)表,以及遍歷20G以上大小的mongoDB表。為了提供更好的靈活性和可維護性,采用了商業(yè)系統(tǒng)傳統(tǒng)的B/S架構(gòu),項目本身使用SpringMVC框架,頁面使用j Query技術(shù),使用Ajax傳遞參數(shù),數(shù)據(jù)庫使用MyBatis框架,使用的數(shù)據(jù)庫為關(guān)系型數(shù)據(jù)庫MySQL以及非關(guān)系型數(shù)據(jù)庫mongoDB, mongoDB是最流行的一種非關(guān)系型數(shù)據(jù)庫,它是模式自由和面向文檔的。并有應(yīng)用數(shù)據(jù)連接池來控制數(shù)據(jù)庫連接資源。項目使用的應(yīng)用服務(wù)器為jetty,它架構(gòu)比較簡單,可擴展性非常好而且非常靈活,使用的項目管理工具為maven,版本管理工具為SVN。 實習(xí)期間,總計開發(fā)大型常用功能模塊7個,接口10個以上,經(jīng)歷產(chǎn)品上線20余次,如今產(chǎn)品已經(jīng)正式上線,供北京、上海、杭州的同事們使用,使用效果良好,公司越來越倚重本系統(tǒng),不斷有新的需求出現(xiàn),目前系統(tǒng)仍在不斷的更新和完善。
[Abstract]:With the development of enterprise management concept, the competition and cooperation between Internet companies are becoming closer and closer. In order to achieve satisfactory performance and achieve the rapid development of the company, Depends on leadership decisions and grass-roots staff's perception of the current situation. Nowadays, in the era of digital information, traditional management analysis and decision-making means are changing into "talking with data". If a company wants to develop faster and better, then the data analysis must be taken seriously, which is related to whether the decision of the company's leadership is correct and whether the direction of the enterprise's development is feasible. In this way, data extraction, collation and analysis based on large amount of data have become a must for all Internet companies and most software companies. This project also meets the different needs and operations of the company's different functional personnel based on data statistics. To provide company leadership and operators with a number of basic operational data, data increments between different time nodes, etc. To provide the company sales personnel with a tent system, order processing and revenue inquiries. To provide the company operators with user opening, renewal, capacity expansion, billing and other practical functions. To market personnel to provide private cloud opening, query and other functions. At the same time, this project contains many commonly used statistical interfaces. Since entering the company, I hand over the synchronous disk background management system, independently responsible for the synchronous disk background management system requirements acquisition, design, development and maintenance. Among them I obtain the demand from the operator hand, carry on the demand analysis. After completing the detailed design independently, report to the superior to explain the design ideas, confirm that the official development. I completed the development of all modules, including front page and background logic and database development. The difficulty of the project is how to improve the efficiency under the premise of ensuring the accurate statistics when the data is very large. Some of the functions need to check three more than 10 million MySQL data table, as well as the size of more than 20 gigabytes of mongoDB tables. In order to provide better flexibility and maintainability, the traditional B / S architecture of commercial system is adopted. The project itself uses Spring MVC framework, page uses jQuery technology, Ajax passes parameters, database uses MyBatis framework. The databases used are relational database MySQL and non-relational database mongoDB. MongoDB is the most popular non-relational database which is schema-free and document-oriented. Data connection pool is also used to control database connection resources. The application server used in the project is jetty, which has simple architecture, good extensibility and flexibility. The project management tool is maven. the version management tool is SVN. During the internship period, a total of 7 large commonly used functional modules, more than 10 interfaces, and more than 20 product launches have been developed. Now the products have been officially launched for use by colleagues in Beijing, Shanghai, and Hangzhou, with good results. The company more and more rely on this system, there are new requirements, the current system is still constantly updated and improved.
【學(xué)位授予單位】：北京交通大學(xué)
【學(xué)位級別】：碩士
【學(xué)位授予年份】：2015
【分類號】：TP311.52

【相似文獻】

相關(guān)期刊論文 前1條

1 解阮;;微云同步盤和騰訊微云區(qū)別![J];計算機與網(wǎng)絡(luò);2014年14期

相關(guān)碩士學(xué)位論文 前1條

1 于鎧瑞;同步盤后臺管理系統(tǒng)的設(shè)計與實現(xiàn)[D];北京交通大學(xué);2015年

，

本文編號：2059328