Finally, some kind of big pictures emerge—some kind of expression of what I’ve been doing with most my adult life. This unimpressive rendition of a table started with the far left column as a list of data formats in decreasing disk space:
So, Apache log files are my largest set of data—then comes the Blog post data (you are reading now) in MySQL/WordPress. Notice how I still avoid storing my crap in “the cloud.”
The next column lists the technologies I use/built with the data forms in the first column. Here is where the organizational lousiness comes in because the order of items in this column has nothing to do with that in any of the columns. My struggle to compensate for this is through arrows going all over the place.
The arrows pointing to the third column intend to show me where the solutions in the first column will end up technologically. For example, DAR will use the Entity Framework, support WCF and maybe WF (Windows Workflow Foundation).
| Data Format | Application of Data Format | Future of Application |
| Apache log files | DAR parses and loads these files into SQL Server 2008. |
DAR will be modified to run on some kind of dependency injection framework—probably StructureMap or Unity. SSIS and SSRS are being introduced for processing the results of the load. |
| SQL Server 2008 |
GenericWeb and DAR use various approaches in the Songhay.Data namespace. |
The Songhay.Data.Linq namespace will play a role here, featuring Entities Framework. |
| MySQL | WordPress uses MySQL exclusively. | No immediate plans to improve here. |
| SQLite | SQLite.net and my custom PHP libraries approach. | The Songhay.Data.Linq namespace should play a role here, featuring Entities Framework. |
| Word DOCX | No released solutions approach. | A WPF version of CleanXHTML is in the works. |
| OPML | An internal InfoPath solution is used to generate list data. Newer PHP/Zend designs use OPML lists for lightweight site index data. | A simple OPML editor for WPF and ASP.NET MVC is in the works. |
This entry was posted on Monday, November 16th, 2009 at 8:33 am and is filed under .NET related, Data Management Solutions, Design Diary, Digital Media Production, Expression Studio, InfoPath, Word, XAMPP Stack, root. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
[...] showed off my last sketch which was really a mess. This one is a bit [...]