Database tools

April 7th, 2010 Comments off

Here’s a short list of some recommended Data Modelling Tools in alphabetical order, and
if you have any specific recommendations or comments, please write comments
There’s a short note about about Data Modeling and Database design at the bottom of the page.
Finally, here’s an analysis of some Data Modelling Tools.

PRODUCT VENDOR PRICE COMMENTS
AquaData Studio ER Modeler AquaFold $400 A free 14-day evaluation copy can be downloaded.
The purchase price includes 12-month support. After the first year, support can purchased for 35% of the original license price.
“Discounted licences are available for qualified Academic users and Free licenses are available for qualified Open Source Software (OSS) Developers.”
Altova DB Design Altova One of a broad range of Tools.
Argo UML Tigris Free – Open Source For Modelling UML Diagrams – but not for the faint-hearted.
Azzurri Clay Azzuri (Japan) Free !!! From Japan -Open Source Plug-In for Eclipe – Reverse Engineering and generates SQL.
Pro version costs 35,000 Japanese Yen (about $150) !!
Case Studio 2 Acquired by Toad (see below under Toad Data Modeler) CharonWare Free Download, then $175(Lite) or $369(Full) Looks impressive – supports an unusally wide range of Databases, including Firebird, MaxDB,Postgres – if you try it, please me have your comments.
Here’s a “5-Star” Review from Dan Horn.
CASEWise CASEWise Aimed at Business Process Modelling, but has links to DataArchitect.
ConceptDraw CS Odessa $179 (50% off) For ERD, UML, ORM, FlowCharts, etc. – Free Download Trial is available. I like the appearance of the diagrams this Product produces and this is an important consideration for me.
DataArchitect Sybase $2,000 If you are buying for the company, buy this one.
DataArchitect is part of Power Designer, which is described below.
DataArchitect TheKompany $39.99 Highly recommended by Andy Brown and an unbeatable price. Comments and experiences please.
Database Design Tool (DDT) Open Source THANKS VERY MUCH to Josh Bosh, Milwaukee’s most beloved Web specialist, for providing this link.
Database Design Studio Chilli Source $39 – $200 Comes in two versions – Lite at $79 ($39 Educational), which supports ERD Modeling and Forward Engineering and Professional at $299, which adds support for Reverse Engineering.
Database Designer MicroOlap $125 Specially for PostgreSQL and includes Reverse Engineering.They give it away free if you mention it in your Blog.
DB Constructor Robert Schambach Free/$150 Here’s a glowing reference at the FreeDownloadCenter Web Site.
DBDesigner 4 FabForce.net Free (Donations welcome) Open Source and highly recommended if you work with MySQL.
DBDesigner-Fork SourceForce.net Free A Fork of DBDesigner 4 (see above)- generates SQL scripts for Oracle, SQL Server, MySQL and FireBird.
DB Diagram Designer PrimeLogics Offers a free evaluation download or $130 to buy. Looks very interesting – modeller plus data editor using ODBC connections. If you try it please let me know your opinion.
DBSchema Concrete Software, Romania Free download and then only $45 to buy. Reverse Engineer Oracle and other Databases using JDBC connections.
Can also generate SQL to create Databases from a Data Model.
DBVisualiser Minq Free evaluation and then only $129 to buy,($103 for Education). Helpful for DBA work, like performance monitoring.
A Finalist for ‘Best Data Access Tool 2005′ in the Java Developers Journal Readers Choice Award and included in the BEA WebLogic Workshop.
Free version available with “the basic level of features that most users require”.
Nizana $149 “Forward and Reverse Engineer, Affordable, Easy to Use.”
Dezign Datanamic Offers a free download or starts at $229 to buy. A recent upgrade offers significantly improved features.
Supports Forward and Reverse Engineering for about 20 different Databases.
If you are buying for yourself, buy this one
Dia Hosted by Sourceforge Free – Contributions suggested “Dia is software for drawing diagrams similar to Visio”, such as UML. It’s Open Source with many authors. Install it from here
Druid From SourceForge Generates SQL Scripts and Java classes.
Thanks again to Josh Bosh.
Enterprise Architect Sparx Systems $99 UML Analysis & Design Tool and very affordable.
Entity Framework Add-on IdeaBlade $995+/developer “Makes Microsoft’s Entity Framework easier to use”
ER Creator Model Creator About $100 Includes a Tutorial and a Trial version.
ER Diagrammer KeepTool $240 Free download is available and a User Forum is supported.
ER/Studio Embarcadero Prices very difficult to find on the Web Site – always a bad sign !!!
ERWin Computer Associates One of the Market Leaders
Experience Electronic Exerience Free Trial then 90 Euros (about $50)
Google WWW SQL Designer Ondrej Zara (Czechoslovakia) (Free) Open Source Good-looking sample Data Model.
Happy Fish Polderij NV. (in Dutch) $89 Previously known as Rational A great name and a new Product so please tell us if you have any experience with it.
IBM InfoSphere Data Architect IBM $5,570 !!! Provides reverse and forward engineering facilities for a range of databases, also ERD and UML Modelling.
ImportER MySQL Datanamic Excellent value at $55 Reverse Engineering for MySQL
Jude UML Diagrammer Jude FREE or $200 A FREE Community version is available, and they publish a lot of very favourable User Comments in their Community Forum.
KeepTool KeepTool $300 / 300 Euros Can Reverse Engineer Oracle Databases to create Data Models – Comments and experiences welcome.
MagicDraw No Magic Award-winning UML Modeller and very popular with Java enthusiasts.
ModelRight ModelRight Free Trial, then $495 for DB2, Oracle and SQL Server, $295 for MySQL and PostgreSQL, and $195 for Access. An enthusiastic user is David McKelvey from Richardson,Texas, who says “As a pure Database Physical Modeling Tool, nothing else comes close.”
MySQL Workbench MySQL Free with MySQL (also free) Looks good and offers Reverse Engineering.
OpenSystemArchitect Code By Design Free (Open Source) Thomas Kellerer says :- “I wasn’t very excited about [this]. It crashed several times and the project doesn’t seem active any more.”
I have included it for completeness and I would welcome any comments.
Oracle Designer Oracle $200 Available from the Oracle Technology Network (free to join).
Oracle says “Oracle Designer is our model-driven development tool based on the principles of Information Engineering.”
Oracle J-Developer
Thanks to Thomas Kellerer for helping me keep this up-to-date.
Oracle Free Download UML diagramming is part of J-Developer.
Also available from the Oracle Technology Network.
Oracle says “Oracle JDeveloper is an integrated development environment with end-to-end support for modeling, developing, debugging, optimizing, and deploying Java applications and Web services.”
PG Designer From John. Open Source – for PostgreSQL.
Thanks again to Josh Bosh.
Platinum Repository Computer Associates This is a Repository, rather than a Modelling Tool, with a ‘Where-used’ facility, and it lets you add entity types,such as Business Function, Business Role and Script.
Poseidon GentleWare Comes highly recommended, good for UML, and has an open-source FREE version.
Power*Architect SQL Power Free (Open Source) Thomas Kellerer says :- “Looks quite nice at first glance. Commercial Support is available” from SQL Power, which seems a good company to partner with.
Power Designer Sybase $2,000 If you are buying for the company, buy this one.
The Data Modelling Tool in this composite product is called “DataArchitect”.
Unfortunately, the design of the web site has changed recently and information about Data Architect is difficult to find. But the product is excellent, and I have found its powerful Reverse Engineering facilities to be very useful.
ProVision WorkBench Proforma Corporation. Prices on Application !!! “A Repository-based integrated business process and object modeling toolset.”
An interesting range of Data Model Exchange facilities.
Rhalotel DB Diagram Mgr Rhalotel 98 Euros/$100
RM Bench Byte Refinery Free Trial then $120 “Graphical Modelling of Relational Databases in Eclipse”.
Saphir Computer Associates
(acquired from Silwood)
Used to be about $14,000 but check with CA Saphir is more than a Modelling Tool. It sits between an ERP like SAP and a Modelling Tool like ERWin.
It provides a very useful and powerful Metadata manipulation package which allows you to extract metadata from ERPs such as SAP, J.D. Edwards and PeopleSoft, which can then be ‘reverse engineered’ into a Modelling Tool like ERwin, to see the Data Model.
SilverRun ModelSphere DM Data Modeller Grandite Offered on a unique Buy or Rent Scheme ($1,500/year).
But the Web Site says ‘Please contact us for a customized quote’ – which often means ‘If you have to ask, you can’t afford it’.
Offers Evaluation Download
SmartDraw SmartDraw $50 !!! Recommended – Promoted as a UML Drawing Tool with impressive support.
SQL Maestro SQL Maestro Group FREEware Please let me know if you have any experience with this product.
SQL Manager EMS FREE Trial available
Squirrel Squirrel FREE Open Source
StarUML SourceForge FREE “The Open Source UML/MDA Platform” (from Korea).
System Architect 2001 Popkin $3,000-5,000 per seat. In an evaluation, I found this product very difficult to use, the diagrams were very ugly and it crashed too often for me to recommend it. Downloads available for Evaluation.
Toad Data Modeler Quest Free Download, then $479 Price is 30% off to CASE Studio 2 customers
From the makers of Toad, and based on CASE Studio 2 – Includes 24×7 support, runs on over 40 DBMSs, and you can create ER & Data Flow diagrams, reverse engineer and generate SQL Scripts.
TogetherSoft Solo Borland Downloadable Supports UML
Toolkit for Conceptual Modeling (TCM) University of Twente, Holland Free and Downloadable Very interesting combination of Tools, including UML.
Thanks to Tony Adams for suggesting a better link here.
Umbrello SourceForge FREE Open Source UML Modeller
Visio Microsoft Trial CD available Many Versions- Standard($199),Technical($399),Professional($399) and Enterprise($999)
Visual Thought CERN (Godfathers of the Internet) Give it a try for UML.
THANKS AGAIN to Josh Bosh, Milwaukee’s most beloved Web specialist, for providing this link.
Win A&D Excel Software No price information on the Web Site Unusually offers products for MAC as well as Windows – UML Modelling as well as ERD.
xCase Resolution Software $800 (Download Trial available) “xCase is a complete database design and maintenance tool including archiving and model compare and merge across different DBMSs”.

