Terima kasih Mas Hendro dan juga Mas Pur atas penjelasannya. Maaf mas Hendro, nanya terus (semoga tidak bosen menjelaskan).... maklum saya gak tahu banyak tentang pengelolaan database mysql. Begini, setelah saya jalankan skerip yg pertama untuk author, muncul begini: +-----------+-----------+--------------------+ | biblio_id | author_id | author_name | +-----------+-----------+--------------------+ | NULL | NULL | Valade, Janet | | NULL | NULL | Fogel, Karl | | NULL | NULL | Douglas, Korry | | NULL | NULL | Douglas, Susan | | NULL | NULL | Shklar, Leon | | NULL | NULL | Rosen, Richard | | NULL | NULL | Woychowsky, Edmond | | NULL | NULL | Taylor, Arlene G. | | NULL | NULL | Stueart, Robert D. | | NULL | NULL | Moran, Barbara B. | | NULL | NULL | Morville, Peter | | NULL | NULL | Rosenfeld, Louis | | NULL | NULL | Robinson, Mark | +-----------+-----------+--------------------+
Sedangkan untuk skrip kedua, topics, muncul: +-----------+----------+--------------+ | biblio_id | topic_id | topic | +-----------+----------+--------------+ | NULL | NULL | Website | | NULL | NULL | Computer | | NULL | NULL | Database | | NULL | NULL | RDBMS | | NULL | NULL | Project | | NULL | NULL | Design | | NULL | NULL | Information | | NULL | NULL | Organization | | NULL | NULL | Metadata | | NULL | NULL | Library | | NULL | NULL | Development | +-----------+----------+--------------+ Yang saya tanyakan: 1. Apakah saya harus menghapus author dan topic yg terdaftar di atas? 2. Apakah bisa saya hapus melalui modul/menu Master File terus sub menu author atau topik di SLIMS, atau harus menggunakan sekrip Mysql? Nah kalau harus melalui sekrip ini gimana caranya? (maaf, sekali untuk sekrip mysql saya buta banget). Terima kasih banyak. Salam --- In [email protected], Hendro Wicaksono <hendrowicaksono@...> wrote: > > Cara mengatasinya memang agak sulit karena bukan masalah teknis aplikasi tapi > integritas data. Mau tidak mau memang harus mencari kutunya satu2, menghapus > dari data bibliografi. Kemudian membersihkan masterfile author dan topic yg > tidak terpakai (orphan) dengan sekrip SQL utk author: > SELECT biblio_author.biblio_id,biblio_author.author_id,mst_author.author_name > FROM mst_author LEFT JOIN biblio_author ON > biblio_author.author_id=mst_author.author_id > > WHERE biblio_author.biblio_id IS NULL and biblio_author.author_id IS NULL > > dan SQL untuk topic: > SELECT biblio_topic.biblio_id,biblio_topic.topic_id,mst_topic.topic > FROM mst_topic LEFT JOIN biblio_topic ON > biblio_topic.topic_id=mst_topic.topic_id > > WHERE biblio_topic.biblio_id IS NULL and biblio_topic.topic_id IS NULL > > > Semoga membantu > Hendro Wicaksono > > > ------------------------------------ -- Towards cyber libraries to support information society in Indonesia. Joining ICS-isis by sending mailto:[email protected] Visit ICS-Portal at http://digilib.binus.ac.id/ics/index.phpYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ics-isis/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ics-isis/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
