41 results about "Relational data base management system" patented technology

A software system automatically and dynamically generates a fully functional user interface (UI) based upon, and connected directly to, an underlying data model (as instantiated within a relational database management system (RDBMS)). The UI derives from an automated interrogation of the RDBMS, and comprises all mode displays (e.g., browse, search, edit, add) for all tables, and a full complement of mechanisms—integrated directly into the mode displays—for representing, navigating, and managing relationships across tables, regardless of the complexity of the underlying RDBMS schema. It utilizes a hierarchical “context stack” for suspending the working state of a particular table while “drilling down” to work with related-table information and return relevant changes to the base table. The embodiment further provides methods to enhance and extend the internal representation of table structures, constraints, relationships, and—special requirements (“business rules”) for improved revelation of the schema structure through external interrogation.

The present invention relates to the usage pattern, commonly found in many software applications, of defining sets of objects based on object attributes. A specifically designed set definition language for defining sets, called SDL, is described and a software system that implements this language efficiently on top of a standard relational database management system (RDBMS) is presented. The unique features of the SDL language are the implicit constraints that are enforced on the relational data that belong to the objects. Unique to the SDL system is also the logical metadata of dimensions that enables the SDL system to enforce these constraints across relations. The SDL system utilizes several optimization techniques to enable efficient implementation on top of RDBMS. It is also shown how the SDL language and the SQL language can be merged with bidirectional inlining using syntactic gates. Query composition tools are also described that facilitate the creation of SDL expressions.

An optimization technique that reorders outerjoins and antijoins with inner joins in a bottom-up optimizer of a relational database management system (RDBMS). Each join predicate is associated with a normal eligibility list (NEL) that includes tables that are referenced in the join predicate and an extended eligibility list (EEL) that includes additional tables that are referenced in conflicting join predicates. An EEL includes all the tables needed by a predicate to preserve the semantics of the original query. During join enumeration, the optimizer determines whether a join predicate's EEL is a subset of all the tables in two subplans to be merged, i.e., whose EEL is covered. If so, the two subplans are combined using the join predicate. Otherwise, the two subplans cannot be joined. Two approaches are used to reordering: without compensation and with compensation. The "without compensation" approach only allows join reorderings that are valid under associative rules. Thus, the optimizer will not combine subplans using a join predicate whose EEL is not covered. The "with compensation" approach allows two subplans to be combined using the join predicate, when a join predicate's EEL is not covered, as long as the join predicate's NEL is covered. Compensation is performed through nullification and best match. Multiple compensations may be merged and performed at any time.

A method, apparatus, and article of manufacture for creating macro language files for executing SQL queries in a relational database management system via the World Wide Web of the Internet. In accordance with the present invention, Web users can request information from RDBMS software via HTML input forms, which request is then used to create an SQL statement for execution by the RDBMS software. The results output by the RDBMS software are themselves transformed into HTML format for presentation to the Web user.

Described is an electroencephalograph (EEG) data collection system. The system includes a helmet with a plurality of data collection electrodes. Each data collection electrode has a housing and a pressurized probe affixed with the housing. The pressurized probe includes an electrically conductive base for electrical communication with the scalp of a user for detecting EEG signals of the user. The pressurized probe is pressurized such that the electrically conductive base is forced away from the housing and toward a user's scalp. The data collection electrode is further formed to hold a discrete amount of an electrically conductive gel therein and dispense the gel proximate the electrically conductive base to facilitate an electrical communication between the user's scalp and the electrically conductive base. The system also includes Relational Data Base Management System that allows for in vivo EEG data collection, analysis, and diagnosis.

An "active cache", for use by On-Line Anaytic Processing (OLAP) systems, that can not only answer queries that match data stored in the cache, but can also answer queries that require aggregation or other computation of the data stored in the cache.

