What programming language is used to store Bank Acct's/money?

In summary, banks tend to store banking information in a variety of formats, depending on the core application used. Older programming languages and technologies are still used in some parts of the banking system, and migration efforts can go wrong if you don't understand the code being migrated.
  • #1
Jarfi
384
12
is it PHP-MySQL?

In websites accounts of users tend to be stored in servers, and on these servers they store the data in some syntax and use PHP, RUBY or something else to add/change the information.

Is it the same in bank accounts? In what format is banking information stored?
 
Technology news on Phys.org
  • #2
Chances are high that it is COBOL on a DB2 under MVS.
 
  • #3
Jarfi said:
is it PHP-MySQL?

In websites accounts of users tend to be stored in servers, and on these servers they store the data in some syntax and use PHP, RUBY or something else to add/change the information.

Is it the same in bank accounts? In what format is banking information stored?
It depends on which core application they use. Sensitive data is usually stored in RDBMS tables like any other data, except it is protected using application-level encryption, column-level encryption, or full database encryption; proper database access controls are still necessary to limit the data users/roles have access to.
 
  • Like
Likes Jarfi
  • #4
There are older programming languages / technologies (to some degree) in the banking system as fresh_42 points out. There has also been migration regarding software platforms - especially during the last decade. Banking systems (regarding the whole platform) consist of various parts. Software platforms / technologies for banking are chosen in a rather conservative way or in other words must be well tested and somewhat mature regarding security, stability and technical support. Java is one of the widely used technologies, C++ and .NET platform (with C# the dominant language) are as well. In database technologies / RDMSs Oracle is a major player worldwide but there are other technologies used as well.
 
  • Like
Likes Jarfi
  • #5
One of the issues with banking systems, is the common practice of performing all calculations involving money using decimal based math (usually fixed point), which is required by banking laws in some countries. COBOL includes decimal based variables (packed or unpacked decimal (using BCD - Binary Coded Decimal)).
 
  • #6
I've even seen old assembler code. I don't think that C++ or something makes a lot of sense on a mainframe. And mainframes still cover security, grading and performance best. I've heard of migration attempts that went wrong. One reason is, that you cannot migrate what you don't understand. And since the early 80's there's really a lot of code been written. And hopefully my bank does not use PHP and MySql. What a horrific imagination! That would be worse than abacuses.
 
  • #7
fresh_42 said:
I've even seen old assembler code.
In the case of IBM mainframes, some of their database access methods are/were implemented as assembly language macros, so applications ended up with a mix of COBOL and assembly. Once assembly was part of the mix, additional code was written in assembly for performance reasons, and these days, assembly remains somewhat due to these legacy issues. It's hard to justify porting large libraries of working legacy code to newer languages due to the time it would take to verify the new code was error free.
 
  • #8
In languages such as C#, the programmer can take advantage of object abstraction. A persons bank information is stored in a RDMS database which is a relational layer for account processing and data security security layer. The choice of the programming language is then independent of the information being processed.
 
  • #9
As others have pointed out the code is likely to be legacy stuff in COBOL as it is really expensive to port these large business applications. Our local Telecom company had a system consisting of 10 million lines of COBOL. Our nationwide banking system has been in operation since 1972 so probably consists of a lot of COBOL. Also companies that make big mainframe computers like IBM try to make them backward compatible with old applications to slow the need for migration.

Cheers
 
  • Like
Likes jim mcnamara

1. What programming language is commonly used for storing bank account information and money?

The most commonly used programming language for storing bank account information and money is SQL (Structured Query Language). SQL is a specialized language designed specifically for managing data in relational databases.

2. Can other programming languages be used for storing bank accounts and money?

Yes, other programming languages can be used for storing bank account information and money. For example, Java and Python both have libraries and frameworks that allow for database management and can be used to store financial data.

3. Are there any security concerns with using a specific programming language for storing bank accounts and money?

The programming language itself is not a security concern. However, the implementation of the language and the security measures taken by the programmer can greatly impact the security of the stored financial data. It is important for programmers to follow secure coding practices and regularly update security measures to protect sensitive information.

4. Is there a specific programming language that is preferred by banks for storing financial data?

There is no one specific programming language that is preferred by all banks for storing financial data. Each bank may have its own preferred language based on their specific needs and systems. However, SQL is commonly used by many banks due to its efficiency and reliability in managing large amounts of data.

5. How does a programming language store bank account information and money?

A programming language stores bank account information and money by using a database management system (DBMS). The DBMS allows for the creation, manipulation, and retrieval of data stored in a database. SQL commands are used to create and manage tables, which store the bank account information and money in an organized and secure manner.

Similar threads

  • Programming and Computer Science
Replies
16
Views
2K
  • Programming and Computer Science
2
Replies
43
Views
2K
  • Programming and Computer Science
Replies
11
Views
997
  • Programming and Computer Science
Replies
3
Views
1K
  • Programming and Computer Science
Replies
5
Views
819
  • Programming and Computer Science
3
Replies
75
Views
4K
  • Programming and Computer Science
Replies
2
Views
2K
  • STEM Career Guidance
Replies
15
Views
2K
  • Feedback and Announcements
Replies
0
Views
94K
Back
Top