|
Discussion Group Previews
|
 |
|
This page contains previews of recent posts to the InfoAdvisors ITBoards.com Dicusssion Groups. To join our groups, click on the Groups tab above and follow the directions for registering.
|
|
|
 |
|
Data Modeling Group Recent Posts
|
|
|
 |
Free process modelling tools [was How do you use your logical models?]
On my links page, I have links to a couple of other free process modelling tools. See http://www.metadatamatters.com/OtherLinks.html#Topic20
regards
George McGeachie ...
How do you use your logical models?
To understand the data, its dependencies, and relationships, independent of database constraints.Regards,WalterWallStreet Consulting Services, Inc.'Managing Your Data Investment'Walter@WallStreet-Consulting-Services.com ...
How do you use your logical models?
To understand what our information assets should be.
To understand where our information assets are.
To find out what we want that is missing and do something about it.
Information management - what's that about?
Cheers,
Mike Vaughan ...
RE: How do you use your logical models?
[html xmlns:v='urn:schemas-microsoft-com:vml' xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:w='urn:schemas-microsoft-com:office:word' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns:p='urn:schemas-microsoft-com:office:powerpoint' xmlns:a='urn:schemas-microsoft-com:office:access' xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882' xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882 ...
RE: How do you use your logical models?
Good comments, Garry, and this isn't a rebuttal - I agree. I've painted that glaze on business people myself here and there, and it's hard to get it off!!
I think that the modeller's main job with business people (after the model is created ... ... !) is to dynamically translate it into English so the business people can understand it in small chunks. Good modellers protect the business ...
RE: How do you use your logical models?
>> More seriously, the logical model
shows w ...
RE: How do you use your logical models?
Ooh..ooh ...(Toodyism,,) I got another
one....
[DIV ...
RE: How do you use your logical models?
>> 'Provides a taxonomy for business
terms.'[SPAN class=96159291 ...
Re: How do you use your logical models?
More seriously, the logical model shows what the business needs or
wants, in business terms. A bit more stable than physical models, that
may have to change as technology changes.&nb ...
RE: How do you use your logical models?
Well, the obvious - it aids creation
of stable data structures. ...
Re: Generalized Banking Model FSDM from IBM
>>>Well, we have an 'object/attribute' schema,>without OBJECT>(actually, we have 90+ of them).
Hmm, maybe I mis-spoke. Perhaps the top level entity should be 'Class', since an Object is an instantiation of a Class. Regardless, I would kindly remove myself from any association with this database since there's nothing relational about it ...
Re: How do you use your logical models?
Logical models? Heck, just CODE, CODE, CODE!
DML_LDM Listmanager wrote:
[a moz- ...
Re: Generalized Banking Model FSDM from IBM
Well, we have an "object/attribute" schema, without OBJECT
(actually, we have 90+ of them).
So there is no referential integrity to relate the ATTRIBUTEs to a
specific OBJECT.
It's like having a LINE_ITEM table without an ORDER table.
To make it more fun, the column that you would expect to be named
"OBJECT_ID" is called "KEY_1 ...
How do you use your logical models?
'To evaluate third party applications/components against'
__________________
Karen Lopez, I.S.P.
http://www.infoadvisors.com
---
Helping you increase the business value of your information management resources.
[img src='http://feeds.feedburner.com/MusingsOnDataProcess ...
How do you use your logical models?
Seems I get into discussions even after all these years on the value of data modeling to an organization. I'd like to start a thread for everyone's reference on uses for logical data modeling. Feel free to post many times as you recall modeling's many uses. Here's my first use.
'Provides a taxonomy for business terms.'
Regards,WalterWallStreet Consu ...
Generalized Banking Model FSDM from IBM
I worked with a DoD model that stated that a PERSON is a subtype of AGREEMENT. Never agreed with that, nor did I understand it.
__________________
Karen Lopez, I.S.P.
http://www.infoadvisors.com
---
Helping you increase the business value of your information management resources.
[a href='http://feeds.feedburner.com/~r/MusingsOnDataProcess ...
Generalized Banking Model FSDM from IBM
What!? They left off the ultimate top level entity, OBJECT? The audacity! I often struggle with the value of abstracting models to the point of, er, abstraction. It's really meaningless to the users and IT folks. I don't see the value from a taxonomy or ontology perspective either. Someone, please enlighten me!Regards,WalterWallStreet Consulting ...
Generalized Banking Model FSDM from IBM
Generic models of organisation I can cope with. - I first saw one of those in 1984.
What I'm puzzled by is a model that goes as far as saying that many requirements can be modelled using 'Event', 'Classification', and 'Accounting Unit'. Most new requirements can just be slotted into the model, I'm told. It'll be interesting to see how that works in practice; could be the simplest Enterpris ...
Generalized Banking Model FSDM from IBM
] The
]main thing that worries me is
]the inclusion of several
]generic hierarchies (anyone
]who has seen it will know what
]I mean) that I think just
]obscure business meaning.
This is one of the key differences I point out about working with third party models. In order to support a wide range of global business needs, the organizations that steward thes ...
Generalized Banking Model FSDM from IBM
I've started working with the IBM FSDM, and no way would I say just take it as it is.
I don't wish to disparage the amount of work that went into this model, but it wouldn't have survived a review at the last bank I worked for! The main thing that worries me is the inclusion of several generic hierarchies (anyone who has seen it will know what I mean) that I think just obscure business meani ...
|
|
|
|
 |