An On-Line Analytic Processing (OLAP) system identifies a plurality of simultaneously computable moving aggregate functions in a query. The identified moving aggregate functions are then partitioned into sets that can be computed simultaneously based on equivalent sort expressions. Finally, the OLAP system generates an access plan that executes the partitioned sets simultaneously.

A financial processing system that accesses account, event and organization attributes from a relational database management database, wherein: (1) the account attributes comprise data about accounts being measured, (2) the event attributes comprise data about account-related transactions, and (3) the organization attributes comprise data about the organization's financial status. Profitability calculations are performed in the computer using the account, event and organization attributes accessed from the relational database management system, as well as one or more profit factors and one or more rules. The profitability calculations comprise the following:Profit (ai)=Net Interest Revenue (NIR) (ai)+Other Revenue (OR) (ai)−Direct Expense (DE) (ai)−Indirect Expense (IE) (ai)−Risk Provision (RP) (ai)for an account ai. The profitability calculations include one or more amortization calculations in the computer using the account, event and organization attributes accessed from the database, and the amortization calculations amortize the Other Revenue, Direct Expense, Indirect Expense, or Risk Provision over a plurality of periods within a term for the account ai. In alternative embodiments, the amortization calculations are selected from a group comprising cash basis, straight-line, declining balance and interest methods.

A database design modeling system for managing data facets for design scenarios as a collection of hierarchical unitized data alternatives is provided. The database design model allows for easy access to data while providing a single persistant location for any one specific data record, thereby reducing any problems associated with conventional data duplication. Further, all data stored within the database is unitized thus eliminating the need for the user to do the unit mapping. According to one aspect of the present invention, a Relational Database Management System (RDBMS) modeling system can be constructed that allows for exercising multiple “What if?” scenarios with minimal user intervention and errors by 1) storing data using a normalized hierarchical storage structure, 2) providing data address indirection means to access data available from a multitude of data sources, 3) providing an object model to leverage programmable support to the orthogonal data views, and 4) providing a GIS client user interface allowing the user to construct a scenario and to view scenario results.

A method, apparatus, and article of manufacture for performing data mining applications in a relational database management system (114). Scalable Data Mining Functions (202) are performed directly against a relational database (116) by executing queries dynamically generated by an application programming interface (204) according to requested parameters.

A relational database workload manager is provided for dynamically managing processing priorities assigned to queries executing within a relational database management system (RDBMS). The workload manager monitors executing query process threads and at set time intervals reduces the processing priority assigned to each executing query. This automated method of managing relational database queries allows short executing queries within a mixed database workload to remain relatively quick without complicated setup and management.

A method, apparatus, and article of manufacture for detecting shared temporal relationships in a relational database. In accordance with the present invention, an invocation of a shares operation that specifies a first event and a second event is received. In response to the invocation, a combination of temporal relationships between the first event and the second event are evaluated to determine whether (1) the second event ends after the first event starts and the first event ends after the second event starts or (2) the first and second events start and end at the same time.

As method is disclosed for retrieving data from a relational database management system (RDBMS). An object-oriented environment submits a query to an object relational layer to access data contained in the RDBMS. The object query can result in at least one logical object description that is defined using one or more predetermined expressions. The logical object descriptions are translated to corresponding relational descriptions, and a relational query is subsequently generated. The relational query is applied to the RDBMS in order to retrieve data satisfying the object query. Various error checks can be performed to detect correctness of the query. Additionally, the relational queries can be optimized to improve processing by the RDBMS.

A method, apparatus, and article of manufacture provide the ability to define a view of data in a computer system A relational database management system (RDBMS) executes and stores the information in the computer system. As part of a process and framework, a series of business rules and process workflows are maintained to manage hierarchical data that resides in RDBMS tables. User input is accepted that defines a hierarchy that is projected onto the data. The hierarchy may be parent-child relationships with no level consistency. Alternatively, the hierarchy may have branches and levels, with each of the levels having a consistent meaning but inconsistent depths due to one level of a branch being unpopulated. The hierarchy is stored as metadata in the RDBMS and utilized to graphically visualize, manage, and manipulate the data.

