|
|
|
Binary Solutions offers a variety of robust and versatile data mining and
data extracting services and solutions that encompass a broad spectrum of
platforms, technologies and retrieval methods.
|
|
|
Our Data Mining Strategy enables us to offer our clients the ability to retrieve
and extract data from a variety of data sources. Once obtained, the data is
processed and ready for integration into another database, or back to the
original data source.
We have worked with the following systems: IBM AS400, Microsoft SQL Server
2000/2005/2008, Microsoft Access, Microsoft FoxPro, and Microsoft Excel. |
|
|
|
|
|
|
|
We offer data extraction services for automotive Dealership Management Systems
(DMS). Whether you require a one-time data retrieval or frequent scheduled
extractions, we are prepared to pull from F&I, customers, inventory and much
more.
We have worked with the following systems: ADP DMS, ADP Web Suite 1000 DMS, EDS
DMS, Adam DMS, and Reynolds & Reynolds DMS. |
|
Our Data Mining Strategy
|
|
Below are a few examples of common data sources from which data is retrieved by
either a push or pull methods. |
|
|
|
The connection process involves the defining of the data source, transfer
technology, and data destination. |
|
|
|
|
Using Microsoft .NET Framework and SOAP Technology. |
|
|
|
|
|
|
|
Typically implimented with data source and data destination are in remote
locations. |
|
|
|
|
|
|
|
Typically implimented when data source and data destination are in remote
locations, and either of the two do not have a network card or access to the
internet due to firewall restrictions. |
|
|
|
|
Determining the data extraction involves defining the method in which the
extraction will be performed. |
|
|
|
|
The most common form of extraction in which a text file is retrieved via the
connection. Text-files are packed with data and seperated by a unique character.
Most common are styles include comma seperated values (csv), tab seperated, and
pipe seperated. |
|
|
|
|
|
|
|
Typically implimented with data source and data destination are in remote
locations. |
|
|
|
|
|
|
|
This is used most for legacy machines and proprietary software where data
exportation is not available. While primitive, it is an effective method of
retrieving data by means of "scraping" the data currently displayed on the
sessions screen. |
|
The normalization process is the heart of the data mining process and consists
of two phases.
|
|
|
|
Strips all incoming data of un-standard characters that are commonly encountered
when working with cross-platform conversions.
|
|
|
|
|
Incoming data at times requires the comparison of one value against a
translation table to yield an altenative value or workflow. The translation
table is ultimately a list of pre-defined results that will replace the caller's
original value based on a logical condition. |
|
|
|
|
Specific to the automotive industry, VIN decoding can be performed on all
extracted vehicles for enhanced data integrity, conditional statements, and
superior end-user standardization. |
|
 |
|
The exportation process arranges the data and prepares it for return to the
original data source. The connection method used to connect for exportation can
be different then the connection method used for importation.
|
|
|
|
DB2 |
|
|
IBM AS400 |
|
|
Microsoft SQL Server |
|
|
Microsoft FoxPro |
|
|
Microsoft Access |
|
|
Microsoft Excel |
|
|
Text-Delimited File |
|
 |
|
|
Below are a few examples of common data destinations to which processed data can
be placed: |
Dealership Inventory
Websites |
 |
 |
Delimited Text File
(Tab, CSV, Pipeline) |
|
|
|