403 results about "Database application" patented technology

Systems and methods for replicating database data and generating read-only copies of the replicated data in a clean shutdown state. For example, systems can include a tracking module (e.g., a filter driver) that monitors transactions from a database application to a source storage device to generate log entries having at least one marker indicating a known good state of the application. The systems further include a computer coupled to a target storage device comprising a database and log files. The computer processes the transactions, based on the log entries, to replicate data to the target storage device; performs a first snapshot on data stored in the database and log files; replays into the database data stored in the log files; performs another snapshot on the database; and reverts the database back to a state in which the database existed at the time of the first snapshot.

An object locating, identifying, tracking, and surveillance system, denoted the Assets Locating, Tracking, and Surveillance System (ALTSS), is provided for managing physical objects and evidence in environments such as police departments, law offices, and the Courts. ALTSS employs radio frequency identification (RFID) technology, computer programming and database applications, networking technologies, and hardware elements. ALTSS may locate and track physical evidence, merchandise, information carriers like files, folders or individual pieces of paper, and people, under certain conditions, in near-real time. It may be configured as part of a local area network, a wide area network, or the Internet. ALTSS may employ exemplary components such as RFID transponders, scanners, strategically located antennas and computers to facilitate tracking of objects and people as needed. Any number of users having access privileges and connected to the network may access ALTSS directly or remotely via the Internet to locate and track evidence or objects.

An embodiment of the invention includes means to select portal resources (portlets, page and page groups) as displayed to a user based on pluggable rules engine; a rules database; and a portlet application aggregation engine which applies rules to select and display selected portlets, pages and page groups to a user.

The invention is an audio-video communication and answering system, where system's properties make it particularly suitable as a Digital Video Messaging System for, amongst other things, answering the door. The elements of the system are a DVMS outside module that is a wireless pocket PC with a proximity sensing, a video camera, a microphone, a speaker, a digital transmitter, a digital receiver, and a keypad; a computerized controller that is a personal computer with components for plaving and recording video and audio media; a DVMS inside module having a screen, a microphone, a speaker, a digital transmitter, a digital receiver, and a keypad; a wireless mode; and a DVMS database application with a graphic user interface. The computerized controller is in communication with a public switching telephone network enabling communication with remote peripheral devices, such as a cell phone, PDA, or computer. The system is based on the Microsoft Windows® Mobile 802.11b to coordinate communication between elements. The database application coordinates responses to prompts and events. The proximity sensor activates the system when the sensor detects the visitor's presence. This then starts a series of prompts and interaction prescribed by the application. The system includes an electrically actuated lock that can be actuated through a code entry or remotely. The system enables a visitor to communicate with an occupant either offsite or onsite, where the visitor never knows the occupant's location, unless the occupant discloses his location.

A method for protecting database applications including analyzing the activity on the server, analyzing the response from the server, and blocking malicious or unauthorized activity. Commands are analyzed for suspicious or malicious SQL statements or access to unauthorized data. Server responses are monitored for suspicious results likely to have occurred from a successful attack or unauthorized access to data. When malicious or unauthorized activity occurs, activity by the source is blocked or an alert is issued.

A method and system for dynamically generating database queries is disclosed. The method and system include storing web interface data, including query attributes for a database, in one more tables. The attributes are then retrieved from the tables and displayed in a graphical user interface web page for user selection. Based on the attributes selected by the user, a SQL query is dynamically generated. The method and system further include displaying results of the SQL query to the user in graphical format, thereby enabling dynamic generation of custom queries.

A computer-implemented method of customizing a database application at runtime includes steps of storing a value associated with a new attribute in an attribute table. The attribute table is configured as a logical extension of a base table that is configured to store values associated with a number of base attributes. The definitions of the new attributes may be stored in an attribute metadata table that is adapted to store the definition of each of the new attributes of the attribute table. A base-attribute pair may be stored in a base-attribute mapping table, the base-attribute pair mapping the name of the base table to the name of the attribute table. An extended attribute may also be stored in an extended attribute table, the extended attribute table including a name column configured to store the extended attribute and a value column configured to store an extended attribute value corresponding to the extended attribute. Rows of the extended value table may be mapped to corresponding rows in the base table. A rule may be stored in a rules table, the evaluation of the rule determining whether the extended attribute value in the extended attribute table is valid.