Categories: Uncategorized Tags:

Dual Boot Macbook

March 29th, 2010 Comments off

If you want to make your Macbook have Dual boot, please try my experience in below.

I have been researching and testing out the
possibility of dual-booting Mac OSX Leopard alongside my Ubuntu Gutsy
on my laptop. It hasn’t been an easy task. Most of the guides out
there are mainly about dual-booting Vista/XP and Mac OSX and are of
little help. My laptop has been through many rounds of partitioning,
formatting, installing using various OSx86 version before I finally
get Mac Leopard to work perfectly, alongside with Ubuntu Gutsy (Yes,
you hear me right…it works perfectly, even the airport, sound card and
graphics). The OSX86 patched release that I am using is iATKOS

“iATKOS is one of the first FULLY patched Leopard v10.5.1
releases. It is also known to have a preinstalled complied efi which
means that you can install legit Apple Updates without downloading any
patches or 3rd party software and also you can stop worrying about
reboots hanging on the “Loading Darwin” screen.” – InsanelyMac Forum

DISCLAIMER:

1. The tutorial works for my laptop configuration. I can’t
guarantee that it will work on yours.
2. The patched release that I am using is only for Intel system
with SSE2/3. If you are using AMD system, this guide is not for you.
3. I shall not be responsible for any loss of data, and in the
worst case, crash of your PC. Please backup all your data before you
proceed with any of the steps below and do it at your own risk.

