CA2249066C - Partage d'enonces sql dynamiques dans un environnement d'application heterogene - Google Patents
Partage d'enonces sql dynamiques dans un environnement d'application heterogene Download PDFInfo
- Publication number
- CA2249066C CA2249066C CA002249066A CA2249066A CA2249066C CA 2249066 C CA2249066 C CA 2249066C CA 002249066 A CA002249066 A CA 002249066A CA 2249066 A CA2249066 A CA 2249066A CA 2249066 C CA2249066 C CA 2249066C
- Authority
- CA
- Canada
- Prior art keywords
- sql
- statement
- cache
- section
- dynamic
- 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.)
- Expired - Fee Related
Links
- 230000003068 static effect Effects 0.000 claims abstract description 59
- 238000000034 method Methods 0.000 claims abstract description 18
- 230000015654 memory Effects 0.000 claims description 15
- 230000001419 dependent effect Effects 0.000 claims description 6
- 238000004590 computer program Methods 0.000 claims 1
- 239000003795 chemical substances by application Substances 0.000 description 36
- 230000006870 function Effects 0.000 description 22
- 238000010586 diagram Methods 0.000 description 7
- 238000005192 partition Methods 0.000 description 6
- 238000012545 processing Methods 0.000 description 6
- 230000009471 action Effects 0.000 description 5
- 230000000694 effects Effects 0.000 description 5
- 239000000872 buffer Substances 0.000 description 4
- 230000006399 behavior Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 238000001514 detection method Methods 0.000 description 2
- 230000009467 reduction Effects 0.000 description 2
- 230000002411 adverse Effects 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 238000013475 authorization Methods 0.000 description 1
- 230000000903 blocking effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000008030 elimination Effects 0.000 description 1
- 238000003379 elimination reaction Methods 0.000 description 1
- 239000000796 flavoring agent Substances 0.000 description 1
- 235000019634 flavors Nutrition 0.000 description 1
- 230000008570 general process Effects 0.000 description 1
- 230000003116 impacting effect Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 238000002955 isolation Methods 0.000 description 1
- COCAUCFPFHUGAA-MGNBDDOMSA-N n-[3-[(1s,7s)-5-amino-4-thia-6-azabicyclo[5.1.0]oct-5-en-7-yl]-4-fluorophenyl]-5-chloropyridine-2-carboxamide Chemical compound C=1C=C(F)C([C@@]23N=C(SCC[C@@H]2C3)N)=CC=1NC(=O)C1=CC=C(Cl)C=N1 COCAUCFPFHUGAA-MGNBDDOMSA-N 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 230000003936 working memory Effects 0.000 description 1
Classifications
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2452—Query translation
- G06F16/24524—Access plan code generation and invalidation; Reuse of access plans
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CA002249066A CA2249066C (fr) | 1998-09-29 | 1998-09-29 | Partage d'enonces sql dynamiques dans un environnement d'application heterogene |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CA002249066A CA2249066C (fr) | 1998-09-29 | 1998-09-29 | Partage d'enonces sql dynamiques dans un environnement d'application heterogene |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CA2249066A1 CA2249066A1 (fr) | 2000-03-29 |
| CA2249066C true CA2249066C (fr) | 2001-12-04 |
Family
ID=4162864
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA002249066A Expired - Fee Related CA2249066C (fr) | 1998-09-29 | 1998-09-29 | Partage d'enonces sql dynamiques dans un environnement d'application heterogene |
Country Status (1)
| Country | Link |
|---|---|
| CA (1) | CA2249066C (fr) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111797112B (zh) * | 2020-06-05 | 2022-04-01 | 武汉大学 | 一种PostgreSQL预备语句执行优化方法 |
-
1998
- 1998-09-29 CA CA002249066A patent/CA2249066C/fr not_active Expired - Fee Related
Also Published As
| Publication number | Publication date |
|---|---|
| CA2249066A1 (fr) | 2000-03-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6321235B1 (en) | Global caching and sharing of SQL statements in a heterogeneous application environment | |
| US10803047B2 (en) | Accessing data entities | |
| US6598058B2 (en) | Method and apparatus for cross-node sharing of cached dynamic SQL in a multiple relational database management system environment | |
| US6353833B1 (en) | Caching of distributed dynamic SQL statements in a multiple node RDBMS | |
| US5625815A (en) | Relational database system and method with high data availability during table data restructuring | |
| US5897634A (en) | Optimized caching of SQL data in an object server system | |
| US5758144A (en) | Database execution cost and system performance estimator | |
| US7577658B2 (en) | Hierarchical locking in B-tree indexes | |
| US6952692B1 (en) | Execution of requests in a parallel database system | |
| US7457796B2 (en) | Method using virtual replicated tables in a cluster database management system | |
| US7818297B2 (en) | System and method for refreshing a table using epochs | |
| Degenaro et al. | A middleware system which intelligently caches query results | |
| Borr | High performance SQL through low-level system integration | |
| Graefe | Hierarchical locking in B-tree indexes | |
| CA2249066C (fr) | Partage d'enonces sql dynamiques dans un environnement d'application heterogene | |
| US6615214B1 (en) | Accommodation of data definition statements in the sharing of dynamic SQL statements | |
| KR100507782B1 (ko) | 데이터베이스 관리시스템 및 그 시스템에서 시스템테이블에 대한 동시성 제어 방법 | |
| EP0100821A2 (fr) | Méthode et appareil de gestion de base de données | |
| CA2249059C (fr) | Mise en antememoire d'enonces sql dynamiques repartis dans un sgbdr a noeuds multiples | |
| CA2282999C (fr) | Methode et appareil permettant le partage en n uds croises de la dynamique en antememoire du langage sql dans un systeme de gestion de bases de donnees a relations multiples | |
| Zhou et al. | GTX: A Write-Optimized Latch-free Graph Data System with Transactional Support | |
| Basu et al. | Performance analysis of an associative caching scheme for client-server databases | |
| Cai et al. | Concurrency Control and Recovery in OLTP Systems: High Scalability and Availability | |
| Hong | Performance of Catalog Management Schemes for Running Access Modules in a Locally Distributed Database System. | |
| Thomasian et al. | Distributed Databases |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| EEER | Examination request | ||
| MKLA | Lapsed | ||
| MKLA | Lapsed |
Effective date: 20100929 |