41 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.

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.

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.

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.

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.

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 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.

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.

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.

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.