Access Locks Up

[vanzandt]

Don't use the list on olapreport.com as your yardstick for database
popularity. Not all databases can be configured to fully support OLAP. OLAP
is online analytical processing, which uses multidimensional data models.
Multibillion dollar businesses and governments use OLAP databases for their
data warehousing and business intelligence because they're the only ones who
can afford it. That's a pretty small segment when compared to the whole
database market.

The database products which can fully support OLAP and are listed on
that page will set you back thousands of dollars up to over $100,000. Access
is a relational database that costs over $100. Alot more affordable and
without alot of the features the big databases provide that cost so much.
OLAP databases need to be designed and operated by expensive, trained users
vs anyone who can use a Windows PC can build and use an Access database.

Access isn't designed to support OLAP and Access users don't need it
to. You can't expect to see it or any other non-OLAP database on that list.
Access supports small relational databases for a small group of users on a
LAN and does it very well at small cost. I daresay that's why it's so common
in so many small businesses, schools and homes all over the world.

bs, I mean come on, Chris

I don't see MS Access anywhere at www.olapreport.com/market.htm

-Aaron

 

[aaron.kempf]

Dude

you're a mother fucking idiot.

SQL Server Analysis Services (Standard) starts at about $1200.

So sorry that you're mis-informed.

and Olap is just one piece of the equation..

RBDMS --> SQL Server beats Jet
SSIS --> SQL Server beats Jet
SSRS --> SQL Server beats Jet
SSAS --> I've built hundreds and hundreds of cubes.. and there isn't
anything in the world that Jet can do that can even compare

 

[vanzandt]

Access and the PC, monitor and OS to run it start at about $650. And
that's all you need to support a typical company's Access databases. SQL
Server Analysis Services needs hardware and software (and usually
networking) costing many thousands of dollars to support a company's OLAP
requirements, in addition to the $1200 starting price. Plus expensive,
skilled employees to design, use and support OLAP databases.

Access is a desktop database which doesn't require expensive computer
equipment or highly trained employees to design or run it. Just about anyone
can install and run Access. The same can't be said about SQL Server's OLAP
support. But most companies don't need that anyway. They just need an
affordably priced, multiuser relational database management system that can
reliably handle up to 1 to 2 GB of data. Access is the answer to that need
far more often than not.



SQL Server Analysis Services (Standard) starts at about $1200.

So sorry that you're mis-informed.

and Olap is just one piece of the equation..

RBDMS --> SQL Server beats Jet
SSIS --> SQL Server beats Jet
SSRS --> SQL Server beats Jet
SSAS --> I've built hundreds and hundreds of cubes.. and there isn't
anything in the world that Jet can do that can even compare

 

[aaron.kempf]

I'm not so sure that it starts at that much, and I see older versions
for -cheap- on ebay.

I technically prefer SSAS 2000 to any other flavor-- for dev of simple
cubes

-aaron

 

[aaron.kempf]

Expensive skilled employees.. to use and support Olap databases...
uh-- do you mean the excel dorks that litter the IT world?

They love pivotTables more than most kids in harlem love crack
cocaine.

Access without SQL is fucking pointless... It's a platform that has
been obsolete for a decade.. It has no migration path..
Putting SQL Server on a desktop-- and using MSDE / SQL Express-- is
the same expense as doing anything similiar with Jet.

Except SQL supports SMP (and Jet doesn't) and SQL also utilizes this
thing called 'MEMORY'-- which means, the simple math is that SQL
Server can read stuff out of memory faster than jet can read it from
disk.

At the same price-- there is no comparison between Jet and SQL Server
performance
or stability
or ease of administration
or scalability

Jet doesn't win any argument, and it hasn't in a decade

It's not easier for development either (if it is, that just means
you're too much of a retard to know what SSMS / QA / EM is)

-Aaron

 

[aaron.kempf]

They just need an
affordably priced, multiuser relational database management system
that can
reliably handle up to 4 GB of data (that has automagic linking to
other databases on the same server). SQL Server Express is the answer
to that need
far more often than not.