982 results about "Database connection" patented technology

Systems and techniques are provided for identifying and tracing an individual session of a web application hosted at a server in a network communication system, based on a request message from a client requesting a function of the web application. Data stored in a database may be accessed by one or more virtual machines executing at the server via one or more data connections from a connection pool allocated to each of the virtual machines. Reference and logging information are stored for each virtual machine and corresponding connection pool, thereby enabling operations performed by each virtual machine for the requested function to be traced with a relatively high degree of granularity at each of various functional layers or tiers of the network communication system.

The invention describes a system and method for allowing an individual to view an educational program remotely. In the preferred embodiment, the invention is used as a healthcare education system. The system comprises a file server which is connected to a database holding the educational programs. A remote interface connected to the file server allows an administrator to assign educational programs to an individual. The remote interface also includes a memory card writer which records the individual's identification code and the address of the file server on a memory card. The individual is given the memory card to take home. When the individual places the memory card in the memory card reader of a multimedia processor, the processor uses the file server address to automatically connect to the file server. The file server receives the individual's identification code from the processor, retrieves the corresponding educational program from the database, and sends the program to the processor to be displayed. After the individual has watched the educational program, completion data in the form of the date and time the program was watched, or the individual's response, is sent from the multimedia processor to the file server. The completion data can then be viewed by the administrator on a report screen.

The invention provides a management method and a management system of database connection. The method and the system aim at solving the problem of management of multiple connection tank resources. The method comprises the steps that a database access request sent by a client side is received; an operation type and a keyword connected with a target are obtained from content of the request; a connection tank object matched with the keyword connected with the target is queried from a connection tank management table of a memory; the connection resource is obtained from the queried connection tank object; a corresponding database is connected according to the connection resource; connection is recorded to a database connection management table; corresponding database operation is executed according to the operation type; an operation result is returned; a connection resource management table is detected; and the connection is recovered according to detection. According to the method and the system, thousands of connection tank resources can be managed uniformly, and corresponding database connection is uniformly dispatched and controlled by a platform, so that the access efficiency is improved significantly compared with mutually independent management of connection tanks in the prior art.

A server executes in a virtual machine and facilitates execution of lightweight plug-in functions that respond to user interface commands from a client device. The functions augment the commands with additional processing even though they may not implement a user interface, they generate data in real time, they access any data repository or data source, can be written in any programming language, and they perceive that they have infinite storage. The client device need not have custom software and implements a traditional file-folder user interface using standard applications. Folders and file contents displayed on the client device need not exist until specifically requested by the user. Plug-in functions have their own root file system but may share a network namespace. Data may be input to a function using a folder name or a micro Web server. Two functions share a database connection to a remote computer. Files stored in a local cache are moved to remote storage transparently when a function needs more space.

An automated support system includes a database of statistics used to calculate and store the solution ratings. The database is connected to a decision-making module that selects appropriate solutions. A known computer operation-related problem is stored in the database. The problem is represented by a set of parameters of a user computer system. Any given set of parameters defines a problem existing on the user(s) computer system. A solution formed by the solution adding module is represented by a special file. The selected solution is automatically executed on the user computer system and operation-related problem is solved. The effective solution is assigned rating stored in the solution database.

Such a system is provided in which a map can be supplied to a user to permit the user to grasp the geography easily, if the address or the telephone number of an installation of destination, such as a restaurant, is stated, even though the scheme of displaying a map picture is not stated by an information provider in a text document of a preset format. An HTML analyzer 211 initiates an analysis loop of an HTML document being browsed to extract a location information letter/character string, which is seemingly an address or a telephone number, from the HTML document. A location searcher 212 calculates the latitude/longitude of a site from the location information letter/character string received through controller 217, using a site information database 213, and sends the so calculated latitude/longitude through controller 217 to a map picture generating unit 214. The map picture generating unit 214 references the map information database 215 connected to it to generate a map picture of an area around the site of destination, e.g., a restaurant.

The invention discloses a query method and system for colored message log, which is based on a distributed database. The system includes a colored message centre, a log server, a log query server and a WEB client-side. The colored message centre includes a plurality of service processors which are used for simultaneous business treatments. Log files are produced during the business treatment process of every business processor. The log server includes a relative collector and a database, which are used for collecting the log files produced by the business processors and introducing the files to the database in batches. The log query server is used for providing a query interface for the log server and providing WEB services for WEB clients. The query method and system for colored message log which is based on a distributed database adopts the three-tier architecture of a query thread manager which is arranged between a database connection pool and query services. The concurrent query of a plurality of log servers is realized. The query efficiency is improved and at the same time the robustness of the system is promoted.

The invention discloses an automated development platform based on model configuration, comprising a visualization work engine module and a database engine. For the visualization work engine module, the inside is divided according to system implementation functions, each divided part contains foreground and background related logics, the visualization work engine module works according to an agile developing model, and loose coupling is carried out among the parts; the database engine comprises a database connection manager, a sql manager, a things manager and an external interface, and is used for creating and managing database connections and maintaining data persistence; the sql manager is used for generating a corresponding sql object according to a data model configured by a user and transmitting the sql object to a tbl class in the visualization work engine module, and the tbl class executes the sql and makes corresponding response; and the platform automatically generates corresponding pages according to the configured data model, realizes insert, delete, update and select of simple functions, improves development efficiency and reduces workload of development.

