Solved

architecture design

Posted on 2011-09-15
3
455 Views
Last Modified: 2013-11-12
Hi,
I have to design architecure for the following scenario.

1) A Customer places an order to a company. The companys operator types in the information of order on screen.
(This is a desktop application in .NET) The problem here is that he may type something incorrectly. The database maintained is Main frames.

now the client wants me to create an architecture to avoid having these wrong entries in main frames database.

So I thought of this solution. (I am really not sure this is right or not but just a thought)
-------------------------------------------------------------------------------------------------------------

Customer places an order and the data entry guy enters the records and We can have a Database inbetween the UI and Mainframe
lets say sql server or oracle. not sure what client would opt for.

The entry made will get to sql server and every night the customer is sent an email with excel sheet for all the orders he requested for
on that day, AS Well he can go to a website where he can login and see all the records of that day which are at present in sql server or oracle (not sure again what the db might be)

When he finds some problem in entries he can call the customer service dept to rectify. fine till here.

1)Now just wondering when should the database records be pushed to IBM Main frame?
 Note: All their data is currently in mainframe linked with all departments

2)when data (ie not verified ones) get into sql server first time,should the data be replicated to IBM mainframe,if so mainframe has wrong entries which are not verified yet by customer isnt it?

3)What about in this scenario, if sql server goes down for some reason. Neither the data will be in sql server nor main frame isnt it?

So what is the best architecture design in this scenario.
0
Comment
Question by:sai0824
3 Comments
 
LVL 77

Accepted Solution

by:
arnold earned 250 total points
ID: 36547298
You have to have a business logic which deals with field entries matching the context, i.e. a date field can be validated, a date of birth, etc.
Not sure how you would go about eliminating all wrong entries or at least how you would go about determining which entries might be wrong.

You could have a two stage process. The data is added, then someone has to review the request to make sure it is complete if not the data needs to be corrected/completed.

Is the purpose of pushing it into the mainframe as a warehouse data storage?

Presumably even if the data is pushed into the mainframe, the option exists or at least should exist that there might be modification down the line.
0
 
LVL 8

Assisted Solution

by:Volox
Volox earned 250 total points
ID: 36561268
You need to get the people you are working for to understand that even the best laid plans result in data entry problems.  Even if you have this interim review process, if the reviewer gets sloppy and misses something, it's going to get into the mainframe.  You need a system that is designed so that corrections to the mainframe data can be pushed and not just depend on everything being correct before it gets there.

That being said, I'm not sure what type of information you are validating or what the rules are around it, but you might consider some automated algorithims to check for common errors.  As arnold mentions you can obviously check formatting for things like dates, SSNs, etc.  For addresses there are third party pieces of software you can buy that standardize and check the address (depending on what your budget is for such things).  You could either auto-correct and / or you could use these checks to find places where the entyr probably isn't correct and highlight those for the reviewer.

In terms of 'architecture'... I think the business requirements side of the problem needs to be better defined.  1/3 of an architecture is the business processes that go with the technology and it sounds like they might not nessecarily have that part figured out yet.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now