473,322 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Data Correlation

Les
Hi can anyone help me,

I have just graduated and have started working for a building developer
which deals with a large quantity of drawings. As you can imagine these all
need documenting and revision of drawings kept a track of. I have recently
taking over the administration of the drawings and their current system is
not capable of easily managing the data so I have taken it upon myself to
try and organise the data in a database. The problem arises when displaying
the drawing numbers with the revision dates and revision letters like below
in a grid fashion.

Day 1 17 9 20 11

Month 3 6 8 1 5

Year 02 02 03 04 04

Drawing Num

Drw1 - A B

Drw2 - A B C

Drw3 - A B

Drw4 -

I have studied database systems during my degree (IT related) but either I
have forgotten or not come across how to do this.

If anyone can help my by either pointing in a direction of where to look or
similar databases that use a similar grid technique I would be very
grateful, I'm not stupid and am prepared to put the work in to get the right
result.

One last thing, as this is being used in an office I only have access to
limited facilities and software that is on offer so the only database
available is MS Access XP, very annoying having studied and worked with
Oracle.

Thanks in advance

Les
Nov 13 '05 #1
2 2136

"Les" <no****@nospam.spam> wrote in message
news:d0**********@news.freedom2surf.net...
Hi can anyone help me,

I have just graduated and have started working for a building developer
which deals with a large quantity of drawings. As you can imagine these
all need documenting and revision of drawings kept a track of. I have
recently taking over the administration of the drawings and their current
system is not capable of easily managing the data so I have taken it upon
myself to try and organise the data in a database. The problem arises
when displaying the drawing numbers with the revision dates and revision
letters like below in a grid fashion.

Day 1 17 9 20 11

Month 3 6 8 1 5

Year 02 02 03 04 04

Drawing Num

Drw1 - A B

Drw2 - A B C

Drw3 - A B

Drw4 -

I have studied database systems during my degree (IT related) but either I
have forgotten or not come across how to do this.

If anyone can help my by either pointing in a direction of where to look
or similar databases that use a similar grid technique I would be very
grateful, I'm not stupid and am prepared to put the work in to get the
right result.

One last thing, as this is being used in an office I only have access to
limited facilities and software that is on offer so the only database
available is MS Access XP, very annoying having studied and worked with
Oracle.

Thanks in advance

Les

Before you look at how to format the output, have you decided how you are
going to structure and store the data? Having studied Oracle, you must have
a reasonable idea of relational database structures and may have already
made some decisions. Perhaps you have started with something like:
tblDrawing: DwgNumber, DwgName, etc
tblRevision: DwgNumber, RevLetter, RevDate, etc

Perhaps you could explain the logic of the grid shown above. You have
columns headings with dates (e.g. 17 June 2002) and then show every drawing
below listing the revision letter on this date. Perhaps I have missed
something, but I can't see how that would be useful, unless all drawings are
updated on the same date.

I could imagine a grid with revision letters as column headings and the
drawing numbers as rows. The tabulated data would be dates - the dates on
which the drawings reached that revision level. This would mean you could
see at a glance the revision level of any drawing and the date it was last
changed.
Nov 13 '05 #2
Les
See notes per point below
"Justin Hoffman" <j@b.com> wrote in message
news:d0**********@hercules.btinternet.com...
Before you look at how to format the output, have you decided how you are
going to structure and store the data? Having studied Oracle, you must
have a reasonable idea of relational database structures and may have
already made some decisions. Perhaps you have started with something
like:
tblDrawing: DwgNumber, DwgName, etc
tblRevision: DwgNumber, RevLetter, RevDate, etc
Les: Yes I have implemented a similar structure to that listed above, this
is working well and I am able to bring up all drawings with the relevant
revisions in queries.
Perhaps you could explain the logic of the grid shown above. You have
columns headings with dates (e.g. 17 June 2002) and then show every
drawing below listing the revision letter on this date. Perhaps I have
missed something, but I can't see how that would be useful, unless all
drawings are updated on the same date.
Les: The drawings are not updated on the same date, we may be issued a
drawing on date n and another on date n+5. However we may have a
construction issue on a drawing and require that particular drawing to be
revised to take into consideration the issues that arose, thus having
another issue of the drawing, on another date. This does not mean that
other drawings are updated as they are still on the same issue/revision. if
the revision letter was issued for each drawing on heading date, this would
make it more different for quick visual checks.

