-
-
7:00
»
Open Source Web Development Tutorials - RSS Feeds
By addressing the need for high availability and session integrity, Oracle Communications Service Availability Machine allows NEPs to concentrate their efforts on developing new applications without having to worry about custom building and integrating such capabilities into each application. Thanks to the machine's easy to use development environment and infrastructure, NEPs can enjoy increased efficiency when creating and delivering highly-available applications. In addition, project risk and time-to-revenue are reduced. Another feature that adds to the machine's appeal is that it leverag...
-
-
10:22
»
Open Source Web Development Tutorials - RSS Feeds
A closer look at Oracle Exalytics reveals an impressive setup highlighted by an Intel Xeon E7-4800 processor with 40 processing cores, Oracle's Sun Fire server with 1TB of RAM, Integrated Lights Out Management, and 40Gb/s InfiniBand and 10Gb/s Ethernet connectivity. By using innovative heuristic adaptive in-memory caching that determines which data is best stored in-memory for optimal performance, Exalytics easily adapts to changing workloads and simplifies the overall management process. Speaking of performance, the press release notes that extensive testing of Oracle Exalytics reveals rel...
-
-
8:54
»
Open Source Web Development Tutorials - RSS Feeds
Described as a modular component within Oracle's Network Resource Management solution, Oracle Communications Network Integrity allows network operators to synchronize and maintain current data in their network inventory systems. The solution also supplies deployment options that are either integrated with Oracle or third-party platforms. Oracle Communications Network Integrity 7.1 comes with several improvements that add to its impressive pre-existing list of features. Version 7.1's enhancements begin with circuit and service assimilation and discrepancy detection capabilities for optical and ...
-
-
9:40
»
Open Source Web Development Tutorials - RSS Feeds
Oracle first introduced its Big Data Appliance as well as the NoSQL database at the company's OpenWorld user conference last October. According to analyst David Menninger of Ventana Research, the appliance was created to manage and analyze data sets deemed to be too large for storing in standard databases. The Big Data Appliance boasts a lineup including Sun server hardware (18 Linux-based x86 Sun servers with 216 processor cores, 648TB raw disk storage, 864GB working memory), Oracle NoSQL database, Oracle's Java HotSpot Virtual Machine, and an open-source distribution of R. George Lumpkin, Or...
-
-
9:47
»
Open Source Web Development Tutorials - RSS Feeds
Headlining PeopleTools 8.52's list of improvements is support for Apple's popular iPad tablet. The move makes Oracle the lone enterprise resource planning vendor to provide an enterprise suite on the iPad, giving users the ability to access PeopleSoft on the go while maintaining the functionality and security one would normally expect in a stationary setting. While iPad support is appealing, it's just the tip of the iceberg when it comes to PeopleTools 8.52's enhancements. The user interface has been upgraded to improve interactivity through the use of new pagelets and inter-pagelet communic...
-
-
9:19
»
Open Source Web Development Tutorials - RSS Feeds
The move expands Oracle Big Data Appliance's offerings of hardware and software offerings geared towards high performance and scalable data processing for Big Data by two solid products. Cloudera Distribution Including Apache Hadoop is the industry's most widely deployed distribution of Hadoop in both commercial and non-commercial settings. Described as being 100 percent open source, CDH is also regarded as the most tested, reliable, and stable product of its kind. Big Data Appliance's portfolio already included Oracle NoSQL Database Community Edition, an open source distribution of R, Orac...
-
-
7:00
»
Open Source Web Development Tutorials - RSS Feeds
The highlight of the latest update includes a number of statements marked as unsafe for statement-based replication. According to the H Open website, all of the statements given the distinction of being unsafe supposedly rely on the result of a select statement where the order cannot be relied upon. Oracle recommends that any users who engage in statement-based logging should read the accompanying documentation for additional guidance regarding the issues addressed in the update. Beyond the replication issue, Oracle also used MySQL 5.5.18 to fix a problem where the master could send dama...
-
-
23:13
»
Open Source Web Development Tutorials - RSS Feeds
In addition to the NoSQL Database release, Oracle also announced that its highly anticipated Big Data Appliance would become available during the first quarter of 2012. Oracle initially gave a sneak peek into both products at the Oracle Open World Conference in San Francisco a few weeks ago, so the rather quick availability and updated information show that the company is taking aggressive steps to measure up to the competition. The timing of Oracle's announcements could not be any better, as its competitors are also making moves in the large-scale data processing arena. EMC and IBM kicked t...
-
-
10:30
»
Open Source Web Development Tutorials - RSS Feeds
How to sort a result set by an alias, an expression, or a column number Figure 3-18 presents three more techniques that you can use to specify sort columns. First, you can use a column alias that's defined in the SELECT clause. The first SELECT statement in this figure, for example, sorts by a column named address, which is an alias for the concatenation of the vendor_city, vendor_state, and vendor_zip_code columns. Within the address column, the result set is sorted by the vendor_name column. You can also use an arithmetic or string expression in the ORDER BY clause, as illustrated by the s...
-
-
7:30
»
Open Source Web Development Tutorials - RSS Feeds
How to use the LIKE operator One final operator you can use in a search condition is the LIKE operator, shown in figure 3-15. You use this operator along with the wildcards shown at the top of this figure to specify the string pattern, or mask, that you want to match. The examples in this figure show how this works. In the first example, the LIKE phrase specifies that all vendors in cities that start with the letters SAN should be included in the query results. Here, the percent sign (%) indicates that any characters can follow these three letters. So San Diego and Santa Ana are both include...
-
-
9:00
»
Open Source Web Development Tutorials - RSS Feeds
How to use scalar functions Figure 3-7 introduces you to scalar functions, which operate on a single value and return a single value. These functions work differently than the aggregate functions described in chapter 5 that are used to summarize data. For now, don't worry about the details of how these functions work, because you'll learn more about them in chapter 8. Instead, just focus on how they're used in column specifications. To code a function, you begin by entering its name followed by a set of parentheses. If the function requires one or more parameters, you enter them within the p...
-
-
7:30
»
Open Source Web Development Tutorials - RSS Feeds
How to code string expressions A string expression consists of a combination of one or more character columns and literal values. To combine, or concatenate, the columns and values, you use the concatenation operator (||). This is illustrated by the examples in figure 3-5. The first example shows how to concatenate the vendor_city and vendor_state columns in the Vendors table. Notice that because no alias is assigned to this column, Oracle assigns a name, which is the entire expression. Also notice that the data in the vendor_state column appears immediately after the data in the vendor_city...
-
-
7:30
»
Open Source Web Development Tutorials - RSS Feeds
How to code the SELECT clause Figure 3-3 presents an expanded syntax for the SELECT clause. The keywords shown in the first line allow you to restrict the rows that are returned by a query. You'll learn how to code them in a moment. But first, you'll learn various techniques for identifying which columns are to be included in a result set. How to code column specifications Figure 3-3 summarizes the techniques you can use to code column specifications. You saw how to use some of these techniques in the previous figure. For example, you can code an asterisk in the SELECT clause to retrieve all...