Query Model Framework Design for Conservation History and Endowments Database: A Case Study on the Digitization of the Sumedang Larang Kingdom’s History and Endowments in Indonesia

Abstract

The use of structured query formulation languages is a method for gaining access to data in information management systems. Writing structured queries is a powerful method of data retrieval, and end users can generate complex database queries by becoming proficient in a particular query language. Digitization of database information systems, history and endowment, and technology conservation are some examples of database conservation techniques in the process of displaying data that require optimal query techniques. Historical and endowment properties comply with a certain set of laws governing waqf recipients, which sets them apart from heritage and cultural assets. Trusted property typically comprises real estate, valuables, or both and has an infinite preservation term so long as it may still be put to use. A solid information technology infrastructure is essential for ensuring comprehensive data security. Given the availability of knowledge and the quick development of information technology, ensuring its sustainability is a challenge. This research is aimed at preserving historical and waqf databases based on the case study of the Kingdom of Sumedang Larang (KSL), Indonesia, through examination of the database, synchronization of digital data with physical data, as well as looking at its relationship with organizations and management. The proposed method, namely the Design and Analysis of Database Query Model for Preservation Information System (DAQMP), creates a recurring query model from the original tabular data placed in the next table as a special table check for data specifications containing important data. The results must be accurately aligned between digital and physical records regularly to serve as a record of any changes and as evidence to determine whether data has been corrupted, altered, or lost.

1. Introduction

Throughout the history of the KSL [1], which was once located in Indonesia, the regional ruler (Raja) donated wealth in the form of waqf treasures, and by definition, waqf ownership is different from inheritance because waqf ownership is sanctioned through a message from the waqf donor to the waqf recipient, where the object of waqf ownership must exist for as long as it can be used. Waqf is the Islamic belief that freezes its subject, or property given, by becoming untransferable in the traditional interpretation of Islamic law. The concept of waqf includes religion and law. Such property consists of substantial territories in various Islamic territories. Therefore, the conservation of the waqf’s property requires reliable methods to ensure that its sustainability is well-awakened.

Globalization, mobility, and emerging digital-age technologies provide us with new avenues for inquiry into how we see ourselves and how we desire to preserve our past, stimulating and enhancing our capacity to do so [2]. Digitizing and preserving cultural heritage (CH) are intricate processes involving various techniques and algorithms to make CH replicas accessible to present and future generations [3]. The inspiration for preserving digital content comes from the manufacturing industry [4], where companies use archive platforms and customized life cycle management (PLM) frameworks to store vital data and knowledge about products at each stage of their lifecycle [5]. These data hold immense importance for the future, helping to avoid past mistakes and serving repetitive purposes.

Viewing cultural heritage as products and studying their lifecycle from a product standpoint reveals the need for long-term preservation of cultural heritage [6]. Over the last two centuries, society has experienced a cultural paradigm shift, always seeking new features that are easier to understand. This poses a challenge in preserving heritage and culture while being concerned about its safeguarding [7]. The advent of new technology has revolutionized the world, fostering instant communication almost anywhere in the world through the mobile phone or laptop [8]. This technological advancement has also permeated the field of cultural heritage, causing major changes in how stakeholder institutions and communities approach their heritage [9]. Communities now actively participate in restoration processes and even engage in social tagging. Therefore, it is necessary to examine how social media and cultural institutions have become highly interconnected [10]. Cultural organizations increasingly utilize social media in their activities, although it is often seen as a marketing tool. Analyzing social media interactions can provide valuable insights into the evolving nature of engagement across various goods [11].

Understanding how digital technology influences human involvement in appreciating heritage has implications for the way heritage management organizations engage with diverse communities within society [10]. Meanwhile, relational databases have served as data storage solutions for decades; the importance of scalable data models cannot be overstated in current web and mobile applications [12]. The term NoSQL encompasses all non-relational databases that provide schemaless and scalable models. These NoSQL databases, also known as Internet-age databases, are currently employed by tech giants such as Google, Amazon, and Facebook, which operate in the Web 2.0 era. Various types of NoSQL databases, including key–value pairs, column-based, column-oriented, and graph-based document databases, allow programmers to model data more closely to the formats used in applications [13]. The use of query modeling in databases can lead to incidental findings, which are unexpected disclosures that have a potential impact on sustainability prevention. In the forensic field, incidental findings can be considered information that is not related to the cause of lost data, the dynamic of the event, or the scope of the investigation. Query modeling regarding how forensic professionals should consider, address, and report incidental findings [14].

