Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. how do i design a database system for an app?

how do i design a database system for an app?

Scheduled Pinned Locked Moved Database
questiondatabasedesignjsonperformance
8 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • B Offline
    B Offline
    BupeChombaDerrick
    wrote on last edited by
    #1

    When designing a program and you want it to store its memory content on a hard disk (database) so that one can restore it's memory at a later time, what is the best way to go about this, do i have to design my own storage API's or there is something available? please need some help.:confused:

    M L P 3 Replies Last reply
    0
    • B BupeChombaDerrick

      When designing a program and you want it to store its memory content on a hard disk (database) so that one can restore it's memory at a later time, what is the best way to go about this, do i have to design my own storage API's or there is something available? please need some help.:confused:

      M Offline
      M Offline
      Mycroft Holmes
      wrote on last edited by
      #2

      This question is so basic and so all encompassing it cannot be answered in a forum post. You need to get a very basic book on computer systems and database. If you don't have the conceptual idea of how a database works then you are not going to understand most of the information on the web, it assumes a reasonable level of knowledge. Try browsing SQLServerCentral.com, you may find some early instruction articles there.

      Never underestimate the power of human stupidity RAH

      1 Reply Last reply
      0
      • B BupeChombaDerrick

        When designing a program and you want it to store its memory content on a hard disk (database) so that one can restore it's memory at a later time, what is the best way to go about this, do i have to design my own storage API's or there is something available? please need some help.:confused:

        L Offline
        L Offline
        Lost User
        wrote on last edited by
        #3

        Persisting your app's state (like Window state, position, etc.) and persisting the data your app is working with (business data like Customer Info, Orders, etc.) are two different things. For persisting app state, you can use XML, plain text files, etc. For persisting business data, you can use a database. If the size of the data you're talking about is very small, you can use XML for that too.

        B 1 Reply Last reply
        0
        • B BupeChombaDerrick

          When designing a program and you want it to store its memory content on a hard disk (database) so that one can restore it's memory at a later time, what is the best way to go about this, do i have to design my own storage API's or there is something available? please need some help.:confused:

          P Offline
          P Offline
          PIEBALDconsult
          wrote on last edited by
          #4

          BupeChombaDerrick wrote:

          store its memory content on a hard disk

          I recommend writing it to a binary file.

          1 Reply Last reply
          0
          • L Lost User

            Persisting your app's state (like Window state, position, etc.) and persisting the data your app is working with (business data like Customer Info, Orders, etc.) are two different things. For persisting app state, you can use XML, plain text files, etc. For persisting business data, you can use a database. If the size of the data you're talking about is very small, you can use XML for that too.

            B Offline
            B Offline
            BupeChombaDerrick
            wrote on last edited by
            #5

            Shameel wrote:

            If the size of the data you're talking about is very small, you can use XML for that too.

            Hey i thought XML was a standard, OpenCV 2.2 uses mostly XML files for storage, so i was actually considering XML, I want to know why i should not use XML for all storage purposes?XML is cool & easy to work with:cool: I actually want to increase the database size of an image indexing software that indexes images based on content for a Content-based Image Retrieval System i have developed so that a huge image database can be indexed, i have been using OpenCV 2.2 storage system for now, I don't know if you have used OpenCV 2.2 storage system, if you have,is it wise to keep using OpenCV 2.2 storage system even for a large data set? :)

            L 1 Reply Last reply
            0
            • B BupeChombaDerrick

              Shameel wrote:

              If the size of the data you're talking about is very small, you can use XML for that too.

              Hey i thought XML was a standard, OpenCV 2.2 uses mostly XML files for storage, so i was actually considering XML, I want to know why i should not use XML for all storage purposes?XML is cool & easy to work with:cool: I actually want to increase the database size of an image indexing software that indexes images based on content for a Content-based Image Retrieval System i have developed so that a huge image database can be indexed, i have been using OpenCV 2.2 storage system for now, I don't know if you have used OpenCV 2.2 storage system, if you have,is it wise to keep using OpenCV 2.2 storage system even for a large data set? :)

              L Offline
              L Offline
              Lost User
              wrote on last edited by
              #6

              Yes, XML is a standard and can be helpful for storing relatively small data without the overhead of using a database. But if the size of the data is very huge, performance will suffer. A properly designed RDBMS database will be really fast even if the data is very huge.

              B 1 Reply Last reply
              0
              • L Lost User

                Yes, XML is a standard and can be helpful for storing relatively small data without the overhead of using a database. But if the size of the data is very huge, performance will suffer. A properly designed RDBMS database will be really fast even if the data is very huge.

                B Offline
                B Offline
                BupeChombaDerrick
                wrote on last edited by
                #7

                Thanks for the answers,i really appreciate that. :)

                M 1 Reply Last reply
                0
                • B BupeChombaDerrick

                  Thanks for the answers,i really appreciate that. :)

                  M Offline
                  M Offline
                  Mycroft Holmes
                  wrote on last edited by
                  #8

                  As a caveat on Shameels comment, if you have a small number of records and each record is large (image file) then xml may be valid. You imply you have a huge image set to manage. You really should look into strategies of image storage there are quite a number of options.

                  Never underestimate the power of human stupidity RAH

                  1 Reply Last reply
                  0
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • World
                  • Users
                  • Groups