Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 "Update-intensive RDBMS"

Author  Topic 

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2003-05-28 : 10:10:53
All ye yaks:

you might want to take a look at this baby - http://www.antssoftware.com/ants_data_server.htm

OS

SamC
White Water Yakist

3467 Posts

Posted - 2003-05-28 : 10:23:30
Coming next. ANTSTEAM.COM ?



Go to Top of Page

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2003-05-28 : 10:28:53
And the Tpc-C is .... ?

Anyone know of any place actually using this? Any case studies ?

*#&#* *#&#* *#&#* *#&#*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2003-05-28 : 11:00:46
I think it hasn't been released yet. I am curious to download the evaluation edition when I get home....



- Jeff
Go to Top of Page

gfahrlander
Starting Member

23 Posts

Posted - 2003-05-28 : 11:06:36
I went there, I looked, I didn't see any ants!

No trees were killed in posting this message. However, a large number of electrons were seriously inconvenienced!
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2003-05-28 : 11:25:06
Hey code is code...I bet you you can still make it grind to a halt...



Brett

8-)
Go to Top of Page

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2003-05-28 : 12:04:57
Any database server that uses versioning instead of locking is likely to have an advantage in situations with heavily contended updates.


Go to Top of Page

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2003-05-28 : 12:58:54
This is part of the interview of the Ants Software COO (Courtesy:ADTMag)

ANTs Software's just-announced Data Server 2.0 is a SQL database management system with a twist. Designed for update-intensive applications like stock trading, telecommunications and package tracking, the product is said to be based on supercomputing principles revived from the 1980s that better match the demands of operational databases with the available performance and speed of modern hardware.

"The problem we're trying to solve is the database locking problem -- you can only have one person updating that classic inventory record at the same time," said Gary Ebersole, ANTs' president, COO and CMO. "We look at this problem and say it's still real, it'll always be real."

SQL is well established, but a lot of things have changed since it was invented. "The core technology was really never designed for high concurrency, and it wasn't designed for wireless applications where you have 240 messages a second from 10,000 users," said Ebersole. "And you can do a lot of tweaking to old technology."

Which is where supercomputers come in. Formed in 1985 as CHoPP Computer Corp., Ebersole's company was dormant for more than a dozen years until it was revived and renamed in 1999 as ANTs, short for Asynchronous Non-preemptive Tasks, the supercomputer-era concept that Ebersole said is the key to getting around the database locking problem.

"In the performance world, there are two issues: latency vs. throughput. In most transactional systems that involve human beings, throughput is more important. You want predictable latency, low latency, but not extremely low latency," Ebersole explained. "But [when] you need to get massive amounts of data through, most database systems choke -- the more workload you put on it in an update-intensive world, the slower the response time becomes and the overall throughput sometimes drops."

ANTs' solution: A message-passing architecture, built on a proprietary micro-threaded engine, within the application space.

"It allows you to be incredibly efficient because you can keep that thread busy all the time," said Ebersole. "And the key to performance is not wasting any CPU cycles doing dispatch services from the operating system, waiting for locks. It allows you to be massively efficient, and efficiency is performance. The shorter the code path, the faster it runs."

Ebersole conceded that Data Server 2.0 isn't, and was never intended to be, a world-beater on the relational database market. Established offerings from big companies are fine, he said, for 90% of developers. They aren't typically dealing with the problems of high concurrency and high workloads. ANTs, he said, is intended for that other 10% of developers.

"Microsoft and Oracle want one tool for all jobs. In their world, they've got the biggest hammer and everything's a nail," Ebersole explained. "We argue that there are problem sets that really require a screw."


Go to Top of Page

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2003-05-28 : 13:40:08
quote:

"Microsoft and Oracle want one tool for all jobs. In their world, they've got the biggest hammer and everything's a nail," Ebersole explained. "We argue that there are problem sets that really require a screw."


Get nailed or get screwed, the choice is yours

Go to Top of Page

cas_o
Posting Yak Master

154 Posts

Posted - 2003-05-30 : 11:56:56
MMMmmm Mmmmmm Update me baby oooohhhh

;-]
Go to Top of Page
   

- Advertisement -