148 results about "Database manager" patented technology

A tagging tree that defines a hierarchical output data structure and relational database query operations that retrieve the data to be included in each hierarchical section is accepted and processed. A query optimizer analyzes the tagging tree to determine database query operations that can be combined into a single query command. An outer-union query command is generated to allow efficient combination of multiple query commands, some of which are predicates to others. The tagging tree is modified to replace the database queries that were combined into the outer-union query to extract data from the results set produced by the outer-union query as opposed to submitting queries to the database manager. The optimized queries can be reused an arbitrary number of times to leverage the optimizing resources that were used in their creation.

A heterogeneous information system such as a digital library often uses a database manager together with other data resource manager(s), such as an object server or a video server, to manage digital content. Such a system often needs to maintain an application-specific database and/or to handle application-specific operational requirements. To facilitate system integration and application development, an application-independent reusable product is created which generates a custom system component or utility, such as a loader, according to a specification provided by a system integrator or an application developer.

A method and system for monitoring the consistency of replicated databases in a shared-nothing database cluster architecture is presented. The method involves the continuous monitoring of the database transaction logs that are maintained by the autonomous database managers that manage the individual database replicas in the cluster. In the event that data discrepancies are detected via the comparison of the transaction logs of the individual database replicas, remedial action is carried out according to configured rules in the main cluster controller. Additionally, if the database management system running within each node of the cluster possesses a database history file that records key events pertaining to a database replica, such as the occurrence of non-logged bulk loads of table data, or the modification of tables, a method can be instituted for the monitoring of the history files for discrepancies between the database replicas.

System for authenticating a user for logon to a content manager running on top of a database manager. A connect procedure connects the user to a database manager; and then a logon procedure logs on the user to the content manager selectively responsive to the user connecting to the database manager; the user being authenticated by a third party by way of a user exit or a trusted logon environment and privilege; or the user being authenticated by the content manager.

Techniques for managing databases include registering multiple databases at a community server. Each database is controlled by a different party. The community server is accessible over a first network to which one or more users from each party have access. Each database is installed on a different network than the first network. The community server receives from a user over the first network a request to perform a management operation relating to a particular database that is controlled by a particular party. The community server determines that the particular database is registered and determines whether the user is authorized to perform the management operation. If the user is authorized, then the community server causes the management operation to be performed.

With these techniques, one or more database devices, such as database appliances, can be managed over the Internet with a browser, at least for many common database management functions. This alleviates the load on an enterprise database manager platform, provides metadata even when the database device or enterprise platform is not working, provides ready backup when a database device or enterprise platform returns to operation, and enables a database administrator for the enterprise to perform some management functions while on the road, away from the site of the enterprise. It can also provide users of an enterprise's database devices with access to some database metadata when the user is on the road or the enterprise equipment is not operating.

In a communications system having a plurality of endpoints (240,242,246) each including a logical entity and its physical counterpart, a system for controlling and managing session between at least two endpoints. The system including a registration manager (202), an application layer router (204), a session controller (206), a group database manager (208), and at least one group entity (210).

A system for localizing an EPG program schedule, including an EPG service provider station including a database of channels and corresponding EPG program schedule information, a database manager identifying a plurality of channel line-ups potentially receivable at a viewing location, a transmitter, and a receiver, a multimedia viewer situated at the viewing location including an automatic channel line-up identifier identifying a first line-up of television channels receivable at the viewing location, a channel line-up processor at the viewing location calculating a channel line-up from among the plurality of channel line-ups that substantially matches the first line-up, a receiver receiving from the EPG service provider station the plurality of channel line-ups, and a transmitter transmitting to the EPG service provider station the identifier of the channel line-up calculated by the channel line-up processor, and a network connection linking the multimedia viewer to the EPG service provider, wherein the EPG service provider station transmitter transmits to the multimedia viewer the plurality of channel line-ups and also transmits to the multimedia viewer EPG program schedule information localized to the viewing location and based on the identifier of the channel line-up calculated by the channel line-up processor, and wherein the EPG service provider station receiver receives from the multimedia viewer the identifier of the calculated channel line-up, and wherein the multimedia viewer receiver also receives from the EPG service provider station the EPG program schedule information.

Systems and methods for providing notifications of changes made in a database table to a remote application is presented. The system and methods manage change notification of a table in a database by notifying an application registered to receive notifications of changes made to a database table. A database manager executing on a device may receive a request to register an application to be notified when a first table of a plurality of tables in a database is changed. The database manager may establish a notification table comprising fields of the first table and one or more additional fields for managing notification. The database manager may establish a trigger on the first table to invoke a trigger procedure to copy a changed row of the first table to the notification table. The database manager may create a rule for the notification table to notify registered applications when a new row is inserted into the notification table

The invention provides a system and method for retrieving and storing industrial data, the system comprising a data retriever that includes a data retrieval manager and one or more watchers for monitoring data associated with one or more industrial devices, wherein if the data associated with the one or more industrial devices is new or modified, the one or more watchers notifies the data retrieval manager thereof and the data retrieval manager uploads the new or modified data. The system further includes a database manager for receiving the new or modified data in a first form from the data retrieval manager and for storing the new or modified data in a structural data form in one or more databases.