Research on digital information systems of heritage and culture is more concentrated on developing a solid approach to dealing with problems with data and user understanding [15]. This is because users in the digital age have a huge influence on the technical and aesthetic elements displayed by historical and cultural property management agencies [16]. In the author’s observation, the legacy and culture of the waqf are often conflicting, both in the form of a conflict of interests of the administrator and of the lost or damaged relics, because data management on YNWPS is still performed manually. On this basis, the authors are interested in researching models for mitigating potential conflict management and the mitigation of loss or change of data through query models. We anticipated that the DAQMP would be helpful in lowering conflict and property loss or damage. The components of assets, such as real estate, land, and historic buildings, can change over time; therefore, it is important to constantly monitor how well digital and physical data match [17].

2. Related Work

Through conceptual domain views expressed in ontologies, the ontology-based data access (OBDA) system enables users to access external databases. Conceptual modeling, query rewriting, and source-to-target mapping are all made easier by semantic technology [17]. In archaeological practice, data acquisition has always been of utmost importance [18]. In recent decades, the increased digitization of data acquisition has significantly impacted archaeological fieldwork, affecting both methodology and interpretation. Digital documentation methodologies have introduced new approaches to representing, analyzing, and understanding heritage sites [19]. With the rapid evolution of technology and substantial improvements in data, traditional database management tools are becoming less effective.

New technologies, such as NoSQL databases, have emerged, radically altering the architecture familiar to many database administrators and leading to improved performance and service availability. However, due to the novelty of this technology, standard or informal migration processes do not yet exist [20]. The conventional digital protection method for traditional cultural heritage suffers from low information recall rates and long processing times [21]. Therefore, a new digital protection method for cultural heritage based on web technologies is proposed. This approach adopts an improved four-layer architectural design pattern to create a web-based digital protection platform for cultural heritage. Application service providers (ASPs) combine an SQL server and architecture to develop database platforms and functional modules for dynamic management directly from the website model. Based on this, cultural heritage digital images are reconstructed using web technologies, and the uncertainty probability of web visualization is calculated. The process involves meta-language modeling and network cultural heritage classification [22,23].

In the current multi-model database world, there are efforts to integrate databases that operate on different data models. This integration involves combining relational and graph databases with functional data models and formal languages, specifically lambda calculus. This approach considers data schemas for both relational and graph databases. Relationships are treated as characteristic functions, and property graphs are viewed as sets of single-valued and multivalued functions. A user-friendly version of this language can serve as a powerful query tool in practice, allowing queries to be sent to integrated systems and then translated into queries in SQL and Cypher [24]. An automated method has been developed for modeling relational databases using SQL triggers and foreign keys [25]. This method efficiently answers positive semantic questions about instances based on Web semantic ontologies.

In contrast to existing knowledge-based approaches, this implementation minimizes the need for additional space in the database to reduce reasoning at query time [26]. Based on this scenario, the system can significantly improve query response time by bypassing integrity constraints and other types of inference during run-time. The use of NoSQL databases has evolved to manage unstructured data for applications, ensuring high performance and scalability. However, many organizations prefer to transfer data from NoSQL operational databases to SQL databases with a relational structure. This allows them to utilize existing tools for business intelligence, analytics, decision-making, and reporting. Despite this condition, the process of transforming NoSQL to relational databases requires manual schema mapping, which requires domain expertise and real-time consumption. This implies that there is a need for an efficient and automated method to convert unstructured NoSQL databases into structured databases. An efficient method has been developed for automatically converting NoSQL databases into relational databases. In experimental settings, MongoDB served as the NoSQL database, while MySQL and PostgreSQL were used as relational databases for performing transformation tasks with different dataset sizes. The method demonstrated excellent performance, outperforming existing cutting-edge methods for converting data from a NoSQL database to a relational database [27,28,29].

Hierarchies are used to organize data into groupings in databases. When integrating data into integrated data systems in software engineering, it is necessary to employ an appropriate method to prevent data duplication. To achieve this, a method partition is created to make it easier to understand the object attributes of the data. Subsequently, data are integrated using the grid method, and a combination of these techniques leads to the hierarchy of grid partition (HGP) method. The HGP method is designed to integrate data from engineering software and databases, simplifying data retrieval for users and eliminating duplicate data. To develop this method, object-oriented modeling tools such as unified modeling language (UML) are utilized. The approach streamlines data access by organizing all data into a data partition grid system, making the data access system more effective and efficient [30].