However is another drawing is issued/revised on the same date it too uses
the same date thus explaining why it looks like all the drawings are
issued/revised on the same day (this is not conveyed well due to the non
fixed font, apologies)

Does this make more sense?
I could imagine a grid with revision letters as column headings and the
drawing numbers as rows. The tabulated data would be dates - the dates on
which the drawings reached that revision level. This would mean you could
see at a glance the revision level of any drawing and the date it was last
changed.
Les: this is the same principle but I wish to have the column heading as the
date, the row heading the drawing number and drawing issue letter in the
grid as this method take less space on the paper.

"Les" <no****@nospam.spam> wrote in message
news:d0**********@news.freedom2surf.net...
Hi can anyone help me,

I have just graduated and have started working for a building developer
which deals with a large quantity of drawings. As you can imagine these
all need documenting and revision of drawings kept a track of. I have
recently taking over the administration of the drawings and their current
system is not capable of easily managing the data so I have taken it upon
myself to try and organise the data in a database. The problem arises
when displaying the drawing numbers with the revision dates and revision
letters like below in a grid fashion.

Day 1 17 9 20 11

Month 3 6 8 1 5

Year 02 02 03 04 04

Drawing Num

Drw1 - A B

Drw2 - A B C

Drw3 - A B

Drw4 -

I have studied database systems during my degree (IT related) but either
I have forgotten or not come across how to do this.

If anyone can help my by either pointing in a direction of where to look
or similar databases that use a similar grid technique I would be very
grateful, I'm not stupid and am prepared to put the work in to get the
right result.

One last thing, as this is being used in an office I only have access to
limited facilities and software that is on offer so the only database
available is MS Access XP, very annoying having studied and worked with
Oracle.

Thanks in advance

Les



Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Prince Kumar | last post by:
I have the following query, which is takling couple of minutes to return 500+ rows! I have all the proper indexes and statistics is upto date. I correlation after the OR clause is the culprit....
1
by: Richard | last post by:
I have been asked to copy a handfull of table spaces in to new identical table spaces so that they can be accessed with out running into the nightly batch update. I first did a FULLCOPY with...
10
by: Nevets Steprock | last post by:
I'm writing a web program where one of the sections is supposed to output a correlation matrix. The typical correlation matrix looks like this: ..23 ..34 .54 ..76 .44 .28 ..02 .77 ...
1
by: Gary Wessle | last post by:
Hi I wrote a code to calculate the correlation between 2 sequence of double numbers presented as vectors. did I go about this the right way? thanks #include <vector> using std::vector;
18
by: robert | last post by:
Is there a ready made function in numpy/scipy to compute the correlation y=mx+o of an X and Y fast: m, m-err, o, o-err, r-coef,r-coef-err ? Or a formula to to compute the 3 error ranges? ...
2
by: truthinlife | last post by:
I am running the following commands on an AIX 5.2 server, using db2 udb v8.2.2. my ipcs -mb command gives me the following: IPC status from /dev/mem as of Mon Nov 20 12:47:25 EST 2006 T ID...
3
by: Vivek | last post by:
Hi, Can someone give an example of a query which produces the following warning: SQL0012W Correlation without qualification has occurred for the column "<column>".
0
by: acesfull | last post by:
Hi, I am trying to do something in SQL that I have done in PHP, but I am trying to have the operation performed as a stored procedure because of the sheer number of inserts I have to perform in PHP. ...
0
by: isthikar | last post by:
hey i am a final year student of b.sc in computing and i am doing my final year project which is a event correlation system to windows domain controller i gona develop using c#.net.... i need some...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.