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

【摘要】：隨著企業(yè)經(jīng)營管理理念的不斷提升,互聯(lián)網(wǎng)公司之間的競爭和合作日益密切,想要取得令人滿意的業(yè)績和實(shí)現(xiàn)公司的高速發(fā)展,取決于領(lǐng)導(dǎo)層的決策和基層工作人員對當(dāng)前狀況的認(rèn)知。如今是數(shù)字信息化時(shí)代,傳統(tǒng)意義上的管理分析和決策手段正在發(fā)生轉(zhuǎn)變,變?yōu)椤坝脭?shù)據(jù)說話”。一個(gè)公司若想更快更好的發(fā)展,那么數(shù)據(jù)分析這塊必須得到重視,這關(guān)系到公司領(lǐng)導(dǎo)層的決策是否正確以及企業(yè)的發(fā)展方向是否切實(shí)可行。如此,基于大數(shù)據(jù)量的數(shù)據(jù)提取,整理,分析就成為了所有互聯(lián)網(wǎng)公司以及大部分軟件公司必須要做的事情。 本項(xiàng)目同時(shí)滿足公司不同職能人員的基于數(shù)據(jù)統(tǒng)計(jì)的不同需求和運(yùn)營操作。向公司領(lǐng)導(dǎo)層以及運(yùn)營人員提供多項(xiàng)基礎(chǔ)運(yùn)營數(shù)據(jù),不同時(shí)間節(jié)點(diǎn)間的數(shù)據(jù)增量等。向公司銷售人員提供營帳系統(tǒng),進(jìn)行訂單處理和收入查詢。向公司運(yùn)營人員提供用戶開通,續(xù)費(fèi),擴(kuò)容,計(jì)費(fèi)等實(shí)際功能。向市場人員提供私有云開通,查詢等功能。同時(shí),本項(xiàng)目含有很多常用的統(tǒng)計(jì)接口。本人自進(jìn)入公司后,交接同步盤后臺(tái)管理系統(tǒng),獨(dú)立負(fù)責(zé)同步盤后臺(tái)管理系統(tǒng)的需求獲取,設(shè)計(jì),開發(fā)以及維護(hù)。其中本人從運(yùn)營人員手中獲取需求,進(jìn)行需求分析。獨(dú)立完成詳細(xì)設(shè)計(jì)后,向上級匯報(bào)講解設(shè)計(jì)思路,確認(rèn)無誤后開始正式開發(fā)。本人開發(fā)完成了所有的模塊,包括前臺(tái)頁面和后臺(tái)邏輯以及數(shù)據(jù)庫開發(fā)。項(xiàng)目的難點(diǎn)在于在數(shù)據(jù)量十分龐大時(shí),如何在確保數(shù)據(jù)統(tǒng)計(jì)準(zhǔn)確的前提下,提高效率。其中有的功能需要聯(lián)查三張以上的千萬級MySQL數(shù)據(jù)表,以及遍歷20G以上大小的mongoDB表。為了提供更好的靈活性和可維護(hù)性,采用了商業(yè)系統(tǒng)傳統(tǒng)的B/S架構(gòu),項(xiàng)目本身使用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ù)庫連接資源。項(xiàng)目使用的應(yīng)用服務(wù)器為jetty,它架構(gòu)比較簡單,可擴(kuò)展性非常好而且非常靈活,使用的項(xiàng)目管理工具為maven,版本管理工具為SVN。 實(shí)習(xí)期間,總計(jì)開發(fā)大型常用功能模塊7個(gè),接口10個(gè)以上,經(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

【相似文獻(xiàn)】

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

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

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

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

，

本文編號：2059328