Posts

Showing posts with the label Datascience

Using Constraint Logic Programming to Formally Optimize 6502/6510 Assembly Code

Image
Introduction This post is an experiment . A first step, a proof of concept, and also a personal exploration. The idea is to start talking not only about SQL Server and Database , but also about Artificial Intelligence , constraint solving , and data-driven reasoning applied to real, concrete technical problems. In this case, the problem comes from an old but fascinating domain: the MOS 6502 / 6510 CPU . Project Overview and Motivation This code represents the first concrete step of a broader project whose goal is to build a code optimizer for the MOS 6502 / 6510 CPU using Constraint Logic Programming , specifically ECLiPSe CLP(FD) . The long-term vision of the project is to explore whether formal constraint-based reasoning can be used to automatically discover provably optimal instruction sequences for real hardware, instead of relying on hand-written heuristics, pattern matching, or empirical benchmarks. Rather than simulating execution or enumerating progra...

How to read XML file from SQL Server. The OPENXML statement and a little bit of Datascience

Image
Hi Guys, Welcome back! Would you like to learn how to read XML file from SQL Server ? Would you like to learn how to use the OPENXML statement ? Today we will do also some datascience.  So what are you waiting for? … Follow me! Introduction XML files are very popular nowadays. They are nothing more than text files with a structure established by means of tags . An example of an XML file could be this: < ROOT > < ROW          STAZIONE = "san pietro capofiume "         DATAINIZIO = "31/12/2018 23.00.00"         DATAFINE = "01/01/2019"         STRUMENTO = "api 200e"         NO2 = "28"         UM = " ug /m3"         F1 = ""         F2 = "1"   ...