FYI. As always, feedback is highly appreciated in [EMAIL PROTECTED] Ciao Frank
-------- Original Message -------- Subject: Link CSV/Text files into HSQL databases / preliminary / 0.2 Date: Tue, 05 Sep 2006 15:52:01 +0200 From: Frank Schönheit <[EMAIL PROTECTED]> Reply-To: [email protected] To: [email protected] Title ===== Link CSV/Text files into HSQL databases Location ======== http://dba.openoffice.org/specifications/Link_CSV_Text_files_into_HSQL_databases.odt Revision ======== 0.2 Status ====== preliminary Changed ======= first public version Abstract ======== In business processes, it's often necessary to exchange data between completely different applications. One common, widely-used, simple file-based format is CSV: text files containing multiple rows of homogenous data. OpenOffice.org can already process such data in Calc, by interpreting the data therein as spreadsheet data, and in Base, by accessing it as relational database table. Especially the latter feature is rather limited, as it's not possible to update the data, or build more complex data models, for instance including relational integrity. HSQLDB, the default database engine used by OpenOffice.org Base, features linkage of CSV/Text files, handling them as if they were native HSQL tables, including applicability of the full power of the HSQL database engine. This document describes an user interface, implemented for OpenOffice.org Base, which allows to conveniently manage those linked tables in an HSQL database. Comments ======== good for a first impression / discussion, still lacking quite some items Issues ====== n/a Feedback ======== mailto:[email protected] -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
