JP2003076593A5 - - Google Patents

Download PDF

Info

Publication number
JP2003076593A5
JP2003076593A5 JP2002168035A JP2002168035A JP2003076593A5 JP 2003076593 A5 JP2003076593 A5 JP 2003076593A5 JP 2002168035 A JP2002168035 A JP 2002168035A JP 2002168035 A JP2002168035 A JP 2002168035A JP 2003076593 A5 JP2003076593 A5 JP 2003076593A5
Authority
JP
Japan
Prior art keywords
storage area
database
processing
stored
storing
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
JP2002168035A
Other languages
Japanese (ja)
Other versions
JP2003076593A (en
Filing date
Publication date
Application filed filed Critical
Priority to JP2002168035A priority Critical patent/JP2003076593A/en
Priority claimed from JP2002168035A external-priority patent/JP2003076593A/en
Publication of JP2003076593A publication Critical patent/JP2003076593A/en
Publication of JP2003076593A5 publication Critical patent/JP2003076593A5/ja
Pending legal-status Critical Current

Links

Claims (11)

第１の記憶領域、第２の記憶領域および第３の記憶領域を有するデータベース管理システムにおけるデータベース管理方法において、
第１のプログラムの実行による処理要求を入力し、該処理要求に基づいたデータベース処理を行い、該データベース処理の処理結果に基づいたデータをデータベースとして第１の記憶領域に記憶し、
所定条件を満たしたとき、第１の記憶領域に記憶されているデータベースを第２の記憶領域に記憶し、
前記第２の記憶領域に格納したデータベースを入力として処理を行う第２のプログラムを実行し、該処理の更新データを第３の記憶領域に記憶した後、前記第２のプログラムは前記第３の記憶領域のデータを参照あるいは更新して処理を行うことを特徴とするデータベース管理方法。In a database management method in a database management system having a first storage area, a second storage area, and a third storage area,
A processing request by executing the first program is input, a database processing is performed based on the processing request, and data based on a processing result of the database processing is stored in the first storage area as a database,
When a predetermined condition is satisfied, the database stored in the first storage area is stored in the second storage area,
After executing a second program for performing a process using the database stored in the second storage area as an input and storing update data of the process in a third storage area, the second program executes the third program. A database management method characterized by performing processing by referring to or updating data in a storage area . 前記所定条件は所定時刻であり、該所定時刻における第１のデータベースを第２の記憶領域に記憶することを特徴とする請求項１記載のデータベース管理方法。2. The database management method according to claim 1, wherein the predetermined condition is a predetermined time, and the first database at the predetermined time is stored in a second storage area. 前記所定条件は所定要求の入力であり、該所定要求が発行された時刻における第１のデータベースを第２の記憶領域に記憶することを特徴とする請求項１記載のデータベース管理方法。2. The database management method according to claim 1, wherein the predetermined condition is an input of a predetermined request, and the first database at a time when the predetermined request is issued is stored in a second storage area. 複数の時刻における第１の記憶領域に格納されたデータベースを格納する領域を前記第２の記憶領域にそれぞれ割り付けて記憶し、該複数の領域に対応する前記第２のプログラムをそれぞれ実行し、該第２のプログラムの処理による更新データを第３の記憶領域の領域にそれぞれ割り付けて記憶することを特徴とする請
求項１記載のデータベースデータベース管理方法。Areas for storing databases stored in the first storage area at a plurality of times are respectively allocated to and stored in the second storage area, and the second programs corresponding to the plurality of areas are respectively executed. 2. The database management method according to claim 1, wherein the update data obtained by the processing of the second program is allocated to each of the third storage areas and stored. 一つの第２の記憶領域に記憶されたデータベースを入力とする複数の前記第２のプログラムの処理による更新データを格納する領域を前記第２のプログラムに対応付けて第３の記憶領域に割り付けて記憶することを特徴とする請求項１記載のデータベース管理方法。An area for storing update data obtained by processing a plurality of the second programs having a database stored in one second storage area as an input is allocated to a third storage area in association with the second program. 2. The database management method according to claim 1, wherein the database is stored. 第１の記憶領域、第２の記憶領域および第３の記憶領域を有するデータベース管理システムにおいて、
第１のプログラムの実行による処理要求を入力し、該処理要求に基づいたデータベース処理を行い、該データベース処理の処理結果に基づいたデータをデータベースとして第１の記憶領域に記憶する手段と、
所定条件を満たしたとき、第１の記憶領域に記憶されているデータベースを第２の記憶領域に記憶する手段と、
前記第２の記憶領域に格納したデータベースを入力として処理を行う第２のプログラムを実行し、該処理の更新データを第３の記憶領域に記憶した後、前記第２のプログラムは前記第３の記憶領域のデータを参照あるいは更新して処理を行う手段とを備えたことを特徴とするデータベース管理システム。In a database management system having a first storage area, a second storage area, and a third storage area,
Means for inputting a processing request by executing the first program, performing database processing based on the processing request, and storing data based on a processing result of the database processing as a database in a first storage area;
Means for storing a database stored in the first storage area in the second storage area when a predetermined condition is satisfied;
After executing a second program for performing a process using the database stored in the second storage area as an input and storing update data of the process in a third storage area, the second program executes the third program. Means for performing processing by referring to or updating data in a storage area . 前記所定条件は所定時刻であり、前記第２の記憶領域に記憶する手段は該所定時刻における第１のデータベースを第２の記憶領域に記憶することを特徴とする請求項６記載のデータベース管理システム。7. The database management system according to claim 6, wherein the predetermined condition is a predetermined time, and the means for storing in the second storage area stores the first database at the predetermined time in the second storage area. . 前記所定条件は所定要求の入力であり、前記第２の記憶領域に記憶する手段は該所定要求が発行された時刻における第１のデータベースを第２の記憶領域に記憶することを特徴とする請求項６記載のデータベース管理システム。The said predetermined condition is an input of a predetermined request, and the means for storing in the second storage area stores the first database at the time when the predetermined request is issued in the second storage area. Item 6. The database management system according to Item 6. 複数の時刻における第１の記憶領域に格納されたデータベースを格納する領域を前記第２の記憶領域にそれぞれ割り付けて記憶する手段と、該複数の領域に対応する前記第２のプログラムをそれぞれ実行し、該第２のプログラムの処理による更新データを第３の記憶領域の領域にそれぞれ割り付けて記憶する手段とをことを特徴とする請求項６記載のデータベースデータベース管理システム。Means for allocating an area for storing a database stored in the first storage area at a plurality of times to the second storage area, and executing the second program corresponding to the plurality of areas, respectively; 7. The database management system according to claim 6, further comprising: means for allocating and storing update data obtained by the processing of the second program in a third storage area. 前記第３の記憶領域に記憶する手段は、一つの第２の記憶領域に記憶されたデータベースを入力とする複数の前記第２のプログラムの処理による更新データを格納する領域を前記第２のプログラムに対応付けて第３の記憶領域に割り付けて記憶することを特徴とする請求項６記載のデータベース管理システム。The means for storing in the third storage area stores an area for storing update data obtained by processing a plurality of the second programs that receive a database stored in one second storage area as an input. 7. The database management system according to claim 6 , wherein the data is allocated to a third storage area and stored. 第１の記憶領域および第２の記憶領域を有するデータベース管理システムにおいて、
第１のプログラムの実行による処理要求を入力し、該処理要求に基づいたデータベース処理を行い、該データベース処理の処理結果に基づいたデータをデータベースとして第１の記憶領域に記憶する手段と、
前記データベース処理における所定時刻における第１の記憶領域に記憶されているデータベースを第２の記憶領域に記憶する手段とを備えたことを特徴とするデータベース管理システム。In a database management system having a first storage area and a second storage area,
Means for inputting a processing request by executing the first program, performing database processing based on the processing request, and storing data based on a processing result of the database processing as a database in a first storage area;
Means for storing a database stored in the first storage area at a predetermined time in the database processing in the second storage area.
JP2002168035A 2002-06-10 2002-06-10 Database management method and system Pending JP2003076593A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2002168035A JP2003076593A (en) 2002-06-10 2002-06-10 Database management method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
JP2002168035A JP2003076593A (en) 2002-06-10 2002-06-10 Database management method and system

Related Parent Applications (1)

Application Number Title Priority Date Filing Date
JP30137496A Division JP3497053B2 (en) 1996-11-13 1996-11-13 Processing method in online database management system and online database management system

Related Child Applications (1)

Application Number Title Priority Date Filing Date
JP2007158157A Division JP2007242061A (en) 2007-06-15 2007-06-15 Data processing method and device

Publications (2)

Publication Number Publication Date
JP2003076593A JP2003076593A (en) 2003-03-14
JP2003076593A5 true JP2003076593A5 (en) 2004-10-28

Family

ID=19195076

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2002168035A Pending JP2003076593A (en) 2002-06-10 2002-06-10 Database management method and system

Country Status (1)

Country Link
JP (1) JP2003076593A (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2016117007A1 (en) * 2015-01-19 2016-07-28 株式会社日立製作所 Database system and database management method

Similar Documents

Publication Publication Date Title
CN107239335B (en) Job scheduling system and method for distributed system
US20190377737A1 (en) Incremental and collocated redistribution for expansion of online shared nothing database
JP2017530469A5 (en)
CN110457397A (en) A kind of method and device that data are synchronous
CN102844754B (en) For the system and method for the outer connection to parallel database management system
CN101329676B (en) Data paralleling abstracting method and apparatus and database system
WO2016069818A1 (en) Efficient maintenance of column store indexes on memory-optimized tables
US20150188989A1 (en) Seamless cluster servicing
US20160239544A1 (en) Collaborative planning for accelerating analytic queries
JP6123028B2 (en) System and method for tuning multi-store systems and accelerating big data query workloads
CN105956666B (en) A kind of machine learning method and system
EP2901344A1 (en) System and method for flexible distributed massively parallel processing (mpp) database
CN107526733A (en) A kind of slide fastener table date storage method and device
CN105243167A (en) Data processing method and device
JP2008508577A5 (en)
CN107870949A (en) Data analysis job dependence relation generation method and system
US20140129531A1 (en) Automatic Entity-Grouping for Scalable OLTP
US7752399B2 (en) Exclusion control method and information processing apparatus
US20060143206A1 (en) Interval tree for identifying intervals that intersect with a query interval
Allmaier et al. Parallel graph generation algorithms for shared and distributed memory machines
CN104376055B (en) A kind of large-sized model data comparing method based on allocation methods
JP2003076593A5 (en)
CN110532311A (en) A kind of distributed data deriving method and system based on queue
CN110069243A (en) A kind of java program threads optimization method
EP3951609A1 (en) Query optimization method and apparatus