43 results about "Database theory" patented technology

A method and system is provided for a tamper-proof storage of one or more records of an audit trail in a database. Since the integrity of the database records may be vulnerable to actions taken by a user such as a privileged database administrator, a mechanism is provided to efficiently detect any changes made by him to the database records. The method creates one or more authentication tokens, and generates one or more validation tokens from the authentication tokens through a combination of a hashing process and an encryption process. Once the validation tokens are created, they are further integrated into the records in the database. The authentication tokens are written to a secured information storage in a predetermined format by a writing machine inaccessible by the user but accessible by the auditor. When an authorized person such as an independent auditor who needs to check the integrity of the records, he can detect a tampering of the records by comparing a validation token computed from the stored validation token with the validation token integrated in the record.

An apparatus, circuit, and method are provided herein for locating and extracting a plurality of matching entries from one or more databases stored within a Content Addressable Memory (CAM) device. The apparatus, circuit, and method may locate the plurality of matching entries by comparing variations of a single search key to the entire database of entries. In other words, a number of bits may be stored within each of the database entries as a descriptor field. When searching for a particular entry or entries, a corresponding descriptor field included within (or appended to) the search key may be modified, after at least one matching entry is found, for locating and extracting additional entries matching the original search key. Use of the descriptor field, therefore, enables the circuit and method to locate and extract a potentially unlimited number of entries matching the original search key. The circuit and method may be used for extracting ‘k’ matching entries, the first ‘k’ matching entries, or all entries matching the original search key.

A method and database are provided to facilitate management of surveillance devices that are distributed over a monitored region, through a geographic information (GI) portal, having GI storage to store map data defining a geographic map of the monitored region. The method and database record, in the GI storage, asset position information with regarding locations for assets of interest within the monitored region. The method obtains, from a remote surveillance device (SD) database, device-related records. The method obtains, from a remote network (NW) database, network-related records. The SD and NW databases are maintained and managed separately from the GI database by one or more independent management units. The method presents, on a graphical user interface, a geographic map of the monitored region with device markers and network links illustrated thereon.

A method and system are presented for quantifying a data page repetition pattern for a database index in a database management system. In one embodiment, the method includes identifying a database index to provide a basis for collecting a data page repetition statistic, the database index having a database index key. The method may also include collecting the data page repetition statistic based on the database index key, wherein the data page repetition statistic quantifies a data page repetition pattern associated with database queries that reference sequential entries of the database index. The method may further include optimizing a data page access process based on the data page repetition statistic. In a further embodiment, the method may utilize both cluster ratio and data page repetition statistics to evaluate data page I / O and CPU cost.

A technique is described for retrieving data from a hash table in an Ethernet bridge. The table has a plurality of columns, each of which has a hash function, thereby creating respective different hash key values.

The invention provides a container-door-type crane simulation operation panorama simulation system and a method thereof. The system comprises an electrical control hardware system and a panorama simulation software system. The electrical control hardware system comprises a crane operation linkage bench, a PLC control system, an electrical control cabinet, a driving motor, a 3D helmet system and a PC. The panorama simulation software system comprises a virtual three-dimensional modeling system, a virtual reality simulation software system, a three-dimensional virtual scene output display system, a student information recording database, a theory examination module, an operation training module and an evaluation system. A student operates a crane linkage bench and other external hardware, through using an Ethernet, operation command and the PC carry out bidirectional communication and a set of crane simulation digit model is established. A three-dimensional graph rendering engine is used to drive visual motion and a crane driver controls electrical equipment so that loading and unloading work panorama simulation operation training is performed on a container of a virtual environment. In the invention, training efficiency and training safety of a crane student are increased.