In various productive, commercial, and academic fields, a multidimensional approach can be employed to maintain the potential on which the data analysis process is based. Additive functions play a crucial role in query response time with simulations, enabling the efficient storage and management of previously obtained results. In the static components of the model, multidimensional variables are characterized by attributes arranged into structures called dimensions. These attributes follow a classical relational approach, where they can take values from homogeneous sets. Dimensions consist of pairs (N, J), where N represents the name of the dimension and J is the attribute hierarchy. The hierarchy consists of tuples (N, E, <, T, V), with N being the name of the dimension, E as the set containing the attribute, and < as a partial sequence relationship defined in E. Therefore, ∀x, y ∈ E, x < y means that x is grouped into T according to the value of the hierarchical level (x < T, ∀x E), and V is the lower value, denoted as V < x, ∀x E. Another important attribute, known as size, represents the variable being analyzed. The steps are entirely dependent on and functionally linked to the attributes [31]. The development of physical data investigation models adapted to digital data relies on existing theories for physical crime investigations, among other factors [32].

The model should be practical and follow the same steps as the actual investigation; it should also be general and not limited to specific technologies or product flows and procedures. The model should be specific enough to allow the development of general technological requirements for each phase. The model should be abstract and applicable to law enforcement investigations, investigative firms, and incident response [33].

3. Materials and Methods

The Prince Sumedang Nadzir Waqf Foundation (YNWPS) presently has the jurisdiction to administer historical heritage and waqf in line with the Decree of the Minister of Law and Human Rights of the Republic of Indonesia Number: AHU-0014381, AH.01.04. Year 2017. Data gathered from YNWPS interviews and a complete hardcopy of the original data document obtained for non-public circulation show that some information on historical goods housed in the museum is made available to the public through the Prince Geusan Ulun Museum website [1,34,35], while for other waqf properties, it is made available through disputed data [36].

The method entails query modeling data to define the connection between management and data entities, which is anticipated to have an impact on data sustainability. Dataset collection was carried out as an integral part of the study aimed at developing a monitoring system that was expected to affect data sustainability [37]. DAQMP builds a recurring query model from the data of the initial tables carried alongside the specific data specifications tables containing significant data, such as heritage items containing material like gold, silver, nickel, and wood, or land and buildings with in-depth details of the current area as well as its boundaries [38]. Data specification tables in DAQMP will be compared using join queries to determine whether the data are identical after check tables made in accordance with earlier data specifications, but utilizing new data input are generated. If there are discrepancies, analysis and study should be performed, followed by documentation and data storage in a new table as findings. Experts should be involved in the case of closure if there are instances of data corruption, alteration, or missingness rather than the data’s actual source. According to the requirements of the Waqf Act of 2004, inspections must be repeated on a regular basis [39].

The query model design was crucial in order to ensure periodic matching between digital and physical data [40]. The dataset comprised a management database containing heirlooms stored in museums and land and rice fields spread across several areas [41]. During investigations, physical data were regularly checked and inputted back into the system using different tables, based on their relevance, by various operators. Stringent criteria were applied during screening to ensure the dataset included accurate representations of diverse heritage goods and soil and rice fields, reflecting real-world scenarios. Initial screening assessed the quality and reliability of the dataset, with obscure goods significantly excluded [42]. To maintain dataset integrity, goods had to be clearly and accurately identified, avoiding ambiguity and enabling their use for subsequent analysis and modeling tasks [43]. Expert identification ensured the quality and reliability of the datasets, particularly for valuable resources such as gold heirlooms or land in city centers, which were goods of great interest [44].

3.1. Semantic Network History of Waqf Descent

Qualitative methods typically have a theoretical basis for guiding research, with an emphasis on ensuring data analysis takes inventory of available resources. The results of the analysis of historical data and the waqf language are described in the semantic network obtained for the study, which is shown in Figure 1 below.

3.2. Data Set Representation

In the last two decades, considerable increases in computing power and available data have led to an analytics and machine learning (ML) revolution [45]. This method discovers new data, represents it with descriptive metadata, automatically categorizes the metadata, auto-populates a data catalog with data sets, and evaluates the new data sets for data fusion options [46]. The dataset consisted of various elements, including data related to history and lineage, Waqf Manager, Nadzir Waqf, Person in Charge of Land/Rice Fields, Person in Charge of Tomb/Site, Cultivator, Land Tenant, Tomb Occupant, Site/Tomb, Land/Rice Field, Museum, and Historical Building. Figure 2 displays the representation of this dataset and its semantic relationships [47].

