Re: What is 'Database Mining'
Posted in 1993
Topics: SQL Development & Query Writing
In <1993Apr9.201122.27928@informix.com> proberts@informix.com (Paul Roberts) write: > I find myself wanting to "factor" a large table into two smaller tables > - basically "unjoin" it. > If there is a theory or a method behind this, I'd love to get a pointer > to it. If you are working within a single database, and want to break a large relation into smaller ones - sounds to me that you are talking about Decomposition of relations. This is discussed in "Principles of DB and Knowledge-Base Systems" (CS Press) Vol. 1, by J.D. Ullman, Chapter 7. It has to do with lossless-join decomposition into Boyce-Codd Normal Form, and other normal forms that preserve functional dependencies and/or data. I am not sure about the relation between the factoring of relations into smaller ones, and "database mining" as described in the other followups to the "What is 'Database Mining'" question. Hagit.