A method and apparatus for accessing a recursive scalable database in a multidimensional hierarchy through World Wide Web Internet communication channels to create, store, retrieve, manipulate, update and delete database objects that include records, audio, video and image data. Every time a file is to be restored in database memory (either a new file or a modified file) a pointer for storing the file is created which includes a file tag, derived from user identification data, and a new address in database memory to prevent any form of overflow. Space at the new memory address is selected to accommodate any size change of the modified file, permitting the storage area to expand. Thereby conferring the recursive scalable characteristic on the system

Methods, systems, and computer code for (i) performance-monitoring a multi-tier application including a .NET tier and a database tier; and (ii) for visually presenting performance-data to a user are disclosed. In some embodiments, a multi-tiered performance data interface, for example, including a .NET tier performance data interface and a database tier performance data interface operatively coupled to the .NET tier performance data interface, is provided. In some embodiments, the .NET tier performance data interface is configured to present .NET stack data and the database performance data interface is configured to present internal database performance data, for example, wait times (e.g. relative magnitudes of different types of wait times). Techniques for matching .NET-tier requests to execute SQL statements with database-tier executions of SQL statements are also disclosed.

An improved method and system for on-line reorganization of an IMS database while allowing concurrent updates. In one embodiment, the method involves building and dynamically maintaining a map of free blocks in the IMS database. The user then provides a list of candidate database records to be analyzed. The physical characteristics of each database record on the list are then analyzed. Calculations are made to identify fragmented database records and the segments which contain fragmented boundary twin chains. A reorganization recommendation list is created for each database record on the list, including fragmented boundary twin chains. Each fragmented database record on the reorganization recommendation list is then reorganized. This reorganization process includes the following steps: a) determine the number of blocks needed; b) assign and protect the number of blocks needed; c) identify the assigned blocks; d) retrieve the database record, delete the database record, and insert the database record into the identified blocks; e) commit the changes to the database. This process of analyzing the physical characteristics of each database record on the list and reorganizing the database records is continued until each database record on the list is no longer fragmented. User access to the database is maintained (i.e., the database is on-line) during the analyzing and reorganizing processes.

Methods of processing transactions in a multi-tier network of at least one database client and a plurality of database servers including a primary and a backup database server are described. One method includes the step of concurrently executing a plurality of transactions including a selected transaction on a first database server during an epoch exclusively identifying the first database server as a primary. The selected transaction is committed on the first database server in response to a commit request, if the commit request is encountered before the epoch is changed. The selected transaction is broadcast to a second database server for non-concurrent execution. The selected transaction is committed on the second database server if execution is completed and the epoch has not changed.

Providing analytics information from a cloud service includes maintaining an analytics database that is separate from data and servers accessed by users of the cloud service, selectively pushing information from the cloud service to the analytics database, where data and servers accessed by users of the cloud service are inaccessible for direct access by the analytics database, and allowing users limited access to the analytics database, where users of the analytics information that are accessing the analytics database are restricted from accessing data and servers of the cloud service. The analytics database may include a first database of adapted database records and a second database of dynamic logs of service related events. The adapted database records may be initially formed using the data and servers accessed by users of the cloud service prior to being pushed to the analytics database.

An apparatus having a computer-implemented database controller module, a computer-implemented database module, and a computer-implemented database query module. Software and / or firmware that is / are included in computer-implemented database controller module is / are configured to enter baseline data into the computer-implemented database module and to enter changes into the computer-implemented database module using an extensible multidimensional effectivity method of recording only an indicated change with its effectivity parameters. The computer-implemented database query module is configured to retrieve answers to queries relating to the baseline data and the changes and to return the answers in response to the queries.

An objective of the invention is to provide a method and a device used for database recovery. Specifically, the method comprises: obtaining a database on-line redo log and a database archiving log; according to the database on-line redo log, performing database recovery operation; obtaining the database archiving log generated in the database recovery operation; updating the database archiving log, and according to the updated database archiving log, performing database recovery operation on assigned point-in-time. Compared with the prior art, the method recovers a database through the on-line redo log, to obtain an archiving log corresponding to the on-line redo log in recent transaction operation time, so as to update all archiving logs, and make the archiving logs cover all point-in-time in database historical operation, and the updated archiving logs are used to recover the database, so that the database can be recovered to any point-in-time. The method completely reserves database data, so that data of the database is completely protected.

