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

A system and a method for copying data

一种数据、数据库的技术，应用在电数字数据处理、结构化数据检索、特殊数据处理应用等方向，能够解决减慢产品服务开发过程、用户不方便等问题

Inactive Publication Date: 2013-06-26
STANDARD LIFE EMPLOYEE SERVICES
View PDF4 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This is inconvenient for the user and considerably slows down the development process of the product service

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
  • A system and a method for copying data
  • A system and a method for copying data
  • A system and a method for copying data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0057] figure 1 is a diagram of the structure of a system according to the invention with a database. In the figure shown generally at reference numeral 1, an IBM DB2 database 3 is shown comprising a plurality of data tables denoted X1 to X3 . . . Fields for information about a person's name, address, phone number, and other items such as insurance policy numbers, financial service products, brokerage details, and more. In each data table, at least some of the fields may be indexed. As we all know, indexes make it easier to search data in large databases.

[0058] A relational database 5 includes a set of information about data tables that have been derived from a database 3 in which data tables contain relationships valid for the purpose of defining links and relationships between the data tables. In this example of the invention, the effective relationships are those that define or describe data indexing, application relationships, or referential integrity between parent ...

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

The present invention relates to a system and method for copying data between environments in an information management system such as the copying of business data between production and test environments in a database system. The system has a relations database with a set of relations created outside the runtime environment which are derived from a first database and which provide a link between database tables in the first database. The system also has a service generator which extracts and copies database tables at runtime to form a predetermined service or product. When the service generator receives a request to copy a product or service, this is done only if the data in the database tables comprising the product or service is the subject of one or more relation in the relations database.

Description

technical field [0001] The present invention relates to a system and method for replicating data between environments in an information management system, and in particular to replicating business data between a production environment and a test environment in a database system. Background technique [0002] Database systems are used in a wide variety of enterprises for the storage and manipulation of data. For example, data can relate to customers' personal information and information about various products and services they have purchased. A relational database system such as IBM DB2 UDB is used to store this type of data. [0003] A database system relies on metadata stored for the normal operation of a database instance. The database system uses this information in the form of DML (Data Manipulation Language) statements or calls to database utilities when servicing user requests. In DB2 UDB, this metadata information is stored as database tables and views called syste...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/27G06F16/254G06F16/214
Inventor 安德鲁·拉塞尔·诺森德雷克·英格利希巴里·马尔科姆·梅辛杰杰勒德·罗伯逊
Owner STANDARD LIFE EMPLOYEE SERVICES
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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