Amazon Web Services is set to allow users to import data from Oracle and Teradata warehouses directly into its own Amazon Redshift cloud data warehouse. Using the AWS Schema Conversation Tool (SCT), customers will be able to migrate data from commercial relational databases straight into the cloud. The Schema Conversation tool analyses data and enables the automatic conversion of source database schema for the majority of custom code, including views, stored procedures and functions, to a new format which is compatible with the new target database. Any code which can't automatically be converted in this way is marked so the process can be done so manually. "AWS SCT will run an analysis of your data warehouse, automate the schema conversion, apply the schema to the Amazon Redshift target and extract your warehouse data, regardless of volume. You can use Amazon S3 or Amazon Snowball to move your exports to the cloud, where Amazon Redshift can natively import the data for use," Amazon … [Read more...] about AWS Schema Tool allows you to export Oracle and Teradata warehouses to Amazon Redshift
Exporting oracle database
Oracle CTO Larry Ellison is beginning to sound a bit obsessive about Amazon Web Services and his love affair with infrastructure-as-a-service may not be all that strategically sound.The enterprise software giant delivered a solid third quarter as its growth in the cloud continues to outpace declines in software licensing. Software- and platform-as-a-service continues to fare well for Oracle. These results got an assist from the NetSuite purchase, but it's clear that Oracle is a significant cloud services player. But in a time when Workday and Salesforce are strengthening ties with Amazon Web Services and SAP is partnering with the likes of AWS, Google Cloud Platform and Microsoft Azure you have to wonder about Oracle's infrastructure-as-a-service fascination. Clearly, IaaS is a scale game and the value beyond AWS, Microsoft, Google and IBM is going to be in SaaS and PaaS.Also: Stacking up the cloud vendors: AWS vs. Microsoft Azure, IBM, Google, Oracle | AWS Schema Tool allows you to … [Read more...] about Oracle CTO Ellison fixated on AWS, infrastructure as a service but why?
Read this Full SQL on Hadoop? Splice Machine opens up its database for trials Splice Machine has brought together technology from two Apache projects in its quest to create a SQL-on-Hadoop database. Read More After six months in public beta and a 20-company charter testing scheme, Splice Machine today released version 1.0 of its Hadoop database. The company describes the product as opening up the Hadoop stack to a full-featured SQL database, capable of running transactions and analytics simultaneously. Splice Machine has brought together technology from two Apache projects, taking the Apache Derby Java relational database and replacing its storage layer with the Apache HBase NoSQL database. Then it has modified the planner, optimiser and executor inside Derby to take advantage of HBase's distributed architecture. The firm said feedback from companies taking part in testing has resulted in a number of improvements to the database for version 1.0. These include analytic window … [Read more...] about Splice Machine’s SQL on Hadoop database goes on general release
Oracle's hostile bid for PeopleSoft is currently under review by Canadian antitrust regulators, adding yet another antitrust hurdle for the database-software maker to jump. The investigation by Canada's Competition Bureau is not a surprise, given the size of the $7.25 billion buyout proposal and Oracle's large presence in Canada--it has 13 offices and more than 1,000 employees. But it means that the software maker has to get approval from yet another regulatory agency. It already faces examination from the U.S. Department of Justice, a large group of state attorneys general and the European Union. "When we become aware of a transaction like this, we commence our work like we have done in this particular case," said Robert Lancop, assistant deputy commissioner in the Competition Bureau's mergers branch. Canada's antitrust bureau automatically reviews mergers if the combined companies will have sales equivalent to at least $400 million in imports, exports or within Canada, and if … [Read more...] about Canada weighs in on Oracle’s takeover bid
If you have the budget and don't mind the "database is the platform" mentality, go for Oracle9i Database: It delivers a truly powerful solution. Though it still requires you to do a lot of tuning, the rich management tools in this release can reduce some of the stress of keeping your enterprise up and running. It also outperformed all of the other products on our JSP Nile Throughput test, delivering over 620 pages per second. Compared with IBM's DB2, you'll pay more for additional modules and you'll risk vendor lock-in, but Oracle has become something of a standard in itself, with a far larger pool of IT experts than its competitors. On the downside, it's not as open as DB2, and its lower-priced versions cut out features that IBM includes. The Oracle Universal Installer manages the more than 1.5GB of files required for the Enterprise edition. We used the separate data migration wizard to move our test database from Version 8i to 9i. The installer also creates a sample database, along … [Read more...] about Oracle9i Database