The invention provides a writing-into-database method for performance data in a telecommunication network management system, comprising the steps that: a message receiving thread stores the performance data of a received message in a message buffer zone, a file writing thread writes the performance data in the files in the event that current conditions meet the set conditions; a writing-into-database thread writes the performance data in the files into a database. Usage of the method in the invention can reduce loss of the performance data and shorten writing-into-database delay time of the performance data under the situation of the extraordinarily large amount of performance data.

A method and system are presented for quantifying a data page repetition pattern for a database index in a database management system. In one embodiment, the method includes identifying a database index to provide a basis for collecting a data page repetition statistic, the database index having a database index key. The method may also include collecting the data page repetition statistic based on the database index key, wherein the data page repetition statistic quantifies a data page repetition pattern associated with database queries that reference sequential entries of the database index. The method may further include optimizing a data page access process based on the data page repetition statistic. In a further embodiment, the method may utilize both cluster ratio and data page repetition statistics to evaluate data page I / O and CPU cost.

The invention discloses a database synchronization method based on drive encapsulation. The method comprises the following steps: encapsulating native database drives to form a drive end of the synchronization method, wherein interfaces provided by the drive end are the same as interfaces of the native database drives; when database accessing is carried out by an application through the interfaces provided by the drive end, directly querying a database and returning a result if the database accessing is database querying, and otherwise, recording modification operations to a log file while the database accessing is carried out; sending contents of the log file to a service end by the drive end; extracting the modification operations by the service end according to the contents of the log file, synchronizing the modification operations to other databases, and then returning a synchronization result to the drive end; and backing up the log file. The method of the invention does not depend on technical constraints of database vendors, can support various relational databases, and support synchronization of heterogeneous data, and has good data synchronization performance in a case of low loads on the databases.

An information repository and management system for data regarding a client base which integrates a plurality of information types including database records, word processor files, e-mail, other hyperlinked documents, web pages and web sites. Implemented as a database application on a web-enabled database server, sales and marketing team members may access the system through an intranet or remotely through an Internet. Portions of the database may be extracted and placed on a portable computing device for traveling purposes. The extracted database can be later synchronized with the central database upon return of a sales and marketing team member from a meeting or business trip. Links and expandable subforms are provided to web sites for stock quoting and client home pages, allowing sales team members to quickly gather information regarding a company's latest news announcements, stock performance, and financial status. Client relationship documents, such as meeting summaries, previous meeting briefing packages, and action item tracking sheets are organized and accessible through the system.

A method for the selective utilization of graphics processing unit (GPU) acceleration of database queries in database management is provided. The method includes receiving a database query in a database management system executing in memory of a host computing system. The method also includes estimating a time to complete processing of one or more operations of the database query using GPU accelerated computing in a GPU and also a time to complete processing of the operations using central processor unit (CPU) sequential computing of a CPU. Finally, the method includes routing the operations for processing using GPU accelerated computing if the estimated time to complete processing of the operations using GPU accelerated computing is less than an estimated time to complete processing of the operations using CPU sequential computing, but otherwise routing the operations for processing using CPU sequential computing.

A timing signal fault diagnosis device for an electronic control internal combustion engine comprises a central processing unit 11, a timing signal processor 10, a database memory 12, a user interface 13, timing signal input interfaces 14 and timing signal output interfaces 15. According to the device, three working modes are provided, and an input timing signal format is analyzed and compared with a pre-stored format in the database memory 12 to realize the timing signal fault diagnosis; a timing signal input into a novel engine is analyzed, and the characteristic parameter of the timing signal is stored in the database memory 12 for diagnosis of the fault of the same model of engine in the future; the timing signal is output, an ECU (electronic control unit) is activated, and accordingly, fault diagnosis for an engine which cannot operate is facilitated.

