Patents
Literature
Hiro is an intelligent assistant for R&D personnel, combined with Patent DNA, to facilitate innovative research.
Hiro

1001 results about "Database connection" patented technology

A Database connection is a facility in computer science that allows client software to talk to database server software, whether on the same machine or not. A connection is required to send commands and receive answers, usually in the form of a result set.

Devices for providing distributable middleware data proxy between application servers and database servers

The present invention discloses devices Including a transparent client-connection manager for exchanging client data between an application server and the device: a request analyzer for analyzing query requests from at least one application server; a data-retrieval / command-execution module for executing query requests; a database connection manager for exchanging database data between at least one database server and the device: a cache-memory pool for storing data items from at least one database server: a cache-policy module for determining cache criteria for storing the data Items In the cache-memory pool; and a data-consistency invalidation module for determining invalidated data Items based on invalidation criteria for removing from the cache-memory pool. The cache-memory pool Is configured to utilize memory modules residing in data proxy devices and distributed cache management utility, enabling the memory capacity to be used as a cluster to balance workloads.
Owner:DCF TECH

Retail checkout system and method

A near field communication (NFC) based checkout system comprises an NFC enabled mobile telephone that reads product data from an NFC tag associated with a product. The mobile telephone updates a shopping list when the consumer scans an item. The consumer uploads the shopping list at a payment terminal at the checkout via an NFC link. The payment terminal connects with a price look up (PLU) database and downloads the price data for the items in the shopping list to provide a total price. The payment terminal requests authorisation of the total price from the consumer's financial authorisation.
Owner:NCR CORP

Data output system, communication terminal to be connected to data output system, data output method and storage medium

In a data output system, a server to which this invention is adapted is connected to a database which holds data of plural types of data formats, searches the database based on the content of a search request made by a search requester, and outputs the search result after performing conversion and edition on the search result in accordance with the ability, function and / or capacity of a communication terminal to which the search result is to be output.
Owner:CASIO COMPUTER CO LTD

Granular application sessions tagging

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.
Owner:CELLCO PARTNERSHIP INC

System and method for monitoring a physiological condition

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.
Owner:ROBERT BOSCH HEALTHCARE SYST

Method and apparatus for switching website multiple data sources

The invention discloses a method for switching website multiple data sources. The method comprises the following steps: searching a mapping relation between a request parameter and a data source identification to obtain the data source identification corresponding to the request parameter in an access request; initializing a context of the access request and writing the obtained data source identification in the context; calling a data source switching module to obtain the data source identification from the context and obtaining a corresponding connection pool of a database server from a switching strategy according to the data source identification; and obtaining database connection from the connection pool of the database server, switching an access to the corresponding database and executing the access to the database. The invention further discloses a website multiple data source switching device which allocates data source resources by centralized data source connection management, which greatly reduces the number of the desired database connections in the database server; moreover, the website multiple data source switching device can timely and dynamically allocate available database resources, thus reducing the waste of the resources.
Owner:北京中企开源信息技术有限公司

Management method and management system of database connection

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.
Owner:ALIBABA GRP HLDG LTD

Method and apparatus for eliminating partitions of a database table from a join query using implicit limitations on a partition key value

A database facility supports database join queries in a database environment having at least one database table divided into multiple partitions based on a partition key value. The facility determines whether the values in a table joined to the partitioned table place an implicit limitation on the partition key, and eliminates from query evaluation any partitions which do not satisfy the implicit limitation. Preferably, the database uses a star schema organization, in which implicit limitations in a relatively small dimension table are used to eliminate partitions in a relatively large fact table.
Owner:IBM CORP

Massive data continuous analysis system suitable for stream processing

The invention discloses a massive data continuous analysis system suitable for stream processing, which comprises a metadata management module, a query plan generation module, a data import task generation module, an increment processing module, an MR (MapReduce) message processing module and a database connection module, wherein the metadata management module is used for managing meta-information of data tables and databases; the query plan generation module is used for receiving a query request and generating an optimal query plan; the data import task generation module is used for receiving a data import request and generating a data import MR operation set; the increment processing module is used for incrementally committing data import and query operations to a Hadoop system in parallel; the MR message processing module is used for receiving a result of a Map or Reduce function of the Hadoop system and outputting the result to a Reduce end or the next operation; and the database connection module is used as an interface between the Hadoop system and the databases. According to the invention, the Hadoop system is used for organically organizing the databases in nodes and simultaneously executing data import and data query and a pipeline technology is used for improving the MR execution flow, so that the data query is executed in a continuous stream mode and the time of analyzing massive data is greatly shortened.
Owner:HUAZHONG UNIV OF SCI & TECH

Plug-in function platform and methods

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.
Owner:ESOPTRA NV

System and method for automated solution of functionality problems in computer systems

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.
Owner:AO KASPERSKY LAB

Information processing method and apparatus

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.
Owner:SONY CORP

Distributed database based on multimedia message log inquiring method and system

InactiveCN101163265AImplement concurrent queriesRealize centralized error controlRadio/inductive link selection arrangementsSpecial data processing applicationsWeb serviceClient-side
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.
Owner:ZTE CORP

Automated development platform based on model configuration

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.
Owner:STATE GRID SHANDONG ELECTRIC POWER

Batch processing request-based Microsoft SQL server database cluster

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.
Owner:无锡浙潮科技有限公司