In the graph, the data commodities that YNWPS controlled were shown as gray circles. These goods included land, rice fields, historical buildings, sites, tombs, manuscripts, and data about people involved in managing and using waqf assets. Existing data cataloging products have recently begun integrating ML to recommend actions based on prior user interaction and column matching learned from previous labels. To facilitate data analysis, a model representation was developed [48]. Based on the representation of datasets from Figure 2, 13 entities are taken to study their relationships, as shown in

Table 1. Variables and Data Sources.

No.	Variable and Data	Data Source	Description
1	Genealogy of the Sumedang Larang Royal Palace	YNWPS	Historical Manuscripts and Genealogies of Waqf
2	Nadzir Waqf	YNWPS	Biodata of the Nadzir Waqf
3	Manager YNWPS	YNWPS	Biodata of the Manager YNWPS
4	The Foreman	YNWPS	Biodata of the Foreman
5	Person in Charge of Historic Buildings	YNWPS	Biodata of the Person in Charge of Historic Buildings
6	Land/Ricefield	YNWPS	Data of the Land/Ricefield
7	Heritage/Museum	YNWPS	Data of the Heritage/Museum
8	Historic Buildings	YNWPS	Data of the Historic Building
9	Grave/Site	YNWPS	Data of the Grave/Site
10	Cultivators	YNWPS	Data of the Cultivators
11	Tenants of Waqf Land	YNWPS	Data Tenants of Waqf Land
12	Responsible Museum	YNWPS	Biodata of the Person in Charge of the Museum
13	Responsible Person	YNWPS	Biodata of the Person in Charge of the Grave/Situs

.

The scope of the data managed is as follows:

• 30 people as managers.
• 346 cultivators of 94,343 hectares of rice fields spread across 8 locations.
• 540 land tenant population on 34.05 hectares spread across 13 locations.
• 230 heritage goods in the form of jewelry, weapons, tools, and buildings.

Examples of inheritance quantities of goods are relatively small, but very valuable material and age are shown in Figure 3, Figure 4 and Figure 5.

Figure 5 shows an illustration of the immovable goods data object according to the address from the data catalog, displaying rice fields in position on Mount Puyuh Nagorak (Sawah Lega), with modified data coordinates [36].

3.3. Designing a Web-Based Framework for the Digitalization of History and the Waqf of the KSL

The broad insight of the stakeholders including the Waqf Nadzir and YNWPS as the managers was needed to improve the sustainability of digital and physical data preservation [7]. This insight led to the design of the following web-based information system framework based on the information retrieved from the stakeholders [50]. In its application, the ontology concept of data and information systems integration offers a suggestion for an almost flawless ontological integration [51]. Conceptual data models suited to each application, shared metadata for interoperability between applications like relational databases and object-based software, and ontology-based interaction with various implementations [52].

Modularization is necessary for ontological division to help simplify ontology more broadly [53]. This modularization is crucial when one needs to hide or remove knowledge that is not necessary for existing applications or divide the modules so that they can be worked separately. Users can hide or delete entities and axioms that are irrelevant to the application. A number of benefits of ontological modularization include the reuse of ontology, collaboration, and scalability for data processing [54].

Technology integration is very important in the twenty-first-century learning society [55]. The framework module’s integration design is shown in four components in Figure 6: the management module, the movable goods module (museum artifacts), the immovable goods module (land and buildings), and the genealogy module to view the lineage of the monarchs who passed down endowments [47].

The implementation of the framework shown in Figure 6 is described in more detail in the web navigation framework design shown in Figure 7.

The framework was built with policies for users, administrators, and managers. The extent of the preservation process was directly aligned with the specific goals set by the organization responsible for overseeing historical artifacts and legacies [56]. These entities played a pivotal role in catering to public requirements by safeguarding cultural memories and heritage, thereby paving the way for posterity. By furnishing such content to the public, they addressed the inherent necessity for reestablishing connections and deriving significance from the bygone eras, consequently illuminating the relevance of history in the contemporary world. The wider use of models may require broader discussion among heritage professionals and the provision of training [57].

3.4. Data Organization and Governance

