Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data management method and system based on .NET database connection pools

A data management system and data management technology, applied in the field of data management methods and systems based on .NET database connection pools, can solve problems such as inability to determine data accuracy, connection pools are not beneficial, improper use, etc., and achieve fast user experience. , The effect of improving user data security and fast response speed

Inactive Publication Date: 2015-11-25
BEIJING YITUOLIAN TECH
View PDF3 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0011] The value of the database connection pool is generally taken line by line, so the accuracy of the data cannot be determined. However, if the connection pool is used incorrectly, it may bring negative effects to the application. Improper use of the connection pool is not only not beneficial but also harmful

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data management method and system based on .NET database connection pools
  • Data management method and system based on .NET database connection pools
  • Data management method and system based on .NET database connection pools

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] Embodiments of the present invention are described in detail below, examples of which are shown in the drawings, wherein the same or similar reference numerals designate the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary and are intended to explain the present invention and should not be construed as limiting the present invention.

[0037] Such as figure 1 Shown, the data management method based on the .NET database connection pool of the embodiment of the present invention is to be carried out following steps by the database management system of .NET database:

[0038] Step S1, the database management system establishes a connection pool according to the connection string of the first request for database connection.

[0039] Specifically, a connection pool is created with a unique connection string. In this step, the database management system creates a ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention brings forward a data management method and system based on .NET database connection pools. The database management system based on the NET databases execute following steps: establishing a connecting pool according to a connecting string under the first request for database connection; creating a thread for a connecting request when the connecting request is received by a user; searching for connecting pools in order to know whether databases in the idle state are present to connected with databases and distributing databases to threads for connection if present; recalling data by threads according to distributed connection database; and releasing databases and connecting to connecting pools after threads finish fulfilling functions corresponding to connecting requests. The data management method and system based on the .NET database connection pools have following characteristics: accurate positioning operation is achieved; user experience is enhanced; response speed user experience speed are high; safety of user data is improved; and efficiency and scalability of application programs are enhanced.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a data management method and system based on a .NET database connection pool. Background technique [0002] Connecting to databases is a resource-intensive and relatively slow operation in an application, but they are also critical. A connection pool is a container of open and reusable database connections. The connection pool is released from memory when all database connections are closed. The most basic advantage of using a connection pool is to improve the performance and scalability of the application, and its main disadvantage is that one or more database connections will always be kept open, even if they are not currently being used. ADO.NET's DataProviders will use the connection pool by default. If you don't want to use the connection pool, you must specify "Polling=false" in the connection string. [0003] With the vigorous development of the Internet, database sec...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
CPCG06F16/25
Inventor 高鹏飞崔涛申海鸥
Owner BEIJING YITUOLIAN TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com