Americas

  • United States

Converting a SQL database to XML; Which is the best database OS?

Opinion
Apr 24, 20062 mins
Enterprise Applications

* Dr. Internet columnist Steve Blass offers advice on converting a SQL database into XML * Help Desk columnist Ron Nutter discusses database operating systems

* Converting a SQL database to XML

By Steve Blass

Q: I want to convert the database definition of an existing SQL database into an XML schema, so I can use the schema with model-driven development tools (Eclipse Modeling Framework) to create a new distributed application that works with the data. Are there tools available for converting SQL databases into XML?

A: Several SQL-to-XML conversion and translation tools are available. The Enterprise and Professional versions of the XMLSpy products from Altova.com can produce an XML schema from a relational database.

To read Steve’s response in its entirety, please click here.

* Which is the best database OS?

By Ron Nutter

Q: NetWare is often held up as the best x86 platform for file and print, due to its architecture. For example: stripped-down kernel, cooperative multitasking and protocol optimization for network file requests. Is there similarly an OS that is architecturally the best for a dedicated database server?

A: This is not a simple question. There are really two choices to be made. One is the OS that the database server will run on and the other is the database server itself. First, decide which database engine you want to use. The application, or what you want to do with the database, may dictate that for you. Once you have made that decision, that will probably dictate which server OS you’ll be running on. You will have a better time implementing a dedicated database server when it fits your needs instead of having to adjust to what the database can do.

To read Ron’s response in its entirety, please click here.