A method, system, apparatus, and article of manufacture provides the ability to visualize master data management (MDM) data as part of a MDM workflow user interface (UI) in a computer system. MDM data resides in one or more tables of a relational database management system. An MDM system maintains, as part of a process and framework, a first process workflow to manage relationship data. The relationship data is data required to manage an association of one piece of MDM data to another piece of MDM data. A first process workflow provides a UI node that contains a link to a file that describes UI components to display when the first process workflow is executed. A first component of the UI component identifies an Adobe™ Flex™ based UI component. The Adobe™ Flex™ based UI component enables the representation and viewing of the MDM data in a hierarchy.

A method comprises obtaining data from a source system. Further, the obtained data is pre-processed by a stepwise operation to generate pre-processed data. The last operated upon data is recorded. In addition, the pre-processed data is transformed into subject-oriented data by utilizing reusable primary keys and Relational Database Management System dates in the source system to link related pre-processed data. Additionally, the subject-oriented data is stored in a data warehouse. The Relational Database Management System dates are utilized for distinctly characterizing the subject-oriented data when a plurality of tables containing data with duplicate primary keys are combined in the data warehouse.

A Customer Relationship Management (CRM) system accesses customer transaction data from a database managed by a Relational Database Management System (RDBMS), and then performs a pattern detection function using the customer transaction data, wherein the pattern detection function finds patterns in customer purchasing behavior, as evidenced by the customer transaction data, related to a sequence of when purchases occur. Specifically, the pattern detection function finds the patterns in the customer purchasing behavior by comparing a focal product set to an analysis product set over a specified time interval.

Scoring and detecting anomalies in a dynamic number of transaction records within a relational database management system by initiating a function for accepting and storing a transaction record in the relational database management system; This function and the analytics are integral to the RDBMS, as distinguished from extracting the data and passing the data to a separate application external to the RDBMS. The function determines if the transaction is for a different individual then a previous transaction or for the same individual. If the transaction is not for a different individual, adding the new transaction data to a memory work space and returning a NULL statement, otherwise passing the memory work space to a service. In the next step the memory workspace is accepted and an analytic model is executed to produce a score, and return the score to a calling function. This score is received at the calling function, the memory work space for the individual is released, and the score is returned to the calling statement. All of the NULL statements are collapsed and a single record is retained for the individual. This record contains the score, that is, a buying preference or pattern, a travel pattern, a calling pattern, a maintenance prediction, a risk score, or a credit score, by way of illustration.

A financial processing system that accesses account, event and organization attributes from a relational database management database, wherein: (1) the account attributes comprise data about accounts being measured, (2) the event attributes comprise data about account-related transactions, and (3) the organization attributes comprise data about the organization's financial status. Profitability calculations are performed using the account, event and organization attributes accessed from the relational database management system, as well as one or more profit factors and one or more rules. The profitability calculations include the following:Profit=Net Interest Revenue (NIR)+Other Revenue (OR)−Direct Expense (DE)−Indirect Expense (IE)−Risk Provision (RP)In this calculation, Other Revenue (OR) comprises: (1) revenue that can be associated with an account, (2) revenue that can be associated with a person, and (3) revenue that is not specifically associated with an account or person.

Methods, apparatus, and articles of manufacture for capturing commercial loan application data and assigning a commercial loan request are disclosed herein. Embodiments of the invention provide mechanisms for capturing commercial loan application data, assigning a commercial loan request, monitoring an approval process, and administering association of accounts with approved requests via a series of user interface displays communicated to a user via a network communication link. In addition, the network environment of the invention provides for the storage of data in a relational database management system that enables previously entered data to populate data fields of applets within the user interface displays without the necessity to re-enter the data. Moreover, the status of the review process may be monitored to more quickly respond to requests for such information by the customer.

An apparatus, method and computer program product for physical database design and tuning in relational database management systems. A relational database management system executes in a computer system, wherein the relational database management system manages a relational database comprised of one or more tables storing data. A Deep Reinforcement Learning based feedback loop process also executes in the computer system for recommending one or more tuning actions for the physical database design and tuning of the relational database management system, wherein the Deep Reinforcement Learning based feedback loop process uses a neural network framework to select the tuning actions based on one or more query workloads performed by the relational database management system.

A system and method for collecting, indexing, searching, accessing and downloading data over local and global computer networks. Data is reposed in a central database, indexed and interrelated by attributes characteristic of the data type. The data includes objects such as documents, queries, attribute lists and the like. The data is indexed and managed using a relational database management system (RDBMS). The central database and the RDBMS reside in a server that can be coupled to the global network through a network / user interface. Queries received by a user are converted to a format understood by the RDBMS. Objects can be returned as an image file for viewing, and can be purchased for downloading. Content to the database may be provided by individuals or proprietors of other databases, either on the network or through direct input to the server. Content to the database can also be self-generated by the RDBMS.

A financial processing system that accesses account, event and organization attributes from a relational database management database, wherein: (1) the account attributes comprise data about accounts being measured, (2) the event attributes comprise data about account-related transactions, and (3) the organization attributes comprise data about the organization's financial status. Profitability calculations are performed in the computer using the account, event and organization attributes accessed from the relational database management system, as well as one or more profit factors and one or more rules. The profitability calculations comprise the following:Profit (ai)=Net Interest Revenue (NIR) (ai)+Other Revenue (OR) (ai)−Direct Expense (DE) (ai)−Indirect Expense (IE) (ai)−Risk Provision (RP) (ai)for an account ai.Thereafter, one or more earnings calculations are performed in the computer using results from the profitability calculations and tax adjustment attributes accessed from the database. The earnings calculations comprise the following:Earnings (ai)=Profit (ai) * (1−Effective Tax Rate)for the account ai. In these earnings calculations, the Effective Tax Rate comprises the following:Effective Tax Rate=(1−tax rate2) * (tax rate1)+tax rate2The tax rate1 and tax rate2 are effective rates, wherein tax rate2 is deducted from income, and tax rate1 is not deducted from income. In one embodiment, tax rate1 is a federal income tax rate and tax rate2 is a state income tax rate.Finally, one or more total earnings calculations are performed in the computer using results from the earnings calculations. The total earnings calculations comprise the following:Total⁢⁢Earnings=∑i⁢⁢[Earnings⁢⁢(ai)]for all accounts ai.

A processor tracks a frequency of access requests of a first index corresponding to a first data page of a plurality of data pages stored in a database. The processor determines the first index corresponding to the first data page having a frequency of access requests that exceeds a configurable target, and the processor retains, with preference, the first data page that corresponds to the first index, within the cache memory.

The present invention describes a method for a secure crossover hashing process of an item's physical identity and digital identity. Three layers are involved in the method of the invention which are the physical layer (303), database layer (302) and blockchain layer (301).The digital item identity in the digital layer stores the digital item's identity (213) as a database table record in a relational database management system (217). The physical item identity is stored in a NFC or RFID tag.The invention performs multi-layer hashing of the item's physical identity and digital identity to ensure the authenticity of the item as well as its physical identity and digital identity. The invention further verified and secures the item's ownership history by an information hashing process with blockchain distributed ledger technology.

Mediums, apparatus, computer program code, and means may be provided to customize electronic records associated with a distributed communication network via an automated back-end application computer server. According to some embodiments, a relational database management system database and a plurality of database tables linked to the relational database management system database may be accessed. The back-end application computer server may retrieve electronic record layout information and utilize pre-determined logic associated with the plurality of linked tables, including logic that matches multiple pointers within a single pair of linked tables, to automatically insert accessed data into a customized electronic record in accordance with the electronic record layout information. The customized electronic record may then be transmitted to be rendered via an interactive user interface display.