Thursday Jan 17, 2008

Hi MySQL, welcome to Sun

{short description of image}Wow, the MySQL announcement from Sun has certainly made a lot of noise in the blogosphere. The Register comments here..., and also post their interview with Rich Green & Marten Mikos. You've probably seen Jonatahan's Blog and Comments.

The Register Article has some interesting, and some wrong headed and tedious comments about the MySQL current licencsing policies, it'll be interesting to see how it moves forward. We all obviously have a lot to learn, it should be fun.

tags:                

Thursday Sep 15, 2005

Sybase 15

I popped into the Brewer's Hall at the invitation of Sybase for thier UK launch of Sybase 15. The have three great new features to help them compete with Oracle and the free ones, and its good to see them spend some money and more importantly intellect on the database server.

The optimiser has been given a major overhaul. They've looked long and hard at what they can do and what academia and the market say is possible and adopted more modern, flexible and cheaper query plans, including multiple entry points, eliminating work tables, minimising the use of nested loops, new storage structures, more row level locked defaults etc. Some of the query performance improvements they claim would be unbelievable if you don't understand what they've done. This has been done to support their re-engineering of the size limits to allow VLDB implementations, together with changes to enable more effective OLAP mixed work load solutions. However, perfromance improvements can/will be obtained by more traditional OLTP implementations.

Sybase 15 has improved XML support, both storage and more excitingly, the ability to expose stored procedures as a web service. This might not be enough to encourage people to locate the data server in a DMZ, but either Sybase replication or standard web proxy architectures should be sufficient to protect the solutions.

Another featured highlight is LDAP implementation, I was discussing with Mark Hudson of Sybase about this because it extends the solutions design capability based on Sun/Sybase co-operation and he pointed out that Sybase have been on a road to LDAP implementation since V12.0, initially offering support for the server maps but now offering User authentication. I expect that understanding the definition, storage and aquistion of privilidges and aliases will need a fuller reading of the documentation.

They've also responded to customer calls and the markets growing requirement for more pervasive Encryption. My final personal highlight is that they've improved statement level statistics capture, permitting the simpler tracking of rogue queries.

Mark also let slip that Grid enablement is next. It'll be interesting to see what competition will do to the market's solutions designs when active/active HA databases become non-proprietary.

tags:

Sunday Aug 01, 2004

Sybase commits to Solaris x86???

Since starting to write, I have been reading others entries to the Sun blogging community. This is a link & repeat of John Gardner's web log entry about Sybase & Sx86. Click here .... for John's original blog. The entry & hyperlink interested me as Sybase commit their ASE to Solaris x86, even as a developer cut. Click here .... for the download. I've been using Sybase for a long time as those of you who have access to internal publications know and am glad to see them follow me & Sun into fabric, Solaris based computing. This will give those sites committed (or locked into) Sybase two advantages. The first is that since Sybase have historically worked hard to ensure that hardware is not a performance constraint, internal contention is more frequently the problem than with its competitors. Utilising Solaris x86 and the x86 CPUs will allow Sybase to 'crack' serial hot spots or "code paths" more effectively. Secondly, Sybase has always had an effective 'data movement' solution and the new platform changes the price and hence enables a the deployment of distributed database solutions, based on caching patterns or real life geography.

I've started to write a Sun paper on consolidating Sybase on Solaris, its 30% written and you may see some of it here. I will be downloading the sybase binaries onto my Sun laptop sometime soon.

Version 1.2

About

DaveLevy

Search

Archives
« April 2014
MonTueWedThuFriSatSun
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
    
       
Today