Business Objects vs. MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

They are rolling out Business Objects where I work. In my gut, I think MS
Access iis probably better.

Does anyone here know the differences (performance-wise) between the two?
 
They are rolling out Business Objects where I work. In my gut, I think MS
Access iis probably better.

Does anyone here know the differences (performance-wise) between the two?


If "Busines Objects" means some 3rd party software, then you will have a
learning curve

If "Busines Objects" means some programmer at your office developed a class
library, then it will also have a learning curve, but it will let you change
your code so that it's tighter. Imagine the Northwind database, how cool it
could become, if it had programming that thinks in terms of customer
collection of customer objects that had methods, instead of having to
manipulate recordsets.

While performance is important, you also have to think about how
maintainable the code is. If your application can operate on a high level
of abstraction, then GREAT! If your application is "married" to the nuts
and bolts of the physical storage, then people like me will be sending
proposals for incredible amounts of money to fix it.

Here are some references:

What to do:
http://www.amazon.com/gp/product/02...102-0597696-8121709?s=books&v=glance&n=283155

(Or if that has "session junk" in it, then just goto Amazon and do a search
on "Design Patterns" and look at the first book on the list. It should be
white with a blue border)

What NOT to EVER DO:
Anything on this guy's web site should be absolutely forbidden:
http://mindprod.com/jgloss/unmain.html
--


Peace & happy computing,

Mike Labosh, MCSD MCT
Owner, vbSensei.Com

"Escriba coda ergo sum." -- vbSensei
 
I worked with Business Intelligence (Objects) a few years ago. The
difference between it and Crystal was that BI has a security level. When you
connect into the DB with Crystal you had access to everything, however, with
BI you had access only to what the Universe allowed you access to. A
Universe is simply a part of the complete DB. You can create many different
Universes giving the end users access to only specific parts of the complete
DB. I mention Crystal because the two companies have now merged into one.
BI was very easy to use.

Look up BI or BO (spelled out) on the internet, there is a lot of info.
They have come a long way since then. There are some really useful new
features.

Hope this helps.
 
Business Objects is crap.

use Access Data Projects and a beefy 4-processor relational server.

get a 2nd sql server (probably only a dual proc) for olap

-Aaron
 
Back
Top