[database-design] Forum Topics

Public registration platforms often deal with users who are not technically experienced. This makes content presentation extremely important. A system may work perfectly on the backend, but if instructions are unclear, users will struggle. One approach that improves usability is simplifying explanations for processes such as the online ration card …

No Freelancers this is full time employment (Part time is also available). NO Agency, No third party, No businesses, we are only looking to hire individuals, senior roles only. English speaking should be intermediate C2

Hey everyone, I am working on setting up an eCommerce site and want to make sure the database is designed properly from the start. For example: Should I normalize everything or keep some denormalized tables for faster queries? How do you usually handle product attributes and variations efficiently? Any tips …

Looking for a little guidance, for a seemingly not such a complicated project for a website. Maybe y'all could assist me with the optics of this? I want a page on my site to have some input bottons, that will access an astrological database, for some end-user basic information, which …

Hey everyone, I am having trouble with the performance of a DynamoDB table that stores posts and replies. For posts, the PK is USER#<user-id> and the SK is POST#<post-id>#TIMESTAMP. For replies, the PK is POST#<post-id> and the SK is REPLY#<reply-id>. #TIMESTAMP. When there are thousands of replies to a post, …

I'm facing a database connection error in my MySQL-based application. The credentials are correct, but I keep getting: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' Is it a privilege issue, host misconfiguration, or MySQL version mismatch? Seeking expert developers in the USA to resolve and optimize the database connection.

I'm a beginner with databases and I'm trying to design a database in Microsoft Access that will allow users to make bookings for fitness classes. There are two slots per day that these classes can be booked for and each session can cater for 10 people. What I am struggling …

Hi, I'm using update statistics command to analyze a table and would like to know later when this table was analyzed. I saw that in the user_tables table the num_rows coulmn was changed but the last_analyzed coulmn was not changed. Does anyone know if last_analyzed coulmn should be changed and …

We have a mixed set of licenses at my organization: some of use are on Tableau Server, others are on Tableau Cloud. I am having difficulty figuring out how to share a dashboard I made in Tableau Server with a user who only has Tableau Cloud access. I have been …

i want to create table in ms acces database during run time......... Dim myConnection As ADODB.Connection Dim Conn As String Dim vtblNametxt As String Private Sub cratblebtn_Click() vtblNametxt = tblNametxt.Text myConnection.Execute ("create table " & vtblNametxt & " (id varchar2(3),pname varchar2(20), qtyp number(4));") End Sub Private Sub Form_Load() Set myConnection …

In the fast-paced world of startups, solid data pipelines are essential for success. They streamline data collection, enhance decision-making, and improve operational efficiency. By ensuring data consistency and scalability, robust pipelines support real-time analytics and provide a competitive edge. Startups can deliver better customer experiences, ensure compliance, and achieve cost …