The Waqf Nadzir was observed to be the stakeholder in relation to the data needed due to the responsibility of making more data-driven decisions across the organization [58] through the waqf managers, as described in the framework in Figure 8.

Figure 8’s intra-organizational and inter-organizational relationships illustrate how both internal and external organizations participate in management and oversight. The prior approach is intended to make management and supervision easier, both practically and conceptually [59]. Similar to how fundamental scale data are described, scale data are detailed to form data structures. Before the application launches, standard operating procedures must be created to reduce risk, especially in regard to data updates, which makes it possible to carefully plan out data mitigation for risk management.

3.5. Potential Conflict

Throughout the history of waqf’s journey, there have been three conflicts, of which the third has not been fully resolved (see Figure 1). Thus, within operational management, there are potential conflicts described in the relationships between the entities. Table 1 had some potential conflicts and lost data, as shown in the following matrix:

Table 2. Matrix of potential conflicts and lost data.

Entity	Nz	Py	Fm	Cl	MG	NM	WL	PM	St	Ct	CR
Nz	0	1	0	0	0	0	0	0	0	0	0
Py	1	0	0	1	0	1	1	0	0	0	0
Fm	0	0	0	0	0	0	1	0	0	0	0
Cl	0	1	0	0	0	0	1	0	0	1	0
MG	0	0	0	0	0	0	0	1	0	0	0
NM	0	1	0	0	0	0	0	0	0	0	0
WL	0	1	0	0	0	0	0	0	0	0	0
PM	0	0	0	0	1	0	0	0	0	0	0
St	0	0	0	0	0	0	1	0	0	0	0
Ct	0	0	0	1	0	0	1	0	0	0	0
CR	0	0	0	0	0	0	0	0	0	0	0

Note: Nz: Nadzir Waqf, Py: YNWPS Manager, Fm: Foreman, Cl: Cultivators, MG: Movable Goods, NM: Non-Moving Goods, WL: Waqf Land Tenants, PM: Person in Charge of the Museum, St: Site/Cemetery, Ct: Caretaker, CR: Cemetery Residents.

shows that potential conflicts could lead to the loss, change, and corruption of data. The colors used in the table are explained as follows.

The explanation of the color used in Table two is given in

Table 3. Color meaning in Table 2.

0	Unexpected conflict	1	Light conflict
0	No conflict	0	Small conflicts can occur
0	Expected conflict	1	Heavy conflict

.

The 13 data entities in Table 1 could enter into conflict, among various things, if:

5.

The YNWPS management started cultivating and living on the waqf land.

6.

Nadzir Waqf takes over as the YNWPS manager.

7.

The foreman changes to the position of cultivator.

8.

Cultivator is derived from caretaker.

Likewise for:

• Movable property if: damaged, altered, replaced, or lost.
• Immovable property if: land area changes; tenants or cultivators change; and land use is not in accordance with the agreement.

There will probably be another lawsuit from the heirs’ environment if disagreements and data updates are not handled effectively. According to the information in Figure 1, there have been three lawsuits since the management generation changed.

4. Results

The development of society and the economy, along with more prevalent sources of degradation, have been perceived to pose an increasing threat to cultural and natural heritage [60]. The safeguarding of this legacy at the national level was judged inadequate due to a lack of sufficient scientific and technological means to deliver efficient conservation education to the local population [61]. While that goes on, international accords, standards, and resolutions on cultural and natural property have shown how important it is for everyone on earth to safeguard their distinctive and irreplaceable properties [62]. Therefore, it is crucial for relevant managers to exercise greater prudence and conduct frequent data audits in order to resolve and mitigate conflicts [63].

4.1. Mitigation Workflow Query Platform DAQMP

Data tracing steps were required platforms in digital data protection, and physical data were divided into two platform parts, namely management platforms and application platforms.

1. Platform Management by Administrator. Establish manager authorities to enable different administrators to conduct various levels of database platform management operations.

2. An application platform was used to examine historical and waqf database collections related to digital data tracing and physical data, for moving object data and non-moving object data.

The DAQMP for the information system of preservation history and endowments is to create a recurring query model from the original tabular data to the next specified data specification table containing important data [64]. The specifications of this table will be checked through a check table that was created according to the previous data specification, but using the new data input of the verification results, then performing a join query to see the data similarity [65]. If there are differences, then analysis and investigation must be carried out and documented, and the data must be stored in a new table as findings. The conclusion of the case must involve the expert rather than the data object since the original authority of the data remains with the experts in the data field [66]. Steps to perform DAQMP semi-automatically are shown in Figure 9.

4.2. Model Query Mitigation for the Conflict Manager

Since the derivation of the waqf in 1912 (Figure 1), there have been three conflicts. Every generation of managers faces conflicts, which can only be settled through formal legal actions in a court of law. The Query Mitigation for the Conflict Manager model is expected to map potential conflicts to prevent future conflicts [67]. The query model should be designed based on the potential conflict table. The potential conflict with the waqf administrator is shown in Figure 10. And for mitigation, it can be performed by joining queries so that the data can be shown, and then the manager’s lead note can take a decision [68,69].

In the verification of potential conflict data, the first step is to create the initials of tables, namely as in

Table 4. The initials of the table manager entity.

Entity	Initial
Nadzir Waqf	=Nz
YNWPS Manager	=Py
Cultivator	=Cl
Caretaker	=Ct
Waqf Land Tenants	=Wl
Foreman	=Fm

.

Potential conflicts of interest in the management of waqf can occur if Nadzir Waqf becomes a YNWPS manager, YNWPS managers become cultivators, foreman become cultivators, and caretakers become cultivators. For simple data verification, it is enough to use the join query model based on the Id_Card attribute. Examples if Nadzir Waqf becomes the YNWPS manager of the query model are shown in

Table 5. Query model to coordinate potential mediators of disputes.

/* Create a simulated table to check the synchronization of the nadzir data with the manager data */

create table Nz(Nz_Code varchar (6), Name varchar (25), Outer_Job varchar (25), Position_nadzir varchar (25), Address varchar (40), Id_Card numeric (16), sk varchar(30), Information varchar(50), primary key (Nz_Code));

create table Py(Py_Code varchar (6), Name varchar (25), Id_Card numeric (16), Ttl date (default), Position varchar (40), Address  varchar (30), primary key (Py_Code), foreign key (Nz_Code), reference Nz);

/* Command to run a join query */

SELECT      Nz.name FROM       Nz INNER JOIN    py ON        Nz.Id_Card = Py.Id_Card;

/* Algorithm to Check Nadzir Waqf Data Synchronization: Simple Nested Loop Join */

for each record Nz.name ɛ Nz do   for each record py ɛ Py do     if (nzi == pyj)= true then print “finding”     add (nzi, pyj) to result     else then print “clear”

.

For Py, Cl, Ct, Pt, and Fm entities, they can be created in the same way as the query model above. Nadzir Waqf supervises waqf property and also manages the organization’s governance structure. If the query results show the findings, then the head of Nadzir must take action in accordance with the basic budget of YNWPS because Nadzir Waqf is forbidden from being the manager of YNWPS.

4.3. Moving Goods: DAQMP Mitigation

Moving goods that existed at the time of printing are still recorded in hand-managed digital data, and the presence of data changes has been unrecorded for decades [70]. Every year, managers and local residents gather under the Thanksgiving flag to remember the history of the warehouse and clean it as a means to honor the past of KSL. The ‘washing heirlooms’ tradition’s purpose in the museum Prabu Geusan Ulun is a ceremony with a performance-like framework and purpose. Several phases are involved in the preparation, presentation, and closing phases of this procession, which are all three separate phases [71]. The ‘Washing heirlooms’ tradition serves many purposes, including those related to the ceremony, the ‘Washing heirlooms’ ritual itself, entertainment, communication, social interaction, and religion. But it is likely to cause damage to the object [72]. So far, there is no proper record of re-documenting the inheritance data. In this case, investigation of the synchronization of digital data with physical data is essential as part of maintenance for preservation [73].

The focus of this research on moving data is on data that have high economic and historical value, such as items containing gold, silver, nickel, and others [74]. The query model should be designed based on the potential conflict table, and the step is designed according to Figure 9. For the prevention of moving data changes, an overview of data entities is shown in Figure 11.

In verifying the potential data to be corrupted, altered, replaced, or lost, the first step is to create a table with initials, where moving goods data are divided into two categories, namely, non-jewelry and jewelry categories [75].

Table 6. The initials of moving goods table.

Movig Good Item	Initial
Moving Goods	=SMG,
Specification Moving Goods Non-Jewelry	=Spec_MGNJ
Check for Moving Goods Non-Jewelry	=C_MGNJ
Check Result Moving Goods Non-Jewelry	=C_R_MGNJ
Specification Moving Goods Jewelry	=Spec_MGJ
Check for Moving Goods Jewelry	=C_MGJ
Check Result Moving Goods Jewelry	=C_R_MGJ
Recommendation Moving Goods	=Rec_MG,