The invention relates to a batch processing request-based Microsoft SQL server database cluster. The cluster consists of two parts, wherein a gateway and backups thereof are arranged at the front end of the cluster, and two or more of database server nodes are arranged at the rear end of the cluster; each node is provided with a structured query language (SQL) Server example and a cluster proxy and is not provided with a shared disk structure; and each node has an independent and consistent data set, and the cluster is only provided with a host. The gateway is used for managing the integral cluster; and for each client link, the gateway opens a database link corresponding to each node simultaneously to receive, analyze and optimize all client requests, wherein the client requests are divided into two classes, namely the read-only query requests and the data updating requests; for the read-only query requests, the gateway sends the requests to any one node to execute the requests according to a set load balancing algorithm so as to realize the real database access load balancing and improve the performance of a system; and the updating requests are sent to the host of the cluster to be executed, and are subjected to synchronous data by the host to other nodes to keep the data set of each node real-time and consistent, eliminate a single-point fault source and realize system fault tolerance. The integral cluster can improve the performance, availability and reliability of the system obviously and solve various problematic issues of the performance, single-point faults, zero data loss and the like in the field of databases, and is a comprehensive database cluster scheme.

This invention discloses a kind of database access method and apparatus. The method comprises the following steps: a) creating the description file of database system connection parameter; b) creating the description file of database system access operation; c) reading the description file of database system connection parameter, initializing database connection pool; d) reading the description file of database system access operation, initializing database access operation object; e) acquiring database access operation object according to the database access claim; acquiring effective connection from the database connection pool; accessing database and returning result. The said apparatus comprises description module, analysis module and process module. By describing the connection parameter of database access and parameter of data access operation, this invention can reduce redundancy code, and increase system operation efficiency.

The invention discloses an expandable running maintenance report generation method. The method comprises the following steps of: 1) associating a third party running maintenance monitoring system, and inputting database connection related information; 2) adding a data source, and testing the correctness of the data source; 3) managing the data source, and synchronizing the data source information; 4) obtaining a report template, wherein the report template can be selected from a template library of a report server or designed via a report designer in a custom manner; 5) analyzing the selected report template and verifying the correctness of the template by the report server; 6) setting parameters for generating the report, and associating the data source added in the step 2); 7) setting time for generating the report, and automatically transmitting the information, such as an address of a report file, and the like; and 8) generating the report file, and querying and downloading historical report files.

The invention discloses an automated database index creation method and system. The method comprises the steps: obtaining a data source corresponding to a database operation statement to be approved and instantiating the database connection; processing each database operation statement to be approved in a way of determining a database table used in the database operation statement and an index related field used in each database table; obtaining a field combination of an existing index of the database table from the data source; for each database table, creating a database index when a set formed by the index related fields in the database table is not a sub-set or a superset of the combination of each existing index of the database table and a corresponding database index is not created yet. The invention also provides the corresponding system. According to the automated database index creation method and system, automatic creation of indexes is realized according to the database operation statement to be approved and sample data, and the efficiency of the index creation is improved.

System, method, computer program product embodiments and combinations and sub-combinations thereof for backing up an in-memory database. In an embodiment, a backup server is provided to perform backup operations of a database on behalf of a database server. A determination is made as to whether the database is an in-memory database. Database server connections are utilized during data accesses for the backup operations when the database is an in-memory database.

The invention provides a control method of a database connection pool. The control method includes: normalizing thread priority; judging whether the current connection pool is empty or not, if not, taking out first data connection, setting the current state to be busy, and returning to the data connection; if yes, judging whether number of unreturned data connection in a current external program reaches maximum number of connection in the connection pool or not, if not, increasing the data connection prior to adding the same to the current database connection pool, and returning to the first data connection of the database connection pool; if the number of the unreturned data connection used in the current external program reaches the maximum number of the connection, setting the priority of the current thread, acquiring first time as current time, circularly judging whether the current connection pool is empty or not, and allowing the database connection pool to enter a waiting state. Data access performance can be effectively improved under the condition of high concurrency and multi-data source environment.

The invention relates to a heterogeneous database storage unified interface and a database access method by using the same. The interface mainly comprises a heterogeneous database drive management unit, a heterogeneous database connection pool, a heterogeneous database operation unit, a heterogeneous database connection configuration unit and a unified external API (Application Program Interface) unit. Through the heterogeneous database storage unified interface, a plurality of application processes can simultaneously access databases with different structures without modifying the databases and/or programs or knowing the kinds of the databases, so that the design of an application program can completely independent of different database treatment designs to achieve the aim that program design is irrelevant with the databases; and the operation APIs of all the databases are same, therefore, application codes are simplified, the maintenance is convenient, data transplanting and changing are realized.

An improved data access layer (DAL) architecture enables database connection pooling or multiplexing across machine boundaries. Drivers installed at web servers communicate with servers in a DAL. The DAL servers present a virtual database to the web servers, and the DAL servers in turn open connections to a set of physical databases. DAL servers are able to recycle connections that are no longer needed, or to move available connections from one DAL server to another, so as to provide improved efficiency in connection management, burst management, and peak load management. Scalability is thereby improved, and more efficient use of system resources is facilitated.

A computer program product has program code adapted to provide, upon execution, a database of objects and a database engine for managing the objects. Each object comprises metadata for describing the object and for defining a hierarchical structure of branches which constitutes the object and which includes relations to other objects. An individual branch has a metadata type, which is selected from a predetermined and limited set of n different metadata types and which represents one respective hierarchical level in the hierarchical structure, and a metadata value. An individual branch may also have an arbitrary number of other branches, of any hierarchical level strictly subordinate to the hierarchical level of the individual branch, connected to the individual branch as children thereof. The arbitrary number may include zero branches.