Basic background information Mariadb Ver 15.1 District 10.11.6 MariaDB Glarea cluster, one with three nodes: Node1:192.168.18.78 Node2: 192.168.18.79 Node3: 192.168.18.80 Among them, Node1 node was restarted after a power outage of 1 hour, and after executing the system ctl start mariadb, it was stuck for a long time (running for …

Project Preparation. Business Blueprint. Realization

More programming fun! OK this time around I'm trying to create a table with the statement, CREATE TABLE tablename ( recnumber SERIAL PRIMARY KEY, recordvalues VARCHAR ( 500 ) NOT NULL, datecreated DATE ) And it basically works, and I can add records using the dba account. However when I …

solving this question

What scenarios are suitable for using Redis to store chat messages?

I'm working on an SQL query for a complex reporting system that involves multiple tables and joins. However, the query's performance is not meeting my expectations, and I suspect that the way I've structured my joins might be inefficient. Here's a simplified version of my query: SELECT orders.order_id, customers.customer_name, products.product_name, …

[URL="http://www.ibm.com"]IBM[/URL] researchers have [URL="http://www.zurich.ibm.com/news/07/asme.html"]unveiled[/URL] prototype 3D visualisation software that will enable doctors to interact with their medical data in pretty much the same way they interact with their patients. The technology, known as the Anatomic and Symbolic Mapper Engine (ASME), uses an avatar representation of the human body which the …

Web development refers to the creating, building, and maintaining of websites. It includes aspects such as web design, web publishing, web programming, and database management. It is the creation of an application that works over the internet i.e. websites.

How to do database marketing?

I'm trying to figure out where is the report metadata (structure) stored in Netsuite database, (which I ingest into Snowflake from SuiteAnalytics API) if it's in the back-end db at all? I'm trying to reproduce a custom report programmatically outside of Netsuite (in Tableau) and I need to be able …

An equipment company wishes to create a database to support the hiring of tools and machinery to clients. The company has three types of equipment: power tools, such as drills and vacuum cleaners, plants such as excavators and scaffolding. Each piece of equipment is identified by a number. Power tools …

I have this code <?php // Connect to the database $servername = "localhost"; $username = ""; $password = ""; $dbname = ""; // Create connection $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } // Get the user's IP address $user_r_ip …

I look after the company's access database which records the company's products from different suppliers. The table's primary key is the product code and the table also contains a description of the item, the supplier, if discontinued, buying in price and RRP. The product prices are updated from a spreadsheet …

create table customer ( cname char(20) not null, street char(30), city char(30), primary key(cname) ) create table branch create table account ( bname char(15) not null, bcity char(30), assets integer, primary key(bname), check(assets>0) ) ( account # char(10) not null, ( bname char(15), balance integer, primary key(account#) forigen key (bname) …

Hey Peeps, Hope all are doing well. Happy to be a part of this community. So am fairly new in the programming world and exploring a few job opportunities in this field. Coming to my query, So was going through this list of questions, although concepts seem easy to understand …

Hi ppl I am developing website for my friend's very small resort, please see [url removed] this resort have 8 rooms in total and all rooms are of same type so every room is equally priced. I just need code or logic to check availability of given [B]no. of rooms[/B] …

Hello All, I am a software developer and got the opportunity to work on a large web development project. I want to know which source allow efficient data storage feature between file system and dbms in a large project. I have asked this query on Quora and according to this …

The program below is written in **C** and is used to create a **learning management system**. This program is beneficial during the development of an **e-learning** desktop application. Let me know if you find the code below helpful and if you have any additional suggestions:

With this, I'm needing to first off start with the search bar that searches for the last name of a customer. Once the search button is pressed, in a table below it is to produce the full name of the customer, their email address and their city they reside in. …

**I have attached all of the coding needed** I'm using PHP to design a website. The problem that I am facing is that, the button on the add products page isn't taking the inputs and putting them on the products list page. I'm wondering what I can do to get …

[functional module] WDR [Operation steps & amp; problem phenomenon] 1、gs_guc reload -N all -I all -c "enable_wdr_snapshot=on" 2、select create_wdr_snapshot(); 3、select * from snapshot.snapshot; [Screenshot information] openGauss=# select name,setting from pg_settings where name like '%wdr%'; name | setting -----------------------------+--------- enable_wdr_snapshot | on wdr_snapshot_interval | 60 wdr_snapshot_query_timeout | 100 wdr_snapshot_retention_days | 8 …

Hello , i am using vb6.0 can some one help me with my problem. I want to summarize a database with multiple name and display it into one data where the date is same today. thank you for any one would response. for example. below is a table where multiple …

Hello I am building a database (i prefer MongoDB) that i will store over 100 mil ipv4 and ipv6 records for logging purposes. Data sample : 1.1.1.1 -> 0x1010101 1.2.3.4 -> 0x1020304 34.53.63.25 -> 0x22353f19 255.255.255.255 -> 0xffffffff 0001:0001:0001:0001:0001:0001:0001:0001 -> 0x10001000100010001000100010001 1111:1111:1111:1111:1111:1111:1111:1111 -> 0x11111111111111111111111111111111 2345:0425:2CA1:0000:0000:0567:5673:23b5 -> 0x234504252ca1000000000567567323b5 2345:0425:2CA1::0567:5673:23b5 -> 0x234504252ca1000000000567567323b5 …

The installed openGauss database is always wrong, prompted by the figure below：Failed to obtain the environment variable PGHOST. Traceback (most recent call last): File “gaussdb/om/script/gs_install”, line295,in <module> DefaultValue.setActionFlagFile(“gs_install”) File “gaussdb/om/script/gspylib/common/Common.py”, line 2230,in setActionFlagFile Raise Exception(ErrorCode.GAUSS_518[“GAUSS_51802”]%“PGHOST”)

openGauss is an open source relational database management system, which deeply integrates Huawei's years of experience in the database field. Combined with the needs of enterprise scenarios, what deployment forms does it support in the enterprise architecture?

In China, many manufacturers are 'replacing IOE' and are moving closer to open source databases.openGauss is an open source database developed by Huawei itself. Although there is policy support,but ，Oracle has always been ranked first in DB-Engines Ranking. So, do you think openGauss database can replace Oracle database?

I am building a ipv4/ipv6 geo ip **MongoDB** database and i will have millions (100+) of ips Structure will of the database will be [ { _id: 58fdbf5c0ef8a50b4cdd9a8e , ip: '34.53.63.25', ip_hex: '0x22353f19' , type: "ipv4", data : [ { country : "CA", region : "region1" city : "city1", blacklisted …

What are the main core technologies of the openGauss database?For example, availability (RPO / RTO), performance (TPS / QPS), DB4AI / AI4DB, etc.In addition, under the development trend of cloud development, how to ensure its security?

The logical objects of databases are generally the same, but there are some differences. Compared to openGause and Oracle, the logical structure and physical structure are not strictly distinguished.So, what are the main logical objects of the openGauss database?

# Introduction # If you're like most data scientist, analysts, or developers, you probably spend a lot of time worrying about your ever-growing store of data. After all, it's the lifeblood of your business. You need to ensure that it's properly stored and accessible when you need it. This article …

# Introduction # As we move into 2022, businesses will continue to look for ways to become more data-driven. This means that knowing how to use Structured Query Language, commonly called SQL or 'Sequel', will remain an essential skill for data scientists, analysts, and developers. In this post, we'll provide …

Is there a limitation on how many schemas and security objects you can have in one Snowflake database and will there be performance degradation with thousands of these objects? Will splitting the data into multiple snowflake databases help performance?

Hello, I am fairly new to VBA development trying to upgrade my employee training database in VBA from a single listbox with single line select/add/edit capability to one that pulls employee data from listbox1, searches training available by job title in listbox2, and combines the data into listbox3 also adding …

I have a very complex java program written with net beans 7.1. It consists of 1 .java file that has a main(), and over 25 supporting .java files (most used for routines inside of tabs). In addition there are 15 different databases (embedded) associated with it. The program is virtually …

so we were trying to make a simple log in form and our professor simply told us to copy the codes he wrote:  i copied it but i got a red line under line 20 and 21 . I dont know what to do, no one is responding to …