JCK - A Veteran-Owned Small Business		 EXCELLENCE IN DATA ARCHITECTURE

since 1989

America Support You		 4348 Pine Grove Ave
Fort Gratiot MI USA
48059-3732
V: 810 982-8639
  Training Consulting Experience & Colleagues Articles & White Papers About Us
Business Event Analysis & Modeling (BEAM™)

BEAM™ for Decision Support Systems

Extended Relational Analysis (ERA™)

Structured Query Language (SQL)

Course Offerings

Schedule & Registration



What is User Focused Data Architecture?




The industry standard data access language.

Whether your system is client/server, web-based, SOA, or even an old green-screen mainframe application, it's probably based on a database that uses Structured Query Language.

If your data is stored in a SQL database, that means you can usually access the data directly – without having to go through your application. Why would you want to do that? There may be many reasons, like:

  • Ad-hoc reporting - Your production system may not produce all the reports you wish, or you may wish to enhance ones that it already has.
  • Decision support systems - You may want to reformat your data into more useable structures, or feed other systems from your various production environments. You may want to summarize or analyze your data in new ways.
  • System Enhancements - You may want to develop new systems that "tap into" existing systems, or add capabilities like web reporting.
SQL is the key to all these efforts and more. Fortunately, SQL is easy for technical and non-technical staff to learn.

Why learn SQL?

Structured Query Language is the common language of database systems. Though different vendors such as Oracle and IBM have slightly varied dialects, a knowledge of basic SQL will enable you to "get beneath" your operational systems and question the data directly to get the answers you need.

If you're like most organizations, you cannot get the information you need because you are swimming in raw data. Thousands of records to sort through, reams of reports that require manual scanning – wouldn't it be nice to be able to quickly narrow down and summarize all that to get just the information you need to answer your questions? That's what SQL can do for you.
 

Back | More


Since 1989, JCK has been devoted to teaching and implementing the principles of User-Focused Data Architecture. UFDA is based on the principle that the users are the data experts in any organization. Sound data architecture should focus on extracting the user's knowledge, clarifying ambiguous defintions, and building understandable data structures. These definitions and structures serve as the basis for system development. The first and most well known UFDA technique is Extended Relational Analysis ™ (ERA), which has been proven for decades. More recent techniques include Business Event Analysis & Modeling ™ (BEAM), which is useful for both Transactional Systems (BEAM TSS) and Decision Support Systems (BEAM DSS).