database

Last day to participate in ITVidya.com oracle quiz and win Free Passes to Oracle Developers Conference in Bangalore on May 17-18, 2007.

Get to WIN a Sony PSP at the event! Attendees will receive hands-on lab manuals, free software DVDs, event T-shirt and more!

For a detailed agenda for what's in store for Developers at the Oracle Develop Conference, visit http://www.oracle.com/technology/events/develop2007/schedule-apac.html

The much awaited Oracle Develop - the premier conference for developers is coming to Bangalore on May 17-18, 2007. This is a must attend event for all developers to learn about the latest in technology and to network with others.


Attend for Hands-on labs sessions, real case studies and product roadmap and strategy information.

Dear Members,

Second free service pack for SQL Server 2005 database application released by Microsoft

SQL Server 2005 Service Pack 2--a large, recommended bundle of tweaks--aims to make the database software compatible with Microsoft's new Windows Vista operating system and Office 2007 suite. The update, released Monday, also adds a number of data compression, manageability and interoperability enhancements.

Open-source players MySQL AB and Open-Xchange Inc. are teaming up so Open-Xchange can embed MySQL's database into its Linux-based collaboration server.

The two companies announced a partnership and support agreement last week to optimize the interaction between MySQL databases and Open-Xchange groupware functions. Open-Xchange customers won't have to pay extra for product support for MySQL, they said.

The partnership will result in more choice for customers in the way that they use the Open-Xchange server and can help users cut costs, according to Open-Xchange.

MySQL was interested in supporting the integration because an increasing number of companies are choosing open-source collaboration products, like Open-Xchange, instead of proprietary products, the database vendor said.

Open-Xchange competes with other open-source collaboration products from Scalix Corp. and Zimbra Inc. as well as established proprietary software including Microsoft Corp.'s Exchange and IBM's Notes/Domino.

The move is typical of a growing wave of significant partnerships being struck between commercial open-source players designed to simplify the integration of their respective products.

For instance, back in June, open-source customer relationship management software vendor SugarCRM Inc. announced a relationship with open-source business intelligence company JasperSoft Corp. to allow SugarCRM users to generate reports using the co-developed JasperReports for the SugarCRM reporting engine.

ITVidya will highlight some of our members and other invitees who are contributing to the growth of IT industry and making a difference to the careers and business life of IT Professionals.

We will pose a few questions to them to get to know them better, learn from them, understand their future aspirations and contributions they want to make, and also find ways in which the community can contribute to them.

Members are also encouraged to get to know them better by asking them questions, or share about them if they know or have benefitted from the member.

The first in the series of Star Member is Mr. Ivan Bayross.

We are delighted that David Axmark, co-founder of MySql has agreed to be interviewed by our members at ITVidya.com.

David Axmark was involved with the MySQL database well before it had a name. David's primary focus now at MySQL is Open Source licensing and strategy, as well as community evangelism. He actively promotes Open Source software and MySQL at conferences and other venues around the world. Interested in free software since the early '80s, David is committed to developing a successful business model through Open Source software.

David has been visiting India often to give talks on MySql, I had met him at IIT during one of his visits to Mumbai.

The H2 Database Engine is a free SQL database that is written in Java and can store data in memory or on disk. The engine supports client/server and local access and encryption.

H2, the free SQL database. The main feature of H2 are:
* It is free to use for everybody, source code is included
* Written in Java, but also available as native executable
* JDBC and (partial) ODBC API
* Embedded and client/server modes
* Clustering is supported
* A web client is included

Download

Download the current release (2006-02-04 / Alpha):

Windows Installer (4.2 MB)

Oracle launched Project Raptor , a free graphical tool that enhances productivity and simplifies database development tasks.

With Project Raptor, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own.
An Early Adopter release is now available for download for Windows and Linux. Project Raptor can connect to any Oracle Database version 9.2.0.1 and later.

Read more

Security should be the first thought that comes to a MySQL administrator's mind after creating a new database. Privilege as was discussed in the section, "The Privilege Tables", securing a database is accomplished through modifications made to the tables found in the mysql database. In this section, the reader will learn how to secure the newly created widgets database. Before doing so, a brief summary of exactly how the privilege tables are modified is in order.

There are two methods used to modify the privilege tables. The first is through the use of typical SQL statements such as INSERT, UPDATE and DELETE. However, this method has largely been deprecated through the introduction of the second method, which involves the use of the special commands GRANT and REVOKE. Therefore, only this second method will be discussed in this section