Set up quick and easy database metadata housekeeping with the Java Apache POI libraries and Microsoft Excel.
Tutorial Details:
Databases are everywhere. In IT, you can't build a substantial application without providing tables to store the data that the application will rely on (properties, configuration settings, etc.) and process. Maintaining a clear understanding of the role the columns play in your tables is essential, as maintenance needs and enhancements force tables to evolve.
Entity relationship diagrams (ERD), while central to such development efforts, don't go far enough when it comes to explaining the actual use of a particular column. Some ERD design tools do allow you to store metadata in them, but this forces anybody who wants to look up metadata definitions later to either use those specific tools. Moreover, descriptions stored in design tools, while adequate for those involved in the design process, may not meet the needs of developers performing maintenance or creating enhancements after the application goes live. Consequently, the usage and meanings of columns and tables typically get modified, lost, or obscured over time.
Read
Tutorial at: Click here to view the tutorial
Rate Tutorial: Manage Database Metadata with POI and Excel
View Tutorial: Manage Database Metadata with POI and Excel
Related
Tutorials:
 Java Tip 77: Enable copy and paste functionality
between Swing's JTables and Excel - JavaWorld
Java Tip 77: Enable copy and paste functionality
between Swing's JTables and Excel - JavaWorld
|
Code generation using Javadoc - JavaWorld August
2000
Code generation using Javadoc - JavaWorld August
2000
|
Leverage legacy systems
with a blend of XML, XSL, and Java - JavaWorld October 2000
Leverage legacy systems
with a blend of XML, XSL, and Java - JavaWorld October 2000
|
The magic of Merlin - JavaWorld March 2001
The magic of Merlin - JavaWorld March 2001
|
Manage distributed
sessions - JavaWorld April
2001
Manage distributed
sessions - JavaWorld April
2001
|
Generate JavaBean classes dynamically with XSLT
Generate JavaBean classes dynamically with XSLT
|
Maven ties together tools for better code management
Maven ties together tools for better code management
|
Java Tip 143: Utilize
the Database Schema
Browser
Java Tip 143: Utilize
the Database Schema
Browser
|
Interesting
concept ...
Interesting
concept ...
|
Excelling in
Excel with Java
Excelling in
Excel with Java
|
Simple classes for JDBC
Simple classes for JDBC
|
PDFTextStream v1.1.2 Released; Fast Java PDF Text Extraction
PDFTextStream is the ideal solution for Java applications and J2EE web services that need to rapidly and accurately extract text and document metadata from PDF files.
|
Application Integration: Sun Java System Access Manager 2004Q2 and JDBC Authentication Module
Today, most user authentication solutions for Web applications are ad hoc and are based on proprietary schema definitions in relational databases. So, if you have multiple Web applications, you may have a separate user database for each of your applicatio
|
Annotations in Tiger, Part 1: Add metadata to Java code
Annotations, a new feature in J2SE 5.0 (Tiger), brings a much-needed metadata facility to the core Java language. In this first of a two-part series, author Brett McLaughlin explains why metadata is so useful, introduces you to annotations in the Java lan
|
They just work
Writing CSV files: CSVPrinter
This class makes it easy to output CSV. Given values, it will automatically determine if they need to be quoted and escape special characters. Comments can easily be written and correct line beginnings will be added.
|
A first look at Apache Geronimo
Start developing and deploying J2EE apps on the first open source J2EE server. When released, Geronimo will be the first J2EE-certified open source server. This article will give you the basics you need for developing and deploying J2EE applications on Ge
|
Running Lucene Search on WebLogic Portal 8.1
Lucene comes with two main services available: indexing and searching. The indexing tasks are done independently from the search tasks. Both the index and search services are available so that developers can extend them to meet their needs.
|
Manage Database Metadata with POI and Excel
Set up quick and easy database metadata housekeeping with the Java Apache POI libraries and Microsoft Excel.
|
DB Solo - Database development and management tool
DB Solo is a powerful database development and management tool for developers
and DBAs. DB Solo has an intuitive user interface that allows you to explore
and manage your database objects as well as execute your own ad-hoc queries.
|
Comparing J2ME Multimedia Options
This article presents the latest developments in MMAPI: the new security considerations raised in MMAPI 1.1, the differences between MMAPI and the MIDP 2.0 Media API, J2ME Wireless Toolkit 2.2 support for MMAPI, and JSR 234, Advanced Multimedia Supplement
|
|
|
|
