Database

Oracle Magazine March 2013

Create: Sat, 04/19/2014 - 08:52
Author: nurhidayat

Cloud Documentaries | In this issue of Oracle Magazine, real organizations use Oracle public and private cloud solutions—including Oracle Cloud, Oracle Database, and Oracle Enterprise Manager 12c—to put their own customers first, integrate cloud and legacy information systems, move their standards-based cloud solutions between different cloud service providers, deploy solutions in Oracle Cloud and private cloud environments, and more. See “Utility Computing in the Cloud” (page 24) and “Banking on a Private Cloud” (page 30) in this issue to learn more about how three organizations use and benefit from Oracle cloud solutions.

The Oracle Cloud and Oracle private cloud solutions featured in this issue also rely on Oracle engineered systems, including Oracle Exadata and Oracle Exalogic. And because these are real-world stories, no mainframes of any kind were used in the successful deployment of and access

In movies and television shows, information technology is often scaled down to fit the story. That magically computed result, that missing electronic file, and that unknown password that will stop something bad or start something good can go from nonexistent to resolved in one brief scene. And for historical reasons, I suppose, the significant computing power in most screen fiction seems to come from a vintage mainframe— rather than a modern supercomputer or engineered system.

I haven’t seen too many references to cloud computing in movies or on television, but those that I have seen seem limited to the idea that a treasured file or information the hero or villain may be looking for is safe from local mayhem because it is safely stored “in the cloud.” Fortunately, the fact that a movie or television show delivers a very narrow definition of cloud computing as internet-located storage isn’t likely to break the on-screen story or reduce the entertainment value of a production.

Oracle Magazine January 2013

Create: Sat, 04/19/2014 - 08:42
Author: nurhidayat

This issue of Oracle Magazine presents and celebrates the winners in all of the 2012 Oracle Excellence Awards programs, including the Oracle Excellence Awards for CIO of the Year, Technologist of the Year, and Database Administrator of the Year.

Managing nominations, judging, trophy design and delivery, events, publicity, and more across 12 awards programs is no small collection of responsibilities. Oracle Global Customer Programs oversees the 12 Oracle Excellence Awards programs, coordinates many of these activities, and deserves much congratulations and thanks for all of its efforts. The judging processes vary across the different awards categories, but several programs — including Technologist of the Year — use Oracle user group leaders as judges. Thanks to these community leaders for volunteering their time and expertise. Thanks also to the nominators, designers, and everyone else who worked behind the scenes.

Aplikasi Inventory Sederhana - Penggunaan Trigger untuk Tracking Stock Barang
nurhidayat Tue, 01/07/2014 - 12:24

Belajar SQL: Perhitungan Stok dan Harga Rata-Rata Barang untuk Aplikasi Inventory

Create: Sun, 12/29/2013 - 09:00
Author: nurhidayat

Belajar SQL | Semua programmer atau software developer aplikasi perkantoran pasti pernah menggunakan SQL. minimal untuk proses CRUD (Create, Read, Update, Delete) sederhana. Namun hanya sedikit yang memanfaatkan SQL untuk proses perhitungan rumit seperti penggajian, perhitungan average harga barang, status inventory, dan sebagainya hanya dengan menggunakan Single SQL Statement, alias dengan satu perintah SQL saja. Beberapa waktu lalu saat diskusi online dengan kawan-kawan di Facebook, saya tergelitik untuk membuat contoh SQL beraksi untuk menghitung nilai stok dan harga rata-rata barang setelah terjadi proses keluar masuk barang pada bulan tertentu. Contoh kasusnya adalah seperti ini.....

Belajar SQL: Query Sederhana Menghitung Status Dinamis

Create: Tue, 12/17/2013 - 21:53
Author: nurhidayat

Belajar SQL: | Kadangkala kita memerlukan sebuah field berubah nilainya seiring waktu berjalan. sebagai contoh kasus adalah untuk mengetahui apakah garansi suatu barang masih berlaku atau tidak. Salah satu caranya adalah dengan menyediakan field "status" untuk menyimpan nilai berlaku atau habis untuk mengetahui status garansi bersangkutan. Cara ini punya kerumitan karena kita perlu mengubah isinya. Maka, alih-alih menyimpan data status garansi dalam sebuah field khusus, maka akan lebih mudah jika kita cukup menyimpan akhir masa garansi dan menentukan status garansi menggunakan query. Metode ini dinamakan juga sebagai Computed Field.

Belajar SQL: Penggunaan SUM dan JOIN untuk membuat Laporan Summary

Create: Sat, 11/16/2013 - 10:08
Author: nurhidayat

Belajar SQL | Membuat laporan summary data dari table di database bisa dibilang gampang-gampang susah. Gampang ketika hanya membuat summary dengan sumber data satu buah table saja. Namun jadi makin rumit ketika summary melibatkan 2 (dua) table atau lebih. Silakan pelajari TUTORIAL berikut ini sebagai salah satu contoh kasus untuk membuat summary data dari 3 buah table terpisah.

Oracle Magazine November 2012

Create: Wed, 08/28/2013 - 11:37
Author: nurhidayat

oracle magazine free download dunia database programmerI didn’t count the number of conversa-tions I had or heard that included the word, but I’m quite comfortable saying that cloudwas the word of the week at Oracle’s conferences and events in San Francisco, California, September 29 through October 5, 2012. There were announcements focused explicitly on Oracle cloud technologies and solutions, but cloud was also a big part of every Oracle product, technology, and service announcement and discussion.

Oracle CEO Larry Ellison’s Sunday keynote at Oracle OpenWorld 2012 was about cloud computing, including the history of cloud computing going back to NetSuite in 1998 and the beginnings of Oracle Fusion Applications development in 2004. Ellison discussed public and private clouds, the levels of cloud services—software as a service (SaaS), platform as a service (PaaS), and infrastructure as a service (IaaS)—and their key components, and Oracle’s latest offerings in each of these service areas.

Ellison talked about Oracle technologies designed specifically for better cloud com-puting, from infrastructure and private cloud services to database multitenancy and engi-neered systems. He also unveiled the latest Oracle engineered systems releases and discussed their infrastructure and platform support for cloud computing.

Oracle Magazine September 2012

Create: Wed, 08/28/2013 - 11:26
Author: nurhidayat

oracle magazine free download dunia database programmerOracle Magazinepublishes some small amount of Oracle news every 60 days, and that’s not an apology or false modesty on behalf of the magazine. Oracle generates far more news about products, strategy, and tech-nology in a two-month period than we could possibly fit in the pages of this publication. (Take a look at the Oracle press release feed at pressroom.oracle.com to see what I mean—and to search for the latest Oracle news.)

Information technology news is also the kind of news that benefits from several dif-ferent approaches, formats, and presenta-tions. Oracle Magazinestrives to present Oracle news in news briefs and interviews, community briefs, customer reference stories, technology how-to content, and anal-ysis. But even these variations are not enough to guarantee that organizations have the news they need to see the potential impact the latest Oracle products, strategy, and tech-nology could have on their own operations.

Fortunately, as the volume of news about Oracle and Oracle technology has continued to expand, it has gotten easier to sepa-rate into components and address with a tighter focus. The aforementioned Oracle press releases are now broken into bite-size bullets, suitable as launch points for social media conversations. Oracle Web pages, data sheets, white papers, customer case studies, and newer-media assets including podcasts, Webcasts, and videos present new infor-mation in all sizes, to fit the time you have and the approach you’re looking for when exploring any area of Oracle technology.

Oracle Magazine July 2012

Create: Wed, 08/28/2013 - 11:21
Author: nurhidayat

oracle magazine free download dunia database programmerThe ComputerWorld article gives examples of the many types of information contained in tables on the Web and points out that pro-gramming languages have developed features specifically for working with information in tables. The hard part of the “data stored in tables” truth presented in the article appears to be that tables are not new, but rather are years-old constructs that have organized the information of the internet in clearly defined structures. The article also points out that NoSQL isnew, but the hard truth there is that NoSQL is also about data in tables.

To me, the fact that most of the Web is data stored in tables is fantastic. The down-side to that truth is that only mostof the Web is in tables. And as for the hard truth that even a newer technology like NoSQL works with data in tables, I see only benefit in adding new capabilities for the structures that already contain most of the information of the Web.

Like many people, I’ve counted on tables—on the Web and in intranet applica-tions—for Web transactions and interactions as well as for storage and access to various types of information for years. For internal projects, I’ve used relational database tables in situations where I first did not understand how using tables would help, but in each case the truth was that using the tables was convenient and definitely added value to both the process and the result.