I need a suggested book.

Hi experts,

Please see this link for information about what I need the book for, and then, offer me any suggestions you have about what book explains principles of architecture relating to this topic.  If you have any further insight on the topic itself, I could use more of that also,,, Thank you EXPERTS!

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Try going to a bookstore with a nice storefront, a good rack of books, and a soft chair to browse before purchase. One reason to do so is that many books will do little more than repeat what you have already learned.

One secret is to look for books from reliable publishers, where lately we've been giving more credit to O Reilly than others.

Another is to take in the whole design, and think of where your weaknesses lie, for what part of processing is more interesting, and for what your job will let you practise.

If you want to run internet, front and backend, then studying more Oracle for the backend would be warranted, and probably more Java at the front end. Maybe try Visual Basic for front end. Try cgi with anything, but preferably compiled. Security is not addressed well, that is probably someone else's job where you are at.

Answer: Bookstore
Jose ParrotGraphics ExpertCommented:

By reading the accepted answer there, I conclude you are looking for Visual Studio 2005 + SQL Server 2005 + Crystal reports.

I disagree to this approach by a simple reason:
Microsoft stuff is toward Microsoft stuff. Zero portability, zero open, althought MS marketing says the inverse.
The more you use it to develop applications, the more you need buy Microsoft stuff to install in your clients' PCs. Be prepared to spend US$ 200K/year in unnecessary Microsoft licenses. Crystal reports, for exemple, is based on Microsoft Office. Even for a extremely simple table, with no formulas, just numbers and strings, something easely solved with a table in pure HTML (so a simple browser is enough to read it) will force your clients to install Office in each workstation.

Of course, Visual Studio 2005 + SQL Server 2005 will integrate well. But will Vista support your application for a long time? Why you'll need to upgrade your application if it is working well? Because MS make new dependencies for their products in each new "inovation" they create.

Please, note, I'm not recommending you to never use MS stuff. Visual Studio 2005 and SQL Server 2005 are very good tools, and you can, for sure, adopt it. But be aware of unique features of such tools to avoid extreme dependency.

The accepted answer at the link you provided, stated that "as long as you're coding a web-app the only dependency you will be creating is to the server OS". That's true, but pay attention for dependencies on .net environment runtime, which MS offer that for free - why for free if MS target is profit? No need to think very much.

As you have a sizing audience, the best approach is a 3 tier application:
 - a database server. SQL Server is good, Oracle is better, MySQL is cheap and probably enough.
 - an application server. This is your code, the server side, where the dynamic pages are created and queries constructed.
 - a web server.  IIS is good (but avoid unique features of it). Apache also is good.

The infrastructre can be solved with 2 servers: one for database and the other for web and application.

You need also web tools, like Macromedia MX Studio - Dreamwaver (very good), to construct the pages. FrontPage is a limited and inefficient tool, but can be used, if you also don't use its unique features.

All the above is about tools.

Let me say now about methodology. This is MUCH more important.
You must use a version control to support your development. The old MS SourceSafe is good.
You must document each module, each function, procedure. Use PDF files.
You must model your application. Probably the best way is a modeling tool, like IBM Rational ClearCase or other case tools, in the sense of have a well modeled application.

Without all the care on a solid foundation for your application, you'll have trouble for the eternity.

If you agree with these points, I can suggest an appropriated literature.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
>>"Crystal reports, for exemple, is based on Microsoft Office. Even for a extremely simple table, with no formulas, just numbers and strings, something easely solved with a table in pure HTML (so a simple browser is enough to read it) will force your clients to install Office in each workstation"

What total nonsense.  Crystal Reports ( a product of a company called Business Objects, which is in no way affiliated with Microsoft) is a totally independent Report generation tool kit, that has nothing to do with MS Office, and the use of CR in no way requires or is related to MS Office.  Using CR will not require any interaction with MS Office.

Jose ParrotGraphics ExpertCommented:
Thanks to AW for correct point. Maybe I wasn't clear.
Actually I didn't said that Crystal is owned by Microsoft.
I said that CR programs are dependent on MS Office.

For exemple, to find a sample in CR CDs, the programmer needs Access.
The CR manuals has lots of samples on how to integrate CR to Office.
When creating a schedule format, the CR administrator wizard menu's has the options: Crystal, Excel, Word, etc.
Most selected is Excel. Why? Because he/her don't need to read the manual to use Excel...

This is the same trap for programmers. To have efforless programming, the programmer choses the easy way, by "integrating" its code to MS Office, so the programmer is in a trap. Soon the company will need to install MS Office in all workstations.

I agree that using CR will not REQUIRE any interaction with MS Office. But I know too that CR will ALLOW such integration. This is the trap. Why are Microsoft Platform SDK, DirectX SDK, CE SDK, and a lot of MS SDKs for free? These DSKs are millions and millions of lines of code. For free???? Think about.

I don't hire and will fire every programmer, despite their experience or certifications, if they are effortless minded people. The less the programmer works the more the server is large and the software costs are high.

Actually I consider such discussion of secondary importance.
The real important start point is the application design, defined by bussiness needs.

As you are to develop an application to hundreds of users, I want you to avoid such traps.
Another danger is the lack of documentation for each use case.
And, let me suggest to redirect your attention to this first step and hire an experienced consultant.
I think you need now a strategy police, to later define the tatics and finally decide the technological aspect of your project. The tools choice will be a consequence of a well defined project.

As an argument to the company executives, you can present the hidden costs of a bad design compared to consultant cost.

travishabermanAuthor Commented:
Thank you!  ... I did have a follow up question for some more points...

see here...

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.