Generate source code with industry proven analysis and design practices.
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 object definition in SQL and PL/SQL including: tables, indexes, triggers, and packages.
Includes procedure and optional function calls for insert, update, and delete using table row buffers and individual columns.
Random sample data to assist with development testing. (We can also help with load modeling and capacity analysis.)
Basic query, insert, update and delete on all tables. Also includes LOV and navigation UI elements. This is all built into the database (APEX).
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.
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 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.
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.pdfDMSTEX 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.
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.
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.
The following are some basic beliefs we use to guide our practices.
"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
"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
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.
In data modeling, there are three kinds of data structures in an application:
Business Objects - Fundamentals of the business, whether computerized or not. Ex. credits/debits, product/services, etc
Business Intelligence Objects - Reporting and Information, whether computerized or not. Ex. month-end aggregates, units queued at an operation
System Objects - Necessary for computerized use. Ex. users, login history, error logs.
Pre-defined Essential Entities (Generic Data Model Patterns) are available and increase efficiency of requirements analysis and design.
In an application architecture, there are two forms of business intelligence:
Real-Time Reporting
On-Line Analytical Processing (OLAP)
In an application implementation, there are two modes of system operation:
On-Line Transaction Processing (OLTP)
Batch Processing.
Database agnostic requires one of 2 approaches:
LCD (lowest common denominator) of database functionality
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.
"Don't do anything yourself that you can get a machine to do for you." - Walter "Pat" Dieterich, Riesel, TX
Phone: (469) 464-9491