shows the initial moving goods list.

The query model that synchronizes digital data with physical data is shown in

Table 7. The query model synchronizes digital data with physical data for non-jewelry legacy.

/* Create a simulated table to check the synchronization of digital data with physical data for non-Jewelry legacy */

create table Spec_MGNJ(KD_Goods varchar (6), Category varchar (25), item_name varchar (25), Shape varchar (25), Material varchar (25), Gold_rust numeric (3), Skeleton varchar (16), Holding varchar(30), Long numeric(3), Heavy varchar(20), Motive varchar (25), primary key (KD_Goods));

create table C_MGNJ(KD_Goods varchar (6), Category varchar (25), item_name varchar (25), Shape varchar (25), Material varchar (25), Gold_rust numeric (3), Skeleton varchar (16), Holding varchar(30), Long numeric(3), Heavy varchar(20), Motive varchar (25), Verification_date date(default), inspection_  officer varchar (25), primary key (KD_Goods), reference Spec_MGNJ);

/* Command to run a join query */

SELECT     * FROM     Spec_MGNJ LEFT JOIN   C_MGNJ ON      Spec_MGNJ.Spec != C_MGNJ. Check;

/* Nested loop joining algorithm using C_MGNJ, a simple test for Spec_MGNJ synchronization */

for each record items_name ɛ Spec_MGNJ do for each record items_name ɛ C_MGNJ do     if (Spec_MGNJ.Speci != C_MGNJ. Checkj) = true then print “finding”     add (items_namei, items_namej) to result     else then print “clear”

.

Table 8. Query models synchronize digital data with physical data for moving goods (jewelry).

/* Create a simulation table to check the synchronization of digital data with physical data for moving jewelry items */

create table Spec_MGJ (KD_Goods varchar(6), Category varchar(25), item_name varchar (25), Material varchar(25), Gold_rust numeric(3), Accessories varchar(16), Number_of_earrings numeric(4), Heavy_earrings numeric(4), Number_of_flowers numeric(4), Weight_of_flowers numeric(4),    Total_weight varchar (25), primary key (KD_Goods));

create table C_MGJ(KD_Goods varchar(6), Category varchar(25), item_name varchar(25), Material varchar(25), Gold_rust numeric(3), Accessories varchar(16), Number_of_earrings numeric(4), Heavy_earrings numeric(3), Number_of_flowers numeric(4), Weight_of_flowers numeric(4), Total_weight varchar(25), Verification_date date(default), Inspection_officcer varchar(25), primary key (KD_Goods), reference C_MGJ );

/* Command to run a join query */

SELECT     * FROM     Spec_MGJ LEFT JOIN   C_MGJ ON      Spec_MGJ. Spec != C_MGJ. Check;

/* Nested loop joining algorithm using C_MGJ, a simple test for Spec_MGJ synchronization */

for each record items_name ɛ Spec_MGJ do for each record items_name ɛ C_MGJ do if (Spec_MGJ. Speci != C_MGJ. Checkj)= true then print “finding” add (items_namei, items_namej) to result else then print “clear”

shows the synchronized digital and physical data.

4.4. Non-Moving Goods: DAQMP Mitigation

According to the latest data from the management of YNWPS, there has been a change in land area in the form of rice fields since the waqf was passed to heirs in 1949. In 1949, the land area in the form of rice fields was 100,178 hectares, while in 2010, the land area in the form of rice fields was 87,125 hectares (data were taken from the adjudication team of the National Land Agency of the Sumedang Regency Government, and the data were not available to the public). It is uncertain if the data has been sold or has changed in status up to this point. In order to ensure accurate recording of data modifications or loss, DAQMP is required. The changes in immovable property, either in the form of rice fields or land, focused on the broad changes and functions of land from the past and present, as it became part of the organization’s revenue as the management capital for the sustainability of Waqf estate [76]. The step mitigation is designed according to Figure 9, and the potential change in the non-moving object-entity relationship is shown in Figure 12.

In verifying potential data that change widely, changes functions, or changes usernames, the first step is to create tables with initials.

Table 9. The initials of the table for non-moving goods.

Non-Moving Good Item	Initial
Non-Moving Goods	=NMG
Check Non-Moving Goods	=Check_NMG
Check Result Non-Moving Goods	=C_R_NMG
Recommendation	=Rec_NMG

