StimpyX Posted March 30, 2002 Share Posted March 30, 2002 ...well here's a slightly technical interview with two guys, Benoit Schillings and Dominic Giampaolo, involved deeply with the first consumer OS to actually attempt it (i.e. BeOS): http://www.theregister.co.uk/content/4/24648.html An interesting read for anyone intrigued by what's involved for something like this (but lack the background or expertise to put the details together on ones own), and why the BeOS never went into full release with a *pure* DB filestore. Link to comment Share on other sites More sharing options...
neowin_hipster Posted March 30, 2002 Share Posted March 30, 2002 Tom Servo seems to Know a lot about SQL so I bet he could enlighten us on this. I've read a bit and it seems to be a much more powerful and versatile file system. Linux will follow suit. Link to comment Share on other sites More sharing options...
Glowstick Posted March 30, 2002 Share Posted March 30, 2002 SQL Server is a pretty fast and self-optimizing database. It doesn't require as much memory as MS wants you to believe (heck I run it idling and it needs 14megs of RAM, it uses memory on needed-basis, if it starts to idle after work, it starts to free memory, of these 14megs I think 6megs can be paged, so it's 8megs). There are no public details about how the data store itself works, but it seems to be pretty efficient and fast. About using it as filesystem, there is not much info available except for the fact (meanwhile official) that MS wants to add filesystem semantics to it. How they would look like exactly, noone knows for sure. Maybe it will be a traditional filesystem using a MFT and SQL Server acting as directory service for the files, maybe SQL Server will replace the whole filesystem. In latter case noone knows details. An idea could be storing each cluster (e.g. 4kb) in one row, but that would be inefficient since it'd need to run a query to grab each cluster. If it would query all, it'd be equivalent to loading the whole file into memory. So this case looks unlikely. Or it would store the whole file into a blob in one row and apply file system semantics to the blob. In what way is the question. As far I know does SQL Server store a blob only continously (means no fragmentation). The question is how IO and blob growing will work (esp since it aint allowed to fragment, correct me tho if I'm wrong). All summed up: No idea. Link to comment Share on other sites More sharing options...
G0D Posted March 30, 2002 Share Posted March 30, 2002 bitch, that made my head hurt :/ Link to comment Share on other sites More sharing options...
Glowstick Posted March 30, 2002 Share Posted March 30, 2002 I will hurt it even more on IRC, trust me ;) Link to comment Share on other sites More sharing options...
Tim Dorr Veteran Posted March 30, 2002 Veteran Share Posted March 30, 2002 Question: What's the point for desktop users? I see no reason to add something that's not going to improve user experience while slowing performance on the desktop level... Link to comment Share on other sites More sharing options...
radioboy Posted March 30, 2002 Share Posted March 30, 2002 Because it will make organizing and sorting files amazingly easier. Ever use BeOS? Not only does the whole file system run super-fast but it's a sinch to organize files by just about any attribute (and hell, you can even make up your own) Link to comment Share on other sites More sharing options...
Glowstick Posted March 30, 2002 Share Posted March 30, 2002 Who said it would slow it down? I wrote a small app to stuff data into SQL Server (see it as archive). The benchmarking I added to it performed very fast (notice the datafiles are stored on a NTFS partition, where as in Storage+ there will be no underlying filesystem). As I have heard, Microsoft wants to offer a flat hierarchy, means no folders. I would appreciate that, coz it would ease lots of stuff here. But there will be still folders simulated I think, dunno if that's only planned for supporting legacy apps or if it's permanent. Link to comment Share on other sites More sharing options...
Recommended Posts