Re: New to the job



On Oct 13, 10:17 pm, nujcha...@xxxxxxxxxxxxxx wrote:
I just got a new job (woohoo). First challegne I face is to build a
data model and a data dictionary of all the systems existing in the
organisation. I have a number of constraints to acheive this because
of the following

1. Nobody knows the full picture of how many systems we have in the
organisation. I think IT dept probably are aware of 90% systems used
in the orgnisation

2. We have accessed to the databases as they are hosted in house but
there wasnt knowledge transfer so staff do not know about underlying
database

The organisation has 4000 employees, this is my 2nd week at work and I
want to impress my boss so much and obviously want to pass probation
but I am struggle. My initial idea is that try to find the master
database but I think it depends on the context and master database can
vary when context changes.

Help me please, what would u do if you were me?

Thanx
Peppe

ONE I want to congratulate the manager that recognizes the need for
this documentation.

TWO given the need for this documentation,I sincerely believe you will
not find a master DB. GIve up that idea.

THREE Patrtition the systems. Get one or a few documented. That will
impress your manager more than getting a fast answer. Look for ways to
make the documentation easy to change and keep in synch with the
databases.

You have a great opportunity here to become a better expert on the
company's databases than some long timers in your shop. You should do
well. Good luck.

Ed

.



Relevant Pages

  • Re: Solaris 10 CDE login problem - The DT messaging system could not be started
    ... 4.Check to see any magic cookie related error messages in these ... | This happens when the tool-talk databases get corrupted. ... Contrary to the documentation that I have seen these ... Another suggestion was ...
    (comp.unix.solaris)
  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Move databases between servers
    ... What I'm trying to do now is to copy master. ... Now I'm reinstalling sql with identical version, and restore all databases ... Since the logins are in master and operators/agents are in msdb why I ... copy all database and log files to new server ...
    (microsoft.public.sqlserver.setup)
  • Re: Quote from student, after teaching Pick
    ... People like the PICK model for its simplicity of language not its ... The data model is but one aspect of it, ... I have used Java a bit and PHP less against MV databases, ... I don't know which DBMS you are referring to. ...
    (comp.databases.pick)
  • Re: Does Codds view of a relational database differ from that ofDate&Darwin?[M.Gittens]
    ... data model", yet well-known researchers are happily reinventing the square wheels of IMS and similar systems, apparently blissfully unaware of the history and fate of hierarchical databases. ... that even some of the big names that are right at the core of the hype, are very clear about what they think XML is useful for what it is not useful for, and who would judge any claims that it would somehow replace the relational model as, and I quote, ridiculous. ...
    (comp.databases.theory)