{"title":"在MS SQL Server Express中存储大量数据","authors":"D. Fojtik, Petr Podešva, J. Gebauer","doi":"10.1109/CARPATHIANCC.2015.7145059","DOIUrl":null,"url":null,"abstract":"The article describes proven methods for MS SQL Server Express which automatically keep the latest data in the primary database, while older data are transferred into dynamically created databases. The system was deployed in Třinecké Železárny a. s. where the data older than 30 days is kept in the primary database, and older data is transferred into databases that were dynamically created for each month of production. Thanks to this method, all databases are smaller than 2 gigabytes, while all data is easily accessible from one SQL Server Express.","PeriodicalId":187762,"journal":{"name":"Proceedings of the 2015 16th International Carpathian Control Conference (ICCC)","volume":"26 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2015-05-27","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"4","resultStr":"{\"title\":\"Storing high volumes of data in MS SQL Server Express\",\"authors\":\"D. Fojtik, Petr Podešva, J. Gebauer\",\"doi\":\"10.1109/CARPATHIANCC.2015.7145059\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"The article describes proven methods for MS SQL Server Express which automatically keep the latest data in the primary database, while older data are transferred into dynamically created databases. The system was deployed in Třinecké Železárny a. s. where the data older than 30 days is kept in the primary database, and older data is transferred into databases that were dynamically created for each month of production. Thanks to this method, all databases are smaller than 2 gigabytes, while all data is easily accessible from one SQL Server Express.\",\"PeriodicalId\":187762,\"journal\":{\"name\":\"Proceedings of the 2015 16th International Carpathian Control Conference (ICCC)\",\"volume\":\"26 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2015-05-27\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"4\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings of the 2015 16th International Carpathian Control Conference (ICCC)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/CARPATHIANCC.2015.7145059\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the 2015 16th International Carpathian Control Conference (ICCC)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/CARPATHIANCC.2015.7145059","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 4
摘要
本文介绍了MS SQL Server Express的成熟方法，这些方法自动将最新的数据保存在主数据库中，而将旧的数据传输到动态创建的数据库中。系统部署在Třinecké Železárny a.s.中，其中超过30天的数据保存在主数据库中，较旧的数据传输到为每个月的生产动态创建的数据库中。由于这种方法，所有数据库都小于2gb，而所有数据都可以从一个SQL Server Express轻松访问。
Storing high volumes of data in MS SQL Server Express
The article describes proven methods for MS SQL Server Express which automatically keep the latest data in the primary database, while older data are transferred into dynamically created databases. The system was deployed in Třinecké Železárny a. s. where the data older than 30 days is kept in the primary database, and older data is transferred into databases that were dynamically created for each month of production. Thanks to this method, all databases are smaller than 2 gigabytes, while all data is easily accessible from one SQL Server Express.
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