The present invention may be used for determining a topology of a network in the presence of network address translation. From an active client behind a translating device, communications are initiated that effect the network address translation. The communications are monitored beyond the translating device to infer partitioning of servers into equivalence sets relative to the network topology induced by the network address translation. Active clients behind the translating device may include a respective actual sending address in a message sent to a server beyond the translating device. The server beyond the translating device distinguishes between communications affected by and not affected by network address translation, which may include comparing an apparent source address of a message against an actual address provided in the message by the active client behind the translation device. The external server may also distinguish between active and passive client messages. The server server may cause a message to a passive client to be redirected to an active client; the active client, in turn, communicates to the external server. The external server stores addresses of devices in translated address sets, which may be maintained in a database and managed in a database manager.

A system for locating, segmenting, annotating and retrieving multimedia files, provides a database of metadata (68) relating to multimedia files (70), a database manager (64), and a database client (66) for accessing the data contained within the database. The database client (66), together with the metadata database (68) and database manager (64) provide a variety of different functionalities, namely a deep linking functionality, a segmentation functionality, a metadata annotation functionality, a retrieval functionality, and an access functionality. The user, through database client (68) annotates the multimedia file or segment of multimedia file with metadata which is saved in the database (68). When the user desires to locate a multimedia file, the metadata is searched or browsed to locate the database entry associated with the multimedia file in question. The system further provides the ability for the user to load, open and start the playing of a multimedia file from a point intermediate to its start and end point, and without the user having to experience the portion between the start point and the intermediate point, break down larger files into shorter segments or individual frames (or still images) or regions within frames (or still images) without creating additional copies of the selected segments of the multimedia files of interest, thereby avoiding copyright issues from arising.

Distributed MPEG-7 based Surveillance Servers for Digital Surveillance Applications (DM7SS), provides a distributed MPEG-7 compliant surveillance system platform that can provide flexible and extensible indexing and searching mechanisms based on MPEG-7 standards and technologies for distributed digital surveillance systems. A database manager implements a database process to manage metadata and predefined descriptors of surveillance video clips by sending the metadata to a database engine that handles storage of data into and retrieval of data from a relational database management system, and mapping or converting the predefined descriptors into schema of a relational database. A search manager handles an archive video search process, wherein a master server provides unified interfaces for video search requests that can be processed concurrently among slave servers. An update manager allows new modules to be added to a server, such as new description schema definitions, new metadata processing procedures, and new search processing procedures.

A communications processing section in a managing device transmits a request for a transmission of generated power quantity information via the Internet to an electric power generator to be managed. A database manager in the managing device stores the generated power quantity information transmitted back from the electric power generator into a database. A timing controller in the managing device controls so that the number of electric power generators to which a transmission request is being transmitted does not exceed a predetermined value.

A digital information verification (DIV) system (10) wherein a process controller (12) directs operation of a database manager (14) and a search engine (16) that access a personal base (20) and an entity base (22) containing information provided by individual-members (30) and entity-members (32), collectively users (34) of the DIV system (10). The users (34) access the DIV system (10) via user access devices (28), a communication unit (26), and an authentication processor (24) that determines the nature of each user (34) based on an ID number (44, 54) and password. The information provided by the users (34) is stored in personal records (40) and entity records (50), respectively stored in the personal base (20) and entity base (22), and can become verified information based upon comparison.

A database manager selectively caches journal entries for certain database changes based on dynamic selection criteria. Preferably, a journal disk drive is provided for storing changes to the database. Database change entries are sequentially cached in a main memory journal buffer, awaiting journal write. When a buffer is filled, its buffer contents are written to the journal disk. However, certain change operations will cause the contents of the buffer to be written to the journal disk immediately, before filling the buffer. Certain database change entries selectively cause the buffer to be written, depending on dynamic selection criteria. Preferably, these selection criteria take into account both the estimated time to recover in the event of a system crash and the current level of activity on the system. Generally, the busier the system, the more data will be cached, and vice versa.

The invention discloses a system and method for rapid configuration of a database management background. The system comprises an authority manager, a database manager, a background configurator and a background user manager. The method comprises the steps of classifying users and menus in the system and setting authority relations; establishing and storing data list pages and data edition pages needed by the system; performing authority management on the users and the menus, configuring a data table for the menus, configuring the data table to the menus and configuring corresponding fields for the data table, configuring page address links and data table links on function pages; and performing self-defined modification of the function pages by background users. The system and method for rapid configuration of the database management background have the advantages that users directly associate the menus, the previous complex authority relations are avoided, the development difficulty is greatly reduced; the database development is automatically generated, so that the development volume is remarkably reduced; background configurations are automatically generated, the background configuration difficulty is remarkably reduced; and the background management and development cost is reduced.

The present invention aims to dynamically re-configure hosts and storage in a shared-nothing database. In the shared-nothing database, processes 24 to 29 executed in the hosts 11 to 14 access data of a storage device 30. A system manager 70 and a database manager 10 manage the hosts 11 to 14 and the storage device 30. The processes 24 to 29 access one or more disks 51 to 54 of the storage device. To add or reduce the number of the hosts, the processes 24 to 29 are reassigned among the hosts 11 to 14.