NoSQL DB For .Net Document-based Database (ECM)?

Apr 19, 2010

I'm halfway through coding a basic multi-tenant SaaS ECM solution.Each client has it's own instance of the database / datastore, but the .Net app is single instance.The documents are pretty much read only (i.e. an image archive of tiffs or PDFs)I've used MSSQL so far,but then started thinking this might be viable in a NoSQL DB (e.g. MongoDB, CouchDB).The basic premise is that it stores documents, each with their own particular indexes. Each tenant can have multiple document types.

e.g. One tenant might have an invoice type,which has Customer ID, Invoice Number and Invoice Date.Another tenant might have an application form, which has Member Number, Application Number, Member Name, and Application Date.So far I've used the old method which Sharepoint (used?) to use, and created a document table which has int_field_1, int_field_2, date_field_1, date_field_2, etc.Then, I've got a "mapping" table which stores the customer specific index name,and the database field that will map to.I've avoided the key-value pair model in the DB due to volume of documents.

This way, we can support multiple document types in the one table,and get reasonably high performance out of it,and allow for custom document type searches (i.e. user selects a document type, then they're presented with a list of search fields).

However,a NoSQL DB might make this a lot simpler,as I don't need to worry about denormalizing the document.However,I've just got concerns about the rest of the data around a document.We store an "action history" against the document.This tracks views,whether someone emails the document from within the system,and other "future" functionality (e.g. faxing).

We have control over the document load process,so we can manipulate the data however it needs to be to get it in the document store (e.g. assign unique IDs). Users will not be adding in their own documents,so we shouldn't need to worry about ACID compliance,as the documents are relatively static.

So,my questions I guess :Is a NoSQL DB a good fit Is MongoDB the best for Asp.Net (I saw Raven and Velocity,but they're still kinda beta)Can I store a key for each document,and then store the action history in a MSSQL DB with this key?I don't need to do joins,it would be if a person clicks "View History" against a document. How would performance compare between the two (NoSQL DB vs denormalized "document" table)Volumes would be up to 200,000 new documents per month for a single tenant. My current scaling plan with the SQL DB involves moving the SQL DB into a cluster when certain thresholds are reached,and then reviewing partitioning and indexing structures.

View 1 Replies


Similar Messages:

C# - NOSQL Database Selection For Forum?

Oct 20, 2010

i am developing a FORUM i am using asp.net, c# language for code. I have read a article about NoSql i inspired a lot from there advantage over RDBMS (sql) so i was thinking that should i use NoSql concept for Forum DataBase or not. I am not a expert in database. So can u suggest me should i use NoSql? Currently I am using sql(rdbms).

View 1 Replies

C# - Printing The Documents Based On Document Type?

Nov 9, 2010

i have .doc,.xls,.PPt,.rtf files in the server. How do i implement the print functionality for the user. I have the list of file names and file type. some code samples to print the documents based on the file type. I am using c# 4.0 ASP.NET

View 1 Replies

C# - Database Table To XML Document?

Jul 8, 2010

Basically I have a asp.net that I need to display an XML document (straight xml, with the tree nodes) I have the sql statement which returns the row names and each one of their values. Just wondering how I should go about doing this?

SQL Server 2008, my query is just a select * from offices, my results is "1","New York","New York City","555-5555" I would like the output to be

<item id="1">
<state>New York</state>
<city>New York City</city>
<phone>555-5555</phone>
</item>

where state/city/phone is the column name, and the value is the value of that column

View 3 Replies

Display Uploaded Document From Database

Oct 10, 2010

I have a MVC 2 web application. The website captures grant applications for loans. With each application I can upload documents. The way that we upload documents to the database is as follows:

private IEnumerable<byte> GetStreamByteArrayData(Stream stream)
{
byte[] buffer = new byte[8192];
int bytesRead = 0;
while ((bytesRead = stream.Read(buffer, 0, buffer.Length)) > 0)
{
for (int byteIndex = 0; byteIndex < bytesRead; byteIndex++)
{
yield return buffer[byteIndex];
}
}
}

The calling method looks like this:

Convert.ToBase64String(GetStreamByteArrayData(hpf.InputStream).ToArray());

In my grid that displays the uploaded documents I have the document name, mime type and so forth. What I am trying to do is to have the name of the document in a link. When the link is clicked then the document is opened. I have no idea how to do this in an MVC app. Can someone provide some sample source code?

View 2 Replies

Web Forms :: Store A Document In A Database?

Jul 21, 2010

I am using ASP.NET 3.5 and SQL SERVER 2008. How can I store a document in sql server after I attach the document to a form in ASP.NET 3.5.

View 3 Replies

Databases :: How To Retrieve Images And Document In Database

Jun 9, 2010

i can view the images from the database (datatype = binary) but the problem is the .doc and pdf is not appearing at the page...

[Code]....

View 5 Replies

How To Insert Data To A Database From A Text Document

Jan 28, 2010

In my application,i want to check a condition whether the 'ENTER' key is pressed or not.i want to read data from a text file and insert this data to my database.I have written my code in a button-click event.In the text file, every field is separated by a comma so that each field can be identified.After one record,'ENTER' key is pressed and next record is written in next line.so i want to insert each row in the database until the next line.i suppose i can check this with the ASCII code of "Enter" key.

View 2 Replies

Hosting An In-process Document Database On Windows?

Jan 8, 2011

Are there any document-databases, similar to MongoDB, that run within an ASP.NET web application, and could be hosted on a server without any unique machine configuration?

I'm asking this because the hosting provider I'm currently with only support SQL Server 2008 as a database, but I'd like to run my website off a document database.

(Or am I better off going with a specialized database host, such as MongoHQ)?

View 1 Replies

How To Point The Login Control To A Different Database Based On The Database Selection

Feb 23, 2010

For the login control that I am using, there is a connectionstring which is automatically created in the web.config file.I ran an .exe file which populated the specified database with all the asp login related tables and stored procedures...

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=localmachineName;Initial Catalog=DBName;Persist Security Info=True;User ID=DBUserName;Password=password" providerName="System.Data.SqlClient"/>
How can I point the login control to a different Database based on the database selection by a user i.e. the user can change the name of the database and so the login should point to that database.

View 7 Replies

DataSource Controls :: Remove Uploaded Document From Database?

Jan 30, 2010

I have a Document name column with varbinary(max) type column in my table

first time when i upload document i am storing doc as a byte array

Dim fs As Stream = Me.fileupload1.PostedFile.InputStream
Dim br As New BinaryReader(fs)
Dim bytes As Byte() = br.ReadBytes(fs.Length)

in my application i have remove atttachmentDoc button, i want to remove uploaded doc from db

so when i pass like this to my storedprocedue

Dim obj As New cls1
Dim bData() As Byte = New Byte(0) {}
bData=nothing
With obj
Dim dt As DataTable = Read_Doc()
If dt.Rows.Count > 0 Then
If Not IsDBNull(dt.Rows(0)("Document")) Then
.Document = bData
.Document_extension = ""
.Remove_Attachment(Me.Selected_ID)
End If
End If
End With

i got error

dbAccess.executeQuery: Procedure or function 'SP_DML1' expects parameter '@Document', which was not supplied.

View 1 Replies

Controls :: Save ITextSharp PDF Document To MySql Database

Mar 26, 2016

I want update pdf to databse without using any controls(file upload) 

i will convert the webpage to pdf when i click convert i also automatically saved to database how????

View 1 Replies

How To Save The Created Word Document On Database, Or On Server Folder

Feb 14, 2011

I am Generating a Word Document by using Following Code:

StringBuilder str1HTMLContent = new StringBuilder();
str1HTMLContent.Append("<html>".ToString());
str1HTMLContent.Append("<body>".ToString()); [code]....

The word file is Created and popup on windows .How can i save this created word Document on Database, or on server folder?

View 2 Replies

ADO.NET :: Trying To Populate Database Fields By Reading Text From A Word Or PDF Document?

Mar 11, 2011

I am trying to populate database fields by reading text from a Word or PDF document. Like if a user uploads a file then certain text from that file can be usd to populate a database table.

View 1 Replies

Controls :: Read Contents Of Word Document And Save In Database In C#

May 7, 2015

I want store MS word content in sql server not complete document only content should be save. Is it possible using C# .NET (Windows Application) or ASP .NET.

View 1 Replies

C# - How To Download Word Document Stored In Database As Content Data In Sql Server

Jan 4, 2010

How to download a word document which is stored in database, sql server as a content data through C#? This is my Code I'm using:

string doctype = dtResumeInfo.Rows[0]["ContentType"].ToString();
string docname = dtResumeInfo.Rows[0]["FileName"].ToString();
//[code]....

But, it is showing the following error:SubStatusCode 'Response.SubStatusCode' threw an exception of type 'System.PlatformNotSupportedException'
base {"This operation requires IIS integrated pipeline mode."} System.NotSupportedException {System.PlatformNotSupportedException}
Headers 'Response.Headers' threw an exception of type 'System.PlatformNotSupportedException'

My IIS version is 6.0 where I published. Donwloading word document can be done only in IIS 7. So, this is the cause of the error. Is there any other way to overcome this problem? Any other code will support lower version??

View 2 Replies

DataSource Controls :: Document Managment System To Store All Documents In Database?

Jun 16, 2010

Is it a good idea to create a document managament system that stores all kinds of documents inside sql server database. This will have infrastructure to accomodate all kinds of applicartions..

View 2 Replies

Social Networking :: Hide URL Of Document When Using Google Document Viewer With IFrame

Jan 24, 2014

<iframe src="http://docs.google.com/viewer?url=filename&embedded=true" style="width:600px; height:600px;margin-left:20px;" frameborder="0"></iframe>

I am using above code to show our document online.

But when we inspect element it is showing url of file which we dont't want.

it is possible to hide this url or any other alternate to show our document to user without exposing our physical file path.

View 1 Replies

WCF / ASMX :: How To Pass Xml Document (huge Document) Through WCF RestFul Service

Aug 16, 2010

I have xml document and wanting to pass it through wcf restfull service, i am able to do that by using string format i mean i can pass the xml as string param in the restful service and it worked but now my xml document becomes huge so if i pass it as string then it gives URI long error. any way i can pass the huge xml document through the WCF RESTFul service.

View 1 Replies

Data Controls :: Open Word Document Stored In Database And View In Browser?

Apr 19, 2014

how we can open word,pdf,txt document which is saved in sqlserver database in binary format.

View 1 Replies

Web Forms :: Convert Word Document To PDF Document Using ITextSharp

May 9, 2012

I want when user upload  a doc file it convert into pdf. How can i do this. I read that itextsharp convert it.

View 1 Replies

Forms Data Controls :: Upload Book - Document And File That Must Be Stored In A Database Table

Nov 25, 2010

I need to upload book , document and file, that must be stored in a database table. For this I need code.

View 3 Replies

Web Forms :: Hiding The Document Name When Launching A PDF Document?

Sep 15, 2010

I am launching a pdf document using either:

1. Response.Redirect("filepath/document.pdf"), or

2. Response.ContentType = "Application/pdf"
Response.WriteFile("filepath/document.pdf")
Response.End()

Both methods successfuly launch the PDF document displaying the document path and title in the title bar. For security reasons I'd like to HIDE the document title. Can someone advice how this can be done? (How can a PDF document be launched without showing the actual document's name)

View 14 Replies

Migrate Existing Database From Specific Application To New Ms Access Based Application (database)?

Aug 2, 2010

how to migrate an existing database from a specific application to a new Ms Access based application(database)?

View 4 Replies

Convert Word Document To PDF Document?

Jun 10, 2010

I want to convert to Word Document in a PDF document. I do not want to use any third party control. I want to do it on my own. Can somebody tell me how to start with it?

View 7 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved