|
I have done such work before. I agree with Prateek that combining table 2 and 3 is better. It results in de-normalised tables but the benefits you get in reporting are huge.
Plus I would strongly recommend that you have only one amount not TranDrAmount and TranCrAmount and make Credits positive and Debits negative. This makes calculating the net balance for an account (which is done very frequently) just a simple SUM statement on Table 2. If negative is is a debit balance and if it is positive it is a credit balance.
HTH
|
|
|
|
|
Whatever you do, make sure you have three distinct databases:
One for yourself,
One for your business partner(s), and
One for the Infernal Revenue Service.
That is the way to succeed in business!
|
|
|
|
|
Hello!
I am a UX Designer for a firm based out of Tampa Florida. We design software for engineering firms as well as architect firms. Currently, we are working on ERP software. You know, that boring stuff whee you fill out timesheets and manage projects.
Anyhoo....
We are trying to make user friendly applications, which means your opinion matters most to me.
The issue I have currently is this: as an architect working at your firm, if you were to log in to a dashboard for a business system, what would you like to see on your dashboard? Things assigned to you, performance items, to do lists, number of vacation days left... the sky is the limit.
Any serious feedback would help tremendously.
Thanks!
|
|
|
|
|
I would think looming milestones in projects where I was a stakeholder would be a biggie, but then I'm not an architect.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
Architect or not, this is the exact feedback I am looking for! Thank you for responding - any other ideas would be welcome as well!
|
|
|
|
|
They're called KPI's (key performance indicators), and will vary by individual and circumstance; and in how they are "visualized" (e.g. gauge; slider; meter; diode; etc.)
For example, my KPI's this afternoon are: Temperature; Precipitation; and Wind Velocity.
(I'm walking the dog).
|
|
|
|
|
Gerry Schmitz wrote: will vary by individual and circumstance
Fully agreed. I tried to point this more out in my own post below. I feel like the UX dude is forced to do the Bussiness Analyst's job in this very example.
|
|
|
|
|
While you question is interesting, the answer from me is...
it depends.
It depends on ones preferences, experience, and focus. There isn't *one* type of architect. There are a lot of people, working as architects.
And while you *could* go out and ask every single one of them, you shouldn't. UX is important, but what you're asking us is something that should be answered by a business analyst working on your project and in the end be sealed into requirements.
UX gets into the game once you display the stuff the BA requested, and not replace the BA's job.
|
|
|
|
|
Why are you asking a bunch of software geeks what your users want, ask the bloody users!
Half the time they have no firm idea but should put up some suggestions. If they are too useless then give them a blank page! Seriously we can't design a dashboard for you, it has to come from your users!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Sorry - I was under the impression this was in an architects forum. I was, indeed, trying to ask the users.
We have a full system with full requirements from a BA. Trust me when I say, I do not want that job. However, often times, the BA requirements are coming from the business, which is fine, but in our case, is often disconnected from what the users want to see.
But thank you all, this has been helpful, and your feedback (coupled with feedback gained from other boards, and some of our actual users) we have what we need to begin.
Thanks again!
|
|
|
|
|
Member 12507295 wrote: what would you like to see on your dashboard
Nothing...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
Hi all,
I have to create an integration layer between WCF XML/SOAP and JSON/Rest
Mostly i have to get WCF and send Json/REST, from LOB apps (all over WCF) to my app, and that is assyncronous a few times a day.
I have also some online comunications in both directions.
The question is should I use any integration framework, or do it from scratch.
I am used to do integrations by hand, but now i have about 60-70 diferent calls from 5 diferent LOB apps to integrate.
If i should use any framework what do you would recomend?
Regards,
Rui Silva
|
|
|
|
|
In each WCF set up an extra end point that delivers JSon this can all be done in the config. Plenty of responses on google[^] covering this subject.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Tanks RAH
That will be the best approch. However i dont control the WCF services.
Even if i control them i cant be sure if they deliver basic types that can be read by non microsoft systems. (Ex. Java does not understand .net datatable)
|
|
|
|
|
I doubt there is a "framework" to service such an obscure requirement. You are going to have to build a service (wcf or webapi) that sits between the existing wcf and the client app(s) that changes takes the datatable from source and serves up the formats you want.
Bloody ugly solution to fix a really silly situation. You really should be talking to the WCF owners!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
An ESB would do that, but that's probably a big hammer to address a fairly narrow issue.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
Sounds like you have too much "plumbing code" imbedded in your "LOB" code.
I create a separate API / Wrapper DLL for every unique web service I deal with: The "LOBS" all deal with clean interfaces; the API libs each in turn deal with whatever protocol is needed.
|
|
|
|
|
We are in the process of Architecting a mobile app to be developed using Qt and Azure Mobile Services. Coming from C#.Net background and worked on WPF applications, it's something new for us. We have used MVVM, MVP in past along with Layered architecture.
Which architecture pattern will be the best fit for this kind of application?
Read about Layered and Onion architectures. Onion architecture provides loose coupling in a better way and adhere to DDD somewhat.
Please suggest if something else will be a good fit.
Also, like to know which development methodology(DDD/BDD/TDD) shall be used considering the duration to be 4 months.
|
|
|
|
|
Why are you looking at it from the wrong end? The first thing you need to do is to get the overall design of the application worked out. Only then can you really see which patterns, methodologies etc will fit with what you are trying to create.
|
|
|
|
|
Thanks Richard. Can you suggest what should be covered in overall design? Is it going to UML diagrams(Component, Class, Use case). In Agile world, how much design would be enough for such an application.
|
|
|
|
|
Well you know what you want this application to do, so you should be able to identify all its requirements and get them documented. Like I said above, you need to get your design complete first, then you can start looking at what processes and patterns would be most useful to turn that design into a working product.
|
|
|
|
|
|
The question looks quite blunt.
MVVM, AFAIK it's like a MS trademarked one. (Though there are a pile of frameworks for Web-client). It's tightly bound with WPF/SL & similar MS frameworks.
MVP/ MVC, unless it's with frameworks like Cocoa (mac) & Asp.net MVC, which gives you some guidelines with implementations, it's just a pattern you can implement anywhere by yourself.
All these what we are talking about is UI design patterns.
And the link you've shared talks about Software Architecture in general.
First decide what UI pattern framework is available right out of the box in Qt. This is just for the UI to Data binding design.
The rest is the whole story. It all depends on what you need in your App. You can create you own "patterns" as per your need!
Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy.
|
|
|
|
|
|
Hi all,
I'm contemplating what would be a good approach to find all the files of a certain filetype (*.bgl) that a third-party (unmanaged) application loads into memory - basically to get an overview of names and paths of them.
Could someone of you please give me a hint or reading sources? I found the article "C# How to Scan a Process' Memory" but I'm too unexperienced to tell if that approach makes sense for retrieving a filelist only.
Thank you very much in advance,
Mick
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
