Hi Djordje, You are right in saying that the terminology within SQLServer and Sybase are very similar - in fact I don't know of any differences.. They are both bred from the same monster back in the days of Ashton Tate :)
I would make one change with your list: In SQLServer and Sybase, an Oracle Tablespace is called a Database, not a filegroup. So an Oracle schema is not a Database. ============================================================= Oracle SqlServer DB2 Sybase ============================================================= Database Server Sys schema Primary File group Tablespace Database SYSTEM tablespace Master database other schemas "Data" File group Temp tablespace TempDB database Redo log file Log file Database block Page Extent Extent (8 pages -> 64K). (multiple of blocks) Can be shared by logical objects. Sessions Processes Data dictionary System catalogue ============================================================= Data dictionary views System catalogue tables ============================================================= dba_objects sysobjects dba_tab_columns syscolumns dba_indexes sysindexes dba_users sysusers dba_data_files sysfiles v$lock syslocks v$session sysprocesses There are a few more, but they don't jump to mind at the moment, and I'm off home now to spend some time with my little girl :) I'd be interested in a more complete list if you do come up with one. Maybe I could post it to a web site? hmmm.. HTH Mark -----Original Message----- Jankovic Sent: Wednesday, October 24, 2001 23:10 To: Multiple recipients of list ORACLE-L We need to communicate inside a team made of DBAs that support different database platforms: oracle, sql*server, Sybase, adabase (Am I wrong that sql*server and sybase terminology is pretty much the same?). There are some terminology differences between different databases (to start with the word "database" that means different in oracle and sql*server world). I have tried to compile a start terminology difference list. If you could contribute to the list you can send an e-mail to me directly, I would compile the list and send the compiled version to the list. If you don't hear back from me that probably means that the list was not very responsive :-(. Also, please let me know if you think some terminology is wrong in this list. Thanks. Djordje Jankovic [EMAIL PROTECTED] Oracle SqlServer DB2 Database Server Schema Database Sys schema Master database Tablespace File group SYSTEM tablespace Primary data file other tablespaces Secondary data files Redo log file Log file Database block Page Extent Extent (8 pages -> 64K). (multiple of blocks) Can be shared by logical objects. Data dictionary System catalog Data dictionary views System catalog tables dba_objects sysobjects dba_tab_columns syscolumns dba_indexes sysindexes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