Roaming usage management apparatus for managing roaming mobile devices connected to roaming networks. The management apparatus includes a data gathering application for gathering roaming activity data, a database application, which aggregates the records into activity logs of calls per roaming device, and an output unit which sends outputs to or concerning respective roaming devices, in order to manage them based on activity levels or kinds of activity recorded in the logs. The embodiments thus provide management of roaming devices. The management is per roaming device, preferably real time, and may be used to leverage takeup of roaming services.

A system and method describing a compatibility server for rehosting database applications written for a specific vendor's database on the database of a second vendor, without the need of rewriting the application to take into account differences in the application programming interfaces between the first vendor's database and the second vendor's database. Requests for access to the database are translated from one format to another at execution time. The server is also capable of translating error messages, data types and data formatting from the format used by the second database to that expected when making requests to the first database. Stored procedures defined in the first database are migrated to the second database as text blocks, and are translated at execution time into a high level programming language, compiled and executed against the second database. All information necessary for the mapping of schema, data, data types, error and status messages and data formatting, as well as information necessary to execute stored procedures, is stored in a plurality of metadata tables in the second database, which are created during a migration phase prior to executing the application.

Database partition monitoring and dynamic logical partition reconfiguration in support of an autonomic self-tunable database management system are provided by an automated monitor that monitors one or more resource parameters in a logical partition running a database application in a logically partitioned data processing host. The monitor initiates dynamic logical partition reconfiguration in the event that the parameters vary from predetermined parameter values. In particular, the monitor can initiate removal of resources if one of the resource parameters is being underutilized and initiate addition of resources if one of the resource parameters is being overutilized. The monitor can also calculate an amount of resources to be removed or added. The monitor can interact directly with a dynamic logical partition reconfiguration function of the data processing host or it can utilize an intelligent intermediary that listens for a partition reconfiguration suggestion from the monitor. In the latter configuration, the listener can determine where available resources are located and attempt to fully or partially satisfy the resource needs suggested by the monitor.

In accordance with new technique, a computerized data recovery system includes a storage subsystem and a backup server operatively coupled to backup storage medium, the storage subsystem including a continuous data protection system. The backup server executes a recovery manager which: collects consistency points from at least two database applications executing on at least one host; collects journal terms of the continuous data protection system for each of the at least two database applications; collects log terms associated with each of the at least two database applications; displays to a user a timeline for a protected term and consistency points for the at least two database applications; receives recovery time selection from a user; receives recovery database application selection from the user; receives baseline database application selection from the user; performs crash recovery for each database application; and performs recovery of data based on transactions associated with the at least two database applications.

A database may facilitate zero-downtime upgrades by concurrently maintaining multiple editions of database objects for use by both pre-upgrade and post-upgrade clients of a database application. Operations performed within the database are associated with an edition based on, for example, an initiating client or transaction. When an operation references an object or data, the database automatically performs the operation using the object or data associated with the edition with which the operation is itself associated. The database may determine the associated edition without explicit identification of the associated edition in a query or in code. Thus, no client or stored procedure code changes are necessary to reflect a new edition added during an update. Data changes in one edition may be automatically and immediately propagated to the other edition through the use of cross-edition triggers, thereby allowing both pre-upgrade and post-upgrade clients to remain fully functional throughout an upgrade.

Techniques for automatically installing an application on a device on a network include sending, to a server, data indicating device resources on the device. The device requests a database application from the server. The device downloads from the server an initial customized value for a configuration parameter based on the device resources and the database application. The device also downloads the database application. The device installs the database application with the initial customized value for the configuration parameter.

A system and method for creation, modification and/or use of plan guide(s) is provided. Plan guide(s) can be employed to optimize the performance of query(ies) when it is not possible and/or desirable to change the text of the query directly. Plan guides can be useful, for example, when a small subset of queries in a database application deployed from a third-party vendor is not performing as expected. Plan guides influence optimization of queries by attaching query hints to them. In accordance with an aspect of the subject invention, a query plan execution system is provided. The system includes an execution component, a query optimizer, and, a plan cache. Plan guides and other associated metadata are stored in a plan guide metadata store.

Techniques are provided that allow mobile devices to use database applications without having to specifically design the database applications to support all forms of mobile devices. In particular, techniques are provided in which the data coming out of a database application is formatted into Extended Markup Language (XML). The XML is the same regardless of which client is to receive the data. Prior to supplying the data to a client, the Extended Style Sheet (XSL) is applied to the data to format the data into the format required by the client.

