Re^3: Joint Database Technology

I do not see any advantages to what your propose over what an RDBMS offers. There is more to the story than just storing and retrieving data. $Clients want the data pivoted into all arrangements of reports. Standards such as PCI compliance shun using Personally Identifiable Information as non-encrypted keys. And then you have technologies such as Hadoop can perform map/reduce algorithms on flat files that span across multiple machines.

What you have sounds cool, but not at the expense of ignoring current solutions that take a lot more into consideration than what you have here. What would sound cooler is a deploy-able implementation of what you propose -- and i certainly hope you don't limit your audience to just 1 platform.

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

Comment on Re^3: Joint Database Technology Select or Download Code

Replies are listed 'Best First'.
Re^4: Joint Database Technology by Anonymous Monk on Jun 12, 2017 at 17:55 UTC
For reporting from JOINT Flat File/SDBM databases, I personally would use Win32 Perl OLE module to talk to MS-Excel, sending my report outpit directly there to formatted reports and pivot tables.	[reply]
Re^4: Joint Database Technology by locked_user erichansen1836 (Sexton) on Oct 05, 2017 at 12:26 UTC
Jeffa, for pivot tables use MS-Excel. The Perl Win32::OLE module allows one to establish a Perl COM connection to MS-Excel in the background. I have used this for over a decade to send my SQL Result Sets from MS-Access database files to Excel files. I don't use the MS-Access front-end software, but only connect to MS-Access files via Dave Roth's Win32::ODBC Perl module. Remember, this did not stop Microsoft Corporation from producing MS-Access software for data storage. Likewise, I don't expect most people would object to FlatFile/SDBM databases not providing an all inclusive solution for reporting. If you are looking for a single product that does everything (such as MS-Access/MS-Excel combined into one software), good luck.