Assumption

Before we start, it is assumed that you are operating from one hard
disk and have Ubuntu Gutsy already installed in the disk.

What you need:

1. Ubuntu Gutsy Live CD – Get the .iso at Ubuntu download and burn
it into a CD
2. iATKOS_v1.0ir2.iso – There are two versions to this:
iATKOS_v1.0i and iATKOS_v1.0ir2. Get the one with the ‘r2′ behind. The
file size is 2.44gb. Source for it in Google. Burn the image to a DVD.
3. pc_efi_v80.tar.bz2 – This is essential for configuring the grub.
Download and place it in your Gutsy’s home folder. (Google the term
‘pc_efi_v80.tar.bz2′ and you should be able to find the download
site.)

Let get started!

Creating a partition for Mac OSX

1. Back up your data, especially the /boot/grub folder. (Resizing your
hard disk can cause data loss. Please back up all data before you
proceed)

2. Go to your BIOS (check out your system user manual for the button
to access your BIOS during bootup). Change the first boot device to
your DVD-ROM Drive.

3. Insert the Ubuntu Live CD into the DVD ROM and reboot the PC.

4. Boot into Ubuntu (Select “Start or Install Ubuntu” in the boot up
screen and wait for it to finish loading)

5. Open System->Administration->Partition Editor.

6. Select the partition that is installed with Ubuntu Gutsy. Click Resize/Move.

7. Enter the new file size. (iATKOS needs a minimum of 5GB for
installation, so make sure that you have at least 5GB of free space
after resizing). Click OK

8. Back to the GParted screen, you should now see a partition of free
space that is unallocated. Click on it and select “New”. Allocate all
the available space and format as FAT32. (Do not select any other
format except FAT32).

9. Once you are done with the configuration, click ‘Apply’ to finalize
changes. You should now have a ext3 partition that contains your Gutsy
and a FAT32 partition. (You should also see a swap partition. Don’t
touch that. It is necessary for Gutsy to run.)

10. Exit GParted and restart the PC.

Installing Mac OSX

11. The PC will eject the Live CD. Remove the Live CD and replace with
the iATKOS DVD. Press ENTER to reboot the PC.

12. You should now see a darwin load screen . When it prompted you to
install Mac OSX, press ENTER.

13. Wait. After some time, if nothing goes wrong, you should see the
Leopard installation screen with a red apple.

14. Press the “–>” on the screen

15. In the next screen, go to Utilities->Disk utility

16. On the left side of the window, you should see the various
partitions all greyed out.

