BR9915673A - Método e aparelho para coordenar operações em tabelas dbms - Google Patents
Método e aparelho para coordenar operações em tabelas dbmsInfo
- Publication number
- BR9915673A BR9915673A BR9915673-3A BR9915673A BR9915673A BR 9915673 A BR9915673 A BR 9915673A BR 9915673 A BR9915673 A BR 9915673A BR 9915673 A BR9915673 A BR 9915673A
- Authority
- BR
- Brazil
- Prior art keywords
- data
- unloaded
- tables
- database
- temporary
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99938—Concurrency, e.g. lock management in shared database
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99942—Manipulating data structure, e.g. compression, compaction, compilation
Abstract
"MéTODO E APARELHO PARA COORDENAR OPERAçõES EM TABELA DBMS". Tabelas de banco de dados são descarregadas lançando-se um número de encadeamentos (400) correspondente a um número de diretórios de exportação (320) localizados em dispositivos separados de armazenamento (310) que mantêm as tabelas de banco de dados. A cada encadeamento é atribuída uma tabela de banco de dados para descarregar (420). Os dados descarregados de cada tabela de banco de dados são armazenados num diretório de exportação correspondente (320). Os dados são descarregados a partir de cada tabela do banco de dados pela leitura de blocos de dados a partir de cada tabela e pelo armazenamento dos logs de dados no diretório de exportação (320). Cada encadeamento é tratado por um processo separado num ambiente de Multiprocessamento Simétrico (SMP). O processo é repetido até que cada tabela do banco de dados tenha sido descarregada. Os dados são então carregados nas tabelas de banco de dados criando primeiro um número de tabelas temporárias correspondendo ao número de encadeamentos (600), lendo um conjunto de dados armazenados no diretório de exportação (320) e armazenando os dados nas tabelas temporárias.
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US09/200,254 US6477535B1 (en) | 1998-11-25 | 1998-11-25 | Method and apparatus for concurrent DBMS table operations |
PCT/US1999/027835 WO2000031635A1 (en) | 1998-11-25 | 1999-11-24 | Method and apparatus for concurrent dbms table operations |
Publications (1)
Publication Number | Publication Date |
---|---|
BR9915673A true BR9915673A (pt) | 2002-01-02 |
Family
ID=22740953
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
BR9915673-3A BR9915673A (pt) | 1998-11-25 | 1999-11-24 | Método e aparelho para coordenar operações em tabelas dbms |
Country Status (13)
Country | Link |
---|---|
US (1) | US6477535B1 (pt) |
EP (1) | EP1147469B1 (pt) |
JP (1) | JP2002530776A (pt) |
KR (1) | KR20010103705A (pt) |
CN (1) | CN1331817A (pt) |
AT (1) | ATE529807T1 (pt) |
AU (1) | AU770289B2 (pt) |
BR (1) | BR9915673A (pt) |
CA (1) | CA2352306A1 (pt) |
HK (1) | HK1043210A1 (pt) |
IL (1) | IL143281A0 (pt) |
WO (1) | WO2000031635A1 (pt) |
ZA (1) | ZA200104265B (pt) |
Families Citing this family (42)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7805423B1 (en) | 1999-11-15 | 2010-09-28 | Quest Software, Inc. | System and method for quiescing select data modification operations against an object of a database during one or more structural operations |
US6834290B1 (en) * | 1999-11-15 | 2004-12-21 | Quest Software, Inc. | System and method for developing a cost-effective reorganization plan for data reorganization |
US7065538B2 (en) * | 2000-02-11 | 2006-06-20 | Quest Software, Inc. | System and method for reconciling transactions between a replication system and a recovered database |
US20020129146A1 (en) | 2001-02-06 | 2002-09-12 | Eyal Aronoff | Highly available database clusters that move client connections between hosts |
US7231391B2 (en) * | 2001-02-06 | 2007-06-12 | Quest Software, Inc. | Loosely coupled database clusters with client connection fail-over |
US20040162836A1 (en) * | 2001-02-06 | 2004-08-19 | Eyal Aronoff | System and method for altering database requests and database responses |
US7882103B2 (en) * | 2002-03-28 | 2011-02-01 | Teradata Us, Inc. | Using point-in-time views to provide varying levels of data freshness |
US7130969B2 (en) * | 2002-12-19 | 2006-10-31 | Intel Corporation | Hierarchical directories for cache coherency in a multiprocessor system |
US7111128B2 (en) * | 2002-12-19 | 2006-09-19 | Intel Corporation | Hierarchical virtual model of a cache hierarchy in a multiprocessor system |
US7917646B2 (en) * | 2002-12-19 | 2011-03-29 | Intel Corporation | Speculative distributed conflict resolution for a cache coherency protocol |
US7269595B1 (en) * | 2003-03-19 | 2007-09-11 | Unisys Corporation | Reducing database reorganization time |
US20050010595A1 (en) * | 2003-07-11 | 2005-01-13 | International Business Machines Corporation | System and method for automating an identification mechanism and type information configuration process for a real-time data feed to a database |
US7925665B2 (en) * | 2004-03-08 | 2011-04-12 | Siebel Systems, Inc. | Using query persistence for efficient subquery evaluation in federated databases |
US7822929B2 (en) * | 2004-04-27 | 2010-10-26 | Intel Corporation | Two-hop cache coherency protocol |
US20050240734A1 (en) * | 2004-04-27 | 2005-10-27 | Batson Brannon J | Cache coherence protocol |
US20050262250A1 (en) * | 2004-04-27 | 2005-11-24 | Batson Brannon J | Messaging protocol |
US7395381B2 (en) * | 2005-03-18 | 2008-07-01 | Intel Corporation | Method and an apparatus to reduce network utilization in a multiprocessor system |
US7958513B2 (en) * | 2005-11-17 | 2011-06-07 | International Business Machines Corporation | Method, system and program product for communicating among processes in a symmetric multi-processing cluster environment |
US7814045B2 (en) * | 2006-10-04 | 2010-10-12 | Sap Ag | Semantical partitioning of data |
US7747578B2 (en) * | 2007-03-09 | 2010-06-29 | Microsoft Corporation | Reducing database fragmentation |
US7860833B1 (en) * | 2007-11-28 | 2010-12-28 | Teradata Us, Inc. | Deriving session level statistics for temporary tables |
US8135930B1 (en) | 2008-07-14 | 2012-03-13 | Vizioncore, Inc. | Replication systems and methods for a virtual computing environment |
US8060476B1 (en) | 2008-07-14 | 2011-11-15 | Quest Software, Inc. | Backup systems and methods for a virtual computing environment |
US8046550B2 (en) | 2008-07-14 | 2011-10-25 | Quest Software, Inc. | Systems and methods for performing backup operations of virtual machine files |
US8429649B1 (en) | 2008-09-25 | 2013-04-23 | Quest Software, Inc. | Systems and methods for data management in a virtual computing environment |
US8996468B1 (en) | 2009-04-17 | 2015-03-31 | Dell Software Inc. | Block status mapping system for reducing virtual machine backup storage |
US9778946B2 (en) | 2009-08-07 | 2017-10-03 | Dell Software Inc. | Optimized copy of virtual machine storage files |
CN101739447B (zh) * | 2009-11-16 | 2012-11-28 | 金蝶软件(中国)有限公司 | 一种对临时表的管理方法及装置 |
US8453145B1 (en) | 2010-05-06 | 2013-05-28 | Quest Software, Inc. | Systems and methods for instant provisioning of virtual machine files |
US9569446B1 (en) | 2010-06-08 | 2017-02-14 | Dell Software Inc. | Cataloging system for image-based backup |
US9547562B1 (en) | 2010-08-11 | 2017-01-17 | Dell Software Inc. | Boot restore system for rapidly restoring virtual machine backups |
US8898114B1 (en) | 2010-08-27 | 2014-11-25 | Dell Software Inc. | Multitier deduplication systems and methods |
US9311375B1 (en) | 2012-02-07 | 2016-04-12 | Dell Software Inc. | Systems and methods for compacting a virtual machine file |
US9323812B2 (en) | 2013-04-11 | 2016-04-26 | Oracle International Corporation | Hybrid bifurcation of intersection nodes |
CN104700255B (zh) * | 2013-12-06 | 2020-04-10 | 腾讯科技(北京)有限公司 | 多进程处理方法、装置和系统 |
US20150227586A1 (en) * | 2014-02-07 | 2015-08-13 | Futurewei Technologies, Inc. | Methods and Systems for Dynamically Allocating Resources and Tasks Among Database Work Agents in an SMP Environment |
CN104376082B (zh) * | 2014-11-18 | 2019-06-18 | 中国建设银行股份有限公司 | 一种把数据源文件中的数据导入到数据库中的方法 |
US10095721B2 (en) * | 2015-03-27 | 2018-10-09 | International Business Machines Corporation | Index building in response to data input |
CN104793969B (zh) * | 2015-03-27 | 2018-10-19 | 小米科技有限责任公司 | 应用程序卸载方法及装置 |
US10353885B2 (en) | 2016-07-29 | 2019-07-16 | International Business Machines Corporation | Storing data records |
CN107357885B (zh) * | 2017-06-30 | 2020-11-20 | 北京奇虎科技有限公司 | 数据写入方法及装置、电子设备、计算机存储介质 |
CN108228893A (zh) * | 2018-02-05 | 2018-06-29 | 广州中元软件有限公司 | 一种关系数据库数据持久化优化和排队方法 |
Family Cites Families (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5093782A (en) * | 1987-12-14 | 1992-03-03 | Texas Instruments Incorporated | Real time event driven database management system |
US5517641A (en) * | 1992-05-27 | 1996-05-14 | Cdb Software, Inc. | Restartable method to reorganize DB2 tablespace records by determining new physical positions for the records prior to moving using a non sorting technic |
US5437032A (en) * | 1993-11-04 | 1995-07-25 | International Business Machines Corporation | Task scheduler for a miltiprocessor system |
US5668993A (en) * | 1994-02-28 | 1997-09-16 | Teleflex Information Systems, Inc. | Multithreaded batch processing system |
US5687372A (en) * | 1995-06-07 | 1997-11-11 | Tandem Computers, Inc. | Customer information control system and method in a loosely coupled parallel processing environment |
US5754771A (en) * | 1996-02-12 | 1998-05-19 | Sybase, Inc. | Maximum receive capacity specifying query processing client/server system replying up to the capacity and sending the remainder upon subsequent request |
US5860070A (en) * | 1996-05-31 | 1999-01-12 | Oracle Corporation | Method and apparatus of enforcing uniqueness of a key value for a row in a data table |
US5884310A (en) * | 1996-06-14 | 1999-03-16 | Electronic Data Systems Corporation | Distributed data integration method and system |
US5761667A (en) * | 1996-08-07 | 1998-06-02 | Bmc Software, Inc. | Method of optimizing database organization using sequential unload/load operations |
US5694602A (en) * | 1996-10-01 | 1997-12-02 | The United States Of America As Represented By The Secretary Of The Air Force | Weighted system and method for spatial allocation of a parallel load |
US5873091A (en) * | 1997-04-28 | 1999-02-16 | International Business Machines Corporation | System for data structure loading with concurrent statistical analysis |
US6122640A (en) * | 1998-09-22 | 2000-09-19 | Platinum Technology Ip, Inc. | Method and apparatus for reorganizing an active DBMS table |
-
1998
- 1998-11-25 US US09/200,254 patent/US6477535B1/en not_active Expired - Lifetime
-
1999
- 1999-11-24 BR BR9915673-3A patent/BR9915673A/pt not_active IP Right Cessation
- 1999-11-24 IL IL14328199A patent/IL143281A0/xx unknown
- 1999-11-24 CA CA002352306A patent/CA2352306A1/en not_active Abandoned
- 1999-11-24 JP JP2000584387A patent/JP2002530776A/ja active Pending
- 1999-11-24 AU AU18297/00A patent/AU770289B2/en not_active Ceased
- 1999-11-24 EP EP99961787A patent/EP1147469B1/en not_active Expired - Lifetime
- 1999-11-24 WO PCT/US1999/027835 patent/WO2000031635A1/en not_active Application Discontinuation
- 1999-11-24 AT AT99961787T patent/ATE529807T1/de not_active IP Right Cessation
- 1999-11-24 KR KR1020017006581A patent/KR20010103705A/ko not_active Application Discontinuation
- 1999-11-24 CN CN99814739A patent/CN1331817A/zh active Pending
-
2001
- 2001-05-24 ZA ZA200104265A patent/ZA200104265B/en unknown
-
2002
- 2002-04-12 HK HK02102793.3A patent/HK1043210A1/zh unknown
Also Published As
Publication number | Publication date |
---|---|
WO2000031635A1 (en) | 2000-06-02 |
ZA200104265B (en) | 2002-05-24 |
US6477535B1 (en) | 2002-11-05 |
IL143281A0 (en) | 2002-04-21 |
AU1829700A (en) | 2000-06-13 |
EP1147469A4 (en) | 2003-06-18 |
AU770289B2 (en) | 2004-02-19 |
CN1331817A (zh) | 2002-01-16 |
ATE529807T1 (de) | 2011-11-15 |
EP1147469B1 (en) | 2011-10-19 |
EP1147469A1 (en) | 2001-10-24 |
HK1043210A1 (zh) | 2002-09-06 |
KR20010103705A (ko) | 2001-11-23 |
CA2352306A1 (en) | 2000-06-02 |
JP2002530776A (ja) | 2002-09-17 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
BR9915673A (pt) | Método e aparelho para coordenar operações em tabelas dbms | |
US6115721A (en) | System and method for database save and restore using self-pointers | |
WO2004034215A3 (en) | System for processing and organizing pharmacy data | |
DE69403192T2 (de) | Vorrichtung und verfahren zur datensicherung von speichereinheiten in einem rechnernetzwerk | |
DE69720181D1 (de) | System und verfahren zum laden von mehrfachen anwendungen in eine chipkarte | |
DE69804108D1 (de) | Zweischritt-befehlspuffer für speicheranordnung und verfahren und speicheranordnung und rechnersystem unter verwendung desselben | |
ATE450009T1 (de) | Verfahren und gerät zum reorganisieren einer aktiven dbms-tabelle | |
RU97111812A (ru) | Способ обращения к данным, хранимым в компьютерной системе, способ архивирования данных и компьютерная система для осуществления способов | |
CA2111958A1 (en) | Method and apparatus for modifying relocatable object code files and monitoring programs | |
JPS6470839A (en) | File sequence access method and apparatus | |
KR890016469A (ko) | 업무처치 처리 시스템내의 인텍스트리의 동시 변형용 방법 및 장치 | |
KR970062862A (ko) | 저 전력 소비 컴퓨터 및 그의 애플리케이션 프로그램 실행 방법 | |
EP0377436A3 (en) | Apparatus and method for increased operand availability in a data processing unit with a store through cache memory unit strategy | |
HK1062947A1 (en) | Hash technique eliminating pointer storage to reduce ram size | |
DE58900464D1 (de) | Anlage und verfahren fuer die periodische be- und entladung eines gasspeichers. | |
US7016911B2 (en) | Management of user-defined routine libraries in database environments | |
Ahuja et al. | An associative/parallel processor for partial match retrieval using superimposed codes | |
ATE154988T1 (de) | Verfahren zur verlängerung der benutzungsdauer von informationsträgern mit eeprom | |
Shrivastava et al. | Fault-tolerant sequential programming using recovery blocks | |
CN107918668A (zh) | 一种k‑db数据库表空间元数据本地存储方法 | |
DE502004006212D1 (de) | Verfahren zur bearbeitung von cdr-informationen | |
JPS6423377A (en) | Control method for picture data | |
Halpern | Variable-width tables with binary-search facility | |
JPS6410363A (en) | Data recovery system for storage device | |
JPH02281319A (ja) | 記憶サブシステム |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
B08F | Application dismissed because of non-payment of annual fees [chapter 8.6 patent gazette] |
Free format text: REFERENTE AO NAO RECOLHIMENTO DA 8A E 9A ANUIDADE(S). |
|
B08K | Patent lapsed as no evidence of payment of the annual fee has been furnished to inpi [chapter 8.11 patent gazette] |
Free format text: REFERENTE AO DESPACHO 8.6 DE RPI 1999 DE 28/04/2009. |