|
This project provides a hierarchical model of the structure of a database. Documentation is available in the Javadoc.
Question (arch-overall): Describe the overall architecture. Answer: DatabaseModelAPI -The Database Model API provides a hierarchical model of the structure of a database. The tree contains elements such as schemas, tables, columns, keys or indexes. A model can either be read from a live connection or built up from scratch.
The model construction is based on a model provider, which provides the elements which make up the model (e.g., the schema names, or the names of the tables in a schema). There will be a SPI for model providers, and there can be various model providers for different database servers. The API client will be able to specify which provider will be used when building a model.
Models can be serialized and deserialized to/from an XML file.
DDL commands which create the database described by a model can be generated for various database systems. A SPI will be provided for DDL generators.
The service providers will be registered as J2SE Service Providers.
Question (arch-usecases): Describe the main use cases of the new API. Who will use it under what circumstances? What kind of code would typically need to be written to use the module? Answer:Database-enabled applications need to display the structure of a database. An example could be the Database Explorer. The next version of the Database Explorer will be based on the Model API.
Another example are database diagrams, which are a 2-D view of the structure of a database. The model serves as a data source for the diagram. Diagrams can be created from scratch, which corresponds to the ability to create models from scratch.
A SQL editor can benefit from the Model API too, as it can use it to retrieve the list of database elements displayed in the code completion.
A client of this API will typically pass a java.sql.Connection instance to a factory method and receive an instance of the Model class. The Model.getSchema() method can be called to retrieve the schemas, the Model.getTables() method will return the list of tables in a schema, and so on.
Question (arch-time): What are the time estimates of the work? Answer:A big part of the model itself and the XML serialization is already implemented. About two months of work for an engineer remain to implments the planned functionality. The milestone by which this API should be stable is promo-G.
Question (arch-quality): How will the quality of your code be tested and how are future regressions going to be prevented? Answer:All Javadoc-specified functionality should be covered by unit tests.
Question (arch-where): Where one can find sources for your module? Answer:This API should be as independent of NetBeans as possible. Currently there are not dependencies on any NetBeans modules. In the future a dependency on org.openide.util will be considered (the default lookup will be used for retrieving the registered service providers).
Question (dep-non-nb): What other projects outside NetBeans does this one depend on? Answer:None.
Question (dep-platform): On which platforms does your module run? Does it run in the same way on each? Answer:No known platform dependencies.
Question (dep-jre): Which version of JRE do you need (1.2, 1.3, 1.4, etc.)? Answer:XXX no answer for dep-jre
Question (dep-jrejdk): Do you require the JDK or is the JRE enough? Answer:XXX no answer for dep-jrejdk
XXX no answer for deploy-jar
Question (deploy-nbm): Can you deploy an NBM via the Update Center? Answer:XXX no answer for deploy-nbm
Question (deploy-shared): Do you need to be installed in the shared location only, or in the user directory only, or can your module be installed anywhere? Answer:XXX no answer for deploy-shared
Question (deploy-packages): Are packages of your module made inaccessible by not declaring them public? Answer:Only official API and SPI packages are exported.
Question (deploy-dependencies): What do other modules need to do to declare a dependency on this one? Answer:XXX no answer for deploy-dependencies
XXX no answer for compat-i18n
Question (compat-standards): Does the module implement or define any standards? Is the implementation exact or does it deviate somehow? Answer:No.
Question (compat-version): Can your module coexist with earlier and future versions of itself? Can you correctly read all old settings? Will future versions be able to read your current settings? Can you read or politely ignore settings stored by a future version? Answer:XXX no answer for compat-version
java.io.File
directly?
Answer:
XXX no answer for resources-file
Question (resources-layer): Does your module provide own layer? Does it create any files or folders in it? What it is trying to communicate by that and with which components? Answer:XXX no answer for resources-layer
Question (resources-read): Does your module read any resources from layers? For what purpose? Answer:XXX no answer for resources-read
Question (resources-mask): Does your module mask/hide/override any resources provided by other modules in their layers? Answer:XXX no answer for resources-mask
org.openide.util.Lookup
or any similar technology to find any components to communicate with? Which ones?
Answer:
JDBC drivers and database runtimes are searched for in the global lookup.
Question (lookup-register): Do you register anything into lookup for other code to find? Answer:XXX no answer for lookup-register
Question (lookup-remove): Do you remove entries of other modules from lookup? Answer:XXX no answer for lookup-remove
System.getProperty
) property?
Answer:
XXX no answer for exec-property
Question (exec-component): Is execution of your code influenced by any (string) property of any of your components? Answer:XXX no answer for exec-component
Question (exec-ant-tasks): Do you define or register any ant tasks that other can use? Answer:XXX no answer for exec-ant-tasks
Question (exec-classloader): Does your code create its own class loader(s)? Answer:XXX no answer for exec-classloader
Question (exec-reflection): Does your code use Java Reflection to execute other code? Answer:XXX no answer for exec-reflection
Question (exec-privateaccess): Are you aware of any other parts of the system calling some of your methods by reflection? Answer:XXX no answer for exec-privateaccess
Question (exec-process): Do you execute an external process from your module? How do you ensure that the result is the same on different platforms? Do you parse output? Do you depend on result code? Answer:XXX no answer for exec-process
Question (exec-introspection): Does your module use any kind of runtime type information (instanceof
,
work with java.lang.Class
, etc.)?
Answer:
XXX no answer for exec-introspection
Question (exec-threading): What threading models, if any, does your module adhere to? Answer:XXX no answer for exec-threading
Question (security-policy): Does your functionality require modifications to the standard policy file? Answer:XXX no answer for security-policy
Question (security-grant): Does your code grant additional rights to some other code? Answer:XXX no answer for security-grant
XXX no answer for format-types
Question (format-dnd): Which protocols (if any) does your code understand during Drag & Drop? Answer:XXX no answer for format-dnd
Question (format-clipboard): Which data flavors (if any) does your code read from or insert to the clipboard (by access to clipboard on means calling methods onjava.awt.datatransfer.Transferable
?
Answer:
XXX no answer for format-clipboard
XXX no answer for perf-startup
Question (perf-exit): Does your module run any code on exit? Answer:XXX no answer for perf-exit
Question (perf-scale): Which external criteria influence the performance of your program (size of file in editor, number of files in menu, in source directory, etc.) and how well your code scales? Answer:Performance scales linearly with the number of connections and drivers, but usually the numbers are small.
Question (perf-limit): Are there any hard-coded or practical limits in the number or size of elements your code can handle? Answer:None known.
Question (perf-mem): How much memory does your component consume? Estimate with a relation to the number of windows, etc. Answer:XXX no answer for perf-mem
Question (perf-wakeup): Does any piece of your code wake up periodically and do something even when the system is otherwise idle (no user interaction)? Answer:XXX no answer for perf-wakeup
Question (perf-progress): Does your module execute any long-running tasks? Answer:XXX no answer for perf-progress
Question (perf-huge_dialogs): Does your module contain any dialogs or wizards with a large number of GUI controls such as combo boxes, lists, trees, or text areas? Answer:XXX no answer for perf-huge_dialogs
Question (perf-menus): Does your module use dynamically updated context menus, or context-sensitive actions with complicated and slow enablement logic? Answer:XXX no answer for perf-menus
Question (perf-spi): How the performance of the plugged in code will be enforced? Answer:Some methods of the database runtimes may take a long time (especially the start method). These methods are never called in the event thread and a progress dialog is displayed.