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

Universal constraining realizing method for real-time internal memory database

An implementation method and real-time memory technology, applied in special data processing applications, electrical digital data processing, instruments, etc., can solve the problems of complex constraint relations, bloated software codes, high error rate, etc., achieve universality, shorten development cycle, The effect of code error rate reduction

Active Publication Date: 2008-06-04
SHANGHAI MUNICIPAL ELECTRIC POWER CO
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In this way, the constraints between tables and the constraints within the tables will be very complicated. If each table is implemented with independent constraints, the software code will be very bloated, the error rate will be high, and the reusability will be poor.

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
  • Universal constraining realizing method for real-time internal memory database
  • Universal constraining realizing method for real-time internal memory database
  • Universal constraining realizing method for real-time internal memory database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] The general constraint processing of the real-time in-memory database in this embodiment includes creation of constraints and constraint checking.

[0027] Constraints are created after the tables and indexes are successfully created, including the creation of outer join constraints and check constraints. When creating an out-of-line constraint, since the out-of-line constraint involves both the child table and the parent table, the method adopted is to create the constraint information of the child table and the parent table at the same time, so as to improve the constraint creation speed.

[0028] When creating external constraints, this embodiment provides the following specification interfaces, that is, instruction codes, for developers to call.

[0029] DbsCreateConstraint(ChildTableName, ParentTableName, field1, field2, ...)

[0030] Among them, ChildTableName, ParentTableName are the names of the child table and the parent table respectively, field 1, field 2, ....

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 method for realizing universal restraint includes inputting and creating standard command of external restraint and checking restraint, inspecting them and then storing created restraint data in memory after memory databank table set up, carrying out operation as if all restraints are satisfied when insertion or refreshing record operation is required on some table, refusing operation as if any external restraint is not satisfied when record deletion operation is required on some table.

Description

technical field [0001] The present invention relates to a real-time memory database system, and more particularly, to a method for ensuring constraint processing in a database in the system. Background technique [0002] Real-time memory database technology has been widely used in communication, control and other fields. Generally, the reading time of disk to data is on the order of 10 -3 seconds, while the read time to memory is 10 -8 second. The real-time in-memory database is characterized by operating all data objects in memory, and the relationship between data objects is also reflected in memory operations, which greatly improves the performance of the system. [0003] The constraint attribute is one of the important attributes of the table, that is, when the record operation of the table is performed, the legality of the operation should be checked as needed. A mature database system that expresses and handles constraint properties generically and simply is necess...

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/30
Inventor 凌晨陈暤冯卫东杨炼
Owner SHANGHAI MUNICIPAL ELECTRIC POWER CO
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