Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 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.