Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 390 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
Datamodel for application variants
Up to now, we have a school administration application for higher schools which is based on a (one) data model. As we are now making a variant of the application, I like to keep one data model and making two subviews, each for one of the application. They share around 60 % of the same foundation of the data model, the rest is different.
My question: Is there an easier, i. e. better approach?
I have already some sub views for the current data model, but am not able to generate DDL for a subview. I can select for example all tables in subview and run DDL Preview (context menu) to get the code.
Second question: Is there a possibility to run Generate DDL from the menu bar for subviews?
Thanks and best regards,
Robert
Best Answer
-
Hi Robert,
Is there a possibility to run Generate DDL from the menu bar for subviews?
yes, you need to select the subview you want to use as filter
After that you can tune further what to be included - comments, some indexes or constraints to exclude, required objects from physical model, name substitution, ....
And you can save it in DDL generation configuration and every time you generate DDL you can load that configuration in order to have repeatable DDL (in this case it's not required to start from subview)
Also you can use DDL generation configuration in compare functionality in order to filter out some objects from comparison
Philip
Answers
-
Hi Robert,
Is there a possibility to run Generate DDL from the menu bar for subviews?
yes, you need to select the subview you want to use as filter
After that you can tune further what to be included - comments, some indexes or constraints to exclude, required objects from physical model, name substitution, ....
And you can save it in DDL generation configuration and every time you generate DDL you can load that configuration in order to have repeatable DDL (in this case it's not required to start from subview)
Also you can use DDL generation configuration in compare functionality in order to filter out some objects from comparison
Philip
-
Hi Philip
Thanks for pointing me to these nice features. Tried it and works fine :-)