Let's list some features that MySQL's new Enteprise DB should have:
- communication abstraction layer (e.g. local communication or sockets like SAPDB's x-server and the API it uses)
- each DB has it's own independant threaded kernel-process with its own paramaters (e.g. if one kernel crashes, the others aren't afftected at all)
- user scheme like all other enterprise DBs (each user has its own tables etc.)
- two online modes a DB (e.g. admin mode, warm mode)
- storage abstracting layer (e.g. files, raw devices)
- ANSI SQL Syntax
- foreign keys
- transactions
- smarter limitations (e.g. postgresql has a row-limit of 1.6TB)
this might be not that important for others, but it is defenitly one of my favorites:
- table inheritance (with renaming, ORDBMS)an ORDBMS would have saved me a lot of work/tables on my last project!
- Unicode support (i think UTF-8 is crap for sorting and other stuff, should be UCS2 perhaps)
- correct sorting of Unicode chars (perhaps user-definable sorting-maps)
- query optimizer with query-rewriting - backup sollution (not just stupid dump mechanisms)
- ....
more to come. please extend the list.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
