About | Contact | SUBMIT PRESS | Advertise | FAQ
Spatial Newsletters | Twitter |
HomeNewsArticlesExpertsDataJobsEDULBSSTOREEVENTSDirectoryBLOGPHOTOSSocial Media
Software | Web Services | Submit Press | Utilities | Geo BIZ | iPhone News | Social Media | LBS | Webinars | LiDAR | Cloud  
advertisement

Top Geo News
Put Your News here! 
Social Connect




vimeostumble


Facebook

GISuser Sponsor


Recent Site Additions
Featured Webinar
Featured Video


GISuser TOP 10 Viewed Videos
More Photos and Videos

GIS Job Opportunities
 

Loads of GIS Jobs!

GIS Analyst
Data Processor
Software Developer
Support Analyst - Database
Applications Prototype Specialist–Web Development
Research Assistant for Geographic Information Centre
Academic Associate in Geographic Information Centre
Director of Mobile Product and Technology (Denver)
Subject Matter Expert — Infrastructure Industry - 12WD11118
GIS Analyst Senior
GISuser Sponsor

Directory
PhotoFinder 
Category: Geotagging Tools


GISuser Sponsor


AnyGeo - Anything Geospatial

↑ Grab this Headline Animator

GISuser RSS Feed
Home arrow News arrow GIS, Geo Tech Software arrow Get to the Database Data using DbSchema Relational Data Browse     

Feature - Using QR Codes to Deliver Maps Electronically
HOT JOB
post a GIS job * JOB OPPS * Subject Matter Expert, Autodesk CA / GIS Developer, VA
FEATURE - Using Social Media and Twitter To Land The Perfect Job
Submit Your GIS/Geo News/PR to GISuser
Get to the Database Data using DbSchema Relational Data Browse  E-mail
Written by DbSchema   
05 January 2012

Databases are widely used to support different kind of applications, from large to small, recently even in different Android applications. In most of the cases the SQL language is used to access and modify the database data. This can be sometimes complicated and would require deep technical knowledge. Using DbSchema Relational Data Browse the same can be done in an intuitive and simple way, fast, by anyone.

DbSchema is a universal database tool. It can work with all relational databases (MySql, SqlServer, Oracle, Postgresql, Db2, Informix, Sqlite, Derby, Sybase, etc.) and on all operating systems. From the most important features we can enumerate:

- diagrammed layouts for interacting and documenting the database schema
- SQL Editor for editing and executing SQL queries and scripts
- Query Builder for building complex queries using the mouse
- Relational Data Browse for exploring the database data
- Schema compare and synchronization, migration of the schema over development and productive databases
- HTML5 documentation including the layout image
- High quality diagram print-outs

Using Relational Data Browse is possible to explore data from multiple database tables. The editor can be started directly from schema diagrams. Here the data from one table can be explored just with a click. Filters can be set, sort criteria, etc. Than the data explorer can descend into child tables, based on foreign keys.

The great advantage is the intuitive way to explore the schema and get to the data. There is no need to know ahead the structure of the schema as the data browse is flexible and allows a dynamic explore of the tables.

The Data Browse does emphases the relationality between tables, so looking for the data the user will navigate from table to table as the real business model is. This is a kind of ´Clean code´ of databases. The Clean Code principle says that the quality of the code is directly related to the easiness to read and understand the code. Similar, for databases the quality of the database schema is directly related with the easiness to understand the schema. Indirect we can say this is related with the easiness to explore the data from database.

In this context the Relational Data Browse is an outstanding tool; there is no great SQL knowledge required in order to get in a direct contact with the schema model. Writing SQL queries is not a simple job and very often it requires good skills in this language. And even for those who have these skills, Relational Data Browse will offer the chance to focus on the schema architecture instead of language details.

We had the experience of Rui Martins, Java consultant and expert in large databases for communication companies. Using Relational Data Browse he could involve himself very fast and efficient in large projects with more than one thousand tables. He could move very fast through the schema and understand how the data were arranged and from here on to look directly in the code to find the problem he was looking for.

Few Universities around the world have adopted DbSchema as a tool for learning and working with databases. Especially the Relational Database Browse have facilitated the learning the SQL language, so understanding the Relational Database Browse was easier to understand the SQL language.

To understand how the Relational Data Browse works you can read the DbSchema Quick Tour and watch the video tutorials at the website http://www.dbschema.com/. The purchasing price is $127.

 
< Prev   Next >

Submit Your GIS/Geo News/PR to GISuser



Search the Spatial Media Web Resources
Developer Tip
PhoneGap - OpenSource Devlopment Framework; Deploy to 7 Major Mobile Platforms
 
HOT Devices
Introducing the RAMPAGE 6 Rugged Notepad with Android 
Social Media Tips
Using Social Media and Twitter To Land The Perfect Job - Tips, Tricks, Trends - Finding a job can be a daunting task but it doesn't have to be. Many are turning to social media, in particular Twitter, to help score a new gig.
 

deliciousrssnewsletterlinkedinfacebooktwitter

More GISuser Features

feature articlesSee more GISuser Features HERE / See GISuser Spotlights Here

AnyGeo - Geospatial Updates from Glenn

↑ Grab this Headline Animator

Recent Directory Listings
1. SAIC GeoRover Mobile
    Category: GIS for Tablets - iPad and Android Tablet Geo Solutions
    Created: May 22, 2012
2. Arvada Colorado OpenData
    Category: OpenGov and OpenData
    Created: May 21, 2012
3. Colorado OpenData
    Category: OpenGov and OpenData
    Created: May 21, 2012
4. Inlailawatash Forestry...
    Category: Geo Tech Companies & Consultants
    Created: May 15, 2012
5. CSU Fresno
    Category: Distance Learning, Online GIS Education
    Created: May 10, 2012
Show more...
Featured Events

 List Your Event Here 

2X A Week Newsletter

See Recent edition
newsletter

subscribe GISuser

We won't share your address!
Sponsor

Popular Stuff!


RSS and Feeds

Software

software reviews
Geo Technology Software

GISuser Site Sponsor


Most Popular
GISuser HOT Spots!

Google Mashup Zone
GISuser WebMaps
Free Data Articles
Spotlights & Tips
GISuser Resumes
Data Links
10 Cool Things
The LBS Zone!

Partner Sites


lbszone.com


symbianone

A Spatial Media LLC property

 




Spatial Media, LLC ©2003 - 2011 All rights reserved / Privacy Statement