17. Select the partition with the FAT32 format. Click on Erase on the
right hand side, and under the format options select “MAC OSX
Journaled Extended” and click Erase. This will format the FAT32
partition to HFS format. Once the disk is erased and formatted, you
can see that the partition is now active (in bold) on the left hand
side while rest of the partitions are still greyed out.

18. Exit the Disk utility. This will bring you back to the
installation screen. Click Agree and continue.

19. In the next screen, you need to select the partition for
installation. It should only show one partition (the one we formatted
just now). Select that and click OK.

20. Sit back as the installation goes on for some 20-30 mins based on
your RAM. (Note: Don’t click on customize and select unnecessary
patches, drivers etc, The plain install will do.)

First Login to Mac OSX

21. Once the installation finishes, restart the PC without removing
the installer DVD. You need it to boot into Mac OSX.

22. When the PC restarts, don’t click anything, even when you are
prompted to install Mac. After a while, you should see the grey apple
screen and then the beautiful MAC OS startup screen with welcome
message.

23. Follow through the series of steps to set up your account. Once
finished, you should have a functional MAC Leopard in your desktop.
Depending on your hardware, the sound card and airport might/might not
work. My sound card and airport work right out of the box.

Configure the boot option

Now that your Mac OSX installation is completed, we need to configure
the boot so that you don’t have to boot from the installer disk
everytime.

24. Remove the DVD from the drive and restart the PC.

25. Boot back to your Ubuntu. You should have no problem in booting
back to Gutsy. (If Gutsy can’t boot due to corruption in the grub
bootloader, reboot from the Live CD and restore the /boot/grub folder
from your backup.)

26. In your Gutsy home folder, extract the pc_efi_v80.tar.bz2

27. In the extracted folder, copy boot_v8 to /boot folder (require
administrator access). In terminal,

sudo cp /pc_efi_v80/boot_v8 /boot

28. Open the menu.lst in /boot/grub folder. In terminal,

sudo gedit /boot/grub/menu.lst

look for hiddenmenu and replace it with #hiddenmenu

29. Next, look for something like

title Ubuntu 7.10, kernel 2.6.22-14-generic
root (hd0,x)
kernel /boot/vmlinuz-2.6.22-14-generic
root=UUID=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxx ro quiet splash
initrd /boot/initrd.img-2.6.22-14-generic
quiet

*Depending on your partition configuration, you might see something
like (hd0,2) or (hd1,0).

Insert the following line below it:

title Mac OSX Leopard
kernel (hd0,x)/boot/boot_v8

*change the ‘x’ to the number shown as above.

30. Save and exit.

31.Now, reboot the PC.

32. In the boot up screen, there should be options to boot up Ubuntu
7.10 or Mac OSX Leopard. Select Mac OSX Leopard. You should be able to
boot into Mac OSX

Access Ubuntu partition from Mac OSX

Mac OSX does not recognise ext3 format by default and it is not able
to read/write to your Ubuntu partition. To access Ubuntu partition
from Mac OSX, install Mac OS X Ext2 Filesystem

Access Mac partition from Ubuntu

Accessing Mac partition from Ubuntu gutsy is easier. Install hfsplus
and hfsutils

sudo apt-get install hfsplus hfsutils

Enjoy!

Special thanks to those that make this guide possible:

Easy Installation Guide: Dual Boot Windows Vista and MAC OS X 10.5 ..
Real quick and fool proof

InsanelyMac Forum

http://wiki.osx86project.org/

Categories: Uncategorized Tags:

Triple Boot Macbook

March 29th, 2010 Comments off

Cara install triple boot pada macbook
1. install macos sampai selesai selesai/running
2. buka “disk utility” (application – utility- disk utility)
cek apa partisi hanya 1, bila tidak delete partisi lainya (klik
partisi – “-” – apply), resize partisi mac (tarik windows partisi mac
full – apply)
3. Buka Terminal
$ diskutil list (pastikan hanya 2 partissi: MBR dan HFS saja)
$ sudo diskutil resizeVolume disk0s2 30G “MS-DOS FAT32″ “Data” 61G
“MS-DOS FAT32″ “WindowsXP” 20G
cek:
$ diskutil list
4. Install Windows XP dari CD atau copy iamge Windows ke WindowsXP
(Jalankan WindowsXP live [Windows Barte XP]. Jalankan Ghost copy
partisi dari Windows image ke Partisi WindowsXP)

baca:
http://tripleboot.is2.byuh.edu/
http://cm-wiki.stanford.edu/wiki/Macbook_pro_triple-boot

Categories: Uncategorized Tags:

Hello world!

March 29th, 2010 2 comments

Selamat Datang di Universitas Brawijaya. Ini adalah posting pertamaku

Categories: Uncategorized Tags: