Stack Overflow
Stack Overflow

Questions tagged [system-design]

Systems design is the process of defining the architecture, components, modules, interfaces, and data for a system to satisfy specified requirements. (wikipedia)

Systems design is the process of defining the architecture, components, modules, interfaces, and data for a system to satisfy specified requirements. Systems design could be seen as the application of systems theory to product development. ref

618 questions
0
votes
2 answers

Building an application for internal and external use - how do I structure them?

I'm working on consolidating our company's various information systems into a single web based application. No small feat, but one that we're going to gradually roll out and improve upon as time goes on. The application is divided into two areas - a…
EvilChookie
  • 563
  • 3
  • 14
  • 31
0
votes
2 answers

Architecture: Distributed Data Processing w/ Node Failure Tolerance

I have lots of pieces (tens of thousands) of data/jobs that need frequent recurring processing. The jobs to be processed are stored in a SQL Server 2012 (Web Ed) database that gets updated with new jobs frequently and/or may have jobs deleted from…
Alex
  • 75,813
  • 86
  • 255
  • 348
0
votes
1 answer

Enterprise java app architecture. Dynamic domain model

I wonder what is the best way to implement dynamic domain model persisted in SQL database? Saying dynamic domain model I mean such model when user can change "class" of object by adding or removing properties. For example: little internet shop…
Alex Povar
  • 4,890
  • 3
  • 29
  • 44
-1
votes
0 answers

Automatically Assign Random Seats to People According to Category

I have a seating arrangement in string format with category like this: const seats = '_VCCCCVVVVVVVVVV_/' + '_________________/' + '_U__GGGGCCGGG__C_/' + '_U__GGGGCCGGG__C_/' + '_U__GGGGGGGGG__C_/' + '_U__GGGGGGGGG__C_/' + …
Snehil Shah
  • 333
  • 1
  • 10
-1
votes
1 answer

How to efficiently query hierarchy data?

I have a system build with micro-services (user service and device service) with hierarchy data: Data is separated by organization. Users in OrgA can see all the data (including data in OrgB, OrgC, OrgD, OrgE, OrgF and OrgG). However, users in OrgG…
Enix
  • 4,415
  • 1
  • 24
  • 37
-1
votes
1 answer

Getting the correct current value of limited item (System Design/MySQL)

We ran into an issue. Our company plans to provide a service where we would sell a package where up to 200 users from the client's company can be subscribed to at a time. We are using MySQL. The issue arises when a client either reached the…
flow24
  • 793
  • 2
  • 5
  • 17
-1
votes
1 answer

Relation between tiers in architecture and distributed system?

I was going through a course on system design which mentioned any architecture which has more tiers than a 3-tier architecture to be a distributed system. I believe even a 3-tier system can be distributed. Is it correct? What about 1-tier or 2-tier?
white-hawk-73
  • 856
  • 2
  • 10
  • 24
-1
votes
1 answer

In system design, when saying distributed system, do we mean distributed database system?

For example, if i have a single database in my application, but multiple instances of application running behind a load balancer. Would that be called a distributed system? If so, wouldn't this system be violating the CAP theorem. There is no…
AA_20
  • 21
  • 6
-1
votes
1 answer

How do I create a staging and production environment for the data within a database? Database/API/application architecture planning

I have two applications that will be going through my API and interacting with my database(s). The first application displays production data that the customer can view, this has been through a QA process in a staging environment. The second…
DnR
  • 1
-1
votes
2 answers

Can I use Bloom Filters in searching?

I have a single table in my database that contains 40 million user data entries. My goal is to determine whether a user is present or not, based on their unique ID. However, if I were to provide an incorrect ID, the database would search through all…
Alex Sparrow
  • 197
  • 2
  • 7
-1
votes
3 answers

How to organise and query SQL tables with many user entries, when each user only needs to read their own data input in the last month?

I am making a budget management app which allows users to enter entries of their expenditures with the following schema: user_id, date, item, currency, amount_of_money, category When the app first loads, the app will only need to load the specific…
Chloe
  • 3
  • 4
-1
votes
1 answer

Can we treat binary files as documents?

I am want to be able to store per user multiple types of binary files. Could be pdf, photos or very small video ~2MB. I have in mind 2 approaches: Use MySQL and have a BLOB column in a table and add in the column these different types of files. Use…
Jim
  • 3,845
  • 3
  • 22
  • 47
-1
votes
1 answer

What will happen if I don't scale my application or database servers and I increase the load?

I understand horizontal scaling, vertical scaling, sharding, I want to gain more understanding on what will happen to the application i.e the effects of not scaling over how I can solve the problem by scaling. Here are my doubts, What are all the…
noob codes
  • 3
  • 2
-1
votes
1 answer

Solution to handle billions of records for faster insertion and instant retrieval

I have a text file(call it grand parent file) which contains 1 million lines. Each of these lines contain absolute paths of some other files(call them parents) as shown below. The paths of parent files are unique. %: cat input.txt - grand parent…
SH47
  • 11
  • 3
-1
votes
1 answer

Should each microservice contain event consumer itself or separate from it in event-driven MSA?

Which one is better between (1) having event consumer(e.g. KafkaListener) in server application of a microservice (2) having another application only for consuming the events and calling API of the microservice which contains business logic(e.g.…
Wood
  • 422
  • 7
  • 15
1 2 3
…
41 42