mysql – How do I choose a database structure for a financial accounting app (considering scaling)?

We are creating a financial accounting application that allows users to manage individual and multiple companies among them. The user can be an accountant with n companies or a single company. We are trying to understand how the database should be designed for such an application.


  1. The ability of an accountant to view all open invoices in all of the companies he manages.

  2. The ability to archive records of companies when they leave us.

  3. The ability to view data from multiple companies under one accountant to generate reports.

Database structure:

There are three possible database structures, but we need to know which one suits us best:

  1. Have a parent database that contains all accounts and company information. Each company has its own database in which all transactions are processed and stored.

  2. have a single database that stores all user and company profile data, and each company has its own tables for storing transactions.

  3. Have a single database that holds all of your company's transaction data in a single table called Transactions.

We try to understand which DB architecture suits us best. I have MySQL / MariaDB in mind (just because all the data is relational), but if you think other databases would be better, I would definitely like to know more about it.

Asymptotics – Why is my proof of the asymptomatic time complexity of a dynamic array using the accounting method an incorrect answer?

I had problems formatting the summation symbols. So if anyone knows how to do it right, feel free to edit it.

I have just read the chapter on asymptomatic analysis of CLRS. Although I am aware of the aggregation and the potential method, I thought I should practice a little more with the accounting method. My goal was to prove that if you have an array size 1 and when it is full, you double the size, resulting in a time complexity of O (1) per operation. Here is the evidence I found using aggregate analysis:

If you append n times, the time complexity is as follows:

$ sum_ {i = 1} ^ { log n} frac {1} {2 ^ i} $

that is less than

$ sum_ {i = 1} ^ {+ infty} frac {1} {2 ^ i} $

that is the same $ 2n $. So the time complexity for all N operations is O (N), so the time complexity for a single operation is O (1).

However, if the size starts at 1 and is then added to 1 instead of multiplying by 2 (ie the size starts with 1, then becomes 2, then becomes 3, etc.), the time complexity should be O (N) I use the aggregate analysis.
$ sum_ {i = 1} ^ {n} (i + 1) $

The additional 1 results from the actual placement of the next element. This is approximately (n (n + 2)) / 2 or O (N ^ 2) for all N operations and O (N) for a single operation, which is correct. However, I get a different answer when using the billing method. The actual cost of placing an item is 1, and the asymptomatic cost that I set is 2. So the first time is 2 and copying the second time doesn't take any extra time because I paid for it in advance, and the additional cost of placing this item is 2. So it will:

$ sum_ {i = 1} ^ {n} 2 $

This is equal to O (N) for all total operations and O (1) for a single operation. This is not the right issue. Where did I go wrong and how can I fix it?

Who offers the best finance and accounting service in India?

Mynd Solution offers world-class finance and accounting services and is the leading brand in finance and accounting services with an industry-specific solution. Our solutions are tailored to the customer's goals. Mynd is proud of its capabilities as a specialized partner for finance and accounting. We offer our customers various unique distinguishing features in Q&A services that set us apart from the others.
To take advantage of or learn more about the benefits of the finance and accounting service, visit:

Is the WISECP accounting script free of errors?

Is the WISECP accounting script free of errors? | Web hosting talk

& # 39);
var sidebar_align = & # 39; right & # 39 ;;
var content_container_margin = parseInt (& # 39; 350px & # 39;);
var sidebar_width = parseInt (& # 39; 330px & # 39;);
// ->

  1. question Is the WISECP accounting script free of errors?

    I just discovered WISECP from and was excited to see if anyone had any first-hand experience with this billing script. Is it good for something?

Similar topics

  1. Reply: 13

    Last contribution: 11-04-2003, 05:13 a.m.

  2. Reply: 12

    Last contribution: 27/08/2002, 2:20 p.m.

  3. Reply: 7

    Last contribution: 01-06-2002, 3:43 p.m.

  4. Reply: 2

    Last contribution: 09-04-2001, 8:53 a.m.

  5. Reply: 19

    Last contribution: 06-11-2001, 3:41 p.m.

Publish permissions

  • You not allowed post new topics
  • You not allowed Post responses
  • You not allowed Post attachments
  • You not allowed Edit your posts

Database Accounting Design – Stack Exchange for Database Administrators

I am trying to design the database for my accounting app. I've read a bit about database and came up with this design. I really do not know if my logic is good here
In tbl_journal, the date, amount, and amount of the transaction are stored, and the transaction contains the journal_id, the account, the amount, and the accounts involved in each transaction. This means that there are 2 entries in the transaction, where one entry indicates the positive and the other the negative amount. Amount with the name of the debit / credit account.
A user can enter one or more transactions
A transaction can consist of one or two journal entries
An account may have one or too many transactions (I think this is wrong)

Enter image description here

DreamProxies - Cheapest USA Elite Private Proxies 100 Private Proxies 200 Private Proxies 400 Private Proxies 1000 Private Proxies 2000 Private Proxies - Buy Cheap Private Proxies Buy 50 Private Proxies Buy 100 Private Proxies Buy 200 Private Proxies Buy 500 Private Proxies Buy 1000 Private Proxies Buy 2000 Private Proxies ProxiesLive New Proxy Lists Every Day Proxies123