Skip to main content

Related Articles

No More Database Programming Needed !

Are you tired in writing complex code for your database design? Want to be little relax? This article will help you to enjoy your job.

In early days we had to write coding from the scratch to implement our database designs. Later people moved to database designing graphical tools. The latest trend of designing databases is use database navigation maps where you can visually feel your database design. This method is very useful if your database is little complex and you have lot of key constraints, referential integrity constraints, indexes and triggers etc. Using database navigation maps you can see either the entire database or part of it, how the tables are integrate each other, what are the keys you have defined for tables and references etc. Most importantly you don't need to write any single code or no need to remember complex SQL syntax.



Database Navigator Maps in IBM iSeries Navigator is providing very easy and flexible way of designing you database. Sometimes you might use this tool as visual tool but here I am explaining how you can use this tool as development tool to implement your database physically. Login to iSeries Navigator and browse databases section. If you are not familiar with the iSeries Navigator read this article. Under database section you can see Database Navigation Maps in tree view.

Fig 1: Select Database Navigator Maps
Once you select database navigation maps you will see existing maps in right hand side pane. Double clicking on the map you can open it and see. But let see how you can design new database using this tool. Right click on Database Navigation Maps and browse New -> Map.
Fig 2: Create New Database Navigation Map

This will open Database Navigator window which allow you to design your entire database. There it will list all the existing schemas and you can design your database under any schema listed there.
Fig 3: Database Navigator Window

Drawing area is the place you can use to draw or design your database. Right click on the drawing area and brows Create and select which you want to create. You have options to create database table, view, index, journal, alias, materialized query table and user defined relationship. By default user defined relationship is disabled and later will discuss how to write user defined relationship with the navigator.

Fig 4: Create Objects in Database Design
Once you create new element it is again open same window as iSeries Navigator opens to create new elements. I have already discussed to work them and design your database. You read more details from this article.
Once you designed you database using this tool it will look like this.

Fig 5: Sample Database Navigator Map
Final step is save the successfully design database into you DB2 database management system. Select save option from the file menu then give a name for your map select schema in which you need to save the database.
Later if you want you can change this design any time and save it. Please note that if you save the Database Navigator Map that mean your are physically change your database.
While your friend is spending days to develop a database, you can simple develop your database withing few minutes and have a relax. So try and see how you can simplify your work and have a fun.
If you have any questions you can post them under comments. I will reply them.

Comments

  1. how we download this component?

    ReplyDelete
  2. You don't need to download as separate application. It comes with your iSeries Navigator Client installation from IBM package. Please refer below link if you need to know how to open this application

    http://lk-tech.blogspot.com/2009/05/ibm-iseries-navigator.html

    ReplyDelete

Post a Comment

Popular posts from this blog

Angular PrimeNG checkboxes styling and events handling

  Getting Started With PrimeNG Styling in Angular App This chapter I am planning to show how you can handle events of the checkboxes. For that I will use checkbox for every card to place the order.  To use PrimeNG checkboxes you have to import checkbox module in app.module.ts file. import {CheckboxModule} from 'primeng/checkbox'; import { BrowserModule } from '@angular/platform-browser'; import { NgModule } from '@angular/core'; import { AppRoutingModule } from './app-routing.module'; import { AppComponent } from './app.component'; import { LandingComponent } from './modules/landing/landing.component'; import { HomeComponent } from './modules/home/home.component'; import { CardModule } from 'primeng/card'; import {CheckboxModule} from 'primeng/checkbox'; @NgModule({ declarations: [ AppComponent, LandingComponent, HomeComponent ], imports: [ BrowserModule, AppRoutingModule, CardModu

The Power of ChatGPT and Whisper Models

A Deep Dive into Natural Language Processing Natural Language Processing (NLP) has seen a significant boost in recent years due to advancements in artificial intelligence and machine learning. Two models that have shown remarkable success in NLP are ChatGPT and Whisper. In this article, we will delve into the power of these models and their applications in the field of NLP. ChatGPT is a transformer-based language model developed by OpenAI that uses unsupervised learning to predict the next word in a sentence based on the context of previous words. ChatGPT is a generative model that is trained on large datasets of text, such as books and articles, and can be fine-tuned for specific tasks, such as question-answering or dialogue generation. ChatGPT is known for its ability to produce human-like text, making it an ideal tool for applications such as chatbots, content creation, and language translation. Whisper, on the other hand, is a paraphrasing model developed by Google that is based on

Getting Started With PrimeNG Styling in Angular App

  This chapter I am going to explain how you can do the styling to our flower store app. There are different kind of CSS frameworks you can use to style you app. Such as: 1.        Angular Material 2.        ngx-bootstrap 3.        NG bootstrap 4.        Prime NG   I am planning to use PrimeNG styling framework to style our flower store app. PrimeNG has more than 80 UI component and it is a collection of rich UI components for Angular. All widgets are open source and free to use under MIT License.   How to Install Prime NG 1.     Run   npm install primeng –save  inside your root folder.                    2.        Run npm install primeicons –save to install prime icons. 3.        Run npm install font-awesome --save to Install Font Awesome 4.        Run npm install @angular/cdk –save to install angular  component dev kit. Now we are done with installing Prime NG to out flower store app. If you check your package json you will see below list of libraries.