473,289 Members | 1,963 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,289 software developers and data experts.

Help With Database Design: Multiple Vendor Data Submitting

I am at kind of a loss on how to design a certain database project I am
working on. Basically, we have a proprietary program with a standard
backend (though we do not have direct write access to the backend).
What I am working on is a project to take certain data from the
database, send it to certain vendors, process the data, and send it back
to the proprietary program.

Here is the basic flow as is supposed to happen:

1. Extract data from the program based on a single criteria.
2. Format the data.
3. Send data to Vendor1.
4. Get back data from Vendor1.
5. Based on the responses from Vendor1, take any results that Vendor1
could not handle and send to Vendor2.
6. Get back data from Vendor2.
7. Combine the results from Vendor1 and Vendor2 as appropriate, and
then import back into the program.
The vendors perform validation of our certain parts of our data. Only a
subset of the data sent to Vendor1 is sent to Vendor2 as we are assuming
that Vendor1 has the best data.

When we get back results, there are a few possibilities:
1. They can tell us that they have high confidence that the data we
submitted is either correct or that the data the provided is better.
2. They can tell us that they have low confidence that the data we
submitted is either correct or that the data the provided is better.
3. They can tell us that they have can't help us with that particular
submission (submission being defined as a row of data; more than one row
is typically submitted in one batch).
4. They can tell us our submission was not formatted properly.
5. They can tell us that their data processing servers hiccuped and
that we should feel free to try again.

One of the tricky issues is that submissions to Vendor1 and Vendor2 use
different specs. While currently we are sticking with these two defined
vendors and their specs I have to allow for the possibilities that:
1. Additional vendors could be added to the process.
2. Those additional vendors could be put in anywhere within the process.
3. The specs could change for submission to those vendors.

Additionally, I need to keep track of how the information is processed
so that I can go back into the code of our separate processing tool and
figure out how to fine-tune the processing. Also, since we get charged
by the vendors for their services based on what they send back I need to
keep track of:
1. What submissions were done.
2. When they were submitted.
3. What came back.
4. How confident they were in their data.
5. How many times a row was submitted.
6. The data flow from when the data is pulled

At some point more than one person may be submitting data, but at this
point I am the only one who deals with this particular process.

I figure there are basically two ways of dealing with this:

1. Create one table for each vendor, with each table designed for the
specs of the submissions.
2. Create one table for all submissions, with the table having
redundant rows because the submissions defer depending on which vendor
is used.

In trying to go through google I was hampered by the fact that I do now
know the technical term for such a database setup. If someone could
just tell me what this kind of setup is called, I should be able to find
the resources on my own. Failing that, if someone knows of an archive
of different database designs for different industries I would be most
appreciative.

Marc DVer
Nov 23 '05 #1
0 1274

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

Similar topics

2
by: Mark Hoffman | last post by:
I'm a newbie at Oracle..Be gentle! I have a table that stores information (WMI data) about computers on our network. The table looks like: ComputerID ItemID Class Property Value
2
by: Anders | last post by:
We need to create a lookup structure that can contain a flexible amount of attributes. We have discussed different design solutions for lookup-functionality, and come up with this suggestion: ...
17
by: Dan Williams | last post by:
I am using Microsoft SQL Server 2000 and have a question about our database design. Here is a sublist of tables and columns we currently have:- Employee ---------- Ee_Code PRIMARY KEY...
15
by: sara | last post by:
Hi I'm pretty new to Access here (using Access 2000), and appreciate the help and instruction. I gave myself 2.5 hours to research online and help and try to get this one, and I am not getting...
2
by: Kalpesh | last post by:
Hello, I am facing a design problem here & need your expert design advice on this. Scenario: I have a class called Vendor - which has several simple attributes like Name, Address etc Now,...
0
by: Kalpesh | last post by:
Hello, I am facing a design problem here & need your expert design advice on this. Scenario: I have a class called Vendor - which has several simple attributes like Name, Address etc Now,...
15
by: Jay | last post by:
I have a multi threaded VB.NET application (4 threads) that I use to send text messages to many, many employees via system.timer at a 5 second interval. Basically, I look in a SQL table (queue) to...
6
by: sathyashrayan | last post by:
Dear Group, Please look at the following demo link. http://www.itsravi.com/demo/new_pms/admin/addproject.php
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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)...

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.