Method and apparatus for accessing database

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.
Owner:HUAWEI TECH CO LTD

Expandable running maintenance report generation method

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.
Owner:勤智数码科技股份有限公司

Automated database index creation method and system

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.
Owner:ALIBABA GRP HLDG LTD

Dynamic monitoring system and method for data base list update

ActiveCN1673972AMake full use of system resourcesMaximize environmental supportHardware monitoringSpecial data processing applicationsDynamic monitoringData science
The dynamic monitoring system for updated data base list includes monitoring list for storing the names and life signs of all the user lists; monitoring trigger corresponding to the user lists one by one for intercepting the insertion, updating and deletion operations of user lists; monitoring list backup in the application part of the system; monitoring module accessing the monitoring list via data base connector to obtain the life signs of the user lists and compare the obtained life signs with those in the backup for finding altering; and issuing interface to output real-time data base list updating information. The present invention solves the technological problem of providing dynamic monitoring system and method for updated data base list.
Owner:SHANGHAI BAOSIGHT SOFTWARE CO LTD

Reentrant database object wizard

A system and method for a reentrant database object wizard is provided. The system provides the ability to compare a currently generated dataset to the objects of the underlying database. Columns and tables that are not common between both the dataset and the database are visually displayed for the user to make a decision on inclusion or exclusion. In addition, columns and tables that were previously within the dataset that are no longer available on the database connection are displayed, for example, with warning icons so that the user can either resolve the missing column or table within the database, or remove the column / table from their typed dataset. The system includes a comparison component and a display component. The comparison component provides comparison information based upon a comparison of a dataset to an associated database. The display component displays the comparison information. The system can further, optionally, include an input component which can be employed by a user to provide information associated with the user's decision on inclusion and / or exclusion of column(s) and / or table(s) to the system. Thereafter, based upon the user's input, the system can provide can provide based upon a comparison of the modified dataset to the associated database.
Owner:MICROSOFT TECH LICENSING LLC

Intelligent disaster recovery for database connection failures

Embodiments of the invention provide techniques for disaster recovery in the event of a database connection failure. In one embodiment, a network address for a secondary server may be stored in multiple data objects of a client computer. In the event of a failed connection to a primary server, the network address of the secondary server may be retrieved from one of the data objects stored in the client computer. When an updated network address for the secondary server is received, it may be propagated to the data objects of the client computer.
Owner:IBM CORP

Managing Data Backup of an In-Memory Database in a Database Management System

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.
Owner:SYBASE INC

Control method of database connection pool

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.
Owner:STATE GRID CORP OF CHINA +1

Heterogeneous database storage unified interface and database access method

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.
Owner:北京思特奇信息技术股份有限公司

Limitation method of Web server concurrent number

The invention discloses a limitation method of a Web server concurrent number, relating to the field of information technologies. In a three-tier system framework, the Web server accesses to a database by a connection pool; when user requests have certain large statics or inquiry, the connection pool is gradually used up by the requests, thus the whole system stops responding. In the limitation method of a Web server concurrent number, after transferring client-side information to the functional module of each service, the database connection pool is accessed by an inquiry connection module; the inquiry connection module is divided into a large inquiry connection module and a common inquiry connection module, wherein the large inquiry connection module has the maximum total concurrent number; when a user side submits a large inquiry request, if the request number is smaller than the maximum total concurrent number, one database connection is obtained from the database connection pool, and a database access request is submitted to the database server by the connection; otherwise, the user is prompted to wait. The maximum total concurrent number is set to limit large inquiry connection amount and ensure the response capability of common inquiry.
Owner:STATE GRID ZHEJIANG ELECTRIC POWER +1

Electronic goods shelf label with multi-channel information display and system

The invention discloses an electronic goods shelf label system with multi-channel information display. The electronic goods shelf label system comprises a commodity database, an electronic goods shelf label server, an operation server, replay stations and electronic goods shelf labels. The commodity database is used for storing commodity information. The electronic goods shelf label server is connected with the commodity database and used for sending the commodity information to an electronic goods shelf label terminal through the relay stations. The operation server is connected with the relay stations and used for sending operation information to the electronic goods shelf label terminal through the relay stations. The replay stations are connected with the electronic goods shelf label server and the operation server in a wired or wireless mode, connected with the electronic goods shelf labels within a management range and used for updating the commodity information and the operation information of the electronic goods shelf labels. Each electronic goods shelf label comprises a controller, a power supply module connected with the controller, a storage device, a communication part and display parts. The number of the display parts is at least two. The electronic goods shelf label system can simultaneously independently display and update the commodity information and the operation information, so that labor cost is saved and advertisement revenue value is created.
Owner:HANGZHOU CENTURY TECH

Data access layer

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.
Owner:WALMART APOLLO LLC

Authenticated database connectivity for unattended applications

A custom database connectivity component is deployed in conjunction with a native database connectivity component and a credential manager. The custom connectivity component has a requestor interface for communicating with a requestor application, a credential service interface for communicating with the credential manager, a native database connectivity interface for communicating with native connectivity components, and a decision engine for determining how to convert a request from a requestor to an appropriate API call to the credential manager. The custom connectivity component provides an authenticated and authorized database connection for a requestor application. The component transparently serves retrieves database, or other target resource, credentials on a real time basis, without requiring code changes to the requestor application.
Owner:IRDETO ACCESS
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