Re: What books recommended for Data Modeling ?
Hi All, Need some suggestions/Input. My application database is 8.1.7, NOARCHIVELOG, WIN200, total size 4 GB, more of single user OLTP client-server application. Now the customer wants to give training on this application to hundred trainees at a time. For this he wants to install hundred database instances on same server machine, which *each* will be accessed simultaneously from 100 different client workstations. The reasons for installing all instances on same machine are - to avoid re-installing databases on 100 workstations after each round of training.- No user should see any other user's data. Please suggest if this approach is feasible or is it at all possible.Tested this with upto 5 instances, and it seems to work. The customer is willing to upgrade to any hardware needed for this setup. Thanks in advance for your time.Dilip.
What books recommended for Data Modeling ?
hi all, What books you recommend for Data Modeling ? including how to map business requirements to relational and Data warehouse date model Regards,Salaheldin Aboali_Senior Software Developer Management Information Systems_http://www.mis-kuwait.comPhone:+965.240.64.25+965.240.67.98+965.240.80.92Ext. 235Fax. +965.240.81.53Cell. +965.790.31.65_P.O. Box: 20126 Safat-13062 Kuwait_ BEGIN:VCARD VERSION:2.1 N:Aboali;Salaheldin FN:Salaheldin Aboali ORG:Management Information System;Software Development TITLE:Senior Software Developer TEL;WORK;VOICE:Ext. 235 TEL;HOME;VOICE:+202.744.35.80 TEL;CELL;VOICE:+965.790.31.65 * +2010.150.63.96 TEL;WORK;FAX:+965.240.81.53 ADR;WORK;ENCODING=QUOTED-PRINTABLE:;+965.240.64.25 * +965.240.67.98 * +965.240.80.92;P.O. Box: 20126 =0D=0ASafa= t-13062 Kuwait;Kuwait City;;;Kuwait LABEL;WORK;ENCODING=QUOTED-PRINTABLE:+965.240.64.25 * +965.240.67.98 * +965.240.80.92=0D=0AP.O. Box: 20126 =0D= =0ASafat-13062 Kuwait=0D=0AKuwait City=0D=0AKuwait URL;WORK:http://www.mis-kuwait.com EMAIL;PREF;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] REV:20030806T092715Z END:VCARD
RE: What books recommended for Data Modeling ?
Title: Message Actually, I can recommend 4 books: Database Design Using Entity-Relationship Diagramsby Sikha Bagui, Richard Earp 2. Case*Method: Entity Relationship Modelling by Richard Barker (Hardcover) Avg. Customer Rating: 1. Case*Method: Function and Process Modelling by Richard Barker, Cliff Longman (Hardcover) Avg. Customer Rating: The Hitchhiker's Guide to the Galaxy by Douglas Adams (Mass Market Paperback - November 1995) Avg. Customer Rating: You'll need the chapter about SEP field and the answer to the Question Of. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Salaheldin AboaliSent: Wednesday, August 06, 2003 6:19 AMTo: Multiple recipients of list ORACLE-LSubject: What books recommended for Data Modeling ? hi all, What books you recommend for Data Modeling ? including how to map business requirements to relational and Data warehouse date model Regards,Salaheldin Aboali_Senior Software Developer Management Information Systems_http://www.mis-kuwait.comPhone:+965.240.64.25+965.240.67.98+965.240.80.92Ext. 235Fax. +965.240.81.53Cell. +965.790.31.65_P.O. Box: 20126 Safat-13062 Kuwait_ Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. 0201416964.01.__PIt.arrow,TopLeft,-1,-17_SCTHUMBZZZ_.jpgThe previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. stars-5-0.gifThe previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. 0201565250.01.THUMBZZZ.jpgThe previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. 0345391802.01.__PIt.arrow,TopLeft,-1,-17_SCTHUMBZZZ_.jpgThe previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. stars-4-5.gif
Re: What books recommended for Data Modeling ?
100 instances woh . If you are in 9i look at possibilities like context or label security . or creating another schema . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 9:24 PM I have not heard installing hundred database instances on same server. Maybe you should think creating one instance, and then hundred schemas in it. Guang On Wed, 6 Aug 2003, Dilip Patel wrote: Hi All, Need some suggestions/Input. My application database is 8.1.7, NOARCHIVELOG, WIN200, total size 4 GB, more of single user OLTP client-server application. Now the customer wants to give training on this application to hundred trainees at a time. For this he wants to install hundred database instances on same server machine, which *each* will be accessed simultaneously from 100 different client workstations. The reasons for installing all instances on same machine are - to avoid re-installing databases on 100 workstations after each round of training. - No user should see any other user's data. Please suggest if this approach is feasible or is it at all possible. Tested this with upto 5 instances, and it seems to work. The customer is willing to upgrade to any hardware needed for this setup. Thanks in advance for your time. Dilip. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What books recommended for Data Modeling ?
Perhaps a bit late but I have just been cleaning up the email As an alternate suggestion perhaps running Oracle under VMware with GSX Server. You can build a single instance of the training environment and then replicate the environment to build multiple instances, A nice feature is the ability to make each instance non persistent so that at the end of training you can simply undo all the work done in the training class GSX allows you to run as many instances as your hardware can support and if they are willing to buy big hardware then a GSX license is probably going to be cheap Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Guang Mei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07-08-2003 02:24 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: What books recommended for Data Modeling ? I have not heard installing hundred database instances on same server. Maybe you should think creating one instance, and then hundred schemas in it. Guang On Wed, 6 Aug 2003, Dilip Patel wrote: Hi All, Need some suggestions/Input. My application database is 8.1.7, NOARCHIVELOG, WIN200, total size 4 GB, more of single user OLTP client-server application. Now the customer wants to give training on this application to hundred trainees at a time. For this he wants to install hundred database instances on same server machine, which *each* will be accessed simultaneously from 100 different client workstations. The reasons for installing all instances on same machine are - to avoid re-installing databases on 100 workstations after each round of training. - No user should see any other user's data. Please suggest if this approach is feasible or is it at all possible. Tested this with upto 5 instances, and it seems to work. The customer is willing to upgrade to any hardware needed for this setup. Thanks in advance for your time. Dilip. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What books recommended for Data Modeling ?
I took the advice of Dennis Williams and just read "The Data Modeling Handbook" (http://tinyurl.com/j5wr) and found it to be excellent for normalization of OLTP systems. The authors clearly have lots of experience and offer many "rules" and best practices. The book is expensive for it's size, but worth it. There is a new book that is not yet published called "Effective Oracle by Design", by Tom Kyte. You can preorder it at www.bookpool.com. If it's anything like his other book then it will be most excellent. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions -Original Message-From: Salaheldin Aboali [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 06, 2003 6:19 AMTo: Multiple recipients of list ORACLE-LSubject: What books recommended for Data Modeling ? hi all, What books you recommend for Data Modeling ? including how to map business requirements to relational and Data warehouse date model Regards,Salaheldin Aboali_Senior Software Developer Management Information Systems_http://www.mis-kuwait.comPhone:+965.240.64.25+965.240.67.98+965.240.80.92Ext. 235Fax. +965.240.81.53Cell. +965.790.31.65_P.O. Box: 20126 Safat-13062 Kuwait_
RE: What books recommended for Data Modeling ?
--_=_NextPart_001_01C35C00.634E5820 Content-Type: text/plain; charset=windows-1256 The most important part of working with databases... Have a look at 'Oracle Design', Dave Ensor Ian Stevenson. But if you have not already, I would urge you to attend a training course. It is a complex, subtle area, and not easily learned from text books alone. You also need to decide which methodology and standards you want to follow. peter edinburgh hi all, What books you recommend for Data Modeling ? including how to map business requirements to relational and Data warehouse date model Regards, Salaheldin Aboali _ Senior Software Developer Management Information Systems _ http://www.mis-kuwait.com http://www.mis-kuwait.com Phone: +965.240.64.25 +965.240.67.98 +965.240.80.92 Ext. 235 Fax. +965.240.81.53 Cell. +965.790.31.65 _ P.O. Box: 20126 Safat-13062 Kuwait _ * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * --_=_NextPart_001_01C35C00.634E5820 Content-Type: text/html; charset=windows-1256 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=windows-1256 META content=MSHTML 5.50.4807.2300 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial color=#ff size=2SPAN class=242084909-06082003The most important part of working with databases.../SPAN/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=242084909-06082003/SPAN/FONTnbsp;/DIV DIVFONT face=Arial color=#ff size=2SPAN class=242084909-06082003Have a look at 'Oracle Design', Dave Ensor amp; Ian Stevenson./SPAN/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=242084909-06082003/SPAN/FONTnbsp;/DIV DIVFONT face=Arial color=#ff size=2SPAN class=242084909-06082003But if you have not already, I would urge you to attend a training course. It is a complex, subtle area, and not easily learned from text books alone. You also need to decide which methodology and standardsnbsp;you want to follow. /SPAN/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=242084909-06082003/SPAN/FONTFONT face=Arial color=#ff size=2SPAN class=242084909-06082003/SPAN/FONTnbsp;/DIV DIVFONT face=Arial color=#ff size=2SPAN class=242084909-06082003peter/SPAN/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=242084909-06082003edinburgh/SPAN/FONT/DIV BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2BR/FONTnbsp;/DIV DIVSTRONGFONT face=Verdana size=2hi all,/FONT/STRONG/DIV DIVnbsp;/DIV DIVFONT face=Verdana size=2STRONGWhat books you recommend for Data Modeling ?/STRONG/FONT/DIV DIVFONT face=Verdana size=2STRONGincluding /STRONG/FONT/DIV DIVFONT face=Verdana size=2STRONGhow to map business requirements to relational and Data warehouse date model/STRONG/DIV/FONT DIVSTRONGFONT face=Verdana size=2/FONT/STRONGnbsp;/DIV DIVSTRONGFONT face=Verdana size=2Regards,BRSalaheldin AboaliBR_BRSenior Software Developer BRManagement Information SystemsBR_BRA href=http://www.mis-kuwait.com;http://www.mis-kuwait.com/ABRPhone:BR+965.240.64.25BR+965.240.67.98BR+965.240.80.92BRExt. 235BRFax. +965.240.81.53BRCell. +965.790.31.65BR_BRP.O. Box: 20126 BRSafat-13062 KuwaitBR_/FONT/STRONG/DIV/BLOCKQUOTEFONT SIZE=3BR BR *BR This e-mail message, and any files transmitted with it, areBR confidential and intended solely for the use of the addressee. IfBR this message was not addressed to you, you have received it in errorBR and any copying, distribution or other use of any part of it isBR strictly prohibited. Any views or opinions presented are solely thoseBR of the sender and do not necessarily represent those of the BritishBR Geological Survey. The security of e-mail communication cannot beBR guaranteed and the BGS accepts no liability for claims arising as aBR result of the use of this medium to transmit
Re: What books recommended for Data Modeling ?
I have not heard installing hundred database instances on same server. Maybe you should think creating one instance, and then hundred schemas in it. Guang On Wed, 6 Aug 2003, Dilip Patel wrote: Hi All, Need some suggestions/Input. My application database is 8.1.7, NOARCHIVELOG, WIN200, total size 4 GB, more of single user OLTP client-server application. Now the customer wants to give training on this application to hundred trainees at a time. For this he wants to install hundred database instances on same server machine, which *each* will be accessed simultaneously from 100 different client workstations. The reasons for installing all instances on same machine are - to avoid re-installing databases on 100 workstations after each round of training. - No user should see any other user's data. Please suggest if this approach is feasible or is it at all possible. Tested this with upto 5 instances, and it seems to work. The customer is willing to upgrade to any hardware needed for this setup. Thanks in advance for your time. Dilip. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).