Skip to content

Dataset for CPU specifications of Intel and AMD available as Spring Boot API.

License

Notifications You must be signed in to change notification settings

felixsteinke/cpu-spec-dataset

Repository files navigation

CPU Specification Dataset

Dataset for CPU specifications from Intel and AMD.

Table of Content

Installation

Tested on OpenJDK 17.0.2 & Maven 3.6.3.

Windows:

xcopy .\dataset\ .\dataset-api\src\main\resources\dataset /s /e /h /y 
mvn clean install -DskipTests

Linux:

copy ./dataset/* ./dataset-api/src/main/resources/dataset/
mvn clean install -DskipTests

Dataset API Usage

cd dataset-api
mvn spring-boot:run

Endpoint is available at: GET http://localhost:8080/api/cpu-dataset

Configurations

dataset-api/application.properties

Property Example Value Description
spring.datasource.url jdbc:mysql://localhost:3306/cpu_db Full url to a MySQL database
spring.datasource.username root Username and usually root
spring.datasource.password password Custom password
spring.jpa.hibernate.ddl-auto update or validate Table schema update mode
spring.jpa.defer-datasource-initialization false or true Defer database update with dataset

Container Image

docker run --name mysql -e MYSQL_ROOT_PASSWORD=password -e MYSQL_DATABASE=cpu_db -p 3306:3306 -d mysql:8
docker build -t ghcr.io/felixsteinke/cpu-spec-dataset-api:latest .
docker run -p 8080:80 --name dataset-api ghcr.io/felixsteinke/cpu-spec-dataset-api:latest
docker push ghcr.io/felixsteinke/cpu-spec-dataset-api:latest

Container Configuration

Environment Key Example Value Description
SPRING_DATASOURCE_URL jdbc:mysql://host.docker.internal:3306/cpu_db Full url to a MySQL database
SPRING_DATASOURCE_USERNAME root Username and usually root
SPRING_DATASOURCE_PASSWORD password Custom password

Dataset Update

All updates to the dataset need to carefully reviewed. The column mappings and modifications need to be adjusted in the corresponding Dataset Class for the Dataset API.

Manually Export Data as CSV/Excel from https://www.amd.com/en/products/specifications/processors

Website Screenshot

amd-csv-export

Extracted from https://amperecomputing.com/briefs/ampere-altra-family-product-brief with the responsible Web Scraper.

cd ampere-web-scraper
java -jar ./target/exectuable.jar

Extracted from https://ark.intel.com/content/www/us/en/ark.html with the responsible Web Scraper.

cd intel-web-scraper
java -jar ./target/exectuable.jar

Extracted from https://www.cpubenchmark.net/cpu_list.php with the responsible Web Scraper.

cd benchmark-web-scraper
java -jar ./target/exectuable.jar

Extracted from https://www.cpu-world.com/CPUs/CPU.html with the responsible Web Scraper.

cd cpuworld-web-scraper
mvn -jar ./target/exectuable.jar