Installation and basic features of EnterpriseDB

Exclusive offer: get 50% off this eBook here
Creating your MySQL Database: Practical Design Tips and Techniques

Creating your MySQL Database: Practical Design Tips and Techniques — Save 50%

A short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily.

€9.99    €5.00
by Jayaram Krishnaswamy | January 2009 | MySQL PHP

Postgres is the well known and most used Open Source OLTP database available today. EnterpriseDB sits atop Postgres and leverages it to provide enterprise capabilities to Postgres users. EnterpriseDB is available for Windows platform as well. It has most of the necessary features of an enterprise class such as advanced development, monitoring, migration and administrative tools with a stable environment. It also has plug-in capabilities for Oracle. In the present form EnterpriseDB claims cost effectiveness versus Oracle and better scalability than MySQL. It can easily integrate with most applications such as Java, Ajax, Ruby, Drupal etc. This article by Dr. Jayaram Krishnaswamy mainly describes the installation of EnterpriseDB and the basic features to get started on this important database product.

Installing the EnterpriseDB

Download PostgrePlus Advanced Server 8.3 ( pgplus-advsvr-windows-83012b.exe (120MB) ) from the following site: http://www.enterprisedb.com/products/download.do. After downloading the program double click the executable file. You may need to choose a language from a list of languages. Here English has been chosen. The welcome window gets displayed as shown. Click Next.

Installation and basic features of EnterpriseDB

Choose the option you need. Read notes on this page to make the choice. Here, the Oracle compatibility has been chosen.

Installation and basic features of EnterpriseDB

Click Next or, choose a different location by browsing. Here the default location is accepted.

Installation and basic features of EnterpriseDB

Click Next. The window that shows up displays all the various features that are available. Pick and choose the features. Here all features are chosen.

Installation and basic features of EnterpriseDB

Click Next. The next window shows the links from where the JDBC drivers for connecting to Oracle and MySQL are available displayed. Click Next .

Installation and basic features of EnterpriseDB

In the window that shows up you need to choose the password for the Operating System UserID and Password. Read the cautionary remarks on this page. Choose Next. At this point your anti-virus program may require you to permit to run the program.

Installation and basic features of EnterpriseDB

McAfee is the anti-virus program on this computer.

Installation and basic features of EnterpriseDB

In the window that gets displayed you may need to choose the administrator's log in credentials. You may also Browse and select the Data Destination Directory. Herein the default is accepted. Click Next.

Installation and basic features of EnterpriseDB

In the windows that gets displayed you may choose the type of environment for which the server will be used as well as the work load for which you may be using the server. The dynamic tuning options available are:

    Server Utilization
  • Development: This is a development machine and many other applications will be running on it. Stress testing should not be performed with this configuration. EnterpriseDB will use a minimal amount of memory.
  • Mixed: Several applications will be running on this machine. Choose this option for web/application servers.
  • Dedicated: This machine is dedicated to run EnterpriseDB and will use available memory to optimize performance.
    The Workload Profile
  • Transaction Processing: The running application is a transaction intensive applications.
  • General Purpose: The database will be used for transaction processing as well as complex queries and reporting.
  • Reporting: The database will be used for reporting applications.

For this tutorial, the Mixed option for Server Utilization and General Purpose for Workload Profile were chosen.

Installation and basic features of EnterpriseDB

Click on Next. The Summary page gets displayed showing all the options chosen.

Installation and basic features of EnterpriseDB

Click on the Install button. The window with a progress bar gets displayed.

Installation and basic features of EnterpriseDB

You may get a warning from the anti-virus program on your computer to allow the file to be executed.

Installation and basic features of EnterpriseDB

Click OK to allow install.

Creating your MySQL Database: Practical Design Tips and Techniques A short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily.
Published: November 2006
eBook Price: €9.99
Book Price: €16.99
See more
Select your format and quantity:

Installation and basic features of EnterpriseDB

When you click on Next you will see a window where you can get updates as well as some information on the size of files and their versions.

Installation and basic features of EnterpriseDB

When you click on  Download & Apply you need to provide the authentication information as displayed in the next page. You need to access your Email to complete the information for the updates by clicking on the link provided.

Installation and basic features of EnterpriseDB

Click on Next. In the window that shows up you can get updates. Updates need stopping of the server. You must accept this for the upgrade to proceed.

Installation and basic features of EnterpriseDB

This window shows the completion of the upgrade and the location of the upgrade information.

Installation and basic features of EnterpriseDB

When you click Finish you will see this thank you note from EnterpriseDB.

Installation and basic features of EnterpriseDB

Program shortcuts on the desktop

After a successful install you should be seeing the following when you access Start | All Programs | Postgres Plus Advanced Server 8.3 as shown.

You get a rich set of tools to work with this database. You have the ability to stop/start the database from here as well as from Control Panel | Administrative Tools | Services. The Postgres Studio is a nice GUI for managing objects which can be invoked from here. More on these later.

Installation and basic features of EnterpriseDB

