On Sun, 18 Feb 2001, Michael R. Bernstein wrote:
How are you entering the data into the system? Specifically, how are you *normalizing* the Author and book information?
I don't know what you mean by normalizing, I'm afraid. The data is stored and upated in the external Paradox database, which I then import into PostgreSQL using a Paradox-to-SQL converter and some bash scripts.
I'm working on a ZPatterns based book cataloging application, and right now I'm storing 'Book' objects with the author names as a 'lines' property in the ZClass.
I'd like to change this so 'Author' objects are created and stored in their own Specialist when a book is added, but I'm not sure how.
I'm not sure I understand what the issue is. Can't you just, when data is entered to create a Book, query the Authors specialist to see if the Author exists and create it if it doesn't? --RDM