saving time and money n.
Skip this Video
Loading SlideShow in 5 Seconds..
Equal Format Data Systems PowerPoint Presentation
Download Presentation
Equal Format Data Systems

Loading in 2 Seconds...

play fullscreen
1 / 14

Equal Format Data Systems - PowerPoint PPT Presentation

  • Uploaded on

Saving Time and Money. Equal Format Data Systems. The Future of Data. For the CIO. What makes your Software and Data Systems So Expensive?.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Equal Format Data Systems' - alden

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
what makes your software and data systems so expensive
What makes your Software and Data Systems So Expensive?
  • The least expensive parts of your system are that way because they are uniform, reusable, and reliable, such as the relational database management systems (RDBMS).
  • With traditional design, the most expensive parts are custom-built, not reusable, and only become reliable with time and work. Most of your system is done this way.
equal format data changes the equation
Equal Format DataChanges the Equation
  • Using Equal Format Data, more of your system will be less expensive, and more uniform, reusable, and reliable.
  • Less of your system needs to be custom-built.
comparing cost and time traditional
Comparing Cost and Time - Traditional

Let’s look at the projected costs in a major system consolidation, updating and merging two legacy systems together, lasting 24 months with a cost of $5 million.

comparing cost and time equal format
Comparing Cost and Time – Equal Format

Let’s look at the same project design using an equal format system. Thanks to a reusable design, many tasks can be started earlier, with common forms, reports, and functionality saving more time and money.

why so much customization
Why So Much Customization?
  • Traditional design patterns take all of the data and break it up into separate tables in a customizing process called “normalization”.
  • This process is designed to gain flexibility and save space, but it becomes more complex as the number of tables often climb to hundreds in each database.
what s wrong with traditional designs
What’s Wrong with Traditional Designs?

In a traditional design, a value is given meaning by its position in a table. This has a number of expensive side effects:

  • All tables are custom.
  • Interactions with custom tables are also custom.
  • Complexity is used to gain flexibility and save space.
  • More table design and conversion work is required to handle future changes.

This Old Table

equal format data a new relational design pattern
Equal Format Data:A New Relational Design Pattern

In the newEFD design pattern, the old table is broken into small pieces of Equal Format Data, with the meaning attached to the value.

equal format data reusable reliable relational
Equal Format Data:Reusable, Reliable, Relational
  • Equal Format relational tables are uniform and can be used on almost any relational server. This preserves prior knowledge and improves learning curves.
  • Uniform tables lead to uniform functionality, allowing more reusable code. This improves reliability and security.
equal format data uniform scalable distributable
Equal Format Data:Uniform, Scalable, Distributable
  • The uniformity of Equal Format systems allows data to be partitioned, paralleled, and distributed, in a scalable manner.
  • Equal Format containers support data registries and dictionaries.
equal format data the financial benefits
Equal Format Data:The Financial Benefits
  • Upfront advantages:
    • Quicker development time using off-the-shelf components
    • Quicker development time when developers and project segments are more independent
    • Reliable, tested table design and code reduces debugging
    • Uses your current database servers, preserving corporate investment
  • Long-term benefits:
    • A standard table structure improves learning curves and simplifies maintenance
    • Future enhancements are easier with a design already capable of handling future needs
    • Data dictionaries and registries are easier to create and maintain, maximizing the searching, mining, merging, and distribution of data
    • Less vendor dependence
equal format data the functional benefits
Equal Format Data:The Functional Benefits
  • Important characteristics:
    • Holds any data model, eliminating the need for object or specialty databases
    • Uses your SQL-based database server, i.e. Oracle, IBM DB2, Microsoft SQL Server
    • More flexible and scalable than XML Storage systems
    • Can be merged into existing systems
    • Great for retrievable archives
  • Unique capabilities:
    • Preserves and tracks all data changes with non-destructive modifications
    • Holds a “snapshot” of any time-state of the database
    • Rollbacks can be controlled for changes made during a particular timeframe, by a person, or any other criteria of your definition
    • Compares two databases for differences
equal format data additional applications and uses
Equal Format Data: Additional Applications and Uses
  • Master Data Storage
  • Messaging Systems
  • Data Warehousing, Data Marts, and Data Mining
  • Security, Auditing, Quality Control
  • Merging Legacy Information
  • Facility Data and PLM Data
  • Engineering Project Management
  • Product Catalog Data
  • Development Infrastructure
















datura llc the leaders in equal format databases
Datura, LLCthe Leaders in Equal Format Databases

The Future of Data

Datura, LLC

PO Box 498

Howell, MI 48844-0498


+1 (734) 878-0109 voice

+1 (734) 878-0684 fax