Postgres Plus windows services

When you access Start | All Programs | Administrative Tools | Services and open the Services window you get the following services displayed. Note each of the 'Log On As' items of the services and they can be configured in this window.

Installation and basic features of EnterpriseDB

Postgres Studio

You can open the Postgres Studio from Start | All Programs | Postgres Plus Advanced Server 8.3 | Postgres Studio. You need to provide the authentication to connect to the Server as shown here.

Installation and basic features of EnterpriseDB

If you opt to store the password then you will be given the following instruction. Here the "Store password" option was not chosen. Read the consequences of storing the password.

Installation and basic features of EnterpriseDB

After you are connected you can click on the Advanced Server 8.3 node to expand and access other objects as shown in the next figure. Out of the box, after the installation, there is only one database, mgmtsvr - Management Server Backend database. The databases PGNorthwind and postgres were created later.

Installation and basic features of EnterpriseDB

Summary

The tutorial described the installation of EnterpriseDB which is built on top of Postgres on a Windows XP Professional computer. Some of the basic features such as Windows Services, Program shortcuts, Postgres Studio were described. Future articles will cover managing databases with the Postgres Studio; Migration from / to other vendor products ; database connectivity with applications; integration with other open source applications, etc.

Creating your MySQL Database: Practical Design Tips and Techniques A short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily.
Published: November 2006
eBook Price: €9.99
Book Price: €16.99
See more
Select your format and quantity:

About the Author :


Jayaram Krishnaswamy

Jayaram Krishnaswamy studied at the Indian Institute of Science in Bangalore India and Madras University in India and taught at the Indian Institute of Technology in Madras. He went to Japan on a Japanese Ministry of Education Research scholarship to complete his PhD in Electrical Engineering from Nagoya University. He was a Post-Doctoral Fellow at Sydney University in Australia; a Government of India Senior Scientific Officer at the Indian Institute of Science in Bangalore and Indian Institute of Technology at Kanpur; a Visiting Scientist at the Eindhoven Institute of Technology in the Netherlands; a visiting Professor of Physics at the Federal University in Brazil; an Associate Research Scientist at a government laboratory in São Jose dos Campos in São Paulo, Brazil; a visiting scientist at the National Research Council in Ottawa, Canada before coming to USA in 1985. He has also taught and worked at the Colorado State University in Fort Collins and North Carolina State University in Raleigh, North Carolina. He worked with Northrop Grumman Corporation on a number of projects related to high energy electron accelerators and Free Electron Lasers. These projects were undertaken at the Brookhaven National Laboratory in Long Island and in the Physics Department at Princeton University. He has over 80 publications in refereed and non-refereed publications and 8 issued patents. He is fluent in Japanese and Portuguese and lives in Honolulu, Hawaii, USA.

He has been working in IT-related fields since 1997. He was once a Microsoft Certified Trainer in Networking and a Siebel Certified developer. He has worked with several IT related companies, such as the Butler International in their Siebel practice, with several IBM sub-contractors and smaller companies. Presently he is active in writing technical articles in the IT field to many online sites such as http://CodeProject.com, http://APSFree.com, http://DevShed.com, http://DevArticles.com, http://OfficeUsers.org, http://ASPAlliance.com, Egghead Café, http://SSWUG.org, Packt Article Network, http://databasedev.co.uk, http://cimaware.com, and many others. Between 2006 and 2010 he wrote more than 400 articles mostly related to database and web related technologies covering Microsoft, Oracle, Sybase, ColdFusion, Sun, and other vendor products.

He has written four books all published by Packt related to Microsoft Database and Application Development: SQL Server Integration Services Using Visual Studio 2005, Learning SQL Server Reporting Services 2008, Microsoft SQL Azure; Enterprise Application Development, and Microsoft Visual Studio Lightswitch Business Application Development. He regularly writes for his four blogs on Blogger; http://Hodentek.blogspot.com, http://HodentekHelp.blogspot.com, http://HodentekMobile.blogspot.com, and http://HodentekMSSS.blogspot.com. He received the 2011 Microsoft Community Contributor award.

Contact Jayaram Krishnaswamy

Books From Packt

Learning SQL Server 2008 Reporting Services
Learning SQL Server 2008 Reporting Services

Mastering phpMyAdmin 2.11 for Effective MySQL Management
Mastering phpMyAdmin 2.11 for Effective MySQL Management

Learning jQuery : Better Interaction Design and Web Development with Simple JavaScript Techniques
Learning jQuery : Better Interaction Design and Web Development with Simple JavaScript Techniques

Creating your MySQL Database: Practical Design Tips and Techniques
Creating your MySQL Database: Practical Design Tips and Techniques

Oracle Web Services Manager
Oracle Web Services Manager

Beginners Guide to SQL Server Integration Services Using Visual Studio 2005
Beginners Guide to SQL Server Integration Services Using Visual Studio 2005

Expert Python Programming
Expert Python Programming

Oracle Modernization Solutions
Oracle Modernization Solutions

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software