Enterprise Business Technologies uses ERWIN Data Modeler and Microsoft Visio to create Logical and Physical Data Models and to generate scripts which will be used to create the database. EBT creates logical and physical data models for OLAP databases in third normal form (normalized). Online Transactional Processing (OLTP) Databases are ideal for adding new records, and modifying or deleting existing records. However when analyzing the data, data retrieval can take a lot of time based on the number of tables to be accessed, tables to be joined, and number of records to be accessed. Therefore many organizations opt to implement data warehouse with reporting capabilities or executive dashboard. Analytical Processing is best handled by an OLAP database. The design for OLTP databases is different from that for OLAP databases.EBT creates dimensional logical and physical data models for OLAP databases.
