|
TECDOC 2Q 2019Price: 864 euro*
Update price: 432 euro* |
|
|
TECDOC 2Q 2019Price: 864 euro*
Update price: 432 euro* |
Full version of TECDOC 2Q 2019 in mySQL format.
Owners of 2Q 2019 getting a FREE UPDATE to 3Q 2019.Using the experience of previous releases of the database, starting from 2017, our specialists have significantly changed the structure of the database and methods of data storage that as a result led to the growth of the speed of the queries up to 3 times.
Import is fully automated by means of bash scripts that will create the necessary tables in the database and fill them with the relevant data.
Release 2Q 2019 is available in: Deutsch, English (Gb), Français, Italiano, Español, Nederlands, Dansk, Svenska, Norsk, Suomi, Magyar, Português, Russian, Slovenčina, Čeština, Polski, Ελληvικά, Română, Türkçe, Hrvatski, Srpski, Chinese, Blgarski, latviešu, lietuvių, Eesti, slovenski, English (USA), English (aus), Icelandic, português (br), Ukrainian.
the Structure of the database is built in such a way that you can have as many languages as You need in one database at the same time.
in Addition to the database included in the release archive of images, structured in the following way: /brandName/articleNumber/articleNumber.jpg and also, archive of media materials in PDF formats, etc., structured in a similar way to photos of articles.
Release 2Q 2019 includes PNG icons of car manufacturers, icons of car components, icons of types of spare parts. In addition, almost every car model has a corresponding icon on a transparent background in high resolution.
To quickly deploy the catalog to the Web, the release includes a ready-made set of programs in PHP. Once the database is deployed on the mySQL server, in the php-directory settings file, you must specify the username, password, database name and address of the mysql-server). The catalog code is fully open and on its basis, You can create absolutely any complexity web catalog of cars and spare parts.
the Procedure for updating 2Q 2019 and all subsequent releases is fully automated and will not require the participation of programmers. Both the installation and the update will be able to cope with a person with basic knowledge in the field of web development.
Also on FTP You will find:
1. Full documentation with a description of each table and each field of the database, sample queries.
2. 12Gb of Studio photos of spare parts without watermarks, sorted by folders with the brand name.
3. Many useful media materials.
as a bonus, each buyer 2Q 2019 provided, paid for Q1, api-key to VIN-decoder on the server partsapi.ru. On partsapi.ru you will need to register and report the received login Your Manager chat technical support or email info@autodatabases.ru
| table name | table counts | data size, GB | index size, GB | total size, GB |
| amBrand | 719 | 0.0001 | 0.0002 | 0.0003 |
| amBrandsAddress | 26827 | 0.0064 | 0.0023 | 0.0087 |
| articleCriteria* | 63627213 | 6.9102 | 17.5310 | 24.4412 |
| articleCrosses | 21437030 | 1.2832 | 2.3808 | 3.6640 |
| articleEAN | 3013049 | 0.3271 | 0.2213 | 0.5484 |
| articleLinks* | 294753 | 0.0338 | 0.0137 | 0.0475 |
| articles | 19082088 | 3.6309 | 11.5516 | 15.1825 |
| articlesVehicleTrees | 80589693 | 6.9561 | 24.1834 | 31.1395 |
| articleText* | 11014579 | 1.3525 | 1.9148 | 3.2673 |
| assemblyGroupNodes* | 335659 | 0.0308 | 0.0739 | 0.1047 |
| axleBodyType | 19221 | 0.0015 | 0.0030 | 0.0045 |
| axleBrakeSizes | 70 | 0.0000 | 0.0000 | 0.0000 |
| axleDetails* | 125201 | 0.0220 | 0.0088 | 0.0308 |
| bodyMark | 49169 | 0.0034 | 0.0039 | 0.0073 |
| bodyMarkCarIds | 46575 | 0.0044 | 0.0064 | 0.0108 |
| cars | 661847 | 0.0465 | 0.1700 | 0.2165 |
| countries* | 57018 | 0.0044 | 0.0044 | 0.0088 |
| countryGroups* | 912 | 0.0001 | 0.0001 | 0.0002 |
| genericArticles | 20127240 | 1.0469 | 3.3287 | 4.3756 |
| genericArticlesGroups* | 346332 | 0.0455 | 0.0250 | 0.0705 |
| languages* | 457 | 0.0000 | 0.0000 | 0.0000 |
| legacy2generic | 5655936 | 0.2253 | 0.3307 | 0.5560 |
| manufacturerMotorIds | 25518 | 0.0015 | 0.0033 | 0.0048 |
| manufacturers | 1475 | 0.0001 | 0.0002 | 0.0003 |
| modelSeries | 11406 | 0.0015 | 0.0009 | 0.0024 |
| motorDetails* | 937062 | 0.5713 | 0.5678 | 1.1391 |
| oemNumbers* | 85041901 | 5.8164 | 12.8973 | 18.7137 |
| replacedByArticles | 746223 | 0.0533 | 0.1400 | 0.1933 |
| replacesArticles | 776769 | 0.0611 | 0.1650 | 0.2261 |
| shortCuts* | 3471 | 0.0002 | 0.0004 | 0.0006 |
| tradeNumbers | 4757457 | 0.2117 | 0.4467 | 0.6584 |
| vehicleAxles* | 1510421 | 0.0993 | 0.1160 | 0.2153 |
| vehicleDetails* | 2156063 | 0.6504 | 0.5240 | 1.1744 |
| vehicleDetailsNEW | 0 | 0.0000 | 0.0001 | 0.0001 |
| vehicleMotorCodes | 87727 | 0.0044 | 0.0069 | 0.0113 |
| vehicleProtoTypes | 72564 | 0.0034 | 0.0059 | 0.0093 |
| vehicleSecondaryTypes | 2444 | 0.0002 | 0.0002 | 0.0004 |
| vehicleTrees | 25296918 | 1.5723 | 5.6034 | 7.1757 |
| vehicleWheelBases | 64155 | 0.0044 | 0.0118 | 0.0162 |
| TOTAL ROWS: 348003162 |
TOTAL DATA SIZE: 28.5685 |
TOTAL INDEX SIZE: 79.3910 |
TOTAL TABLE SIZE: 113.2265 |
After submitting this form, You will be given access to a personal section on our FTP server. This is where the products you purchased will be downloaded.
All steps are automatic and take a minimum amount of time.
To purchase "TECDOC 2Q 2019", You just need to enter your e-mail. Payment must be made using VISA, MASTERCARD, MAESTRO, WORLD. Internet payments are protected by SSL certificate and 3D Secure Protocol. JSC "Tinkoff Bank" does not transfer payment data to stores, including card data.
|