Discussions
Categories
- 382.6K All Categories
- 2.1K Data
- 213 Big Data Appliance
- 1.9K Data Science
- 448.4K Databases
- 221.1K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 541 MySQL Community Space
- 469 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 500 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.3K SQL & PL/SQL
- 21.1K SQL Developer
- 293.8K Development
- 9 Developer Projects
- 130 Programming Languages
- 290.6K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 151 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 146 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
- 201 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 294 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 168 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 234 Portuguese
Real-world DB schema
661365
Member Posts: 21
Names of schema elements often contain acronyms (ID, US, PO, GPS etc.) and word abbreviations (Ref, Num, Dpt, Qty, Nbr), making data integration more uphill. My intuition is that abbreviations/acronyms in schemata of relational DBs have a specific nature (e.g. often non standarized and created ad hoc). I would like to verify my intuition with some real-world schema, especially one that could contain abbreviations and acronyms.
Can you recommend me some real-world schema ?
Best,
Maciej
Can you recommend me some real-world schema ?
Best,
Maciej
Tagged:
Answers
-
If I understand whay you are saying then yes since database table, index, view, and column names can be anything the creator wants within the naming scope limitation of the database then abbreviations found in such names are both likely to be site specific and in alignment with 'developer' nature inconsistent. (mild joke there)
Many abbreviations are likely to be obvious like using HIST for HISTORY but INV could be short for INVOICE, INVENTORY, INVENTION or some other application specific feature.
If you want to find an inconsistent system just look for any home grown or vendor application that gone through 10 years of modification, expansion in features, and/or upgrades. Odds are that inconsistencies abound. Though there might be some argument what qualifies as an inconsistency.
HTH -- Mark D Powell -- -
MaciejG wrote:If you have an Oracle support contract the Oracle Apps schemas are available via etrm (search for that) on metalink. That'll keep you going a while. statspack has a schema as do many open source projects.
Names of schema elements often contain acronyms (ID, US, PO, GPS etc.) and word abbreviations (Ref, Num, Dpt, Qty, Nbr), making data integration more uphill. My intuition is that abbreviations/acronyms in schemata of relational DBs have a specific nature (e.g. often non standarized and created ad hoc). I would like to verify my intuition with some real-world schema, especially one that could contain abbreviations and acronyms.
Can you recommend me some real-world schema ?
Best,
Maciej
Niall Litchfield -
Dear Niall,
I'm inside of etrm, but I cannot find Oracle Apps schema. Can you show the exact way, how to navigate and download them ?
Best regards,
Maciej -
Note 432769.1.
Niall Litchfield
http://www.orawin.info/
This discussion has been closed.