Project

General

Profile

Feature #1651

add support for dynamic database features

Added by Eric Faulhaber over 11 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Start date:
04/02/2013
Due date:
07/16/2013
% Done:

100%

Estimated time:
(Total: 600.00 h)
billable:
No
vendor_id:
GCD

Subtasks

Feature #1652: add conversion and runtime support for dynamically prepared temp-tablesClosed

Feature #1955: add conversion support for CREATE-TEMP-TABLE statementClosedOvidiu Maxiniuc

Feature #2122: add runtime support for dynamically prepared temp-tablesClosedStanislav Lomany

Feature #2128: generate and load DMO interface and implementation classes for dynamic temp-tables at runtimeClosedStanislav Lomany

Feature #1653: add conversion and runtime support for dynamically prepared queriesClosed

Feature #1954: add conversion support for CREATE QUERY statementClosedOvidiu Maxiniuc

Feature #2120: add runtime support for dynamically prepared queriesClosedConstantin Asofiei

Feature #2127: complete runtime support for dynamically prepared queriesClosedConstantin Asofiei

Feature #1654: add conversion and runtime support for dynamic buffer creation and cleanupClosedStanislav Lomany

Feature #1953: add conversion support for CREATE BUFFER statementClosedOvidiu Maxiniuc

Feature #2125: add runtime support for dynamic buffer creation and cleanupClosedStanislav Lomany

Feature #1655: add conversion and runtime support for certain dynamic database attributes and methodsClosedOvidiu Maxiniuc


Related issues

Related to Database - Feature #2235: fix deployment issues related to dynamic database conversion resources Closed

History

#1 Updated by Eric Faulhaber over 11 years ago

Requires binary TRPL as a pre-requisite, since conversion will have to occur at runtime, on the fly.

#2 Updated by Greg Shah over 11 years ago

  • Target version set to Milestone 7

#3 Updated by Eric Faulhaber over 11 years ago

We need to determine whether dynamic database features are scope-agnostic in terms of resolving database references; i.e., do we need to keep track of which buffer names should be promoted based on the sequence of open buffer scopes at the time a dynamic feature is invoked? This is done by the SchemaDictionary at conversion time for static buffer references, to enable disambiguation of buffer name references. Are dynamic database features also aware of this scoping? We will need test cases.

If we do find we need to account for buffer name promotion at runtime, note that all per-context buffer scope information is maintained by the BufferManager, so we could get it from there on demand, if necessary (with some changes to that class).

#4 Updated by Eric Faulhaber over 10 years ago

Note that any use of conversion features at runtime will require the use of existing or new conversion rule-sets and configuration information. Since we don't expect the entire conversion project to be available on a runtime installation, any such resources will need to be added to either the p2j.jar or, if customer-specific, to an application jar file. This is not critical for an early working version, but it should not be precluded by our design and implementation.

#5 Updated by Greg Shah over 10 years ago

To clarify:

  1. We are not going to use a binary implementation of TRPL for our first implementation.
  2. We don't want to require the entire conversion process to be used, when we only need to convert small snippets of code/expressions.
  3. The progress.g already has the expr rule that is a valid entry point for use in parsing a single expression.
  4. Re-use the TRPL conversion rulesets as much as is possible.
  5. Make ruleset changes as needed to allow common rulesets to differentially process depending on whether used in the full process or the dynamic database processing at runtime.
  6. I expect that some custom rulesets will be needed to manage the overall dynamic database runtime conversion process. I just want those to reuse as much of the common code as is reasonably possible.
  7. Long term, we want the standard rules to be loaded from the p2j.jar instead of from the file system.
  8. Long term, we want the customer-specific rules and the customer-specific project configuration (e.g. p2j.cfg.xml) to be loaded from the customer's application jar.

#6 Updated by Eric Faulhaber about 10 years ago

  • Status changed from New to Closed

#7 Updated by Greg Shah over 7 years ago

  • Target version changed from Milestone 7 to Runtime Support for Server Features

Also available in: Atom PDF