1 / 14

Equal Format Data Systems

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

alden
Download Presentation

Equal Format Data Systems

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Saving Time and Money Equal Format Data Systems The Future of Data For the CIO

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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

  8. 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.

  9. 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.

  10. 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.

  11. 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

  12. 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

  13. 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 Analysis Facilities EFD EFD EFD CAD Planning EFD EFD EFD EFD PLM Purchasing EFD EFD

  14. Datura, LLCthe Leaders in Equal Format Databases The Future of Data www.datura-llc.com Datura, LLC PO Box 498 Howell, MI 48844-0498 USA sales@datura-llc.com +1 (734) 878-0109 voice +1 (734) 878-0684 fax

More Related