Oracle

Deployment of Oracle into AWS {Comments Off on Deployment of Oracle into AWS}

by Joey L
Amazon is deploying Oracle databases into its AWS service.  Amazon AWS (Amazon Web Services) is a platform of remote computing services in the cloud.  Amazon Web Services provide online services for web applications by offering cloud computing.  The benefit of cloud computing is the ability to minimize capital spending.   Now with the Oracle database, clients can rent database with a “pay-as-you-go” pricing with no up-front fees for long term conditions.  With Amazon’s AWS service, clients are no longer physically restricted by their hardware/software.  The massive global cloud infrastructure of the service allows clients to quickly innovate and launch ideas as well as deploy applications on demand. read more...

Database vulnerabilities discovered {1}

by Alexander V
Summary:

“The largest dedicated database security, vulnerability and misconfiguration research team in the world,” TeamSHATTER, is a department of Application Security, Inc. TeamSHATTER has the most knowledge out of anyone else in the industry in regards to database vulnerability and they know how to make security “an integral part of an enterprise’s…infrastructure.” Recently, TeamSHATTER researchers discovered and reported “four out of the five database vulnerabilities disclosed in the October 2011 Oracle Critical Patch Update (CPU).” The critical patch update for October contained 57 vulnerability fixes, five of which were specific to Oracle database server. The director of TeamSHATTER, Alex Rothacker, said that the October CPU is the weakest release they’ve seen since 2005. He states that “there is a record low number of database patches,” which show that Oracle is “losing focus on database security improvements.” Lastly, he believes that even if Oracle is losing focus because of other commitments or a rise in business, it is “more important than ever for organizations to apply patches as soon as possible while simultaneously employing strong risk mitigation controls.” read more...

Internet Business Intelligence {Comments Off on Internet Business Intelligence}

by Marco M
This article describes the very large amounts of data available on the Internet and focuses on products or tools related to the extraction of data.  Data mining is the extraction of data from the Internet for commercial purposes and is type of business intelligence (“BI”).  BI is a powerful marketing tool for any organization, large or small, e-commerce or non-profit.  It provides information that would help achieve an organization’s goals; however, there is a lack of resources when searching for information about it. Some of the “major BI players” and their BI tools are as listed in this article.  For example, “IBM Cognos 8 provides Dashboards for visualization and Scorecarding for teamwork; Information Builders’ WebFOCUS, in addition to BI, also integrates performance management and data analytics in their tools; JasperSoft’s open source BI Suite supports data analysis, integration, and visualization as well as Web interface capability; Microsoft’s BI Tools are based on SharePoint and SQL services and reporting, which are highly integrated with Office 2010; Oracles’ Business Intelligence Enterprise Edition 11g has various tools that make CRM analytics and ERP analytics easily accessible by users; and finally SAP’s Business Objects XI aims to provide user-friendly data and analytics visualization”. All of these products are designed for “enterprise information systems”.  This article also mentions the need for business intelligence in the industrial and academic bio-research areas.  It discusses the lack of published resources available, and the article ends by predicting that business intelligence can be utilized to acquire information on competitors, track users and “mining can assist in profiling users “. read more...

MarkLogic and Hadoop {Comments Off on MarkLogic and Hadoop}

by Asbed P
MarkLogic’s database, named MarkLogic 5, is another database that will use the open source Hadoop programming framework.  It was just released a few weeks ago, and has a Hadoop connector that allows its users to “aggregate data inside MarkLogic for richer analytics, while maintaining the advantages of MarkLogic indexes for performance and accuracy.”  The database is described by its own company as an enterprise class database which does not use SQL.  Instead it uses both XML and Xquery which means its more well suited for certain classes of applications.  It’s main appeal so far is its ability to manage, index and handle unstructored information from anything from text documents to media files. A great use of this database would be in, for example, an insurance company who has a great amount of documents that need information pulled off of them and sorted into a database.  This combination of MarkLogic and Hadoop will allow MarkLogic to pull the info and Hadoop to sort it and analyze it. read more...

Java Will Lead the Way {Comments Off on Java Will Lead the Way}

by James C
Summary:

SQL Navigator, a development solution for database applications. Designed and developed by Quest Software has released its newest version supporting Java. As the trend for developing in Java has increased, Quest Software has followed in suite by incorporating into SQL Navigator support for implementing Java based procedures and commands. SQL Navigator supports both PL/SQL (Procedural Language / Structured Query Language) and Java application development by lowering the turn-around time by 50 percent. The use of the this market-leading software has globally reached over 50 thousand users. read more...

On-Demand Database Service {Comments Off on On-Demand Database Service}

by Alexander V
Summary:

