OraFAQ Forum: SQL & PL/SQL » need Expert viewpoint on DDL design Java application [XML data in CLOB]

Home » SQL & PL/SQL » SQL & PL/SQL » need Expert viewpoint on DDL design Java application [XML data in CLOB] (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

need Expert viewpoint on DDL design Java application [XML data in CLOB] [message #613992]

Wed, 14 May 2014 03:46

rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg

Senior Member

Hi

attached the DDL of a Java web application. All important data in CLOB data type are XML files.

According to my small DB design skills this is scary. You can't do SQL statements for reporting, you need to use a Webservice. Vendor doesn't publish an ERD.

What you think? Is this "new generation" DB design? Can you explain me sense? What are advantages and disadvantages of this aproach?

Attachment: DDL_oracle.sql
(Size: 264.48KB, Downloaded 1659 times)

Report message to a moderator

Previous Topic:	Using Temp Tables in Oracle SQL
Next Topic:	Need Help In Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 05:15:18 CDT 2024