CN1527229A - Hotal management system for group accommodation - Google Patents
Hotal management system for group accommodation Download PDFInfo
- Publication number
- CN1527229A CN1527229A CNA031051871A CN03105187A CN1527229A CN 1527229 A CN1527229 A CN 1527229A CN A031051871 A CNA031051871 A CN A031051871A CN 03105187 A CN03105187 A CN 03105187A CN 1527229 A CN1527229 A CN 1527229A
- Authority
- CN
- China
- Prior art keywords
- group
- list
- objective
- serial number
- master
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The hotel management system for group accommodation includes group main list data base, group booking list data base and group member list data base, and every record in the data bases has unique journal number. The system also includes guest list relation tree module capable of displaying the subjection relation between the group main list and the underlings, and the guest list relation tree module includes guest list data storing table of several records with one data structure containing guest list journal number, group main list journal number and the group order list journal number. The guest list data storing table is connected via the guest list journal number with other data base, the content of group main list journal number in the record is the guest list journal number of the upper group main list, and the content of the group order list journal number is the guest list journal number of the upper group order list.
Description
Technical field
The present invention relates to a kind of computer application field, particularly relevant for a kind of Hospitality management system that manages that group is moved in.
Background technology
Now, a lot of hotels utilize computing machine to cooperate corresponding software to carry out the each side in hotel is managed.At the singularity of hotel industry, developed a lot of software, alleviate the labour intensity of restaurant workers to a great extent, increase work efficiency, improve service environment.
The most important thing is management in the hotel management, particularly to the management of corporate customer to the client.Can to group move in the software that manages the most famous be the KingSmart Hospitality management system, develop at the singularity that group moves in, such as before group moved in, group can be to the room of hotel reservation quantity, in view of the above, the hotel need open according to booking list; Member in the group also may be different at the state in hotel, such as the part member just moves in, and some member has checked out, and the room rate of being lived between the member is not quite similar or the like; This system includes the master of group single database, group reservation single database and member of community's single database.The master of this group single database has some groups to move in record, wherein each bar records field informations such as this group number, group's name, some group reservation unirecords are arranged in this group reservation single database, wherein each bar records group reservation odd numbers, its higher level's field information such as group number, member of community's single database has some member records, and its member's odd numbers and higher level's group number, the field information of group reservation odd numbers are all arranged in each bar record.But can not express the master Dan Yuqi subordinate's of group single, the single subordinate relation of member of community of group reservation in the visual picture mode, if want to see that the singly all down group reservations of certain master of group are single and the member of community is single, can only open query function, after the input inquiry condition, the group reservation of seeing subordinate from obtain the Query Result form is single, directly perceived inadequately, cause staff of hotel and the personnel's of incorporation work very inconvenient, and be easy to make mistakes.
Summary of the invention
The purpose of this invention is to provide and a kind ofly move in, can intuitively express the Hospitality management system of the master Dan Yuqi subordinate's of group the subordinate relation that group reservation is single, the member of community is single at group.
At above goal of the invention, the invention provides a kind of Hospitality management system of moving at group, it is single to be used to manage the visitor of group who moves in, and this system comprises: the master of group single database; The group reservation single database; Member of community's single database; In the above-described database each records unique objective single serial number, this system also comprises objective single relational tree module of the subordinate relation that can intuitively show the master of group unirecord and its subordinate, the single relational tree module of this visitor comprises objective forms data storage list, this visitor's forms data storage list has some records, each bar record all has a data structure, includes objective single serial number, the single serial number of the master of group, the single serial number of group reservation in this structure; This visitor's forms data storage list links to each other with other database by objective single serial number, and the content of the single serial number of the master of group that should write down is objective single serial number of higher level's the master of group list; The content of the single serial number of its group reservation is objective single serial number of higher level's group reservation list.
In addition, this visitor's forms data storage list comprises objective single type, the single type of this visitor is a numeric type, the single relational tree module of described visitor also comprises the objective single definition list corresponding with objective single type, has the single type code name of the master of group, the single type code name of group reservation, the single type code name of member of community in the single definition list of this visitor at least.
By above technical scheme, can obtain following invention effect.
(1) utilizes the single relational tree module of this visitor, when opening a certain Zhang Tuanti master's unirecord, can show the hierarchical relationship of member of community's list of the master of this group unirecord subordinate's group reservation list and the single subordinate of group reservation with intuitive manner; Or when opening a certain group reservation unirecord, can show the hierarchical relationship of this member of community's list of its subordinate with intuitive manner.
(2) by objective single serial number, objective single relational tree module is connected with the master of group single database, group reservation single database, member of community's single database.Call above data of database information, can also show the information of each group reservation list and member of community's list, such as showing room rate behind reservation, the shotgun house of each group reservation list of statistics, the objective odd number amount of moving in, checking out, each member of community's odd numbers.
(3) any one node that utilizes the dynamic link technology can activate the single relational tree module of this visitor is operated.Such as double-clicking objective single node, can open corresponding visitor and singly operate.
(4) by selection, can carry out batch operation to the single relational tree node of visitor.The part member of community of company booking below single is single such as selecting, and can singly check out to the member of community who chooses or sequence of operations such as recoverys of checking out, and has simplified the program of operating greatly.
Description of drawings
Fig. 1 is the composition diagram that the present invention is directed to the Hospitality management system that group moves in.
Fig. 2 is the subordinate relation figure of a specific embodiment of the present invention.
Fig. 3 is objective single relational tree module of a specific embodiment of the present invention.
Embodiment
Fig. 1 is the composition diagram that the present invention is directed to the Hospitality management system that group moves in.See also Fig. 1, the Hospitality management system 100 of moving at group includes the master of group single database 110, group reservation single database 120, member of community's single database 130 and objective single relational tree module 140.In the master of group single database 110, group reservation single database 120 and the member of community's single database 130 some records are arranged, each bar record all has the unirecord numeral of this visitor of unique identification, promptly objective single serial number.In general, objective single serial number is that system is the single generation automatically of each visitor.Carry out connection between the database by it.
Each bar is recorded as the master of a group list in the master of the group single database 110.When a group moved in the hotel, the hotel was the main information control information list that group sets up.Except the single serial number of visitor, also have group number, group's file-name field at least, write down different group's master's unirecords group inequality number and group.
Each bar record in the group reservation single database 12 is that a group reservation is single.Be meant generally that when a group need move in the hotel to the room of hotel reservation some, the hotel opens the booking list of certificate for it.Opening according to opening certificate according to the time of this group reservation list also can be opened certificate according to the group's number in the group, and the quantity of a group reservation list is confirmed according to the situation of concrete group.The booking form record that identical group is different has different separately group reservation odd numbers, so comprise the group reservation odd numbers at least in each bar record.
Each bar in member of community's single database 130 is recorded as member of community's unirecord, is that the hotel is the individual's that certain member sets up in the team an information list.At least comprise objective single serial number, member of community's odd numbers in each member of community's unirecord, support information such as shop day, fate, state, rent.
The single relational tree module 140 of visitor comprises objective forms data storage list 142, be used for the hierarchical relationship that intuitive manner shows member of community's list of the master of group unirecord subordinate's group reservation list and the single subordinate of group reservation, this visitor's forms data storage list 142 has some records, and each bar is recorded as a node of objective single relational tree module 140.Each bar record all has a data structure, includes objective single serial number, the single serial number of the master of group, the single serial number of group reservation, objective single type and group's name in this data structure.Rely on objective single serial number to be connected with other database.
Objective single type of the single type visitor of visitor forms data storage list 142 has three kinds at least: the master of group is single, group reservation is single, the member of community is single.The single type of this visitor can be a character type, also numeric type.Adopt numeric type in an embodiment of the present invention, and define the single type definition of a visitor table 144.The single type definition table definition of this visitor group single, group reservation is single, the single type code name of member of community, it is corresponding with the objective single type in the objective forms data storage list 142.
Objective single type of the record in objective forms data storage list is that the master of group is single, and then the content of the master of group of this record list serial number is 0, the content of group reservation odd numbers is 0.Objective single type of the record in objective forms data storage list is the group reservation unirecord, and then the single serial number of the master of group that should write down is objective single serial number of its record higher level's the master of group list, and the group reservation odd numbers is 0.Objective single type of the record in objective forms data storage list is member of community's unirecord, and then the content of the single serial number of the master of group of this record, the single serial number of group reservation is respectively its record higher level's the master of group list and objective single serial number of group reservation list.Certainly also being not limited only to is 0, can be any data that are different from objective single serial number.For instance, objective single serial number is the natural number greater than 0, then its can unify for smaller or equal to 0 any one the number.
Whenever adding a record in system, still is member of community's unirecord regardless of the increase master of group unirecord, group reservation unirecord, and system all can increase by a corresponding record number in objective forms data storage list 144.So the line number of this table data store 144 is more than or equal to the record number of the master of group single database, group reservation single database and member of community's database.
In order to illustrate, below especially exemplified by an embodiment.
Table one
| The single serial number of visitor | The group number | Group's name | The people books rooms |
| 4 | Kingsoft | Kingsoft | Zhao one |
Table one is part field and record of the master of group single database.Writing down objective single serial number and be 4, group Kingsoft by name, group number are a master of the group unirecord of kingsoft.
Table two
| The single serial number of visitor | The group reservation odd numbers | Ticket reserving time | The reservation standard | Number between reservation |
| ?5 | ?STD0 | ?2002-12-18 | 100 yuan/day | 10 |
| ?9 | ?STD1 | ?2002-12-25 | 133 yuan/day | 15 |
Table two has write down two unirecord partial informations of group reservation for the partial record in the group reservation single database, and the group of its master of higher level group list number is kingsoft.
Table three
| The single serial number of visitor | Member's odd numbers | Support shop day | Fate | Departure day | State | Rent |
| ?6 | ?11001 | ?2002-12-19 | ?1 | Move in | 100 | |
| ?7 | ?11003 | ?20002-12-19 | ?1 | Move in | 100 | |
| ?8 | ?11005 | Shotgun | 100 | |||
| ?10 | ?11010 | Shotgun house | 133 | |||
| ?11 | ?11012 | Shotgun house | 133 | |||
| ?... |
Table three is the partial record in the group reservation single database, 5 unirecord partial informations of member of community have been write down, the group of its master of higher level group list number is kingsoft, and objective single serial number 6 and higher level's group reservation odd numbers of 7 are STD0, and higher level's group reservation odd numbers of objective single serial number 8-10 is STD1.
Each group's master's unirecord exists some its subordinaties' group reservation unirecord, group's list that there are some its subordinaties in each group reservation unirecord, as shown in Figure 3, open this Zhang Tuanti master's unirecord, show intuitively on the right side of window that the master of this group unirecord and its subordinate's group reservation is single, and the subordinate relation of member of community's list of the single subordinate of this group reservation.
Record in database of every input can increase delegation in objective forms data storage list 142, according to the situation of table one, table two, table three, necessarily storing the information as table four in objective forms data storage list 142.
Table four
| The single serial number of visitor | The single serial number of the master of group | The single serial number of group reservation | The single type of visitor | Group's name |
| ?4 | ?0 | ?0 | ?11 | Kingsoft |
| ?5 | ?4 | ?0 | ?21 | |
| ?6 | ?4 | ?5 | ?31 | |
| ?7 | ?4 | ?5 | ?31 | |
| ?8 | ?4 | ?5 | ?31 | |
| ?9 | ?4 | ?0 | ?21 | |
| ?10 | ?4 | ?9 | ?31 | |
| ?11 | ?4 | ?9 | ?31 |
Table five
| Explanation | The type code name |
| Group is single | 11 |
| Group reservation is single | 21 |
| The member of community is single | 31 |
Table five is the single type list of self-defining visitor corresponding to table four.
1) shown the data that the present invention produces in the present embodiment in the table four, it is single that wherein each line data is represented a different visitor, can obtain the subordinate relation between these several the data recording from this table.
(a) first row " objective single serial number " are that native system is the single unique discriminating digit that produces automatically of each visitor;
(b) secondary series " the single serial number of the master of group " is the serial number of this objective single higher level's of institute who writes down representative the master of group list, is the master of the group odd numbers that 0 expression does not have the higher level;
(c) the 3rd row ' group reservation odd numbers ' are the serial number of this objective single higher level's of institute who writes down representative group reservation list, are that 0 expression does not have higher level's group reservation single;
(d) the 4th row ' group's name ' are group's name of the master of the group list of this record representative, if this record is not that objective single type is the master Dan Zewei of a group sky.
2) in first line data of table four, can see that No. 4 single objective single types of visitor are 11, inquiry can learn that its corresponding type is that group is single according to table five.
3) the objective single type in second, six line data is 21, and objective single type that inquiry can be learnt its correspondence from table two is that group reservation is single, and can see that the higher level's that No. 5 visitors of the second line data representative are single group reservation is single.
4) third and fourth, the objective single type in five, seven, eight line data is 31, inquiry can learn that objective single type of its correspondence is that the member of community is single from table two, and can see their subordinate relation, be No. 5 lists as No. 6 higher levels' of the single institute of visitor of the third line data representative group reservation odd numbers.
5), these several the subordinate relation figure that the visitor is single can have been constructed, as shown in Figure 3 according to above information.Fig. 3 shows the tree hierarchy relation of this objective single relational tree module 140, can represent with tree-like, and also can be the form shape, the present invention not merely is limited to this, so long as can intuitively show and get final product.
If only show its objective single serial number, can not accomplish directly perceived and clearly illustrate its subordinate relation, so, in the normal state, show group number, group reservation odd numbers or member of community's odd numbers of its objective single serial number correspondence.Search the group number, group reservation odd numbers, member of community's odd numbers of its correspondence and with its demonstration at the master of group single database 110, group reservation single database 120, member of community's single database 130 respectively by the single serial number of visitor.
See also Fig. 3, master's unirecord is opened when group, and system can utilize objective single relational tree module 140 to search its subordinate's all entities booking form and all member of community's lists of the single subordinate of group reservation, and its subordinate relation is shown with intuitive manner.And in this specific embodiment, show with tree structure.Label 200 is objective single relational tree module of the master of this group list, and 210 is the group number of the master of this group list, and 220 is one of them group reservation odd numbers of two group reservation lists of the single higher level of the master of this group, and 240 is member of community's odd numbers of its subordinate.According to member of community's odd numbers, in member of community's single database 130, can export some important information, such as be the state of this member in the hotel, be subscribe, move in, shotgun house or one day room rate of this member etc. such as checked out.Add up the member's of each group reservation list state, just can add up the specifying information of this group reservation list, as subscribe, move in, shotgun house, the number statistics of checking out.
Utilize the dynamic link technology, each node of the single relational tree module of visitor is linked with corresponding entry, like this, when activating each node of the single D-tree of group reservation list and member of community, can open with the form of new window by the document that it is corresponding.As activating group reservation, can to open corresponding group reservation when single single, and activating the member of community, can to open corresponding member of community when single single, directly can operate.Also can carry out batch operation by selection to the single relational tree node of visitor.The single following part member of community of company booking is single such as selecting, and program has been simplified in sequence of operations such as recovery that the member of community who chooses is singly checked out or checks out so greatly.
Only disclose among the present invention and opened in the master of the group unirecord, objective single relational tree module 140 shows its subordinate's the group reservation list and the situation of member of community's list.And in native system if open the group reservation unirecord, the single relational tree module 140 of this visitor also can show the situation of member of community's list of its subordinate.Because of principle of work is identical, no longer narrated at this.
Though more than enumerated preferred embodiment of the present invention and be illustrated, do not deviating under the spirit and scope of the present invention, still can do the change of any equivalence.Therefore, conspicuous change of present technique personnel institute or modification all should be included in the protection domain of claims.
Claims (7)
1, a kind of Hospitality management system of moving at group, it is single to be used to manage the visitor of group who moves in, and this system comprises:
The master of group single database;
The group reservation single database;
Member of community's single database; In the above-described database each records unique objective single serial number, it is characterized in that:
This system also comprises objective single relational tree module of hierarchical relationship of member of community's list of the group reservation list that can intuitive manner shows the master of this group unirecord subordinate and the single subordinate of group reservation, the single relational tree module of this visitor comprises objective forms data storage list, this visitor's forms data storage list has some records, each bar record all has a data structure, includes objective single serial number, the single serial number of the master of group, the single serial number of group reservation in this structure; This visitor's forms data storage list links to each other with above database by objective single serial number, and the content of the single serial number of the master of group that should write down is objective single serial number of higher level's the master of group list; The content of the single serial number of its group reservation is objective single serial number of higher level's group reservation list.
2, Hospitality management system of moving at group as claimed in claim 1 is characterized in that: also include objective single type in the described objective forms data storage list, the single type of this visitor has that the master of group is single, group reservation is single at least, single three types of member of community.
3, Hospitality management system of moving in as claimed in claim 2 at group, it is characterized in that: the single type of described visitor is a numeric type, the single relational tree module of described visitor also comprises the objective single definition list corresponding with objective single type, has the single type code name of the master of group, the single type code name of group reservation, the single type code name of member of community in the single definition list of this visitor at least.
4, Hospitality management system of moving at group as claimed in claim 1 is characterized in that: also can comprise a name in the data structure of described objective forms data storage list, described group is called character type, group's name of the record master of group list.
5, as claim 2 or 3 described Hospitality management systems of moving at group, it is characterized in that: objective single type is the objective forms data storage list record of the master of group list, and the content of single serial number of the master of group of this record and the single serial number of group reservation is 0.
6, as claim 2 or 3 described Hospitality management systems of moving at group, it is characterized in that: objective single type is the objective forms data storage list record of group reservation list, and the content of the single serial number of the group reservation of this record is 0.
7, Hospitality management system of moving at group as claimed in claim 1 is characterized in that: the single relational tree module of this visitor shows with tree.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB031051871A CN100334586C (en) | 2003-03-05 | 2003-03-05 | Hotal management system for group accommodation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB031051871A CN100334586C (en) | 2003-03-05 | 2003-03-05 | Hotal management system for group accommodation |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1527229A true CN1527229A (en) | 2004-09-08 |
| CN100334586C CN100334586C (en) | 2007-08-29 |
Family
ID=34282543
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB031051871A Expired - Fee Related CN100334586C (en) | 2003-03-05 | 2003-03-05 | Hotal management system for group accommodation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100334586C (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102609477A (en) * | 2012-01-19 | 2012-07-25 | 北京神州数码思特奇信息技术股份有限公司 | Method for implementing serial number generator |
| CN102938110A (en) * | 2012-11-22 | 2013-02-20 | 张劲松 | Intelligent hotel workflow management system, process management method and check-in registering method |
| CN108334964A (en) * | 2017-01-20 | 2018-07-27 | 阿里巴巴集团控股有限公司 | A kind of business object reservation system, method and device |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2176775C (en) * | 1995-06-06 | 1999-08-03 | Brenda Sue Baker | System and method for database access administration |
-
2003
- 2003-03-05 CN CNB031051871A patent/CN100334586C/en not_active Expired - Fee Related
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102609477A (en) * | 2012-01-19 | 2012-07-25 | 北京神州数码思特奇信息技术股份有限公司 | Method for implementing serial number generator |
| CN102609477B (en) * | 2012-01-19 | 2014-10-22 | 北京思特奇信息技术股份有限公司 | Method for implementing serial number generator |
| CN102938110A (en) * | 2012-11-22 | 2013-02-20 | 张劲松 | Intelligent hotel workflow management system, process management method and check-in registering method |
| CN102938110B (en) * | 2012-11-22 | 2016-06-29 | 张劲松 | Hotel's Workflow intelligentization management system and workflow management thereof and method of checking in |
| CN108334964A (en) * | 2017-01-20 | 2018-07-27 | 阿里巴巴集团控股有限公司 | A kind of business object reservation system, method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN100334586C (en) | 2007-08-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6847973B2 (en) | Method of managing slowly changing dimensions | |
| Codd | Normalized data base structure: A brief tutorial | |
| CN104794123B (en) | A kind of method and device building NoSQL database indexes for semi-structured data | |
| US7254584B1 (en) | Relationship-based inherited attributes system | |
| CN1508736A (en) | Connection item schem | |
| Narang | Database management systems | |
| CN101719135A (en) | Administrative resource catalog control system and method | |
| CN102982186B (en) | Based on maintaining method and the system of the range partition table of oracle database system | |
| CN107506477A (en) | A kind of archive management system | |
| CN102411634A (en) | Data storage method for improving instantaneity of embedded type database | |
| WO1996017311A1 (en) | Method and structure for clustering database tables into classes and presenting each class as an e-r model | |
| Candlin et al. | Mapping Museums 1960-2020: A report on the data | |
| Kantabutra et al. | Using the Newly‐created ILE DBMS to Better Represent Temporal and Historical GIS Data | |
| CN1527229A (en) | Hotal management system for group accommodation | |
| CN117251531A (en) | Family tree association generation method, system and storage medium | |
| US20180075036A1 (en) | Identifying frequent item sets | |
| CN1892655A (en) | Method and data structure for indexed storage of hierarchically interrelated information in a relational database | |
| US8812453B2 (en) | Database archiving using clusters | |
| CN113268454A (en) | Family management method, system, device and storage medium | |
| Prakash et al. | Bitmap indexing a suitable approach for data warehouse design | |
| CN113468146A (en) | Construction method for figuring out basic governing base number based on all elements and all abilities | |
| CN113642298A (en) | Comprehensive operation and maintenance management report processing method and system | |
| CN102479242A (en) | System and method for displaying query result by relational graph | |
| CN1369840A (en) | Method for integrating information cross databases and its architecture | |
| CN116303392B (en) | Multi-source data table management method for real estate registration data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee |
Owner name: ZHUHAI KINGSOFT SOFTWARE CO., LTD. Free format text: FORMER NAME: ZHUHAI JINSHAN SOFTWARE CO. LTD. |
|
| CP03 | Change of name, title or address |
Address after: Jinshan computer Building No. 8 Jingshan Hill Road, Lane 519000 Lianshan Jida Zhuhai city in Guangdong Province Patentee after: Zhuhai Kingsoft Software Co.,Ltd. Address before: Jingshan Hill Road, Lane 519100 Lianshan Jida Guangdong province Zhuhai City No. 8 Patentee before: Zhuhai Kingsoft Software Co.,Ltd. |
|
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20070829 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |