Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

System and method for maintaining large-grained database concurrency with log monitors incorporating dynamically redefinable business logic

A database and monitor technology, applied in the system field

Inactive Publication Date: 2016-02-10
ORACLE INT CORP
View PDF1 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This approach will have minimal impact on the operation of the production system and allow for autonomous operation

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • System and method for maintaining large-grained database concurrency with log monitors incorporating dynamically redefinable business logic
  • System and method for maintaining large-grained database concurrency with log monitors incorporating dynamically redefinable business logic
  • System and method for maintaining large-grained database concurrency with log monitors incorporating dynamically redefinable business logic

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] figure 1 is a block diagram showing a distributed computing environment 10 according to the present invention, including a system for maintaining large-grained database concurrency with log monitors combined with dynamically redefinable business logic. An operational data store (ODS) 11 stores production data generated by the production system 12 . Production system 12 may constitute an on-line transaction processing system to handle electronic commerce (e-commerce), reservations, point-of-sale transactions, inventory control, factory and manufacturing operations, and similar types of activities. For the sake of efficiency, the production system 12 maintains a local production database 13, which stores production data inside.

[0029] In order to maintain a high level of responsiveness and availability, the operational data store 11 is coupled to a dedicated transactional server 14 which provides a high throughput interface to the operational data store 11 . Productio...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

A system (10) and method (150) for maintaining large granularity database concurrency with a log monitor (26) incorporating dynamically redefinable business logic (94) is described. Operations expressed in a data manipulation language are performed against a source database (51). At least one operation constitutes the commit operation that completes each database transaction. A current rule set (55) is defined. Each rule contains business logic (94) that specifies data selection criteria for records held by the source database. A log entry (70) is periodically generated in the log (54) for each transaction committed to the source database (51). Each log entry (70) identifies an affected record and contains transaction data. The transactions identified by each log entry (70) are evaluated against the data selection criteria specified by the current rule set (55). A new record (57) is created based on the metadata (56) describing a target database (58). This new record (57) consists of selecting transaction data from the log entries (70) for each transaction meeting the selection criteria. The new record (57) will be stored in the destination database (58). The data held in the destination database (58) includes at least a partial subset of the source database (51).

Description

[0001] Cross References to Related Applications [0002] This patent application claims priority under 35 U.S.C. §119(e) to co-pending US patent application Serial No. 09 / 804,672, filed March 9, 2001, the contents of which are incorporated herein by reference. technical field [0003] The present invention relates generally to database object abstraction, and more particularly to a system and method for maintaining large-grained database concurrency with log monitors incorporating dynamically redefinable business logic. Background of the invention [0004] Currently, the company's database management system is divided into two categories: production and information. Production databases, including operational data stores, serve as repositories for real-time or near-real-time data that are generated or used in the operation of manufacturing, production, and transactional systems. In contrast, information databases store data periodically obtained from production databases fo...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30G06F12/00
CPCG06F16/2358G06F16/2308Y10S707/99953Y10S707/99952
Inventor 大卫·雷德
Owner ORACLE INT CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com