|
ER/Studio Discussion Group Recent Posts
|
|
|
 |
Application Streaming
We exclusively provide ER/Studio via the Citrix application sharing technologies (similar to Terminal Services) which has (a) greatly reduced support issues and (b) has made the performance consistent between our locations [whether it's internal or through telecommuters using VPN].
[FONT face='Arial, Helvetica, sans serif' siz ...
RE: Version Control Using ER/Studio (UNCLASSIFIED)
Thanks Tom. I agree, this shop could benefit more by establishing more governance about the process of assessing the validity of requirements, but getting any requirements at all is our first problem. Our data warehouse team has a front room group and a back room group. We're still trying to decide which group is supposed to gather requirements and what form they take.
[P ...
Synchronizing Triggers
I use ER/Studio with SQL Server 2005. I have triggers that use the SQL Server 'select * for XML raw' command. ER/Studio 7.1 and 7.5 won't synchronize those triggers into my model, apparently because it is non-standard SQL. I can see in the model to DB differences that triggers exist in the DB but when I select them for synchronization they don't appear in the model to DB differences so I can se ...
RE: Version Control Using ER/Studio (UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: NONE
Just some thoughts to share, but more on philosophical approach to the
problem. If your management will support it, it appears your shop can
benefit more by establishing more governance about the process of
assessing the validity of requirements, particularly if alterations are
being proposed to the physical structu ...
Version Control Using ER/Studio
What are some best practices for using ER/Studio as part of our Data Warehouse Version Control System?
ER/Studio keeps track of diagrams at the file-level through the Named Release feature, but does not provide for versioning at the model or object level.
We'd like to use a combination of ER/Studio, Visual SourceSafe, and TOAD to manage our schemas, tables, p ...
|
|
|
|
|
|
ERwin Users Discussion Group Recent Posts
|
|
|
|
CC will clean converted models
I was just wondering if you have any results for this process yet - we are just beginning to convert and would like to know any results.
Thanks ...
Release 7.2.7
We are just going to 7.2.6 so no help with 7.2.7 but we are dropping Model Manager (we are using 4.1.4.4033) as we find it too slow and cumbersome, especially with larger models - it just does not have enough features for us to put up with the length of time it takes to open a model.
We also found that it has some peculiarities that 'corrupted' some of our models. S ...
RE: Drawing becomes read only
I have also have this problem a lot and CA told me that nobody else is having the problem - here's me thinking it must be me!
We start most of our models from templates but this even happens when we convert from 4.1.4 and save as xml during that process.
In fact, sometimes I can actually get the read-only to go away simply be trying to save the model again! Have ...
RE: Drawing becomes read only
A long, long time ago (maybe during the Logicworks days) I remember having this same problem and it had to do with either a virus checker or backup setting that was causing the file to be marked read only on save.
Karen__________________Karen Lopez, I.S.P.http://www.infoadvisors.com ---Helping you increase the business value of your information management ...
RE: Drawing becomes read only
>> The model has a .erwin extension.
However, it is created from a templa ...
RE: Drawing becomes read only
>> The model has a .erwin
extension. However, it is created from a template.&n ...
RE: Drawing becomes read only
>Thanks for the info on constraints Theo and Garry.>I still can't figure out why my drawing becomes read-only.>When I finish altering it, I save it and close it. The next>time I open it up, its marked read-only and I have to close>it, change the properties on the file, and then re-open to>make my changes. Very odd. I didn't have this problem with[ ...
Release 7.2.7
We are about to move from release 7.2.4 to 7.2.7. Are there any gotchas that we should be wary of other than the foreign key/ index issues described in the Next Release thread?
One of our objectives for doing this is so we can start to use Model Manager. ...
RE: Drawing becomes read only
The model has a .erwin extension. However, it is created from a template. ...
RE: Drawing becomes read only
Hi Nancy...
[SPAN class=175175019-1205200 ...
RE: Reporting Tools
I agree about the data browser as well. It
is the only reporting tool in ...
RE: Drawing becomes read only
Thanks for the info on constraints Theo and Garry.
I still can't figure out why my drawing becomes read-only. When I finish altering it, I save it and close it. The next time I open it up, its marked read-only and I have to close it, change the properties on the file, and then re-open to make my changes. Very odd. I didn't have this problem with earlier versions.
...
RE: Reporting Tools
Theo,
[FONT face=Arial
...
RE: Reporting Tools
I, too, am having a love affair with the Data Browser. It allows me to see data from many perspectives, get it into Excel spreadsheets easily, etc. We would be lost without it.
Rose M. Coder ...
RE: Problems Creating Logical-only Relationships
I saw my last posting got handicapped - it missed quite a few words, and at one point the word NOT was quite relevant. It should have been:
Garry,
I did indeed report the issues me ...
RE: Problems Creating Logical-only Relationships
Garry,
I did indeed report the issues mentioned to CA. I made it a habit not mention quirks and undocumented features unless and before I report them to CA.
As for the Show FK Indexes check box: you got me there. O ...
RE: Reporting Tools
Robert,
I totally agree with your declaration of love for the Data Browser: I couldn't go without it as well.
In addition to what you describe I would like to add that I use DB also to escape the limita ...
RE: Reporting Tools
Please excuse my somewhat contrarian view, but I LOVE Data Browser. Every chance I get , I remind Princeton how valuable it is to me.[SPAN style='mso-spaceru ...
RE: Drawing becomes read only
>>Be aware that when you change the
order of columns, and you have the same co ...
RE: ERwin Enhancement Item - Poll Question
Thank you all for your diverse and interesting set of suggestions. Our next release r7.3 will incorporate several CC improvements - all based on user feedback, some of which came right off this board. As we get closer to our projected beta target (August - September), additional information will be made available for your review.
Regards,
C. Neil Buchwalter
CA
Product Man ...
|
|
|
|
|
|
Visible Analyst and Visible Advantage Discussion Group Recent Posts
|
|
|
|
|
|
 |
|
 |
 |
|
|
DBArtisan Group Recent Posts
|
|
|
How can we disable startup splash screen
When opening DB Artisan 8.5.2 it puts a little startup splash screen right in the middle of my screen. Is there any way I can not have this thing show up? This version seems to take quite a while to open and this little splash screen sits in front of my other windows and I can't do anything with my other apps until it goes away.
Thanks,
Craig
& ...
|
|
|
|
 |
 |
|
 |
 |
|
 |
 |
|
|
Rational Data Architect Group Recent Posts
|
|
|
PDF output of classic diagram report
I have created some classic diagram reports for physical models and I wonder how the reporting components sorts the display of tables within the pdf document. I would expect that they are sorted by table name in alphabetical order - but unfortunately that's not the case!!
Is there a way to influence that ??
Elke ...
|
|
|
|
 |
 |
|
 |
|
|
|
|
|
|
PowerDesigner Group Recent Posts
|
|
|
RE: Facts and Dimensions
Hi Karen,
Yes, that is what I meant. When you create the multidimensional data model and add dimensions, they show up as objects in the screen area. However the fact tables do not. -- Thanks. ...
RE: Facts and Dimensions
...
Facts and Dimensions
Hello - I am creating a multidimensional data model for a data warehouse. I added all facts, dimensions, members and attributes, with no problems. My question is how to show the reference/relationship between the facts and dimensions..
Thanks!
Theresa ...
Re: Sharing Domains
Sorry, I should have been more clear.Easiest way is to have both Master and Child models open in the Browser.Expand in the Master the section you want to replicate.Right-click and drag the element to replicate and drop it in the Child model (move the mouse around until it lets you drop it, typically just below the model name.
From the menu that appears, select Replicate.That&# ...
RE: Sharing Domains
Yes, it helps.
[SPAN class=307380311-18042 ...
Re: Sharing Domains
I use Replication to manage this. In the CDM, I created a "Master.CDM" model. In this model I place the domains, business rules, common entities, data items, etc. This is the model you protect with your life. :-)
Every other model has replicas of the objects, so an Entity Attribute would use a master domain, making the data type unchangeable.&nb ...
Sharing Domains
I am dealing with several models.
Is there a way to share domain definitions?
Alternately, is there a way to copy domain definitions from one model to another?
Thanks
Dave Roth ...
RE: Extended Model Definitions
Hi Bill
Thanks a mill - I would not have figured it out on my own.
Thanks for the help.
Cheers ...
RE: Extended Model Definitions
Ken,
What you are looking for is the EntityAttribute metaclass, which is the association of a DataItem to an Entity. You can add your extended attribute there in your XEM file.
HTH,
Bill Bunke ...
RE: Extended Model Definitions
I have a question on the relationship between the data item and the attribute. I would like to extend the information I capture about an attribute - but cannot find a way of doing it. The only way I have found (so far) is to add it to the Data Item - but I would like the info to differ depending on which Entity the attribute is assigned to.
Anyone got any ideas?
T ...
|
|
|
|
|
|
|
|
|
|