Dataset vs Database
Trying to understand the correlation between datasets and databases - my colleague and I are working with a client (HP TRIM v7) who have provided us access to a single database. We believe there may be other databases that hold records within a single dataset. Is that the case or is it a single DB please?
Database is created at RDBMS engine like SQLServer, Oracle etc, You can choose any name for the Database. Dataset are CM/ RM/ TRIM Application tables created within the Database by providing RDBMS connection string to connect it the Database therefore you can choose any name for Dataset. RDBMS database needs to exist before you create a dataset (create cm tables within). Database is created using RDBMS engine’s provide tool like SQLStudio for SQLServer whereas Dataset is created from CM Enterprises studio. This Dataset creation process is called Registering a Dataset for the Workgroup. Workgroup are processes which knows to interacts with the Dataset tables etc (cm application code etc). Each Dataset is an independant and complete, there is no spanning or cross databases talking , expansion etc.
Client makes a connection to workgroup only, so when you have more than one Dataset registered on the Workgroup Server, Client will show you a popup to choose which dataset you would like to connect to. Each Dataset has a Unique two character / digit ID which are assigned at the time of registering the Dataset. (The character is a legacy and I dont know why HP never updated it to something longer).
hope this answer your question. In CM you would hear of Dataset and Database as interchanged but mostof them would be refering to Dataset.
Yes, in simplest form one-to-one relationship 1 RDBMS Database per Dataset (as explained above that CM tables will be created in that Database).
My definition's different to Harry's...
A CM dataset comprises a SQL/Oracle database, plus the document store(s) and content index belonging to it.
Note: Any posts I make on this forum are my own personal opinion, and unless stated otherwise do not constitute a formal commitment on behalf of Micro Focus.
(Please state the version of CM you're using in all posts.)
If you find this post useful, please use the
I agree, that overall Dataset does have Document Store component defined, from the question I gatherd that OP (Original poster) wanted to understand the context from the Database point of view. Neil, input further clarifies them which is added value. Thanks