Something that has been puzzling me for a bit now, and an hour or two of googlin' hasn't really revealed any useful answers on the subject, so I figured I'd just write the question.
现在一直让我感到困惑的东西,以及一两个小时的googlin'并没有真正揭示这个主题的任何有用的答案,所以我想我只是写了这个问题。
When I create a database in SQL using 'CREATE DATABASE DBNAME' am I implicitly creating a catalog in that database? Is it proper to refer to that 'DBNAME' as a catalog? Or is it something completely unrelated?
当我使用'CREATE DATABASE DBNAME'在SQL中创建数据库时,我是否隐式在该数据库中创建目录?将'DBNAME'称为目录是否合适?或者它是完全不相关的东西?
When I use the MySQL JDBC driver to get the list of tables in a database using the getMetaData() function, the "TABLE_CAT" column (which I would assume means 'catalog') is always set to the name of the database I've choosen.
当我使用MySQL JDBC驱动程序使用getMetaData()函数获取数据库中的表列表时,“TABLE_CAT”列(我假设其意为“目录”)始终设置为我所拥有的数据库的名称choosen。
Coincidence? Or am I just completely wrong on all of this?
巧合?或者我对这一切完全错了?
1 个解决方案
#1
catalog is the JDBC term for what many people (and some RDBMs) call databases. i.e. a collection of tables/views/etc. within a database system.
catalog是许多人(和一些RDBM)调用数据库的JDBC术语。即表/视图/等的集合。在数据库系统中。
#1
catalog is the JDBC term for what many people (and some RDBMs) call databases. i.e. a collection of tables/views/etc. within a database system.
catalog是许多人(和一些RDBM)调用数据库的JDBC术语。即表/视图/等的集合。在数据库系统中。