Data Warehouse {2}

by Rosario E
Data Warehouse

Data warehousing has been evolving since 2008 to analytical architecture that includes data marts, ETL, near line storage, exploration warehouses.

The SQL Server has also evolved since started with small amounts of data on a personal computer with basic functions until now that serves mid-size and large amounts of data for warehousing and it is one of the preferred technology platform for advanced data warehouse. read more...

New Oracle MySQL Migration Tool {1}

by Allen D
Oracle has offered a new tool that allows the users to migrate data from the SQL Server it’s a MySQL database. The tool allows for applications written on the server to be easily tweaked into the database. Additionally, Oracle has offered a new plug-in tool that gives users with no experience on MySQL to work with MySQL data inside Microsoft Excel. With these new tools, Oracle announced that companies can save up to 90% less total costs of ownership by using the new MySQL tools compared to using the traditional SQL Server. Oracle’s efforts to implement migration programs had been a fixed tradition in the software industry for quite some time. Competitors such as EnterpriseDB had also been producing compatible software to Oracle’s SQL flagship database. Companies such as Oracle and EnterpriseDB are very enthusiastic and eager to increase their database market share into corporate IT. Their strategies are not only focused on generating software license revenues and subscription contracts but also to create new environments that enable them to sell compatible applications and other tools. read more...