The present disclosure is directed towards systems and methods for monitoring application level flow for database applications served by a cluster of servers. An application flow monitor may receive and distribute write requests of a client to at least one master server and read requests of the client to one or more slave servers, based on load balancing or similar policies. The application flow monitor may receive responses from the recipient server and may aggregate the requests and responses into Internet Protocol Flow Information Export (IPFIX) messages that may describe the entire communication flow for the application. Accordingly, application flow statistics may be monitored, regardless of which server was involved in any particular request/response exchange, allowing scalability without impairment of administrative processes.

The present invention introduces a development platforms based on the database application systems with function design, the development platform includes system control table, the menu component kits and code generator, the menu component kits is the module of reusable menu classification implementation; System control table is the carrier of description parameters both of storage application system architecture and menu functions, the carrier is the data tables of the relational database; The code generator dynamically generates code execution under storage parameters in the system control table. Development and application of the system using development platform just require system functional design, data table design, menu Form design, without the need to write code or only a very small number of special features menu prepared by the code, which can be generated applications; Application of the system's operation, reading system control table parameters and dynamic generating code execution, completion of system functions; when users change the business model, only a modification of system parameters control table, or to amend the use of the data table menu, and the menu forms can complete system maintenance.

Data-tier application components (DACs) and methods for managing database applications are disclosed. According to one particular embodiment, a DAC includes a single unit of management that packages metadata related to a database object. The metadata related to the database object includes an identifier of the database object, a database runtime resource identifier of a database runtime resource operable to manipulate the database object, and a policy related to execution of the database runtime resource.

A method and system automatically creates and operates a web application from a spreadsheet without the need for specialized programming. The web application includes a guided data entry process created from spreadsheet worksheets. The web application interfaces with a database application, so that model data may be retrieved for analysis. The web application implements the model as a calculator data defining the relationships between the model values. A rendering data defines the appearance of the model values in the web application. A instance data includes the model values for an instance of the web application. A calculation engine calculates model values. A layout engine creates display information from the calculator, rendering, and instance data set. The rendering data includes objects having display methods for creating display information in accordance with its object type. Object types include inputs, outputs, and user interface elements.

A method, computer program product, and system for sharing cloud data resources among associated users. Upon receipt of a request from an associate of a primary user to share a cloud data resource, a sharing profile of the primary user is evaluated to determine if the associate is permitted to share the requested resource, and if so, the requested resource is made available to the associate. The shared cloud data resource can be a database application, data object, data storage resource, or a portion thereof.

The invention relates to a data synchronization method and system among heterogeneous databases, by which the two purposes of historical data synchronization and incremental data synchronization are achieved. According to the method, heterogeneous synchronization among various types of main databases is supported, other tools and scripts are not needed, the historical data synchronization and the incremental data synchronization can be easily configured and are automatically linked, and the complexity is reduced. The system is simple and easy to understand, backstage scrip writing and database command input are not needed, and a whole data synchronization service can be configured even by a person who has no experience in database application. The method and the system are applicable for a synchronization scenario of various types of data.

A database system is capable of executing a database application that transfers a logical object in multiple fragments. The database system comprises a main storage site, a remote storage site, a main protocol executable on the main storage site, and a remote protocol executable on the remote storage site. The remote storage site is capable of linking to the main storage site and mirroring information stored in the main storage site. The remote storage site includes a storage and a cache sidefile divided into a plurality of array sidefile recordsets. The main protocol is capable of including information indicative of logical object fragment commencement and completion in the multiple fragment database application transfer. The remote protocol is capable of controlling the cache sidefile to cache the multiple fragments as received and to enable destaging of the logical object to the storage on receipt of all fragments.

An intelligent framework is provided that is disposed between a high-level language environment and a database system environment. According to one embodiment, the framework programmatically receives information regarding definitions of data structures of objects participating in a software application and information regarding relationships among the objects. Based upon the particular request from the high-level language environment and upon the definitions and relationships, the framework programmatically and dynamically generates appropriate statements associated with the database system environment that accomplish the request. For example, the framework may issue statements to define the structure of a database, access information from the database, and/or manipulate information within the database.