mysql - RDBMS vs NoSQL for CRM, CMS and other financial Systems -

-

i've read whole sql vs nosql stuff out there in internet (spent few days on have rights call way :) ) , still have feeling i'm far away being able decide wich platform our products shall go with. we're start designing new set of products fit crm/cms categories, i'd several b2b, b2c, b2e, e-commerce other financial , banking apps. it's gonna complex system dozens of databases solving different tasks. let's concentrate on db area. found this article particularly interesting db systems in world of enterprise. actual problem is:

is better stay old rdbms such mysql (yes, has open-source, that's requirement) or start off nosql such mongodb/couchdb (i guess cassandra scalable crm, it's not going distributed , heavily clustered system. 4 strong guys job perfectly)???

as additional details can lot of media stuff , docs engaged in system, must stores, markets, hr systems. , consumers of storage web apps mainly.

would better split db back-end 2 parts: rdbms serving relational data , nosql media storage?

what think , if have examples or such experience extremely avoid future problems. thank guys in advance!

there nosql (newsql) databases acid compliant consider. use 1 of handle transactional crm data. there many benefits using these compared traditional relational databases:

  • much better performance
  • schemaless
  • some let remove orm , uses created objects automatically
  • some have integrated web server rest/json support, nice since work web apps end user.

the acid part important if build crm. once build crm system uses nosql database , performance made possible add features never have considered if had used traditional rmdbms.

i idea should put media , documents cdn , refer them database.

your open source requirement bit of showstopper though.

i wrote article on subject might give advice in topic of selecting database:

http://www.ulitzer.com/node/2636237


Comments

Post a Comment

Popular posts from this blog

c++ - Creating new partition disk winapi -

-
i'am trying create new partition , mount volume new, thought createfile let me this, code : lpctstr lpfilename=l"\\\\.\\device\\harddisk0\\partition3"; handle handl=createfile( lpfilename, generic_read | generic_write, file_share_read | file_share_write, null, create_always, file_attribute_normal, null ); if (handl==invalid_handle_value) { qdebug()<<"handl invalid"<<" error"<<getlasterror();} bool success = definedosdevice(ddd_raw_target_path,l"i:",l"\\device\\harddisk0\\partition3"); if(!success) qdebug()<<" definedosdevice failed "<<getlasterror(); bflag = getvolumenameforvolumemountpoint( l"i:\\", // input volume mount point or directory /** u in dir
Read more

Android Prevent Bluetooth Pairing Dialog -

-
i'm developing internal application uses bluetooth printing. want bluetooth pairing occur without user input. have managed working trapping android.bluetooth.device.action.pairing_request broadcast. in broadcast receiver call setpin method, , pairing works ok, bluetoothpairingdialog displayed second or two, disappears - see link below. https://github.com/android/platform_packages_apps_settings/blob/master/src/com/android/settings/bluetooth/bluetoothpairingdialog.java since broadcast non-ordered, can't call abortbroadcast() , , wondering if there other way prevent pairing dialog appearing. can hook window manager in way? i haven't been able come way without modifying sdk. if you're oem, it's easy (i'm on 4.3): in packages/apps/settings/androidmanifest.xml, comment intent filter pairing dialog: <activity android:name=".bluetooth.bluetoothpairingdialog" android:label="@string/bluetooth_pairing_request"
Read more

VBA function to include CDATA -

-
i have following function include cdata: function cdatasection() dim objdom domdocument dim objkmlrootelement ikmldomelement dim objkmlelement ikmldomelement dim cdata ikmldomcdatasection set objdom = new domdocument set objkmlrootelement = objdom.createelement("balloonstyle") objdom.appendchild objkmlrootelement set objkmlelement = objdom.createelement("text") objkmlrootelement.appendchild objkmlelement set cdata = objdom.createcdatasection("text") cdata.data = "<![cdata[<b>latitude = $[latitude]</b>?]]>;" end function when run above, getting error "user defined data type not found" function. yes ripster says find library reference. vba window tools>references for list of relevant references see... http://msdn.microsoft.com/en-us/library/windows/desktop/ms763701%28v=vs.85%29.aspx however, if have hard time tracking down reference, replace dim sta
Read more