Cara Mudah Belajar Pembangunan Sistem Object Oriented Database
Cara Mudah Belajar Pembangunan Sistem Pangkalan Data Berorientasikan Objek
1) Pengenalan
Introduction to ODBMS
By Rick Grehan
An object database management system (ODBMS, also referred to as object-oriented database management system or OODBMS), is a database management system (DBMS) that supports the modelling and creation of data as objects. This includes some kind of support for classes of objects and the inheritance of class properties and methods by subclasses and their objects. (Baca selanjutnya)
2) Perisian Rekabentuk JDeveloper
Database Shema Modeling in JDeveloper
This tutorial shows you how to create a database diagram with database components. You'll see how to create a database user, reconcile the offline definitions with the current database definitions, and generate a DDL reconciliation script. Finally you reverse-engineer database objects.
To see the complete application you will create, click the Download button to download a zip of the final application. Unzip it into your JDeveloper folder. (Baca selanjutnya)
Showing posts with label database. Show all posts
Showing posts with label database. Show all posts
Saturday, December 01, 2012
Tuesday, November 27, 2012
Simple Way To Practice SQL Online
Cara Mudah Untuk Belajar Praktis SQL Secara Online
1) http://sqlfiddle.com
2) http://sqlzoo.net
3) http://apex.oracle.com (Oracle)
Saturday, November 24, 2012
Simple Way To Install Oracle Database On Linux
Cara Mudah Memasang Oracle Database Ke Atas Linux
Cara Mudah Install Oracle Database Ke Atas Linux
Disalin dari: http://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux6-1845247.html
Terdapat juga panduan di sini http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r1/prod/install/dbinst/dbinst.htm
tetapi panduan ini tidak memperincikan bahagian pra-syarat (pre-requisite) yang kebiasaannya membantutkan kerja-kerja pemasangan perisian.
---------------------------------
How I Simplified Oracle Database 11g Installation on Oracle Linux 6
by Ginny Henningsen; updated by Michele Casey
How to simplify the installation of Oracle Database 11g on Oracle Linux 6 by installing the oracle-rdbms-server-11gR2-preinstall RPM package.
Published September 2012
Note: This article applies to Oracle Linux 6. A previous article, "How I Simplified Oracle Database Installation on Oracle Linux," describes how to perform a similar task on Oracle Linux 5.
Introducing the oracle-rdbms-server-11gR2-preinstall RPM for Oracle Linux
Before installing Oracle Database 11g on a system, you need to preconfigure the operating environment since the database requires certain software packages, package versions, and tweaks to kernel parameters. (Be sure to review the appropriate Oracle Database installation guide to familiarize yourself with hardware, software, and operating system requirements.)
|
On Oracle Linux, I discovered that there is a remarkably easy way to address these installation prerequisites: First install an RPM package called
oracle-rdbms-server-11gR2-preinstall. This RPM performs a number of preconfiguration steps, including the following:- Automatically downloading and installing any additional software packages and specific package versions needed for installing Oracle Grid Infrastructure and Oracle Database 11gRelease 2 (11.2.0.3), with package dependencies resolved via
yumorup2datecapabilities. - Creating the user
oracleand the groupsoinstall(forOraInventory) anddba(forOSDBA), which are used during database installation. (For security purposes, this user has no password by default and cannot log in remotely. To enable remote login, please set a password using thepasswdtool.) - Modifying kernel parameters in
/etc/sysctl.confto change settings for shared memory, semaphores, the maximum number of file descriptors, and so on. - Setting hard and soft shell resource limits in
/etc/security/limits.conf, such as the locked-in memory address space, the number of open files, the number of processes, and core file size. - Setting
numa=offin the kernel for x86_64 machines.
Note that
oracle-rdbms-server-11gR2-preinstall parses the existing /etc/sysctl.conf and /etc/security/limits.conffiles and updates values only as needed for database installation. Any precustomized settings not related to database installation are left as is.
The
oracle-rdbms-server-11gR2-preinstall RPM package is accessible through the Oracle Unbreakable Linux Network (ULN, which requires a support contract), from the Oracle Linux distribution media, or from the Oracle public yum repository. Thus, whether or not your system is registered with ULN to access Oracle patches and support, you can use oracle-rdbms-server-11gR2-preinstall to simplify database installation on Oracle Linux. In addition, the Oracle public yum repository now includes all security and bug errata, ensuring systems are secured and stable with the latest security updates and bug fixes.
Installing the oracle-rdbms-server-11gR2-preinstall RPM
The remainder of this article steps through the procedure that I used for installing
oracle-rdbms-server-11gR2-preinstall on Oracle Linux via the Oracle public yum repository. I started with a system running Oracle Linux Release 6 Update 3 for x86_64, a 64-bit version of Oracle Linux that I downloaded from the Oracle software delivery cloud (requires registration or login). First, I set up a yumconfiguration file that pointed to the correct repository, and then I installed the oracle-rdbms-server-11gR2-preinstall RPM from that repository.
Here are the steps for preconfiguring a system for Oracle Database installation using
oracle-rdbms-server-11gR2-preinstall:- As an authorized user (for example,
root), retrieve the file that configures repository locations:# cd /etc/yum.repos.d # wget http://public-yum.oracle.com/public-yum-ol6.repo
- Using a text editor, modify the file, changing the field
enabled=0toenabled=1to reflect repositories that correspond to the machine's operating system release.Here is an excerpt ofpublic-yum-old6.repowith the changed lines in boldface.[ol6_latest] name=Oracle Linux $releasever Latest ($basearch) baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/ gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 gpgcheck=1 enabled=1 [ol6_UEK_latest] name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch) baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/ gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 gpgcheck=1 enabled=1
Because the target system is running Oracle Linux Release 6 Update 3 for x86_64, which installs the Oracle Unbreakable Enterprise Kernel by default, there are two repositories to enable,[ol6_latest]and[ol6_UEK_latest]. - Next, install the
oracle-rdbms-server-11gR2-preinstallRPM using theyum installcommand.The output in Listing 1 shows how the installation checks dependencies and then downloads and installs the required packages.# yum install oracle-rdbms-server-11gR2-preinstall Loaded plugins: refresh-packagekit, rhnplugin, security Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-6.el6 will be installed --> Processing Dependency: gcc-c++ for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: gcc for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: libaio-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: libstdc++-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: glibc-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: compat-libstdc++-33 for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: ksh for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: compat-libcap1 for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Running transaction check ---> Package compat-libcap1.x86_64 0:1.10-1 will be installed ---> Package compat-libstdc++-33.x86_64 0:3.2.3-69.el6 will be installed ---> Package gcc.x86_64 0:4.4.6-4.el6 will be installed --> Processing Dependency: cpp = 4.4.6-4.el6 for package: gcc-4.4.6-4.el6.x86_64 --> Processing Dependency: cloog-ppl >= 0.15 for package: gcc-4.4.6-4.el6.x86_64 ---> Package gcc-c++.x86_64 0:4.4.6-4.el6 will be installed --> Processing Dependency: libmpfr.so.1()(64bit) for package: gcc-c++-4.4.6-4.el6.x86_64 ---> Package glibc-devel.x86_64 0:2.12-1.80.el6_3.4 will be installed --> Processing Dependency: glibc-headers = 2.12-1.80.el6_3.4 for package: glibc-devel-2.12-1.80.el6_3.4.x86_64 --> Processing Dependency: glibc-headers for package: glibc-devel-2.12-1.80.el6_3.4.x86_64 ---> Package ksh.x86_64 0:20100621-16.el6 will be installed ---> Package libaio-devel.x86_64 0:0.3.107-10.el6 will be installed ---> Package libstdc++-devel.x86_64 0:4.4.6-4.el6 will be installed --> Running transaction check ---> Package cloog-ppl.x86_64 0:0.15.7-1.2.el6 will be installed --> Processing Dependency: libppl_c.so.2()(64bit) for package: cloog-ppl-0.15.7-1.2.el6.x86_64 --> Processing Dependency: libppl.so.7()(64bit) for package: cloog-ppl-0.15.7-1.2.el6.x86_64 ---> Package cpp.x86_64 0:4.4.6-4.el6 will be installed ---> Package glibc-headers.x86_64 0:2.12-1.80.el6_3.4 will be installed --> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.12-1.80.el6_3.4.x86_64 --> Processing Dependency: kernel-headers for package: glibc-headers-2.12-1.80.el6_3.4.x86_64 ---> Package mpfr.x86_64 0:2.4.1-6.el6 will be installed --> Running transaction check ---> Package kernel-uek-headers.x86_64 0:2.6.32-300.32.1.el6uek will be installed ---> Package ppl.x86_64 0:0.10.2-11.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: oracle-rdbms-server-11gR2-preinstall x86_64 1.0-6.el6 ol6_latest 15 k Installing for dependencies: cloog-ppl x86_64 0.15.7-1.2.el6 ol6_latest 93 k compat-libcap1 x86_64 1.10-1 ol6_latest 17 k compat-libstdc++-33 x86_64 3.2.3-69.el6 ol6_latest 183 k cpp x86_64 4.4.6-4.el6 ol6_latest 3.7 M gcc x86_64 4.4.6-4.el6 ol6_latest 10 M gcc-c++ x86_64 4.4.6-4.el6 ol6_latest 4.7 M glibc-devel x86_64 2.12-1.80.el6_3.4 ol6_latest 970 k glibc-headers x86_64 2.12-1.80.el6_3.4 ol6_latest 600 k kernel-uek-headers x86_64 2.6.32-300.32.1.el6uek ol6_latest 713 k ksh x86_64 20100621-16.el6 ol6_latest 684 k libaio-devel x86_64 0.3.107-10.el6 ol6_latest 13 k libstdc++-devel x86_64 4.4.6-4.el6 ol6_latest 1.5 M mpfr x86_64 2.4.1-6.el6 ol6_latest 156 k ppl x86_64 0.10.2-11.el6 ol6_latest 1.3 M Transaction Summary ================================================================================ Install 15 Package(s) Total download size: 25 M Installed size: 61 M Is this ok [y/N]: Downloading Packages: -------------------------------------------------------------------------------- Total 710 kB/s | 25 MB 00:35 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : mpfr-2.4.1-6.el6.x86_64 1/15 Installing : libstdc++-devel-4.4.6-4.el6.x86_64 2/15 Installing : cpp-4.4.6-4.el6.x86_64 3/15 Installing : ppl-0.10.2-11.el6.x86_64 4/15 Installing : cloog-ppl-0.15.7-1.2.el6.x86_64 5/15 Installing : kernel-uek-headers-2.6.32-300.32.1.el6uek.x86_64 6/15 Installing : glibc-headers-2.12-1.80.el6_3.4.x86_64 7/15 Installing : glibc-devel-2.12-1.80.el6_3.4.x86_64 8/15 Installing : gcc-4.4.6-4.el6.x86_64 9/15 Installing : gcc-c++-4.4.6-4.el6.x86_64 10/15 Installing : compat-libstdc++-33-3.2.3-69.el6.x86_64 11/15 Installing : libaio-devel-0.3.107-10.el6.x86_64 12/15 Installing : ksh-20100621-16.el6.x86_64 13/15 Installing : compat-libcap1-1.10-1.x86_64 14/15 Installing : oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 15/15 Verifying : gcc-4.4.6-4.el6.x86_64 1/15 Verifying : compat-libcap1-1.10-1.x86_64 2/15 Verifying : ksh-20100621-16.el6.x86_64 3/15 Verifying : glibc-devel-2.12-1.80.el6_3.4.x86_64 4/15 Verifying : libaio-devel-0.3.107-10.el6.x86_64 5/15 Verifying : oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 6/15 Verifying : gcc-c++-4.4.6-4.el6.x86_64 7/15 Verifying : glibc-headers-2.12-1.80.el6_3.4.x86_64 8/15 Verifying : libstdc++-devel-4.4.6-4.el6.x86_64 9/15 Verifying : compat-libstdc++-33-3.2.3-69.el6.x86_64 10/15 Verifying : mpfr-2.4.1-6.el6.x86_64 11/15 Verifying : kernel-uek-headers-2.6.32-300.32.1.el6uek.x86_64 12/15 Verifying : cpp-4.4.6-4.el6.x86_64 13/15 Verifying : ppl-0.10.2-11.el6.x86_64 14/15 Verifying : cloog-ppl-0.15.7-1.2.el6.x86_64 15/15 Installed: oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-6.el6 Dependency Installed: cloog-ppl.x86_64 0:0.15.7-1.2.el6 compat-libcap1.x86_64 0:1.10-1 compat-libstdc++-33.x86_64 0:3.2.3-69.el6 cpp.x86_64 0:4.4.6-4.el6 gcc.x86_64 0:4.4.6-4.el6 gcc-c++.x86_64 0:4.4.6-4.el6 glibc-devel.x86_64 0:2.12-1.80.el6_3.4 glibc-headers.x86_64 0:2.12-1.80.el6_3.4 kernel-uek-headers.x86_64 0:2.6.32-300.32.1.el6uek ksh.x86_64 0:20100621-16.el6 libaio-devel.x86_64 0:0.3.107-10.el6 libstdc++-devel.x86_64 0:4.4.6-4.el6 mpfr.x86_64 0:2.4.1-6.el6 ppl.x86_64 0:0.10.2-11.el6 Complete!Listing 1: Installing theoracle-rdbms-server-11gR2-preinstallRPMThe yum installation logs messages about kernel changes in the file/var/log/oracle-rdbms-server-11gR2-preinstall/results/orakernel.log, and it makes backups of current system settings in the directory/var/log/oracle-rdbms-server-11gR2-preinstall/backup. - At this point, the system is ready for the installation of Oracle Database. For example, to install Oracle Database 11g Release 2, follow the directions in Chapter 4, "Installing Oracle Database," of the Database Installation Guide for Linux."Here are the steps I followed while installing Oracle Database 11g Release 2 in my test environment. Make sure you review all documentation and follow recommended best practices before installing into your production environment.Note: Please note that the installer in earlier releases of 11g Release 2 (11.2.0.1 and 11.2.0.2) will show "missing package" failures; e.g. for the
pdkshpackage. These can safely be ignored, thekshpackage (which is the successor ofpdksh) has already been installed by the preinstall RPM. This bug was fixed in version 11.2.0.3 of the installer.The Oracle Universal Installer performs a number of checks, verifying that the necessary OS packages and versions are installed. In addition, it checks kernel parameters set by theoracle-rdbms-server-11gR2-preinstallinstallation. During the kernel settings check, the installer might flag a few settings as "failed," and you should investigate these failures. In some cases, you still might be able to continue with the database installation. If you check kernel settings in/etc/sysctl.conf, you'll see thatoracle-rdbms-server-11gR2-preinstallhas modified and added the necessary settings to ensure the minimum requirements are met, as defined in section 2.10.1, "Displaying and Changing Kernel Parameter Values," in Chapter 2, "Oracle Database Preinstallation Requirements," of the Oracle Database Installation Guide 11g Release2 (11.2) for Linux. Below is the list of requirements:fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576
If necessary, you can (asroot) edit the file/etc/sysctl.confto specify a setting manually, for example:# vi /etc/sysctl.conf # /sbin/sysctl -p
The Oracle Universal Installer performs additional checks, such as verifying theglibcversion, sufficient disk space, environmental variable and path settings, and sufficient physical memory and swap space. Generally, installingoracle-rdbms-server-11gR2-preinstalltakes care of the prerequisites so that you can proceed directly with installing the database.- As
root, create a parent directory in a file system that has sufficient space to be the target location for the downloaded files:# mkdir /home/OraDB11g # cd /home/OraDB11g
The amount of disk space needed in the file system varies according to the specific installation type, but roughly twice the size of the zip archives, or 5 GB, is enough to house the software and data files. - Into this target directory, download the installation media files from the Oracle Database Software Downloads page on Oracle Technology Network.
- Extract the files:
# unzip linux.x64_11gR2_database_1of2.zip # unzip linux.x64_11gR2_database_2of2.zip
- Log in as the user
oracle. Change directory to thedatabasedirectory and enter the following command to run the Oracle Universal Installer:$ cd /home/OraDB11g/database $ ./runInstaller
- As
Final Thoughts
Installing the
oracle-rdbms-server-11gR2-preinstall RPM can save time when installing Oracle Database 11g on Oracle Linux. The RPM addresses most Oracle Database installation prerequisites and greatly simplifies the installation process.See Also
Here are the resources referenced earlier in this document:
- Oracle Unbreakable Linux Network: https://linux.oracle.com
- Oracle public yum repository: http://public-yum.oracle.com/
- Oracle software delivery cloud (requires registration or login): https://edelivery.oracle.com/linux
- Chapter 4, "Installing Oracle Database," of the Database Installation Guide for Linux:http://docs.oracle.com/cd/E11882_01/install.112/e24321/inst_task.htm#BABBBHJH
- Oracle Database Software Downloads page on Oracle Technology Network:http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
And here are some additional resources from the Oracle Database Documentation Library (http://www.oracle.com/pls/db112/homepage). Relevant subsections from the Oracle Database Installation Guide 11g Release 2 (11.2) for Linux (http://download.oracle.com/docs/cd/E11882_01/install.112/e16763/toc.htm) with currently valid URLs are as follows:
- "About the Oracle RDBMS Pre-Install and Oracle Validated RPMs" from Chapter 1, "Overview of Oracle Database Installation":http://download.oracle.com/docs/cd/E11882_01/install.112/e16763/install_overview.htm#BABDBHCJ
- Chapter 2, "Oracle Database Preinstallation Requirements":http://download.oracle.com/docs/cd/E11882_01/install.112/e16763/pre_install.htm#BABFDGHJ
- "Downloading Oracle Software" from Chapter 4, "Installing Oracle Database," which describes how to download installation files from the Oracle Technology Network Website: http://docs.oracle.com/cd/E11882_01/install.112/e16763/inst_task.htm#autoId6
Also see the blog entry "Oracle RDBMS Server 11gR2 Pre-Install RPM for Oracle Linux 6 has been released":https://blogs.oracle.com/linux/entry/oracle_rdbms_server_11gr2_pre
About the Authors
Ginny Henningsen has worked for the last 15 years as a freelance writer developing technical collateral and documentation for high-tech companies. Prior to that, Ginny worked for Sun Microsystems, Inc. as a Systems Engineer in King of Prussia, PA and Milwaukee, WI. Ginny has a BA from Carnegie-Mellon University and a MSCS from Villanova University.
Michele Casey is the Director of Product Management for Oracle Linux. She has worked with commercial Linux distributions and open source projects as a product manager since 2006. She has also held positions as a system administrator, project manager, and technical support engineer.
Monday, November 05, 2012
Oracle Linux Vs Oracle Windows
Mana satu yang lebih baik? Gabungan Oracle-Linux atau Oracle-Windows?
-----
-----
http://www.dba-oracle.com/art_builder_linux_oracle.htm
-----
 An un-altered overseas supermarket photo!
The only shortcoming of Intel-based servers is their 32-bit architecture. For Oracle, the 32-bit architecture means that very large memory regions (e.g., the Oracle System Global Area) cannot grow beyond four gigabytes—a size far smaller than their 64-bit cousins, where Oracle RAM regions commonly exceed 20 gigabytes.
However, this 32-bit limitation is about to change. The impending availability of Intel 64-bit architecture has caused widespread excitement, and Intel-based servers will soon be able to compete with giant proprietary UNIX servers. IBM has already announced it is abandoning its proprietary AIX UNIX dialect in favor of Linux. While Oracle is quite vocal that Oracle is faster than SQL Server on Intel and has announced a record-breaking benchmark test with the Itanium processors, the company is also very careful not to compare operating system environments.However, Oracle professionals now have a choice: They can use the Intel-based server on Oracle with Linux or Microsoft Windows. There is a huge debate about which OS is best. In support of Oracle Linux Roby Sherman performed an exhaustive study of the speed of Oracle on Linux and Microsoft Windows using identical hardware. Sherman currently works for Qwest Communications in the data technologies group of IT architecture and transversal services. He is a recognized expert in designing, delivering, tuning, and troubleshooting n-tier systems and technology architecture components of various size and complexity based on Oracle RDBMS technology. When you read the full text of the paper, it is clear that Linux has significant advantages over Windows, not just in performance, but also in flexibility of administration and management.  Sherman concludes: "From perspective of performance, RedHat Linux 7.2 demonstrated an average performance advantage of 38.4 percent higher RDBMS throughput than a similarly configured Windows 2000 Server in a variety of operational scenarios." Sherman also notes: "Another point of contention was Window's lack of consistency between many database administrative functions (e.g., automated startup, shutdown, service creation, scripting) compared to what DBAs are already used to in many mainstream UNIX environments (e.g., Solaris and HP-UX)." In support of Windows On the other side, there are Windows supporters who claim that Oracle and Oracle9iAS run far faster using a Microsoft OS. According to John Taschek of EWeek magazine ("Microsoft, Oracle in Benchmark War"), Microsoft conducted a performance benchmark of Oracle’s application server (Oracle9iAS) and concluded: "The results show Windows is indeed faster than Oracle in this particular test—the first time that the same load testing tool and hardware platform were used. However, there are several reasons why this test is not completely valid, but there are two in particular that come to mind: The code used by Microsoft is obviously not Java, and, therefore, no direct comparisons can be made, and Pet Store was never designed to be a benchmark." Where from here? For now, there is no conclusive finding about whether Oracle Intel is best on Linux or Microsoft Windows. Much of the problem lies in the definition of "best." From an Oracle management perspective, Oracle professionals who grew up on the Windows GUI fear having to learn cryptic Linux commands, while UNIX Oracle professionals detest the complicated Windows registry and lack of a command-line interface. From a performance perspective, the debate continues, with neither Linux nor Windows taking a clear lead. However, one thing is clear: As Intel-based processors leap into a 64-bit architecture, Oracle shops will be rushing to adopt these lower cost server alternatives, and proprietary UNIX vendors such as Hewlett-Packard, Sun, and IBM will also be forced to lower their prices to remain competitive.
What if Linux were like Windows?
I run a 64-bit PC with a 32-bit Windows OS, and I’m used to dealing with the inevitable memory leaks, unplanned locks-up and re-boots. I even use IE7 Beta, guaranteeing that I have frequent memory-related problems. It’s fun to watch Windows freak-out with memory problems, as bits and snippets from Random RAM heaps display on your screen. It makes me wonder what it might be like on a shared Windows platform. I first remember seeing buffer overflow RAM leaks in Cobol programming where a S0C4 would include RAM from other regions.
Anyway I wonder what Linux would be like if we had constant zombie processes, core dumps from RAM trace files, kernel panics and Linux-level enqueues on shared resources? Of course, the folks in-the-know never get into the Linux GUI components because they know the command syntax. A reflex-knowledge of Linux commands can out-do any GUI, any day, and that’s why you can’t fake knowing Linux.
It’s fun to watch alleged Linux GUI experts squirm when you ask them to use vi for a complex change, write a shell script or modify a crontab. If it’s not in the GUI they can’t do it and they are lost at the command prompt. Now, I appreciate the point-and-click features of a GUI, but I still write DOS scripts (SFU, Windows services for Unix) when I need a series of tasks.
|
-----
http://www.dba-oracle.com/art_builder_linux_oracle.htm
Monday, October 29, 2012
Apakah itu Perisian Alpha Five
What is Alpha Five Software?
Alpha Five adalah Sistem Pengurusan Pangkalan Data Relational (Relational Database Management System) dan Sistem Pembangun Perisian Pantas (Rapid Application Development) untuk membina Aplikasi Windows dan Web (termasuk teknologi AJAX). Ia adalah saingan kepada Microsoft Access tetapi ia menyokong pembangunan Web yang lebih mudah berbanding Microsoft Access.
Alpha Five V8
Versi terkini adalah Alpha Five V11 yang dikeluarkan pada Oktober 2011.
Pada tahun 2010, Alpha Five dinobatkan di tangga pertama dalam kategori Pembangun Pantas Untuk Aplikasi Web oleh InfoWorld.
Alpha Five dibangunkan oleh Alpha Software semenjak tahun 1982. Ia mula menjadi perhatian apabila Alpha Five Version 8 mendapat anugerah Dr. Dobb's Jolt Award bagi kategori Persekitaran Pembangun Perisian Terbaik.
Aplikasi menggunakan enjin DBF-terbina (built-in DBF) dan dapat dihubungkan kepada MySQL, Oracle, MS SQL Server, DB2, EnterpriseDB, PostGreSQL dan Perisian Database SQL yang lain melalui sumber ODBC. Versi terbaru memuatkan Portable SQL, satu ciri yang membolehkan pengguna menukar database tanpa perlu menulis query semula.
Alpha Five dikatakan lebih hebat berbanding Microsoft Access. Terdapat bahan sumber yang memberi panduan membuat pemindahan dari Access Database ke Alpha Software. Ia juga turut dibandingkan dengan perisian database yang lain seperti FileMaker dan Iron Speed Designer.
Alpha Five menyediakan panduan Getting Started pada pautan http://wiki.alphasoftware.com/tiki-index.php. Di samping itu Alpha Five turut mempunyai komuniti pembangun perisian seperti http://www.alphadevnet.com/whyalphafive.a5w yang menyediakan sumber rujukan bagi ahli komunitinya.
Thursday, March 01, 2012
Memindahkan aplikasi PHP+MySQL dari Linux ke Windows
Aplikasi Silang-Platform (english: Cross-Platform Application) mempunyai kelebihan berbanding Aplikasi Platform-Specific kerana ia boleh dipindah dari satu platform ke platform yang lain tanpa berubah sifat dan khidmatnya.
Antara jenis pindahan aplikasi cross-platform termasuklah jenis Pindahan PHP+MySQL dari server Linux ke server Windows dan sebaliknya.
Tuesday, August 04, 2009
Bagaimana menggunakan database
Database amat berguna dalam kerja-kerja mengurus dan mengawal maklumat. Untuk menggunakan database dengan cekap, pengguna perlu memahami gambaran kasar bagaimana database berfungsi.
Terdapat berbagai jenis database; Hirarki, Network dan Relational. Yang popular dan lazim digunakan pada masa sekarang adalah Relational. Kewujudan perisian percuma seperti Linux dan MySQL telah merancakkan lagi penggunaan database di kalangan pengguna Internet.
Maksud Relational adalah database yang mengambil konsep tabular data representation (data disusun dalam bentuk table/jadual, seperti jadual kelas contohnya). Konsep ini bukanlah sesuatu yang asing kepada pengguna komputer di pejabat. Rata-rata pengguna telah biasa menggunakan lampiran kerja MS Excel yang juga berkosepkan tabular data representation.
Di dalam Relational Database, satu table mewakili satu set gabungan data yang membentuk entiti tertentu. Contohnya table 'pelajar' mengandungi lajur yang mewakili ciri-ciri pengenalan pelajar (nama, no ic, alamat, email) dan baris (setiap satu baris mewakili maklumat seorang pelajar berdasarkan ciri-ciri tadi). Satu Relational Database boleh mengandungi banyak table. Contohnya Database bagi Sistem Pendaftaran Pelajar mungkin mengandungi table 'pelajar', 'jurusan', 'kelas' dan sebagainya.
MySQL adalah contoh Relational Database. Dalam sistem database MySQL, satu komputer akan berfungsi sebagai hos dan komputer2 laing yang berhubung dengannya berfungsi sebagai klien.
Untuk memahami dengan lebih lanjut, anda boleh mencuba MySQL yang dihoskan secara percuma di http://www.freesql.org/
Pakej perisian MS Office juga mempunyai perisian MS Access yang turut menggunakan konsep Relational Database. Bagaimanapun tujuan asas MS Access adalah untuk pengguna komputer peribadi sahaja. Maka ia tidak direka untuk menampung ramai pengguna dalam sesuatu jaringan komputer.
Walaubagaimanapun sifat MS Access yang mudah dan ramah pengguna menjadikannya popular di kalangan pengguna komputer peribadi dan tidak hairan jika usaha menggabungkan MS Access dan MySQL telah dibuat. Melalui penggunaan perisian pemandu MyODBC, anda boleh menggabungkan MS Access (sebagai Front End) dan MySQL (sebagai Back End).
Monday, August 03, 2009
Pengenalan-Database System (Sistem Pangkalan Data)
Database bermaksud satu cara menyimpan dan menguruskan data secara terkawal dan berpusat.
Peranan Database menjadi penting apabila organisasi mempunyai data yang banyak dan berkait antara satu sama lain. Antara kelebihan Database:
1) Simpanan dan kawalan data secara berpusat
2) Pengurusan data secara cekap
3) Mengelakkan gejala data yang disimpan berulang2 dan data yang disimpan berselerak
4) Meningkatkan penggunaan data effektif dengan membenarkan data dicapai oleh perisian yang lain.
Perisian Database boleh dijalankan secara standalone (bersendirian) ataupun secara networked (berangkaian). Sistem secara standalone (bersendirian) turut dikenali sebagai desktop database (pangkalan data (komputer)"atas meja"). Sistem berangkaian pula kebiasaanya berdasarkan Client-Server Architecture (Senibina Pelanggan-Pelayan). Pada masa kini, Networked Database System (Sistem Pangkalan Data Berangkaian) digunakan dengan meluas melalui Internet
Antara Desktop Database yang popular adalah Microsoft Access, Foxpro dan File Maker.
Antara Networked Database yang popular adalah Microsoft SQL, MySQL, PostGre dan Oracle.
Thursday, April 23, 2009
(FREE) Grubba - Online Database Anda
Grubba adalah 'online database' alternatif kepada MS Access dan Filemake pro. Pilih 'template' atau bina 'form' anda sendiri beserta 'database' yang sesuai. Boleh digunakan oleh pengguna baru atau pengguna mahir.
Subscribe to:
Posts (Atom)