2023最新汽车之家汽车车型数据大全_汽车之家2023资源-CSDN文库

共3个文件

sql：3个

版权申诉

5星 · 超过95%的资源 165 浏览量 2021-10-14 13:41:43 上传评论 12 收藏 626KB RAR 举报

《2023最新汽车之家汽车车型数据大全》是一份包含详尽汽车信息的数据资源，主要分为三个核心部分：品牌信息、车系信息以及车型信息。这些数据已整理成SQL格式的文件，便于数据分析和开发人员进行高效处理。以下是这份数据集合中的关键知识点： 1. **品牌信息（brand.sql）**：这个文件包含了所有汽车品牌的详细信息，可能包括但不限于品牌名称、成立年份、总部地点、母公司、品牌历史等。品牌信息是分析汽车市场基础的元素，可以用来研究品牌市场份额、全球布局、品牌影响力等。 2. **车系信息（brand_chexi.sql）**：车系是品牌下的分类，通常根据车型、功能、定位等因素划分。车系信息可能包括车系名称、所属品牌、上市时间、车系特点等。这些数据对于理解各品牌的产品线策略、市场需求趋势以及消费者购车偏好分析具有重要价值。 3. **车型信息（brand_info.sql）**：车型是最具体的产品单位，包含了车辆的具体型号、配置、价格、动力系统、尺寸、安全性能等数据。通过对车型数据的分析，可以洞察市场上的畅销车型、消费者购买趋势、价格区间分布等，对市场预测和产品定位提供参考。 4. **数据表之间的联系**：这三个数据表之间存在着密切的关系。品牌表作为基础，车系表通常与品牌一一对应，表示品牌下的各个产品系列；车型表则细化到每个具体的车型，与车系相关联，展示车系内的具体选项。这种关系结构使得数据分析更加深入，可以通过关联查询获取更丰富的信息，如某品牌的所有车型及其销量，或者某一车系的配置分布。 5. **数据量与更新频率**：数据集合接近6万条记录，覆盖了众多汽车品牌、车系和车型，这为全面了解汽车市场提供了广泛的数据支持。而"最新"的标签意味着这些数据反映了当前最新的市场情况，对于研究汽车行业的最新动态尤其有价值。 6. **数据应用**：这些数据可用于多种用途，包括但不限于： - **市场分析**：通过统计分析，可以识别哪些品牌、车系或车型在市场中最受欢迎。 - **销售预测**：结合历史销售数据，可以预测未来的销售趋势。 - **竞品分析**：对比不同品牌和车型的参数，可发现市场竞争格局。 - **用户画像构建**：通过车型选择，推测消费者的偏好和消费习惯。 - **产品研发**：为汽车制造商提供市场反馈，指导新车型设计和改进。《2023最新汽车之家汽车车型数据大全》是一份宝贵的汽车行业数据资源，涵盖了汽车品牌、车系和车型的全方位信息，是汽车市场研究、产品开发和商业决策的重要依据。

资源推荐

资源详情

资源评论

收起资源包目录

sql.rar （3个子文件）

brand_chexi.sql 468KB

brand.sql 47KB

brand_info.sql 7.91MB

SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for ims_azt_market_brand_info -- ---------------------------- DROP TABLE IF EXISTS `ims_azt_market_brand_info`; CREATE TABLE `ims_azt_market_brand_info` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '车型id', `uniacid` int(10) DEFAULT NULL, `brand_id` int(10) DEFAULT NULL COMMENT '父级品牌id', `chexi_id` int(10) DEFAULT NULL COMMENT '父级车系id', `chexing_id` int(10) DEFAULT NULL COMMENT '汽车车型标志id', `name` varchar(50) DEFAULT NULL COMMENT '车型名称', `year` varchar(50) DEFAULT NULL COMMENT '年份', `sort` int(6) DEFAULT NULL COMMENT '排序', PRIMARY KEY (`id`) USING BTREE, KEY `brand_id` (`brand_id`), KEY `chexi_id` (`chexi_id`), KEY `chexing_id` (`chexing_id`) ) ENGINE=InnoDB AUTO_INCREMENT=57370 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='汽车车型'; -- ---------------------------- -- Records of ims_azt_market_brand_info -- ---------------------------- INSERT INTO `ims_azt_market_brand_info` VALUES ('1', '2', '117', '2096', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('2', '2', '117', '2096', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('3', '2', '117', '2097', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('4', '2', '117', '2097', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('5', '2', '117', '2097', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('6', '2', '117', '2097', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('7', '2', '117', '2097', '24355', 'AC Schnitzer X5 2015款 ACS35 35i', '2015.1', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('8', '2', '117', '2098', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('9', '2', '117', '2098', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('10', '2', '117', '2098', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('11', '2', '117', '2098', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('12', '2', '117', '2098', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('13', '2', '117', '2098', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('14', '2', '117', '2100', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('15', '2', '117', '2100', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('16', '2', '117', '2100', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('17', '2', '117', '2100', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('18', '2', '117', '2148', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('19', '2', '117', '2148', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('20', '2', '117', '2148', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('21', '2', '117', '2148', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('22', '2', '117', '2282', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('23', '2', '117', '2282', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('24', '2', '117', '2282', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('25', '2', '117', '2282', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('26', '2', '117', '2282', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('27', '2', '117', '2365', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('28', '2', '117', '2365', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('29', '2', '117', '2365', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('30', '2', '117', '2371', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('31', '2', '117', '2371', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('32', '2', '117', '2371', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('33', '2', '117', '2513', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('34', '2', '117', '2513', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('35', '2', '117', '2513', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('36', '2', '117', '2666', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('37', '2', '117', '2666', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('38', '2', '117', '3667', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('39', '2', '117', '3667', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('40', '2', '117', '3750', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('41', '2', '117', '3750', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('42', '2', '117', '3895', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('43', '2', '117', '3895', '23562', 'AC Schnitzer M3 2015款 ACS3 sport', '2015.1', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('44', '2', '117', '4362', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('45', '2', '117', '4362', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('46', '2', '117', '4362', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('47', '2', '117', '5603', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('48', '2', '117', '5608', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('49', '2', '117', '5609', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('50', '2', '117', '5614', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('51', '2', '117', '5614', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('52', '2', '117', '5614', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('53', '2', '117', '5874', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('54', '2', '117', '5875', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('55', '2', '117', '6047', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('56', '2', '117', '6226', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('57', '2', '134', '2366', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('58', '2', '134', '2366', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('59', '2', '134', '2367', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('60', '2', '134', '2367', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('61', '2', '134', '2368', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('62', '2', '134', '2368', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('63', '2', '134', '2368', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('64', '2', '134', '2368', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('65', '2', '134', '2443', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('66', '2', '134', '2443', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('67', '2', '134', '2546', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('68', '2', '134', '2546', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('69', '2', '134', '2547', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('70', '2', '134', '2547', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('71', '2', '134', '2547', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('72', '2', '134', '2969', '0', '', '', null); INSERT INTO `ims_azt_market_brand_info` VALUES ('73'

评论收藏

内容反馈

版权申诉