Logo Object Oriented Cybersecurity Detection Architecture (OOCDA) Suite
Executive Summary Start Author Project Map

Excel-DAO-XML Data Exchange Seed Framework
What is Data Exchange (DEX)?:
Our CRM Data Farm Inc. technical team is introducing a new concept called Data Exchange (DEX). We need to address the following to the IT community:

       • What is Data Exchange (DEX)?
       • What are goals of building and standardizing Data Exchange (DEX)?

What is DEX?
To understand what is our DEX, our audience need to understand Web Services which is using XML as a communication tool and web services is defined as follows:

A web service is any piece of software that makes itself available over the internet and uses a standardized XML messaging system. XML is used to encode all communications to a web service. For example, a client invokes a web service by sending an XML message, then waits for a corresponding XML response.

Our DEX is an Intelligent Upgrade of Web Services. DEX is a set of software tools which help the communication and the exchange of data. The data exchange is not limited to XML, but it encompasses the following data structures:

       • Java Data Access Object (DAO)
       • Java Set
       • XML
       • JSON
       • Text
       • Message Queues
       • C-Tables
       • DataTable
       • Misc - We are also open to other data format

DEX also provides data exchange parsers and convertors to resolve any data exchange issues and communication. DEX should be a virtual service running on a virtual server with parsers and convertors to handle any data exchange parsing and formatting. Our DEX's convertors build XML format with No Schema regardless of its sizes and complexities.

What are goals of building and standardizing DEX?
Building and standardizing DEX would pave the road for intelligent and faster communication media the same way web services did for the IT community.

Excel Sheet-DAO-XML Data Exchange Seed Framework
We had built our "ICM_DB_TestComponents" project using NetBeans (8.2). The following are the actual code of our for "ICM_DB_TestComponents" project. We created our first Parser-Converter Java code and we called "Using Business Rule #1".

The following are our "ICM_DB_TestComponents" project input-out files and Java code files.
We welcome any feedback or comments and our contact email is: Sam@SamEldin.com

Input Files:
       1.     SimpleInputExcelSheet.xlsx
       2.     BusinessToken_ID.txt

Java Constant Classes:
       1.     MainConstants.java
       2.     SOAP_XML_Constants.java
       3.     ExcelDAO_Constants.java

Package: Java DAO Classes - unstructured_data_idao:
       1.     ExcelCellMap2DAO.java
       2.     ExcelColumnMap2DAO.java
       3.     JavaCodeGeneratorDAO.java
       4.     OneRow_ExcelCells.java
       5.     TokenValueDAO.java

Package - unstructured_data_parser:
       1.     ColumnCellParserUsingBusinessRule_1.java
       2.     Convert2DAO_Class_UsingBusinessRule_1.java
       3.     DAO2SOAP_XML_Converter.java
       4.     DAO_ClassLoader.java
       5.     DAO_DynamicCompilation.java
       6.     Excel2DAO_CellParserBusinessRule_1.java
       7.     Excel2DAO_Mapper.java
       8.     LoadTokenValueArrayList.java
       9.     ParsingSOAP_XML_MessagesFile.java
     10.     RowCellParserUsingBusinessRule_1.java

Output Files:
       1.     SimpleInputExcelSheetDAO.java
       2.     SimpleInputExcelSheet_XML.xml
       2.     Debugger Tracking of Input and Output

ICM_DB_TestComponents Architect-Design in a Nutshell
Our goal of "ICM_DB_TestComponents" project to automate the parsing-converting of any excel sheet to DAO and SOAP-XML file. It has to perform the following:

• Business key words are stored in a Business Token ID text files to help with parsing, naming the fields, possibilities and accuracy of how to name the fields, methods and intelligent parsing and tracking.
• Parse the excel sheet horizontally to figure out the DAO field's names, types and values and possible values, percentage of accuracy using the Business Token ID text files.
• Using the excel row and column numbers (row * Constant + column) to create an ID index for formulas and functions to track and access.
• Parse the excel sheet vertically to figure out formulas and functions, parameters, comments and labels
• Parse the excel sheet vertically to figure out tables, rows and comments and label
• Create fields (class privet variables) , methods (get() and set())
• Create Java DAO
• Compile and store the .class file
• Create with excel sheet values and store SOAP-XML file
• XML file tags are created with structure and ID to help with conversions to DAO. The size of XML files must be managed and automated for optimizing the two conversion XML-SOAP and DOA-IDAO