Correlating resource usage in a database tier to software instructions executing in other tiers of a multi tier application. In an embodiment, each block of instructions of interest (executing in different tiers) is designed to add a corresponding tag associated with a request (requiring a database operation to be performed). The resources required for performance of the database operation may be measured and the tags may be stored along with the measured resources, thereby facilitating correlation of desired software instruction blocks with the usage of resources in database tier.

Interfaces, systems and methods for searching a plurality of electronic databases, including patent databases. Downloaded database records can be adapted to a common format that includes hyperlinks to respective databases. Software for manipulating one or more of the database records is accessed via a chordal interface, wherein selection of individual software buttons and concurrent selection of two or more software buttons in a two-dimensional array of buttons is interpreted contextually.

The invention discloses a database query and a device, which relates to the network field, the invention is provided to solve the problem of the higher compatible cost between the SQL database and ODBC database. The method comprises the following steps receiving structured query language SQL script, the SQL script carries change quantity for data query; querying script convertor matching with object database type; converting the SQL script into the executable SQL scrip through the script convertor queried, the executable SQL script is that transfer parameter is consistent with target data type; transferring the executable SQL script to the target database to make the target database carry out data query according to the change quantity carried by the executable SQL script. The invention is applied in the process that the SQL script of named reference form is converted into the SQL script of anonymity reference form.

A method for judging the center of focus and process control of a lithography tool. Diffractive features are obtained from multiple diffractive structures located within multiple different focus setting fields. The variability of the diffraction characteristics of each field is determined by direct analysis or comparison with a database. The variability or uniformity can be represented by any measurement, including the standard deviation or range of values ​​of selected features of a database of theoretical diffraction structures or the variability or uniformity of the diffractive features themselves, as represented by RMS differences or intensity ranges. These methods can be used to process control and monitor focus shift by determining the internal field variation of the diffractive features of multi-diffractive structures in a series of wafers.

A method for the selective utilization of graphics processing unit (GPU) acceleration of database queries in database management is provided. The method includes receiving a database query in a database management system executing in memory of a host computing system. The method also includes estimating a time to complete processing of one or more operations of the database query using GPU accelerated computing in a GPU and also a time to complete processing of the operations using central processor unit (CPU) sequential computing of a CPU. Finally, the method includes routing the operations for processing using GPU accelerated computing if the estimated time to complete processing of the operations using GPU accelerated computing is less than an estimated time to complete processing of the operations using CPU sequential computing, but otherwise routing the operations for processing using CPU sequential computing.

Aggregating database entry modifications for replay of database changes includes: inserting, in a journal modification table, of database entry modifications, where each database entry is associated with a relative record number; and, for each relative record number: aggregating, in the journal modification table, a plurality of the modifications into a single modification.

Embodiments of the present invention provide a method, system and computer program product for the seamless integration of an application with an in memory data grid. In an embodiment of the invention, a method for intercepting database queries from a computer program for delegation to an in memory data grid is provided. The method includes retrieving database queries from a database driver for a database management system from a requesting computer program and comparing at least a portion of each of the database queries to a listing of database queries. Thereafter, the database queries are selectively routed to a data grid, such as an in memory data grid, in lieu of the database management based upon the comparison.

A technique is described for retrieving data from a hash table in an Ethernet bridge. The table has a plurality of columns, each of which has a hash function, thereby creating respective different hash key values.

An apparatus having a computer-implemented database controller module, a computer-implemented database module, and a computer-implemented database query module. Software and / or firmware that is / are included in computer-implemented database controller module is / are configured to enter baseline data into the computer-implemented database module and to enter changes into the computer-implemented database module using an extensible multidimensional effectivity method of recording only an indicated change with its effectivity parameters. The computer-implemented database query module is configured to retrieve answers to queries relating to the baseline data and the changes and to return the answers in response to the queries.