Amazon Web Services started a pay-by-the-hour service for Oracle databases that will compete with Microsoft SQL Azure. Both these services are cloud services. The name of Amazon’s new pay by the hour service is Amazon Relational Database Service (RDS) and it will be available licensing models. One licensing model allows you to use a license that you already own and the other model allows you to buy a license from Amazon. “The new service will likely appeal to Oracle database developers, letting them spin up and down instances as needed and scale to required capacity.” Both models sold by Amazon provide the same features which allow users to do common database administration work such as backup and software patching. RDS is offered in “five database instance classes,” each meeting different levels of needs. The fees for RDS  are $0.11 to $3.40 per hour and “discounts up to 48% are available with one-time, up-front payments for one-year and three-year terms.” read more...

Oracle’s NoSQL {1}

by Asbed P
During last month’s OpenWorld conference, Oracle announced a slew of new technologies along with their much anticipated NoSQL database.  Finally the Oracle NoSQL is released and will also be included in Oracle’s Big Data Appliance, which will ship during the first three months of this coming year.  Oracle says their NoSQL database is targeted towards “customers who are acquiring massive amounts of data who are unsure about the schema, who want more fluid capture of the data,” says Marie-Anne Neimat, the vice president of Oracle’s database development.  The database is a Java version of the Berkeley database, which is an open source database developed by UC Berkeley that is commonly used in embedded systems.  Although NoSQL can’t do highly structured queries like other SQL based datases could, the database doesn’t require a fixed schema, so users can add new information as columns as the need rises. read more...

NoSQL Databases {Comments Off on NoSQL Databases}

by Chris S
Databases come in all types, from Relational Database Management Systems to Database warehouses. The RDBMS has been the most popular out of the bunch, but a new database has been gaining favor amongst businesses. NoSQL is the new database type that has been drawing lots of attention. It uses techniques that were not so fitting with the traditional SQL. The big difference is in how NoSQL functionality provides better data storage and retrieval. Technology in general will always have its pros and cons. NoSQL, however, has some interesting advantages. The big advantage to NoSQL database is that administrators will not have to “scale up” as data storage increases. The elasticity of NoSQL allows it to expand transparently to services new nodes that are added to it. Cloud servers are another example of admins not having to increase hardware size to meet big data needs. Big data is one reason why many companies are looking for new ways to handle the massive amounts of data stored on RDBMS. As businesses thrive and collect more data, the RDBMS may not be the best fit for storing decades of data and transaction logs. Everything about these new databases outweighs what RDBMS can do. Unfortunately, NoSQL databases are designed to require very little management, creating a decrease in demand for Database Administrators. That doesn’t mean DBAs will no longer be needed, but companies can cut back on the costs for such skilled individuals. NoSQL databases also cost less to store and retrieve data then typical RDBMS, since they utilize other servers to manage data and transactions. read more...

Oracle talks about Fusion Applications and their new Public Cloud {2}

by Asbed P
Like I mentioned last week, Larry Ellison, Oracle’s CEO, announced many new products during Oracle’s OpenWorld conference’s opening Keynote including applications, database software, a new public cloud, and hardware for both databases and analytics.  In the following days Ellison went into greater detail about their new Fusion Applications and also talked about the new Oracle Public Cloud and why it’s going to be one of the better clouds available in the market.  First of all, Ellison announced the general availability of Oracle Fusion Applications, which includes many new tools, and talked about how it will modernize existing applications like PeopleSoft, Seibel, Hyperion, and their own E-Business Suite.  Ellison said the result is over 100 products “all rewritten on top of modern technology” during the past six years.  He also revealed that these applications are designed to run either on local servers or in the cloud.  He also mentions that the platform will run industry standard middleware and languages, specifically Java and BPEL, and that Oracle has built their security into the Middleware and not the applications allowing all applications to run securely including customer made apps or extensions to basic Oracle apps.  The cloud that these apps will run on is called the Oracle Public Cloud, which is built on industry standards and can work with other clouds and local data centers.  The cloud has layers of databases, Java, data, and security services with the apps, once again including custer made apps and extensions. read more...

Oracle CEO Talks About What’s To Come {2}

by Asbed P
On Sunday October 2nd, CEO of Oracle Larry Ellison, talked about the future of the company during Oracle’s OpenWorld 2011 conference.  He started off by mentioning to the crowd that just because they bought Sun doesn’t mean they were going to stop producing hardware.  He even made a joke about it saying “I guess we didn’t get the memo.”  He then began describing Apple’s business model of developing hardware and software together and used them as an example of what he wants Oracle to become.  Instead of having different companies designing and developing different parts of their machines, he wants everything to be done by them so that it can flow together better. Later on he also began unveiling all the new hardware Oracle has been working on including the Exalogic system which is composed of high end hardware and the Exalogic Elastic Cloud software.  Ellison says Oracle has designed this system to beat out IBM’s P series in performance and pricing.  He also revealed a slew of other hardware and software that will be released soon. read more...