shows the initials for non-moving goods.

The query model that synchronizes non-moving goods data potential changed is shown in

Table 10. Query models synchronize non-moving goods data potential changed.

/* Create a simulated table to check the synchronization of Non-Moving Goods Data Potential Changed */

create table NMG (Location_code varchar(6), Category varchar(25), SPS_No varchar (25),  Location varchar(30), Northern_boundary varchar(30), Southern_boundary  varchar(30), Easthern_boundary varchar(30), Westhern_boundary varchar(30),  Broad numeric(6),  Name_of_tenant varchar(30), ID_Card  numeric(16), Land_Functions  varchar(25), primary key (Location_Code));

create table Check_NMG (Location_Code varchar(6), Category varchar(25), SPS_No varchar (25), Location  varchar(30), Northern_boundary varchar(30), Southern_boundary  varchar(30), Easthern_boundary varchar(30), Westhern_boundary varchar(30),  Broad numeric(6),  Name_of_tenant varchar(30), ID_Card  numeric(16), Land_Functions  varchar (25), Verification_Date date(default), Inspection_officer varchar(30), primary key (Location_Code),  reference Check_NMG);

/* Command to run a join query */

SELECT     * FROM     NMG LEFT JOIN   Check_NMG ON      NMG. Broad != Check_NMG. Broad;

/* Nested loop joining algorithm using NMG, a simple test for Check_NMG synchronization */

for each record broad ɛ NMG do for each record broad ɛ Check_NMG do    if (NMG.broadi != Check_NMG.broadj)= true then print “finding”    add (locationi, locationj) to result     else then print “clear”

.

Although a simple DAQMP needs to be performed, as with physical data for decades, there is no record of a change in the data. Digital data are created manually, the specifications are still fixed, while physical data most likely have changed [77].

5. Discussion

The query algorithm presented in this work is simple, but contributes significantly to predicting data differences [78]. At that time, examiners seemed more concerned with digital data security than physical data. However, as information and communication technology advanced, digital forensic methods continued to evolve. Historical and waqf preservation, particularly concerning waqf property such as heirlooms, land, and historical buildings, were practices predominantly observed in countries with a Muslim majority.

The entrusted property usually contained components that remained unchanged over time, even though human mentality and behavior might change. Data retention played a crucial role in ensuring the security of both digital and physical data. It became meaningless to have secure digital data if it did not match the corresponding physical data or if the goods were lost from circulation [79]. A viable strategy to maintain the security of both types of data was by installing cameras to monitor physical data presented online. This approach could eliminate the need for constant data control and updates [80]. However, in cases of unforeseen events, further investigation was required. Implementing this strategy might involve a substantial cost, which needed to be considered carefully and not executed conventionally. The implementation can be carried out especially for some high-value data such as ‘Crown Binokasih Siger’ (Figure 3), which is based on gold and is 445 years old.

6. Conclusions

Based on the findings and conversation, it seems that creating query models is only talked about for data investment, with the goal of better preserving physical data by comparing one or more characteristics found in digital data with physical data. Maintaining data preservation requires regular DAQMP implementation, which is highly essential. If the query results in a DAQMP exhibit discrepancies, it suggests that the algorithm model can aid in data preservation.

This further development is based on the data set attribute specification that can make separate applications into investigative libraries synchronizing digital data with physical data. Data are more important than ever in the Internet era; thus, it is essential to keep them safe and secure. The use of digital data has changed significantly as a result of digitalization, and its utilization rate has sharply risen. Using information resources to enhance digital data service capability and advance digital data management has become a critical challenge for data resource management due to the development of technology and the accumulation of digital data in the big data era. In that case, choosing an alternative to DAQMP would be wise.

The data that exist in the history and waqf of KSL is relatively small and is not big data; however, the sustainability of data preservation is more important than the amount of data itself, as stated in the mandate of the data waqf letter. The generation of managers continues to change every period and is related to the origin of the data. Historically, data preservation disruption occurred from the aspects of data management and origin.

This study is a component of a series of web-based information system development projects for the digitalization of historical database preservation and KSL waqf. It consists of a literature review, a web-based design framework, an ontology-based query model design, application program development for control, and a data conservation management database. Finally, the DAQMP approach can help conserve history and endowments through conflict prevention by offering quick, accurate, and precise information, according to the final judgment.