Application Development Services

Generate source code with industry proven analysis and design practices.

Database Design and Generation

DMSTEX provides Oracle Database Design and Generation Services (DDGS). We offer Oracle based solutions because of its reliability and scalability from the smallest of installations to the largest record breaking systems. The Database Design and Generation Service include:

Database Schema

Database object definition in SQL and PL/SQL including: tables, indexes, triggers, and packages.

PL/SQL API

Includes procedure and optional function calls for insert, update, and delete using table row buffers and individual columns.

Test Data

Random sample data to assist with development testing. (We can also help with load modeling and capacity analysis.)

Maintenance Forms

Basic query, insert, update and delete on all tables. Also includes LOV and navigation UI elements. This is all built into the database (APEX).

Benefits of DDGS Database Schema and PL/SQL API

  • Temporal Database (With Audit)
  • Bi-Temporal Database (With Audit)
  • Quantized Date/Time
  • Package Based Discrete Domains
  • DML undo on Primary Keys
  • DML Enabled Sub-Type Views and PL/SQL APIs
  • Natural Key Update-able Views
  • Full Procedural PL/SQL APIs
  • Full Path Hierarchical Data
  • Automatic US7ASCII Conversion
  • APEX Data Maintenance Forms and Reports

Demonstrations

Technology

Why Oracle?

Oracle is a well-known and respected name in the field of information technology. The Oracle database provides industry leading performance, reliability, and full scalability from the smallest to the largest systems.

Isn't Oracle Expensive?

Oracle has always been completive in their dealings. As a technical person, I understand that technical personnel are rarely included acquisition negotiations and usually do not see the discounts that result. Additionally, Oracle has worked very hard to be the most competitive cloud provider, resulting in reduced costs when moving from Amazon Web Services to Oracle Could Infrastructure.

Temporal Database

TEMPORAL DATABASE WAS ADDED IN THE SQL:2011 STANDARD. ORACLE STARTED SUPPORT FOR THIS CAPABILITY IN ORACLE11G/TOTAL RECALL, ORACLE 12C/VLDB, AND . HOWEVER, THE CURRENT ORACLE 21C IMPLEMENTATION DOES NOT ENFORCE TEMPORAL CONSTRAINTS. A PRIMARY KEY CONSTRAINTS EXAMPLE IS GIVEN BELOW. AT DMSTEX, WE CAN GENERATE NATIVE PL/SQL CODE TO PERFORM TEMPORAL CONSTRAINT ENFORCEMENT. WE CALL IT TEMPORAL CONTINUITY.

Temporal Continuity

The ability to track Transaction Time (TT) and Valid Time (VT) is a straight-forward implementation of the temporal and bi-temporal database. However, the ability to enforce temporal continuity of Foreign Key and Unique Key constraints is an important aspect of maintaining temporal continuity within that database. This whitepaper provides definitions and examples of temporal continuity enforcement in a temporal database implementation of DDGS

If temporal constraints are enforced on primary keys, the same primary key could be valid during 2 different time frames. However, Oracle 21c will not allow this situation.

DDGS Temporal Continuity.pdf

About

DMSTEX is an Oracle database focused company located in the Dallas - Fort Worth Metroplex. We offer quality software design and development services to meet the needs of businesses. Our company provides personal attention and commitment to our clients, while bringing extensive technical experience and expertise on complex systems.

Our Management

DMSTEX, Dallas County, Texas is managed by Duane Dieterich and Michiet Dieterich. They bring 38 years of combined industry experience to the company. This includes 22 years of experience in Oracle/UNIX consulting, development and administration in 13 different organizations, spanning 12 industries along with engineering and management experience.

Our Mission

The company uses innovative techniques in the software development process to increase efficiency and apply knowledge gained through experience to improve quality. This allows us to provide services that are reliable and affordable.

Philosophy

The following are some basic beliefs we use to guide our practices.

ALL GOOD THINGS COME FROM GOD

"The fear of the Lord is the beginning of wisdom; all who follow his precepts have good understanding. To him belongs eternal praise." Psalm 111:10

DON'T AVOID THE HARD WORK

"The most practical, beautiful, workable philosophy in the world won't work if you won't." -Zig Ziglar

"It's easier to explain price once than to apologize for quality forever."-Zig Ziglar

DATA MODELS ARE THE FOUNDATION

Business processes (how a business operates) change faster than data models (what a business operates on). Whether it's credits/debits, product/services, or customers/vendors, the basic "what" of a business doesn't change much. In contrast, business processes can change often. Applications with comprehensive data models support changes to business processes more efficiently.

THREE KINDS OF DATA STRUCTURES

In data modeling, there are three kinds of data structures in an application:

  1. Business Objects - Fundamentals of the business, whether computerized or not. Ex. credits/debits, product/services, etc

  2. Business Intelligence Objects - Reporting and Information, whether computerized or not. Ex. month-end aggregates, units queued at an operation

  3. System Objects - Necessary for computerized use. Ex. users, login history, error logs.

PRE-DEFINED BUSINESS OBJECTS

Pre-defined Essential Entities (Generic Data Model Patterns) are available and increase efficiency of requirements analysis and design.

TWO FORMS OF BUSINESS INTELLIGENCE

In an application architecture, there are two forms of business intelligence:

  1. Real-Time Reporting

  2. On-Line Analytical Processing (OLAP)

TWO MODES OF SYSTEM OPERATION

In an application implementation, there are two modes of system operation:

  1. On-Line Transaction Processing (OLTP)

  2. Batch Processing.

ORACLE DATABASE FOCUS

Database agnostic requires one of 2 approaches:

  1. LCD (lowest common denominator) of database functionality

  2. different software/codepaths for each database (increased complexity)

Every design decision is driven by this choice. Use of a single database platform increases simplicity and efficiency.

SOFTWARE AUTOMATION

"Don't do anything yourself that you can get a machine to do for you." - Walter "Pat" Dieterich, Riesel, TX

Contact Us

Phone: (469) 464-9491